Is firewall preventing SQL Server from showing up in the EM?
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?
Software/Hardware used:
Software/Hardware used:
ASKED:
March 21, 2008 8:45 PM
UPDATED:
March 24, 2008 1:03 PM
Answer Wiki:
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.
To see all answers submitted to the Answer Wiki: View Answer History.
Check out my SQL Server blog “SQL Server with Mr Denny” for more SQL Server information.
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) .