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.