SSMS won't allow connection to databases.. getting errors


Management Studio won't allow me to connect to the databases.... I open SSMS and I get the following error....

The log for database 'tempdb' is not available. (Microsoft SQl Server, Error: 9001)

When I try to view the logs i get this error...

"Database 'msdb' cannot be opened due to inacesible files or insufficient memory space or disk space. (Microsoft SQL Server, Error: 945)

Your suggestions would be appreciated. I checked the drives and it does not appear like we are short on space at all. Thanks for your help.

more ▼

asked Jan 12, 2012 at 04:58 AM in Default

avatar image

151 15 15 17

(comments are locked)
10|1200 characters needed characters left

1 answer: sort voted first

Have the permissions for the folders or the files been changed? The SQL Server service needs access at the O/S level and the account is subject to security and permissions constraints as any other account.

more ▼

answered Jan 12, 2012 at 05:05 AM

avatar image

12.1k 30 36 42

Not to our knowledge.... we restarted the services and it is ok now. But not sure what caused this. Any ideas?

Jan 12, 2012 at 05:20 AM colibri
(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.



asked: Jan 12, 2012 at 04:58 AM

Seen: 1400 times

Last Updated: Jan 12, 2012 at 04:58 AM

Copyright 2018 Redgate Software. Privacy Policy