I have installed SQL 2005 developers edition onto my local workstation to begin testing our application against it. I configured the surface area to allow remote connections. So on my workstation, I have both SQL 2000, and SQL 2005. SQL 2005 installed as a "named instance" called SQL2005.

I modified my applications login routine to call the SQL 2005 instance, and it works from my workstation if I format the SERVER value as ".\SQL2005". But this will only work on my local workstation. On another workstation, that does not have SQL 2005 loaded, I tried to put it in as 192.168.30.36\SQL2005 but it fails. That format even fails on my local workstation.

Here is the connection string I use to create the connection in the app.

DRIVER={SQL Server};SERVER=.\SQL2005;UID=myUserID;pwd=myPWD;database=CTORE

I've never had a named instance before so I looking for tips and tricks to ensure this will work.

Any help and pointers appreciated.

Kirk