Question

  Asked: Mar 21 2008   8:45 PM GMT
  Asked by: SQL Server Ask the Experts


Is firewall preventing SQL Server from showing up in the EM?


SQL Server, SQL Server security, MMC, SQL Server 2000, SQL Server Enterprise Manager

I have a corporate Dell Image laptop running SQL server 2000. Enterprise manager (EM) shows up without my registered SQL server (local or remote). When I try to re-register I see the other registered servers, however, they are grayed out.

When I use the MMC Snap-In from computer management, I can see my local SQL Server. All services, except MSSQLADHelper, are started. The listing on TCP port 1433, however, does not show that the SQL Server is established nor does it show a remote port. Could this be caused by a Dell firewall? My suspicions are that Dell IT added a fix to my PC to prevent me from using EM. Do you have any suggestions on what the problem could be?

Subscribe to Alerts! Get questions and answers delivered to your Inbox.


E-mail me updates on this question



   SUBSCRIBE

hidden modal window

Answer Wiki (Improve, edit or add to this answer)


 RATE THIS ANSWER
0
Click to Vote:
  •   0
  •  0



It's possible that it's a firewall problem, but not very likely.

Go to register a new server again, but this time disable the wizard and just type in the server name. This should then allow you to register the server with EM.
  • AddThis Social Bookmark Button

Browse more Questions and Answers on SQL Server and Microsoft Windows.

Looking for relevant SQL Server Whitepapers? Visit the SearchSQLServer.com Research Library.


Discuss This Answer


You must be logged-in to discuss a question. Log-in/Register

Mrdenny  |   Mar 22 2008  12:07AM GMT

Check out my SQL Server blog “SQL Server with Mr Denny” for more SQL Server information.

 

CF  |   Mar 24 2008  1:03PM GMT

Thanks for the response. I have attempted the registry of the server without the wizard.
I click action->New sqlserver group->click the subgroup radio enter a name. Nothing shows up on the main panel. Strange since this has been working for years.

however i see the registered sql servers in the list of subgroups (in the window that pops up) .