Diagnosing Connections with SQL Databases and Enterprise Manager

Diagnosing problems with connecting to a SQL Database using Enterprise Manager or Connecting for the first time (Enterprise Manager V8.0 w/SQL 2000):

First check the ‘Client Network Utility’ that comes with SQL Server and its tools. The client network utility is accessible in the program group for SQL Server in the Start Menu. Load up the utility and check to make sure TCP/IP is the only Enabled protocol on the General tab. Having ‘Named Pipes’ in the enabled protocol list is a common problem. All that should be in the enabled list is TCP/IP.


Creating a SQL Server Alias in the Client Network Utility:

You can also create an Alias for the SQL server on the alias tab. On the alias tab click ‘Add’ and punch in the server name. Specify TCP/IP as the Network Library and enter the server name (Ex. SQL6.WEBCONTROLCENTER.COM ). Uncheck the Dynamically determine port option and manually specify 1433.
*The server alias and server name fields should be the same (Ex. SQL6.WEBCONTROLCENTER.COM). Click Ok and exit the client network utility.


Registering the Server in your Enterprise Manager Client:

Load up Enterprise Manager and click the + next to ‘Microsoft SQL Servers’ in the tree list on the left. Right click ‘SQL Server Group’ and click ‘New SQL Server Registration’. The Wizard should now display. Click ‘next’ and select your SQL server alias from the list and add it to the added servers list. Your alias should be the only one listed in the added server list. At the next window (Connect Using) specify ‘The SQL Server login information that was assigned to me by the system administrator’ and click next.

Now fill in your login name and password in the two fields provided under ‘Login automatically using my SQL Server account information.

[Knowing your login info : You can see your username and password by logging into the control center and going to SQL Admin within the domain menu. Select your SQL database and click ‘Info’.]

After you have filled in the login information, click next and leave the default Group name as ‘SQL Server Group’ and continue on with ‘Next’.

It should now be at the Completion page and show the name of your SQL server. Click ‘Finish’. If all went well and you haven’t any connection problems to the SQL server it should now display :

**Server registration completed.**

SQL6.WEBCONTROLCENTER.COM - Registered successfully. (SQL6.WEBCONTROLCENTER.COM was used as an example)

If you received an error message try checking your connection to the SQL server :

In Windows go to the dos console (Start-Run-type ‘command’ and press enter) and ping test the SQL server, type the following and press enter (Fill in your SQL server name) at the prompt :

Ping SQL6.WEBCONTROLCENTER.COM

If you receive replies (4) without packet loss you have a good connection. If you got an error, you may want to check with your ISP or diagnose a problem with your internet connection. Check to make sure you can bring up websites such as www.webcontrolcenter.com in your browser.

If you did get successful replies from the SQL server but still cannot register it in Enterprise Manager you might have a firewall problem and need to speak with your network administrator or ISP.

*After the SQL server was successfully registered in Enterprise Manager : The server should be listed in your tree under SQL Server Group. Click the plus and then the plus for ‘Databases’. Bringing up the databases folder may take some time as your Enterprise Manager client must get information on all the databases on the SQL server before you can access yours. In addition to that, your login will only have access to your database.

If you have any further questions or concerns, contact us at support@newtektechnologyservices.com or call 1-877-323-HOST and speak to support.

Add Feedback