The database [ABC] is not accessible (ObjectExplorer)


  • Hi,

    I am getting an error while accessing the database ABC (which I Created.) and the error is below.


    The database is not accessible (ObjectExplorer

    The database ABC is not accessible. (ObjectExplorer)



    Program Location:


       at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.DatabaseNavigableItem.get_CanGetChildren()

       at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.NavigableItem.GetChildren(IGetChildrenRequest request)

       at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.ExplorerHierarchyNode.BuildChildren(WaitHandle quitEvent)

    I am not able to access the tables in the SQL Authentication mode but able to access in Windows Authentication mode.


    Please Help

    Thanks in Advance


    Monday, October 24, 2011 1:34 PM


  • Your SQL Authenticated Login Doesn't Have Permission On That Database. Can you check it by Going To Security --> Login-->Right and Click Property and then goto user mapping tab.



    Mark as Answer If Reply Was Helpful
    Kuldeep Bisht
    Technical Lead @ Simplion Technologies
    Blog :
    • Proposed as answer by Iric WenModerator Wednesday, October 26, 2011 7:39 AM
    • Marked as answer by Stephanie Lv Tuesday, November 01, 2011 7:09 AM
    Monday, October 24, 2011 3:29 PM

All replies