How can I open multiple databases in SQL Server Enterprise Manager?
Top : General Technical Support : Microsoft SQL Server
| Article ID: |
 |
000022 |
| Rating: |
|
5.0 / 5.0 (3 votes)
|
| Views: |
|
3658 |
|
|
How can I open multiple databases in SQL Server Enterprise Manager?
|
- Create SQL Server Alias (Please repeat the following steps if you want to open mutiple databases)
- Open SQL Server Client Network Utility.
- When Client Network Utility opens, click on the Alias tab.
- Click on the Add button.
- In the Server Alias text box enter a name for your SQL connection.
- Select TCP/IP under Network libraries
- Enter the IP address of the Server your SQL database is located on, in the Server name text box.
- Click on the OK button.
- Your Server alias will now be configured, click on the Apply button.
- Click on the OK button.
- Create SQL Server Connection in Enterprise Manager (Please repeat the following steps if you want to open mutiple databases)
- Open SQL Server Enterprise Manager
- When Enterprise Manager opens, right click SQL Server Group and select New SQL Server Registration.
- The Register SQL Server wizard will now open.
- Click on the Next button.
- From the Available Servers drop down menu, select the server alias you created earlier.
- Click on the Add button.
- The server should now be listed under Added servers, click on the Next button.
- When the next dialog box appears select "The SQL Server login information that was assigned to me by the system administrator" (see above).
- Click on the Next button.
- Enter your Login name and Password ? this will be used every time you connect to your SQL server.
- Click on the Next button.
- Ensure that "Add the SQL Server(s) to an existing SQL Server group" is selected and "SQL Server Group" is selected for Group name.
- Click on the Next button.
- When the next dialog box opens you can click on the Finish button.
- Your SQL Connection will now be created.
|
