5.5.09

SQL Server Login error

Usually while accessing the serer from remote machine, we used to get the below 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: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) (Microsoft SQL Server, Error: 2)"

Reason for this error:
SQL Server is configured to use it locally, remote machines can't access the server.
Steps to rectify it:
start->programs->MS sql server->configuration tool->sql server surface area configuration -> surface area and configuration for service and connection->
sqlexpress->database engine-> remote connections-> activate local and remote connections->select using both tcp/ip ->apply

After this step, restart the database server. This error will disappear

Thanks and Regards,
Venkatesan Prabu .J

No comments:

Post a Comment