Tell me more ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.
up vote 4 down vote favorite

I installed sql server 2008 on windows 7 then i create a Database! after 2 days, i reinstall the windows and isntall the sql server! now i am trying to attach my database file, bot i encounter to bellow error. i think that the files are like a attached file and i cant attach them. what is diffrence of an attached file and a not attached file? how can i to attach this file? Please Help Me.

Error Text:

TITLE: Microsoft SQL Server Management Studio

Attach database failed for Server 'AMIR-PC'. (Microsoft.SqlServer.Smo)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.50.1600.1+((KJ_RTM).100402-1540+)&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Attach+database+Server&LinkId=20476

ADDITIONAL INFORMATION:

An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)

Unable to open the physical file "F:\Company.mdf". Operating system error 5: "5(Access is denied.)". (Microsoft SQL Server, Error: 5120)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.50.1600&EvtSrc=MSSQLServer&EvtID=5120&LinkId=20476

share|improve this question
Crossposted - serverfault.com/questions/403413/… – squillman Jun 29 '12 at 15:12

migrated from stackoverflow.com Jun 29 '12 at 14:59

2 Answers

up vote 5 down vote

I'm pretty sure the problem is that due to the uninstall/reinstall of SQL Server, the database engine no longer has permissions on the database files.

If you move the .mdf and .ldf files to the data folder that you specified on install, it should work for you. If you want to keep the files where they are, make sure the permissions are configured to allow appropriate access to the database engine service account group.

share|improve this answer
Ok.. Very Very GooooooooooooD! Thanks A Lot for your answer! I moved Th .mdf & .ldf databases File To "C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER2\MSSQL\DATA" Folder And I Successed to attach the Files! But i dont know how to change database engine permision To Attach the files without moving! How To Change Permision for allow access my database file? – user9772 Jun 30 '12 at 20:57
@Amir: See here: superuser.com/questions/194365/… – Jon Seigel Jul 1 '12 at 13:06
up vote 0 down vote

I had this issue and the solution was to Run SSMS as Administrator. I blogged about it here.

share|improve this answer
1  
We don't appreciate multiple widespread answers like this. If you want to link to your blog, that's fine, but the answer should be substantive and should stand on its own. I'm removing duplicate posts because they aren't helpful as-is. – jcolebrand♦ Oct 17 '12 at 15:25

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.