SQL2008R2 Setting up remote links

The article below is from the Baidu experience sticky over.

Tested really effective. Leave a backup.

There is a small case to say in front.

Be sure to determine if your SA user password is the same before you operate. Do not think you know the right to skip certain steps directly.

Saying goes.. Listen to people, eat full meal. Make sure it doesn't take any time. But if it really is the problem of the password. That's not half an hour and an hour.

Don't ask me why I emphasize this question. Hey... It's all tears ...

2. 1

   Open sql2008, log on with Windows identity

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

   
   
   
6. 3

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

   
   
8. 4

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

   
   
10. 5

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

    
    
12. 6

    Right-click on the database Select "Facet"

    
    
14. 7

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

    
    
16. 8

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

    
    
18. 9

    Open SQL Server Configuration Manager

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

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

    
    
    
24. 12

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

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

SQL2008R2 Setting up remote links