Connecting and managing remote MS SQL databases with Enterprise Manager

First, please from your space business to get your MSSQL related management information, such as:

User TestUser's MSSQL server address: xxx.xxx.xxx.xxx

The port of the user testuser MSSQL is: 1433

User TestUser's MSSQL database is named: TestUser

User TestUser's MSSQL user name is: TestUser

User TestUser's MSSQL password is: "Hu Jintao" (the user's personal login password)

Second, the database connection steps:

1. Open local SQL Server Enterprise Manager

2, the right mouse button to open the SQL Server group properties, click New SQL Server registration, enter the Welcome to register the SQL Server Registration wizard page

3. Click next to select SQL Server server, enter the IP address or server name of the database server you want to link to in the Available server input box

4. Click the Add button to add the server you want to link to the Added Servers list box

5, click Next button to enter the authentication mode

6. Select the SQL Server login information assigned to me by the system administrator (SQL Server Authentication)

7, click Next to enter the "Select connection Options" page, using the "Automatically log in with my SQL Server account information" option, enter your login name and password

8, click Next, go to the "Select SQL Server Group" Information page, select the "Add SQL Server (A)" option in an existing SQL Server group, select the default group name

9. Click Next to go to the "Completing the Register SQL Server Wizard" page

10, click the Completion button, enter the "register SQL Server Message" page, the system prompts registration success, click the Close button, that is, complete the server database connection

11, click already connected database server---> Click on the database folder, expand the database to the image, double-click the database name you want to operate, expand the database to the image, click on the table branch to the image, the right content frame display your database table list information

12. You can then operate your database as you would a local database.