User gets the following error when trying to connect to TOAD for SQL server with the following format:
Server name: <Server>
Authentication: SQL Server Authentication
Login: <User>
Password:<Password>
Database: <Database>
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.
Microsoft states, This problem may occur when SQL Server 2005 is not configured to accept remote connections. By default, SQL Server 2005 Express Edition and SQL Server 2005 Developer Edition do not allow remote connections.
This issue might be resolved by adding the instance name to the end of the server name in the Server Name field. For example
Server name: <Server>\<Instance>
If this does not resolve the issue, Microsoft offers the follow suggestion at http://support.microsoft.com/kb/914277
When you try to connect to an instance of Microsoft SQL Server 2005 from a remote computer, you may receive this error message. This problem may occur when you use any program to connect to SQL Server.
To configure SQL Server 2005 to allow remote connections, complete all the following steps:
Enable remote connections on the instance of SQL Server that you want to connect to from a remote computer.
Turn on the SQL Server Browser service.
Configure the firewall to allow network traffic that is related to SQL Server and to the SQL Server Browser service.
