June 3, 2006 at 4:54 pm
Hi, I installed SQL server 2005 express edition. When I open SQL Server Management Studio Express, it comes with a login window. I entered the server name as localhost , Authentication is Windows Authentication. When I try to connect it comes up with 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: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) (.Net SqlClient Data Provider)
What should I do ? What should be the server name ?
Thanks
June 4, 2006 at 5:41 am
In the start menu go to
Start Menu\Programs\Microsoft SQL Server 2005\Configuration Tools
and open the sql server configuration manager expand the sql server network configuration manager and click on protocols for mssqlserver on the right hand side you will now see a list of protocols if you are running the management studio on the same machine ensure that shared memory is enabled, if you are trying to access it from a remote machine make sure tcp/ip is enabled. Any changes you make here will not take effect until the sql server service is restarted.
If all of these options are correct then in the connection window in management studio click on the options button and check the connection properties make sure everything is set to default which will try all the protocols one by one essentially make sure it is not set to tcp/ip if this protocol is not enabled.
Valid server name for connectiong sql server express are.
.\sqlexpress
computername\sqlexpress
local\sqlexpress
hth
David
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply