knightforce777
asked on
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
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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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.