Monday 18 June 2012

Can't connect remotly to Sql Server 2008 R2

By default, after the installation of Sql Server 2008 R2 remote access to database server is disabled and you can only access it locally. In order to change that open Sql Server Configuration Manager, expand "Sql Server Network configuration" node, select server instance (default is MSSQLSERVER) and check the status for TCP/IP:



In order to alow remote access double click on entry for TCP/IP protocol and change the value of "Enabled" property to "true". Save your changes and restart the service.

No comments: