N/APosted on - 09/04/2011
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.
Please verify SQL Server is running and check your SQL Server registration properties (by right-clicking on the (LOCAL)node) and try again.
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.