SQL Sever 2012 How to establish a database connection

First, download

http://www.microsoft.com/zh-cn/download/details.aspx?id=29062

Install directly after download.

Second, open the database

1. Click on the link to enter the following screen.

2. Right-click the property in the selected

3. In security, select "SQL Server and Windows authentication mode" on the right to enable hybrid login mode

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

5. In security, click the login name, select SA, right-click Properties, set Password

6. Right-click, select the server configuration on the right side, and see if remoteaccessenabled is True

7. Check the status of the SA: if it is disabled, the SA account will not be logged in.

8. If disable is selected, log in as SA:

An error will occur:

Unable to connect to Yjr\sqlexpress

Additional Information:

The connection to the server was successfully established, but an error occurred during the login process.

9. We can then log in with SA to indicate that the SA account exists

10.SQL Sever Browser must be running.

11. If SQL Sever browser is stopped and cannot be clicked, you need to right click on My computer and click Manage.

A) on the Start menu, right-click My Computer, and then click Manage.

b) in Computer Management, expand services and applications, and then click Services.

c) in the list of services, double-click SQL Server Browser.

D) in the SQL Server Browser Properties window, click Start or Stop.

e) When the service starts or stops, click OK.

Open SQL Sever Configuration Manager

12. For example, the TCP/IP default port number is set to 6233.

13.SQL Sever network configuration, TCP/IP properties, OK two Yes

14. Client protocol, TCP/IP properties, set the default port number to 1433

15. If you are still experiencing a database connection, restart SQL Sever (SQLEXPRESS) in the SQL Sever service:

SQL Sever 2012 How to establish a database connection