"SQL Server does not exist or access denied."
When I open the enterprise manager, no items are displayed. Also, the service manager is running, so I can't even run a database backup. I usually end up in reinstalling the SQL Server 2000. How should I approach this problem?
When you open Enterprise Manager and are unable to see the servers, this is probably because you have not registered any SQL Servers on the server or workstation that you are using. I would try the registration process to access the SQL Server.
Dig Deeper on Microsoft SQL Server Performance Monitoring and Tuning
Related Q&A from Jeremy Kadlec
Adding non-clustered indexes to SQL Server columns and tables frequently queried is possible. Learn how to add non-clustered indexes to SQL Server ... Continue Reading
Learn how to view a query execution plan in SQL Server with SQL Server Management Studio or Query Analyzer. Review and decrease query plan sub tree ... Continue Reading
Want to change the collation to SQL Server 2005 standards after upgrading databases from SQL Server 2000? Learn the best approach involving DTS and ... Continue Reading