本文提供了一套详细的步骤来配置SQL Server 2005的服务，包括将浏览器服务设置为自动启动、启用TCP/IP和Named Pipes、调整远程连接设置等。通过这些步骤可以确保服务器能够正确地响应本地和远程连接。
Steps for Configuration Manager:
Make Browser service automatic from Manual in SQL Server 2005 services
Go to Network Configuration in Configuration Manager
Enable TCP/IP
Enable Named Pipes
Surface Area Configuration tool steps:
Go to Surface Area configuration for services and Connection
In Database Engine click on Remote Connection
In there change to Local and Remote
And choose both TCP/IP and Named Pipes it is the last option.
Then in Managment Studio go to view at the top click on Register server, SQL Server splits your object browser.
Right click on Database engine and then new then click on server registration and you said you have Windows authentication it is the default add the connection info and it will work.
原帖：http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1869763&SiteID=1
扫一扫
592
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
