SQL Server : login success but "The database [dbName] is not accessible. (ObjectExplorer)" -

SQL Server : login success but "The database [dbName] is not accessible. (ObjectExplorer)" -

i using windows 8.1 , sql server 2012.

i using os business relationship "manoj" accessing sql server windows authentication. have deleted user business relationship "manoj" of os , created new business relationship same name "manoj".

but scheme took new business relationship "manoj_2". alter keeps me out accessing old databases, have created.

it says

the database [dbname] not accessible. (objectexplorer)

whenever seek access of previous dbs have created.

i used create new login in sql server "manoj_2", default db "master". still problem persists.

i cannot able detach dbs. unable expand dbs.

note: in os, have admin rights "manoj" account.

please tell me, do? either os or sql server

for situation have connect database in single-user mode.

starting sql server in single-user mode enables fellow member of computer's local administrators grouping connect instance of sql server fellow member of sysadmin fixed server role.

here can find step-by-step instruction this.

in short must start sqlserver instance parameters -m, after start sql server management studio windows authentication.

now sysadmin, assign sysadmin role user, exit , remove -m parameter , restart sql server.

sql-server login