Can't connect remotely to new SQL 2005 instance

[mkrausnick]

I am unable to connect to my new SQL server 2005 instance using Management Studio from my workstation. I get the message "An error has occurred while establishing a connection to the server. When connecting to SQL server 2005, this may be caused by the fact that under the default settings SQL server does not allow remote connections..." etc.

However if I logon to the Windows server using my same user ID, I can connect to SQL Server with no problem.

So I thought, ok, I need to enable remote connections.

To enable Remote Connections I followed the procedure in

http://support.microsoft.com/kb/914277.

It revealed that remote connections are already allowed and the browser service is already running. I changed the connection type from TCP/IP to both TCP/IP and named pipes & restarted the sql instance.

Didn't help.

It's 64-bit SQL server 2005 running on a new Windows 2008 64-bit server.

Ideas please? I'm stumped.



Mike Krausnick
Dublin, California

 

[bborissov]

You should enable Mixed Case Authentication: windows and SQL Server one. You can't connect to SQL Server remotely only with Windows Authentication. You must connect to server first so you get your credentials and then login to SQL Server. With SQL Server you can connect from everywhere if you know the right username and password.

Borislav Borissov
VFP9 SP2, SQL Server 2000/2005.

 

[mrdenny]

You can't connect to SQL Server remotely only with Windows Authentication

What? You can absolutely connect without having a SQL Account. SQL Server works just fine when using Windows Auth only.

Does through faq962-5481. It should get you connected.

Denny
MVP
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / SQL 2008 Implementation and Maintenance / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Admin (SQL 2005/2008) / Database Dev (SQL 2005)

My Blog