2005 Remote Connection Error

Hi,

Hope someone can help with this, having a huge problem connecting to SQL 2005 from a client machine. I get the following error:

"An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) (Microsoft SQL Server, Error: -1)"

I have SQL 2005 installed on a server containing SQL 2000 (default instance) and then SQL 2005 as the instance SERVER\SQL2005. 2005 is running SP1. I'm connecting via windows authentication, using just using Management Studio. I've also configured the server to accept remote connections.

I can connect locally to the 2005 instance. Does anyone have any ideas why this might be happening?

Thanks

Jeremy

See my Screencast about Remote connections on my site which describes in detail how to enable remote connections.

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de|||

Thanks for the reply Jens,

I have definitely enable remote connections already. Do you have any other ideas?

Thanks

Jeremy

|||Can anyone help with this?|||

Sorry for not coming back earlier, lsot the focus on the post. DO you have SQL Server Browser started on the server ? SQL Browser will redirect the client request to connect to the assigned port without naming explictly the port of the SQL Server. If you don′t start the browser on the server, the client will try to connect to the port 1433 which might not be used by the named instance. If you know the port of the named instance, you can also specify that directly within the connection string using servername\instanceName,Portnumber.

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de