0
Thanks

A few words of thanks would be greatly appreciated.

Error connecting to SQL Server 2005




Issue


I have installed SQL Server 2005 and I can not connect to it, I dont know my server name and SQL Server show this error to me:
TITLE: Connect to Server
------------------------------

Cannot connect to home sql express.

------------------------------
ADDITIONAL INFORMATION:

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: 1231)

For help, click: http://go.microsoft.com/...

Solution


There following possibilities.

1. Your SQl Browser is off
2. Protocols under SQLServer Configuration Manager > SQL Server 2005 Network Configuration > Protocols for SQL Express like TCP/IP, Named Pipes are disabled.

Resolution:
  • Just Start SQL Browser.
  • Enable the Protocols.
  • Restart SQL Express service.


This might resolve the problem

Note


Thanks to ABrightWorker for this tip on the forum.
0
Thanks

A few words of thanks would be greatly appreciated.

Ask a question
CCM is a leading international tech website. Our content is written in collaboration with IT experts, under the direction of Jeff Pillou, founder of CCM.net. CCM reaches more than 50 million unique visitors per month and is available in 11 languages.

Published by . Latest update on by aakai1056.

This document, titled "Error connecting to SQL Server 2005," is available under the Creative Commons license. Any copy, reuse, or modification of the content should be sufficiently credited to CCM (https://ccm.net/).

0 Comments