Posts
1150
Comments
891
Trackbacks
1
SQL Server 2005: under the default settings SQL Server does not allow remote connections

If you receive this method when attempting to connect to SQL Server 2005, after establishing that the server is running, open up the SQL Server Configuration Manager (found under Configuration Tools in the SQL Server 2005 start menu group) and check to see which protocols are enabled.  By default, only “Shared Memory” is enabled, and so you will need to enable TCP-IP and/or Named Pipes (depending on your network configuration).

posted on Tuesday, May 09, 2006 9:58 AM Print
Comments
No comments posted yet.

Post Comment

Title *
Name *
Email
Url
Comment *  
Please add 4 and 5 and type the answer here: