5
Answers

The database is not accessible. (ObjectExplorer)

Hi everyone,
I am using Sql Server 2012 edition, when I want to open any database from Management Studio it shows an error "The database codeXDB is not accessible. (ObjectExplorer)".
 
The problem was occurring when I had created a new User Account in windows, and the problem arrises and now I had deleted my old user account but had kept the data as backup.
 
Can anyone help me to resolve this issue. It would be really appreciated.
 
Thanks
Devendra 
Answers (5)
1
Amit Gupta

Amit Gupta

NA 16.5k 25.7k 8y
Hey Devendra
There might be any software glitches, take the backup of your database from the physical path located at
C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\DATA
 
then reinstall the Sql Server again, then try attaching all your database.
 
Hope this helps :) 
Accepted
2
Daniel Jones

Daniel Jones

NA 367 19.7k 8y
Go to > Security > Logins > Right click to the user > Properties
On the left navigation move to > User Mapping > Check the database and in the "Database role membership for: <>" check "db_owner"
  
Or just restart the SQL service, sometime it also helps 
1
Devendra Kumar

Devendra Kumar

NA 264 11.9k 8y
@Rafnas, already tried, also restarted the service but :(
1
Devendra Kumar

Devendra Kumar

NA 264 11.9k 8y
Thanks Daniel, The error still exists as master/any database was also not accessible. Logins section displays only builtin\users and sa
0
Rafnas T P

Rafnas T P

NA 12.2k 435.7k 8y
try running in administrator mode, to do that
right click on SQL Server Management Studio and select run as administrator