Overview of LabVIEW remote connection to SQL Server

Server:
1. Install SQL Server 2000 and upgrade it to SP4

2. Open Enterprise Manager, Select Server/attribute/security, and change "authentication" to "SQL Server and windows (s )"
 
3. confirm that the enabled protocols include: TCP/IP protocol (default port: 1433). You can query them in "server network utility ".
 
4. Check that port 1433 is not blocked by the firewall (if any). In the DOS environment, enter netstat-An to check whether the system is listening for port 1433.

5. Open the SQL engine and start the SQL Server service manager.

Client:
1. Enter the telnet server IP address 1433 in the DOS environment to check whether the connection can be established.

2. create an ODBC Data Source (ODBC ). select "SQL Server verification with user input Login ID and password" (check method can be changed in SQL Server Enterprise Manager). The default login ID is SA and no password.

Development end:
 
When using the LV development platform to remotely connect to SQL Server, you must specify the account and password (the default user is Sa, no password ). ADO connection is available. if LabSQL is used, you must open the ADO connection. VI to modify, and then add two parameters: userid, password