Shulou(Shulou.com)05/31 Report--

What is the method of remote login to SQL Server 2014 database? I believe many inexperienced people don't know what to do about it. Therefore, this paper summarizes the causes and solutions of the problem. Through this article, I hope you can solve this problem.

Log in to SQLServer (2014) database remotely, the details are as follows

Two computers, in the same local area network, IP the same network segment

Configuration:

Computer1: Windows10, install SQL Server 2014 enterprise version (as a server)

Computer2: Windows 10,VS2015

Computer1: (1) set two login methods: Windows user and SQL Server authentication

(2) configure SQL Server configuration Manager

Network configuration turns on both Named Pipes and TCP/IP protocols, and the default pin number for TCP/IP is 1433.

The same client opens the above two protocols

(3) Server configuration above 05 (version 05 opens the peripheral configuration, and Database Engine opens the remote connection in the configuration of services and connections)

In SSMS, right-click the server user name-Server configuration-RemoteAccessEnabled and select true.

(4) re-enable the corresponding server and client service (set to automatic). When rebooting, the service will not be turned off.

(5) Open port 1433 firewall-Advanced Settings-inbound rules-New rules-Port-TCP- specific port (1433). The remaining default listening port dos command: netstat-an

CumputerB: C # writer connects to Computer A SQL Server database

(1) create a new SQL project, and select SQL Server 2014 for the property project settings platform.

Debug-Edit the connection properties to connect successfully

(2) set up C# console program and write code to connect

/ / add namespace using System.Data.SqlClient;// to connect to the database string cnnStr = "Server=DESKTOP-UE87L88;database=WorkshopData1;uid=sa;pwd=neopen"; / / Server name, database name, user name, password myConnection = new SqlConnection (cnnStr); myConnection.Open (); after reading the above, have you mastered the method of remote login to SQL Server 2014 database? If you want to learn more skills or want to know more about it, you are welcome to follow the industry information channel, thank you for reading!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.