I have been confused about the connection between TD and MSSQL in the previous stage. Now I have figured it out again. Let's make a summary!
- According to the instructions in the manual, you need to configure the "client network utility" on the MSSQL Server. The method is as follows:
MSSQL configuration method: Open "client network utility", select Add under alias, and select the protocol in the pop-up Configuration box (Named Pipes and TCP/IP are recommended, other protocols are required ). Enter a custom name in server alias and a host name in server name. This method is only applicable when MSSQL is installed on the local machine. If MSSQL is not easy to succeed on other machines, I have only succeeded in TCP/IP.
TD configuration method: Go to site administrator, select new under DB server to create a connection, select any connection method of MSSQL, and fill in the custom name in MSSQL in server alias, write the user and password, and click ping to create the password.
- When MSSQL is on another machine, my connection method is that MSSQL directly writes the machine name when writing the server alias. You can write the machine name of the MSSQL server on the TD server alias. Make sure that the two machines can be pinged! In this case, MSSQL is running on XP. In this case, you have to create a shared directory for XP to ping the table. You cannot find the reason for this.
- The most powerful method: MSSQL does not do anything on the other side. You can directly write the machine name or IP address of the MSSQL server on the server alias on the TD side, and ping the server and create the server successfully. I have never seen such a statement in the manual. The server alias here is actually the server name.