When the next dialog box opens you can click on the Finish 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.ġ4. Enter your Login name and Password – this will be used every time you connect to your SQL server.ġ2. When the next dialog box appears select 'The SQL Server login information that was assigned to me by the system administrator'.ġ0. The server should now be listed under Added servers, click on the Next button.Ĩ. From the Available Servers drop down menu, select the server alias you created earlier.ħ. The Register SQL Server wizard will now open.ĥ. When Enterprise Manager opens, right click SQL Server Group and select New SQL Server Registration.ģ. Your Server alias will now be configured, click on the Apply button.Ģ.

Enter the IP address of the Server your SQL database is located on, in the Server name text box.Ĩ. In the Server Alias text box enter a name for your SQL connection.Ħ. Linux and Windows ASP.NET, SQL, Coldfusion, and WebMatrix hosting backed by world class 24x7x365 toll. When Client Network Utility opens, click on the Alias tab.Ĥ. How to backup MS SQL 2000 with Enterprise Manager. Open SQL Server Client Network Utility.Ģ. Enter the SQL Server Name as sent in your Technical Details e-mail (for example: ) Click Next Select SQL Server Authentication as. When creating an SQL connection using SQL Server you will need to:ġ. Open Enterprise Manager and expand the list on the left hand side panel to navigate to SQL Server Group (default group) Right Click on SQL Server Group, select New SQL Server Registration. To connect to older version of MS SQL database (such as MS SQL 2000), you can use Enterprise Manager.īefore creating the connection to your SQL database ensure you have created the databse & user also make sure you know the IP Address of the server your SQL database is located on.

Sql server enterprise manager