SQL Server R2 How to open a remote connection to a database (go)

SQL Server 2008 does not allow remote connections by default, and if you want to connect to SQL Server 2008 on a remote server by using SSMs locally, connect to the database remotely. You need to do two-part configuration:

• SQL Server Management Studio Express (SSMS)
• SQL Server Configuration Manager/sql Server Config Manager (abbreviated SSCM)

SQL Server Management Studio Express (abbreviated SSMS) configuration

Open sql2008, log on with Windows identity

After logging in, right-click on "Properties". On the left, select "Security" and select "SQL Server and Windows authentication mode" on the right to enable hybrid login mode

Select "Connect", check "Allow remote connection to this server", then click "OK"

Expand Security, login name; SA ", right-select" Properties "

On the left, select General, select SQL Server authentication on the right, and set the password

Right-click on the database Select "Facet"

Select Server configuration in the Aspect drop-down box on the right, set the Remoteaccessenabled property to True, and click OK

Now that SSMs is set up, exit and log in with SA, success means that the SA account is enabled

SQL Server Configuration Manager/sql Server Configuration Manager (abbreviated SSCM) configurations

Open SQL Server Configuration Manager

Start by configuring SSCM, check the SQL Server service on the left, and make sure that SQL Server on the right and SQL Server Browser are running

On the left, select the SQLExpress protocol under the SQL Server Network Configuration node, the TCP/IP default on the right is "no", right-enable or double-click to open the Settings panel to modify it to "yes"

Select the IP Address tab, set the IP address to the native IP address, and set the TCP port to "1433"

The "TCP/IP" of the "client Protocol" is also modified to "Enabled;

When the configuration is complete, restart SQL Server 2008. You should be able to use it at this time, but still have to confirm the firewall. Open the firewall settings. The SQLServr.exe (C:\Program Files\Microsoft SQL Server\mssql10. Sqlexpress\mssql\binn\sqlservr.exe) is added to the Allowed list.

Modify the configuration file, remote connection string: "Server=ip address; Initial catalog= database name; User Id=sa; password= Password "

Restart the server after the configuration is complete.

Settings for remote access to another computer

installation system, resource files in Baidu Cloud

Install the sqlserver2008client, make a remote connection to the database, first ping the address to see if it can ping, not ping the words, make firewall changes, or shut down the firewall.

To see if you can connect to a host server

Connect using the Sqlserver2008client. Enter the appropriate address and user name password.

To view the relevant configuration content:

Import related databases, connect them

SQL Server R2 How to open a remote connection to a database (go)