none
The database [ABC] is not accessible (ObjectExplorer)

    Question

  • 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

Answers

  • 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
    Thanks
    Kuldeep Bisht
    Technical Lead @ Simplion Technologies
    Blog : www.dbsimplified.com
    • 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