Cant do remote connection do SQL Server 2005 - Server does not exist or access is denied
Posted on 2007-03-19
I'm writing a VB.Net app based on a SQL Server 2005 Express database. I also have the Management Studio Express installed on my laptop that I use for developement. I've set up the application on my PC to simulate a client machine as a test but I cant get a connection to SQL Server running on my laptop.
I can give you the following information:
-Both my PC and laptop run Windows XP Pro SP2.
-I'm using SQL Server 2005 Express on my laptop.
-I'm using a named instance.
-I am able to connect my application to the sever and database locally only (from my laptop).
-I checked that "Allow remote connections to this server" is checked in Management Studio Express.
-I created a UDL file on my laptop that connects successfully to my SQL Server 2005 instance using SQL Authentication. When copying this UDL file to my PC and then test the connection it fails.
-When installing SQL Server Express on my PC, restoring the database and connecting to it from my laptop (ie, just doing the whole test the other way around), I also cant connect so it must be something to do with my settings....
The error message on my PC when trying to connect using the UDL file copied from my laptop is the usual Server does not exist or access denied.
Anything I'm missing?