database not visible

  • we have a application were it connects to the sql server database and it works fine.

    but when we try to connect using the management studio the database is not visible...

    Could someone help me please with this issue....

    it is a Sql server 2008 Express edition.

  • What user are you connecting to the database server as in SSMS? If it's not sa, then make sure that the user you are logging in as has permission to access the database.

  • Login as SA or any user who has System Admin privileges on that instance. Check the permissions for that database.

    Pradeep Adiga
    Blog: sqldbadiaries.com
    Twitter: @pradeepadiga

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

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