Question

怎么配置SQL Server 2008服务器

Answer 1

启用 TCP/IP
配置网络设置
1. 开始-->程序 -- > Microsoft SQL Server 2008 > Configuration Tools > SQL Server Surface Area Configuration
2. 在“ Surface Area Configuration utility” ,点击"SQL Server Configuration Manager"
3. Expand "SQL Server Network Configuration" 选择” Protocols“.
4. Enable TCP/IP. If you need Named Pipes, then you can enable them here as well.
5. Close the SQL Server Configuration Manager.
6. Add Firewall Exceptions

If you have a software firewall installed on your server, you will need to add exceptions for the SQL Server and SQL Browser services. If you are using Windows Firewall, do the following:
In your Control Panel, open the Windows Firewall applet.
1. Go to the Exceptions tab.
2. Click Add Program
3. Browse to and select "C:\Program Files\Microsoft SQL Server\MSSQL.10\MSSQL\Binn\sqlservr.exe"
4. Click OK.
5. Click Add Program
6. Browse to and select "C:\Program Files\Microsoft SQL Server\90\Shared\sqlbrowser.exe"
7. Click OK and then click OK again.

If you are using a third-party software firewall, you will need to follow their instructions to add exceptions to sqlservr.exe and sqlbrowser.exe.
Restart the Services or Reboot the Server
When you have completed all of these steps, you will need to restart the SQL Server and SQL Browser services to complete the process. If you still have problems, you may need to restart your server.