Sql database inaccessible files

Solution to this error is simple but very important. Msg , Level 16, State 14, Line 1 A file activation error occurred. Diagnose and correct additional errors, and retry the operation. So pls tell me reasons of database on offline mode and suspect mode.

I am facing this issue at one of my clients system. See the SQL Server errorlog for details. Microsoft SQL Server,. Then also connects to Database. But clients databases are not visible. They are able to do data operation through applications from other PCs. Issue is only on accessing from SSMS. Additional messages in the SQL Server error log or system event log may provide more detail. This is a severe error condition that threatens database integrity and must be corrected immediately.

Active Oldest Votes. Improve this answer. Samson M. Adeyemo Samson M. Adeyemo 51 2 2 silver badges 3 3 bronze badges. Ben Ben Well basically, the computer is connected to a server, but my individual PC was reliant on that server. But while I was away from work, an error occurred only allowing me to log in as the Owner, therefore I had to grant the permission to the owner for me to be able to see everything from what I have previous done. Also, after reading up about role assignments, that's what I have done not knowing what the right term is.

I am also unable to create a database as well. You need to log in with a username which is already in the sysadmin server role. This usually includes the local Administrators group, so generally if you are a local admin you should be OK. If you are not you need to get someone who is to do this instead. Do you have a blog or a guide in which i could follow, because in all honesty, I don't have the foggiest in what I should be doing! When i try to add a Server Role or a Login it just throws this error message; User does not have permission to perform this action.

Show 2 more comments. Sign up or log in Sign up using Google. Sign up using Facebook. Sign up using Email and Password. Post as a guest Name. Email Required, but never shown. The Overflow Blog. Stack Gives Back Quick access. Search related threads. Remove From My Forums. Answered by:. Archived Forums. Sign in to vote. I am getting the following error with my database Database ' XXX' cannot be opened due to inaccessible files or insufficient memory or disk space.

Does anyone have any suggestion what caused this and how it can be fixed?