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

Tags:
Microsoft SQL Server 2000
MMC
SQL Server
SQL Server Enterprise Manager
SQL Server security
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?

Answer Wiki

Thanks. We'll let you know when a new response is added.

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.

Discuss This Question: 2  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Denny Cherry
    Check out my SQL Server blog "SQL Server with Mr Denny" for more SQL Server information.
    66,360 pointsBadges:
    report
  • CF
    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) .
    10 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following