When I tried to connnect to sql server on my local machine thru visual studio 2005 I got an error message .It says:
An error has occured 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 coneection to sql server)
In the sql server configuration manager I checked the protocols for sql server...named pipes are already enabled...
Can anybody tell me which default settings I should change to connect to the sql server?