SQL Server 2008 opens a remote connection to the database

Tag: adb CDB configuration IP address DEA log User tab on

Reprinted: Chenmengshan _1016 ———— Youdao Yun Notes

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. Need to do two-part configuration: 1,sql Server Management Studio Express (abbreviated SSMS) 2,sql Server Configuration Manager/sql Server Config Manager (abbreviated SSCM) tool/ Raw materials

• SQLServer2008

Steps/Methods

1. 1 open sql2008, log in with Windows identity

2. 2 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

3. 3 Select "Connect", tick "Allow remote connection to this server", then click "OK"

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

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

6. Right-click on the database Select "Facet"

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

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

9. Open SQL Server Configuration Manager

10. 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

11. 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"

12. Select the IP Address tab and set the TCP port to "1433"

13. "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. End Considerations

• Remote connection string: "Server=ip address; Initial catalog= database name; User Id=sa; password= Password "
• 1,2005 's surface area Configurator was changed in 2008.

2, some settings take effect need to restart SQL Server

SQL Server 2008 opens a remote connection to the database