Thursday, December 29, 2011

Enable Sqlserver access over the network

abling SQL Server 2008 (R2) access over Network
Posted on June 21, 2010

First: enable SQL Server itself to be accessed over the network
Open SQL Server Configuration Manager
Expand SQL Server Network Configuration and click Protocols for MSSQLSERVER

Doubleclick TCP/IP

Set Enabled to Yes

(click for large size)

Secondly: change the Windows Firewall to allow incoming connections on the TCP port of SQL Server
Open Windows Firewall with Advanced Security
Click on New Rule

(click for large size)

Now in the wizard you set the type of the rule to Port.

Hit Next.

On the second window you set the Specific local ports to 1433:

Hit Next.

Allow the connection.

Hit Next.

Now enable the checkboxes you want to. I set mine only to Private. Because I only need to access the SQL on my laptop at home:

Hit Next.

Hit Finish and you’re ready to develop SQL over network

No comments:

Post a Comment