30 May 2008
13 Nov 2008
Link to this post
Is it also working for SQL Server 2008 Express?
I have that database on another CPU and cannot establish a connection.
There was an error trying to connect to the Database Server:
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: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)
I currently have windows firewall off
documentation regarding opening SQL Server 2005 for external access is unclear for 2008, but I have enabled tcpip and restarted the SQL service.
Is there a more basic tool to check connectivity from the client? The SQLCMD suggested by MSDN is not installed.