How do I connect to a remote MSSQL database? _ Application Tips

First Please install MSSQL2000 Enterprise Manager on your computer (no longer described here in detail)

First, open Enterprise Manager such as "Figure 1":

"Figure 1"

Second, right click on "SQL Server Group" SELECT "New SQL Server registration" such as "Figure 2":

"Figure 2"

Third, eject the "Register SQL Server Wizard" point "next" such as "Figure 3":

"Figure 3"

Four, after the point "next" need to wait a little bit that appears as "Figure 4" (Wait because the Registration Wizard automatically searches for a SQL Server server that exists on your computer's network), please enter your SQL Server address (for example: SQL) on the available servers. Sql server. CN ", Note: Here please use your own SQL Server address ) and then click" Add "button, then click" Next "can be.

"Figure 4"

Enter "Select authentication Mode", select the following "SQL Server logon information (SQL Server Authentication)" Assigned to me by the system administrator, and then click Next as "Figure 5":

"Figure 5"

Enter your SQL database username password after entering "Select connection Options", such as "Figure 6", then click Next

"Figure 6"

Seven, after entering the "select SQL Server Group" interface, such as "Figure 7" point "Next" button

"Figure 7"

Eight, then complete the Registration Wizard, the direct point of the "completion" button can be as "Figure 8":

"Figure 8"

Nine, this time SQL Enterprise Manager will prompt "is working with SQL." Sql server. CN connection "(" SQL. Sql server. CN will appear as your SQL database server address is the address you entered in Figure 4, as shown in Figure 9:

"Figure 9"

After the registration is completed, the status of the above "Figure 9" shows whether the registration is successful.

If you are prompted for registration failure:

1. Please check that the SQL Server address you entered is correct.

2. Please check that the SQL login username password you entered is correct.

3. Please check your Internet network (or your network administrator) to allow your computer to connect to port 1433.