question

colibri avatar image
colibri asked

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

Hello, 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.
ssmsmanagement-studio
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

· Write an Answer
Blackhawk-17 avatar image
Blackhawk-17 answered
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.
1 comment
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

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

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.