The database XXXX is not accessible (ObjectExplorer)

• Phanit86

  Say Hey Kid

  Points: 673

  More actions

  March 9, 2017 at 4:03 am

  #1932472

  Hello All,

  Finally I solved the issue, reset the password of sa successfully. I thought its worth sharing the solution here which might help someone.
  Special Thanks to John for the hint to change service account to adm.

  1. Changed service account to adm (local admin)
  2. Started SQL in single user mode
  3. Run SSMS as administrator
  4. Added NT account as SQL login and set server role 'sysadmin'
  5. Restarted SQL in normal mode
  6. Logged in with NT user and reset 'sa' password.
  7. Finally changed back to service account in SQL configuration manager.

  Thanks,
  Phani.

• March 20, 2017 at 1:06 am

  This was removed by the editor as SPAM

• Jeff Moden

  SSC Guru

  Points: 1004372

  More actions

  March 20, 2017 at 5:31 pm

  #1934100

  JasonClark - Monday, March 20, 2017 1:06 AM

  Phanit86 - Wednesday, March 8, 2017 7:23 AM

  Hello Experts,

  First of all I am not a DBA guy and have only limited knowledge on SQL server DB. 🙂
  We are using SQL 2008 as a database and currently facing issue when try to access the database. The OS user 'adm' was used to install SQL db on our server long back by previous colleague, when I try to login to system with OS user adm and access our db in management studio, it says "The database <DbName> is not accessible (object explorer)".

  I do not have any other users available to access this database.

  Thanks,
  Phani.

  For this you have to connect database to single user mode.
  Single-user mode enables any member of the computer's local Administrators group to connect to the instance of SQL Server as a member of the sysadmin fixed server role.
  Have a look here: http://stackoverflow.com/questions/26200697/sql-server-login-success-but-the-database-dbname-is-not-accessible-object

  Hope!! this will help you........

  Did you read the post immediately above yours? 😉

  --Jeff Moden

  ---

  RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
  First step towards the paradigm shift of writing Set Based code:
  ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

  Change is inevitable... Change for the better is not.
  

  ---

  Helpful Links:
  How to post code problems
  How to Post Performance Problems
  Create a Tally Function (fnTally)