SQL Server Manager shows "not connected"

Posted on 2006-04-06
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 ( ) 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

    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


    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: )  and it came pack succesfull.

    Still stumped.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Do You Know the 4 Main Threat Actor Types?

    Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

    Suggested Solutions

    Introduction If you are not already aware of what you could use a table with sequential integer values for in SQL, you can read Delimited String Parsing in SQL Server 2005 or later ( by BrandonGalderisi (h…
    Using SQL Scripts we can save all the SQL queries as files that we use very frequently on our database later point of time. This is one of the feature present under SQL Workshop in Oracle Application Express.
    Video by: Steve
    Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
    Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

    737 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

    Need Help in Real-Time?

    Connect with top rated Experts

    18 Experts available now in Live!

    Get 1:1 Help Now