SQL-Configures SQL Server so that it can be accessed remotely

Environment:

SQL Server2008 R2

SQL Server Management Studio

When you test your deployment project today, you find that you cannot access SQL Server remotely. The scenario is that when Management Studio is connected to DB, the Server name is entered./instance, there is no problem. Enter the IP address \sqlinstance. It's not connected.

How to connect remotely, there are a lot of tutorials online.

Summed up there are 3 reasons.

After you log on locally in SQL Server Management Studio, right-click Properties

1. Choose Mixed Mode login, I usually install instance, configure the mixed mode

2. Connect the properties page to allow remote connections.

In SQL Server Configuration Manager

1. TCP/IP to enable.

2. TCP/IP address, port to be set correctly

3. Ensure that instance and SQL Server browser are started normally.

In this step, the first instance will not start. A local database of VS 2012 is deleted for normal display.

Then SQL Server Browser cannot be started, and to start, log in with the administrator account.

Make sure that this is the way it should be shown:

3. Firewall. Try it off first. Then make sure to pass a port.

Change the settings for the Win7 firewall, go to Control Panel \ System and Security \ Windows Firewall, select Advanced Settings, select New Inbound rule

3.1 Allow these two programs:
C:\Program Files\Microsoft SQL Server\mssql.1\mssql\binn\sqlservr.exe,
C:\Program Files\Microsoft SQL Server\90\shared\sqlbrowser.exe

3.2 Add 2 "Inbound Rules" and select "New Inbound Rule"

Select "Port", select "TCP", select "Local Port", enter "1433", name "TCP1433", complete.

Select "Port", select "UDP", select "Local Port", enter "1434", name "UDP1434", complete.