MSSQL 2000 Help (SQL server concise tutorial) and mssql concise tutorial

MSSQL 2000 Help (SQL server concise tutorial) and mssql concise tutorial

SQL SERVER 2000 installation Tutorial: http://www.bkjia.com/article/37380.htm

1. If your SQL space is activated, open your local SQLserver Enterprise Manager, for example:

2. Right-click the SQLserver group and choose create SQLserver registration, for example:

3. The SQLserver Registration Wizard is displayed. Click Next, for example:

4. Enter the available server IP address in your order and click Add, for example:

5. You can add the Server IP address to the right, and click Next, for example:

6. Select the connection mode and click Next;

7. Fill in the SQL username and password displayed in your order as shown in, and click Next;

8. Complete SQLserver registration and click Finish, for example:

9. The registration is successful. (If the prompt always fails, check whether port 1433 is enabled for your LAN, and check the timeout time for your SQL link. The default timeout time for SQL is 4 seconds, it is recommended to change to 60 seconds --- in SQLserver Enterprise Manager => Tools => Options => advanced .)

10. After registering SQLserver, you can see our remote server in the list on the left, such:

11. Click our remote server to expand the database. The database list on the server is displayed. Find the database name displayed in your order and click expand. For example:

12. Right-click the table, select all tasks, and select import data, as shown in:

13. The data import wizard is displayed, for example:

14. Select the server where you originally stored the database and the login method, as shown in:

15. The purpose of selection is the remote server of the company. The general content does not need to be modified;

16. Click Next, select, and click Next;

17. Select the table, view, and other data content you want to import, as shown in:

18. You can select all or manually;

19. After the selection, click Next. The following figure is displayed. Click Next as prompted.

20. Now, you have set up the database, modify the database link in your program, and modify the Server IP address, database name, login user name, and login password displayed in your order, to connect to the database.