Trying to connect to a server/database on SMSS

Ben Westall 1 Reputation point
2021-08-23T11:24:48.743+00:00

I am trying to connect to a third party database (Elmhurst) to edit the data contained within it, however I am getting the following error message whenever I try to connect to the database.

"The database DesignSAP2012Desktop is not accessible. (ObjectExplorer).

Details:

===================================

The database DesignSAP2012Desktop is not accessible. (ObjectExplorer)


Program Location:

at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.DatabaseNavigableItem.get_CanGetChildren()
at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.NavigableItem.RequestChildren(IGetChildrenRequest request)
at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.ExplorerHierarchyNode.BuildChildren(WaitHandle quitEvent)

I've used the software for this function in the past however I didn't set it up myself and I'm a beginner with the software. If anyone can help me please explain it to me in simplistic terms.

Thanks.

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,869 questions
0 comments No comments
{count} votes

4 answers

Sort by: Most helpful
  1. Olaf Helper 41,021 Reputation points
    2021-08-23T11:36:49.937+00:00

    The database DesignSAP2012Desktop is not accessible

    As the message says, the DB is not accessible, e.g. because it is in recovery mode.
    Connect with SSMS to SQL Server + "master2 database and check the state of the DB.

    select name, state_desc
    from sys.databases
    
    0 comments No comments

  2. YufeiShao-msft 7,061 Reputation points
    2021-08-24T06:50:44.867+00:00

    Hi @Ben Westall ,

    This may be a permission issue, perhaps this user login does not have the relevant permission to manage the database.
    You can login with sa and expand Security>Login, right click on the username you need and then properties
    125913-8241.png

    click User Mapping and select the DB you want the user to access and then you can try connecting with the newly checked user.
    125788-8242.png

    0 comments No comments

  3. Kulandhaisamy, Jerome Gerald 0 Reputation points
    2023-12-07T18:09:02.28+00:00

    No...that is not a right solution..that is not working

    0 comments No comments

  4. John Bylsma 0 Reputation points
    2024-02-28T03:56:21.49+00:00

    I was experiencing this same issue and finally figured out what happened. I restored a database and had to recreate the users. Login XYZ already existed, so I added XYZ to the restored database. Somehow though, those the login XYZ didn't seem to connect to the user XYZ. I deleted the database user XYZ, and then remapped the server login XYZ to that database, added proper schemas and then it worked again. Hope this helps.