SQL Server 2005 I get "The database is not accessible"

views:

answers:

SQL Server 2005 I get "The database is not accessible"

I have a computer working as a server with many SQL Server 2005 databases in it since two years ago.

Today, I don't know why, when I try to connect locally to any of the databases it gives me that error. It fails even if I'm logged in using Windows Authentication or as 'sa' user. It just wouldn't let me access the databases' info.

Could anybody explain me what's going on?

Database does not exist or it's offline etc.

First check, can you see the DB in the object explorer in SSMS?

gbn 2010-04-24 16:38:47

I'm connecting to the server using the SSMS already. It shows me the database list but it wouldn't let me see their content and info.

Brian Roisentul 2010-04-24 17:05:53

Well, I don't know what was going on. I ended up rebooting the server and it all started working fine as always.

Brian Roisentul 2010-04-24 17:38:34

I'd still worry if it takes a reboot... which doesn't really make sense unless the DB was offline as I mentioned

gbn 2010-04-27 19:32:16

ansaurus

tags:

views:

answers:

SQL Server 2005 I get "The database is not accessible"

related questions