SQL Server Enterprise Manager blcoked by Firewall?

  • Thread starter Thread starter CJM
  • Start date Start date
C

CJM

I can't connect to the SQL Server instance on my own machin (XP SP2), form
other machines, even when I've logged into that machine as myseldf nor can
colleagues, who are also Domain Admins. The Domain Admins have admin rights
to my SQL server instance, and I am explicitly listed as an administrator
therefore the is no reason that I can see that there should be this problem.

The error message I am getting is:

"A connection could not be established to Servername.

Reason: SQL Server does not exist or access denied"

This is a recent occurance - previously I could do this with no problems at
all...

Recently a colleague has tighten up security and has controlled the windows
firewall via a Group Policy. I was wondering if this might be the problem??
Or is it a problem with the SQL security. I have the power to override this
if I know what ports need to be opened...

Any thoughts??
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Local Security Settings: why the long string *S-1-5-23498...? 1
SQL Server Enterprise Manager 1
errors while connecting to Sql server with DSN connect 1
MBSA complains about SQL Server Authentication Mode / Can't Fix BC 0
Error while trying to establish connection to SQL Server from MSVS2008 7
cannot install programs 1
No Admin Access 3
Managing A Remote Computer 2

Back
Top