SQL Server Manager shows "not connected"

Posted on 2006-04-06
Medium Priority
Last Modified: 2013-12-03
We are running BackupExec 9.1 (with latest service packs) and we had no problems until a 'data-storm' killed the network connections. (Someone cross-connected a hub in the conference room....)

When I restarted the server, it could not connect to the domain controller for credentials or group policy.

Anyway the situation now is this:

The BackupExec services won't start.  I have used the Veritas 'sp_detach_db' and 'sp_attache_db' procedure ( http://seer.support.veritas.com/docs/274102.htm ) and it indicates success.

However, the BE services still won't start.  I can manually stop and start the instance MSSQL$BKUPEXEC in the services manager, but it doesn't help.

I've tried deleted and allowing SQL to rebuild the log file, which it does with no problem.

The final piece of the puzzle:

The SQL Server Manager icon shows 'Not Connected'.  There is no 'red box' or 'green arrow' -- only an empty white circle.  I know that SQL 2000 can do this when there is no network connectivity.  Also, there is nothing listed in the 'services' drop down.

All network issues are resolved, and all other applications are working fine.

Any thoughts or help in resolving this would be greatly appreciated.

Thanks in advance!!

Question by:knightforce777
LVL 18

Accepted Solution

SjoerdVerweij earned 1500 total points
ID: 16392789
What does the server name in the Server Manager say? It should be MachineName\BkUpExec.

I think the services might be running, and your only problem is the Server Manager not having the correct instance name.

Author Comment

ID: 16393028

I typed that in manually, and it found the server, agent, trans -- etc.  And the light turned green!

Unfortuantely, I still can't get the Backup Exec Services started.

I did one other database test (outlined here: http://seer.support.veritas.com/docs/256661.htm )  and it came pack succesfull.

Still stumped.

Featured Post


Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Microsoft Access is a place to store data within tables and represent this stored data using multiple database objects such as in form of macros, forms, reports, etc. After a MS Access database is created there is need to improve the performance and…
MSSQL DB-maintenance also needs implementation of multiple activities. However, unprecedented errors can hamper the database management. In that case, deploying Stellar SQL Database Toolkit ensures fast and accurate database and backup repair as wel…
If you’ve ever visited a web page and noticed a cool font that you really liked the look of, but couldn’t figure out which font it was so that you could use it for your own work, then this video is for you! In this Micro Tutorial, you'll learn yo…
In this video, Percona Director of Solution Engineering Jon Tobin discusses the function and features of Percona Server for MongoDB. How Percona can help Percona can help you determine if Percona Server for MongoDB is the right solution for …
Suggested Courses

840 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question