SQL Server Manager shows "not connected"

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!!

Jon
knightforce777Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

SjoerdVerweijCommented:
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.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
knightforce777Author Commented:
Thanks!

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.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Fonts Typography

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.