1)Start the SQL Server Configuration Manager by selecting Start > All Programs > Microsoft SQL Server > Configuration Tools > SQL Server Configuration Manager.
2)Select SQL Server Network Configuration > Protocols for
3)Enable TCP/IP.
4)Open TCP/IP Properties.
5)On the Protocol tab, make the following selections.
■Enabled: Yes
■Listen All: Yes
■Keep Alive: 30000
6)On the IP Addresses tab, make the following selections.
■Active: Yes
■TCP Dynamic Ports: 0
7)Restart the SQL Server service from SQL Server Configuration Manager > SQL Server Services.
8)Start the SQL Server Browser service from SQL Server Configuration Manager > SQL Server Services.
No comments:
Post a Comment