Microsoft sql server 2005 error 5120

Depending on the type of operation opening databases during server startup, attaching a database, database restore, and so on , the account that is used for impersonation and accessing the database file may vary. Review the topic Securing Data and Log Files to understand which operation sets what permission and to which accounts. If you cannot re-attach a database that resides on network-attached storage, a message like this may be logged in the Application log.

Operating system error 5: Access is denied. This problem occurs because SQL Server resets the file permissions when the database is detached. When you try to reattach the database, a failure occurs because of limited share permissions. For more information about how to change the startup parameters, see Database Engine Service Startup Options.

Possible duplicate - stackoverflow. It looks like you are trying to attach it as a directory, rather than a physical file. Where is the filename? Are you attaching it via T-SQL? If so, can you specify the full T-SQL command? Add a comment. Active Oldest Votes. Improve this answer. Sameer Alibhai 2, 4 4 gold badges 33 33 silver badges 36 36 bronze badges.

Make sure to also update permission for the log file as well. Pro tip: pictures of text aren't as useful as the actual text. Ben Thul Ben Thul The way I found I needed to "fix permissions" wasn't how one might think - there was actually no "Security" tab on the files when you right-click the. I had to re-navigate in Windows File Explorer to the location of the databases. When I did, I was prompted with the User Access Control dialog - clicked Continue - it must've applied permissions though still no "Security" tab to confirm because then I was able to attach the DB files.

Follow Following. Mirza Husain Join 1, other followers. Sign me up. Already have a WordPress. Log in now.

Loading Comments Post was not sent - check your email addresses! Sorry, your blog cannot share posts by email. I do not have access to the security tab since the database is not available. Msg , Level 16, State 1, Line 1. He holds a Masters of Science degree and numerous database certifications. Pinal is an experienced and dedicated professional with a deep commitment to flawless customer service. Nupur Dave is a social media enthusiast and an independent consultant.

She primarily focuses on the database domain, helping clients build short and long term multi-channel campaigns to drive leads for their sales pipeline. Is your SQL Server running slow and you want to speed it up without sharing server credentials?

In my Comprehensive Database Performance Health Check , we can work together remotely and resolve your biggest performance troublemakers in less than 4 hours. Once you learn my business secrets, you will fix the majority of problems in the future. SQL Tips and Tricks. FIX Error First step was to find the Service account, which can be done by opening configuration manager.