Error: The database is not accessible. ( object explorer)

  • I created a new user with administrator rights in Windows7. I can connect to the server instance , and see the list of dbs but I cannot expand any of them because of the error I mentioned . Please help.

  • hlsc1983 (3/25/2016)


    I created a new user with administrator rights in Windows7. I can connect to the server instance , and see the list of dbs but I cannot expand any of them because of the error I mentioned . Please help.

    The account got a login, but it might not have a user for the databases.

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2
  • So what am I supposed to do?

  • You must create a user for that login on each database.

    https://msdn.microsoft.com/en-us/library/ms173463.aspx

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply