Opening SQL Server Enterprise Manager Reports an error

Asked By mindyarmstrong 0 points N/A Posted on - 09/04/2011

Hello Friends,

After Successful installation of MS SQL Server 2000, when I open my SQL Server Enterprise Manager and expand the node Local (Windows NT), the enterprise manager reports the following error, “A connection could not be established to (LOCAL)”

I don’t know the cause of the error, but sometimes it does not report.

SQL Server Enterprise Manager

A connection could not be established to (LOCAL).

Reason: SQL Server does not exist or access denied.

ConnectionOpen (Connect())..

Please verify SQL Server is running and check your SQL Server registration properties (by right-clicking on the (LOCAL)node) and try again.

• Status: Open
• Question Views: 1552
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: MS SQL Server

Answered By Sofia Zofia 0 points N/A #121540

Opening SQL Server Enterprise Manager Reports an error

The error which you have mentioned, there are many reasons for this.  How many times did you get this error.  This error is more common with SQL server 2008.   Which version you are using?

There are many reasons and the error is itself different in many cases.  I have solutions for these two cases.

(1) When the connection is starting you should not surround the name of  the server within brackets that is [ use these brackets  ()  ] and write this (localhost).

(2) The second reason is, fire wall of Windows which will deny connecting to your database which is hosted on servers.

You can do this  by following these steps start menu–> run–> you have to type wscui.cpl–> select exceptions–> Add port–> and then press enter.

About Sofia Zofia

Questions
5

Answers
11

Best Answers
2

• Vote Up 0 Vote Down

• Posted on - 09/10/2011
• Question Category: MS SQL Server