SQL Server Management Studio – Error connecting to remote DB

sql-server-2005ssmsvpnwindows 7

All right, here is the deal:

I'm connecting to a Windows 2003 Server using VPN. On this server, there is a remote SQL Server 2005 Express engine.

I can connect to the database using Visual Studio 2008.

What I can't do though, is connect to this same database with SQL Server 2005 Management Studio (Standard).

I have checked the connection info a hundred times and still nothing.

One thought: do VS ans SSMS use the same sql provider?

Note: I'm running Windows 7 RC. I had absolutely no problem using the same config under Vista.

Best Answer

I'm assuming you've remembered to include the instancename (server\SQLEXPRESS)?

Try to create an ODBC against the same server. If you get the same error; create another ODBC, but use regular "SQL Server" driver, and on the "Client Configuration" settings choose "Named Pipes".

Also, SQLChickens tip about making sure the SQL Browser is started on the server is valid.

Also, try using IP-address instead of the NetBios name.

Related Topic