SQL Server R2 open allow remote connections

Source: Internet
Author: User
Tags microsoft sql server sql server express

Method/Step
  1. 1

    Log in to SQL Server (Windows authentication), right-click after login, and select "Properties".

  2. 2

    Select Security on the left, and select SQL Server and Windows authentication mode on the right to enable hybrid login mode.

  3. 3

    Select "Connect", check "Allow remote connection to this server", we recommend "Maximum concurrent connections" as the actual situation, and then click "OK".

  4. 4

    Expand Security, login name, SA, and right-select properties.

  5. 5

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

  6. Select "Status", select "Enable" and click "OK".

  7. Right-click the database and select facets.

  8. In the "Facets" list box, select "Server Configuration," "Remoteaccessenabled" and "remotodacenabled" set 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.

  9. Start by configuring SQL Server Configuration Manager (SSCM), check the SQL Server service on the left, and make sure that SQL Server on the right and SQL Server browser are running.

  10. Open the left SQL Server network configuration, open the protocol for your own DB instance name, and view the TCP/IP default on the right is disabled and modify it to Enabled.

  11. Double-click to open TCP/IP to view the "all Listen" and "enabled" items in the Protocol tab under TCP/IP properties are set to Yes.

  12. Select the IP addersses tab, IP1, IP2, Ipall set the TCP port to "1433", the TCP dynamic port is a null value, and is enabled as "Yes".

  13. Also modify TCP/IP of the client protocol to Enabled.

  14. Double-click to open TCP/IP on the right, open TCP/IP properties, set the default port to "1433", and enable "yes". When the configuration is complete, restart SQL Server 2008.

  15. In the final step, you will need to map the SQL Server 1433 TCP port and the 1434 UDP port on the firewall.

    END
Precautions
    • After SQL Server Express installation, remote connections are disabled by default. If remote access is required, manual configuration is required. 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. The article is based on the actual situation I used to conduct continuous testing and on-line search for relevant information to rectify. Because I use the CiscoASA5510 firewall, so in the configuration of the firewall once thought as long as 1433 of the TCP port mapping is possible, but the trial is unsuccessful. Finally, the data of the SQL Server network port is searched, and the UDP port of 1434 is mapped out, so it can be successfully connected in the Internet with SSMs.

SQL Server R2 open allow remote connections

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.