Connecting to MS SQL DB via Enterprise Manager

[Munchio]

Hi,

I have SQL Server 2000 on my computer, and I would like to connect to the MS SQL Server database that my website hosting is using via enterprise manager on my computer.

I just don't know what settings I need to use, such as the server name to connect to, and any other settings I might need.

Can anyone point me in the right direction? Many thanks!

[eUKhost.com]

In order to use MS SQL Server Enterprise Manager to connect to your ms SQL Server Database you will first need to establish a connection using the MS Client Network Utility which was also installed when you installed Enterprise Manager on your local machine.

Follow the steps given below to establish the connection :-

1. Open the SQL Server Client Network Utility (Start -> Programs -> Microsoft SQL Server -> Client Network Utility)
2. Click on the "Alias" tab.
3. Click "Add" and enter the following information:
1. Server Alias - eUKSupportHost (This is an example)
2. Network Library - TCP/IP
3. Computer Name - Put_IP_Address_Here.
4. Port Number - 1533 (Or else the port number which is in use)
4. Click OK.
5. Click OK again - This will close out your Client Network Utility session.
6. Open Enterprise Manager.
7. Right Click "Microsoft SQL Servers" and select "New SQL Server Registration" This will open a wizard.
8. Click Next.
9. Select "eUKSupportHost" from the list of available servers and "Add" it.
10. Click Next.
11. Choose to connect using SQL Server Authentication.
12. Enter your assigned SQL Server username and password.
13. Keep clicking next until the wizard is completed.

[Munchio]

Brilliant, works like a charm!

Thanks very much

[annejes]

In order to use MS SQL Server Enterprise Manager to connect to your ms SQL Server Database you will first need to establish a connection using the MS Client Network Utility which was also installed when you installed Enterprise Manager on your local machine.

Follow the steps given below to establish the connection :-

1. Open the SQL Server Client Network Utility (Start -> Programs -> Microsoft SQL Server -> Client Network Utility)
2. Click on the "Alias" tab.
3. Click "Add" and enter the following information:
1. Server Alias - eUKSupportHost (This is an example)
2. Network Library - TCP/IP
3. Computer Name - Put_IP_Address_Here.
4. Port Number - 1533 (Or else the port number which is in use)
4. Click OK.
5. Click OK again - This will close out your Client Network Utility session.
6. Open Enterprise Manager.
7. Right Click "Microsoft SQL Servers" and select "New SQL Server Registration" This will open a wizard.
8. Click Next.
9. Select "eUKSupportHost" from the list of available servers and "Add" it.
10. Click Next.
11. Choose to connect using SQL Server Authentication.
12. Enter your assigned SQL Server username and password.
13. Keep clicking next until the wizard is completed.

I have SQL Server 2008 on my computer, and I would like to connect to the MS SQL Server database that my website hosting is using via enterprise manager on my computer.

[Rock]

I have SQL Server 2008 on my computer, and I would like to connect to the MS SQL Server database that my website hosting is using via enterprise manager on my computer.

You can do so by following the steps mentioned above.. please let know if you notice any problems with that

[AmyJNelson]

To connect to Microsoft SQL Server use following code:
use strict;

use warnings;

use DBI;

my $dsn = "DBI:ODBC:driver={SQL Server};server=XENU-PC\\SQLEXPRESS;database=foobar;";

my $dbh = DBI->connect($dsn, 'username', 'password'); #connect to database
Please note that you need to enable TCP/IP protocol in SQL Server Configuration Manager.