- In Object Explorer, right-click a server and select Properties.
- Click the Connections node.
- Under Remote server connections, select or clear the Allow remote connections to this server check box.
- On the SQL Server, open 'SQL Server Configuration Manager'. This can typically be found linked from the 'Start' menu. For example: Start | All Programs | Microsoft SQL Server 2008 R2 | Configuration Tools | SQL Server Configuration Manager.
- Expand 'SQL Server Network Configuration' and highlight the 'Protocols for [InstanceName]' option.
- In the right-hand window, if 'TCP/IP' currently has the 'status' of 'Disabled', right click on 'TCP/IP' and select 'Enable'.
Note: You will be requested to restart the SQL Server service to complete the configuration change. - Enable access to port 1433 (the port used by SQL Server) on the db server via Windows Firewall and any network-level firewalls.
- To restart the service, you can use the same Microsoft Management Console (MMC) window. To do so, highlight the 'SQL Server Services' option at the top of the tree. In the right-hand window, you can then right click on the 'SQL Server [Instance]' entry and choose 'Restart'.
Source:
http://technet.microsoft.com/en-us/library/ms191464.aspx
http://www.sophos.com/en-us/support/knowledgebase/118473.aspx
No comments:
Post a Comment