sql2008-2012 How to turn on remote connection configuration

Source: Internet
Author: User
Tags management studio sql server management sql server management studio

One, remote connection port settings (a key step)
1. Open SQL Server Configuration Manager on the server. Select the protocol->TCP/IP for the SQL Server Configuration Manager->sql Server network configuration->mssqlserver, select the IP address->ipall->tcp port in the pop-up dialog box, Set to an available port such as 2568. (The default port of 1433 may not be connected)

Second, open SQL Server Management Studio, and on the database engine, right-click Properties---Security server Authentication mode, configured for SQL Server and Windows authentication modes;
? Right-click on "Facet" on the Database engine, select "Server Configuration" on the right side of the popup dialog and set the "Remoteaccessenabled" property to "True" and click "OK";
? Right-click on "Facet" on the Database engine, select "Surface Area Configurator" on the right side of the popup dialog, set the "Remotedacenable" property to "True", and click "OK";
On the database engine, right-click Properties, and select Restart Database engine.

Third, set the login user name, in the database engine security---login name, create a new user:
1, in the General tab, set the user name and login password;
2, on the Server Role tab, tick public (if you check the sysadmin, the user will have all the database management rights, in the 3rd step without checking the database);
3. On the User Mapping tab, tick the database that allows the user to log in, select the database, and in the Database role membership list below, tick the following options: db_datareader db_datawriter db_ddladmin Public
4. On the Status tab, click Grant, Enable.

Test connection
1, open the SQL login interface, enter the server IP and user name and password. Such as:
Server name:xxx.xxx.xxx.xxx,2568
User name: XXX
Password: xxxxxx
Point connection, and the result is connected successfully.

sql2008-2012 How to turn on remote connection configuration

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.