Return to Question

I am trying to attach a database in SQL Server 2008 and I have .mdf file of database but I am getting an exception of

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

Unable to open the physical file "E:\Intelliscence\Backups\test (2011年07月19日)\Database\QBankDB.mdf". Operating system error 5: "5(Access is denied.)". (Microsoft SQL Server, Error: 5120)

I searched the solution of this problem and found one solution of access rights of database file but database file has already full control access rights. Now I want to attach this database or want to get script of this database. But How?

I know this is a duplicate question but all the solutions given in answers are not working for me that's why I am posting this question.

Please help me.

I am trying to attach a database in SQL Server 2008 and I have .mdf file of database but I am getting an exception of

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

Unable to open the physical file "E:\Intelliscence\Backups\test (2011年07月19日)\Database\QBankDB.mdf". Operating system error 5: "5(Access is denied.)". (Microsoft SQL Server, Error: 5120)

I searched the solution of this problem and found one solution of access rights of database file but database file has already full control access rights. Now I want to attach this database or want to get script of this database. But How?

I know this is a duplicate question but all the solutions given in answers are not working for me that's why I am posting this question.

Please help me.

I am trying to attach a database in SQL Server 2008 and I have .mdf file of database but I am getting an exception of

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

Unable to open the physical file "E:\Intelliscence\Backups\QBank (2011年07月19日)\Database\QBankDB.mdf". Operating system error 5: "5(Access is denied.)". (Microsoft SQL Server, Error: 5120)

I searched the solution of this problem and found one solution of access rights of database file but database file has already full control access rights. Now I want to attach this database or want to get script of this database. But How?

I know this is a duplicate question but all the solutions given in answers are not working for me that's why I am posting this question.

Please help me.

I am trying to attach a database in SQL Server 2008 and I have .mdf file of database but I am getting an exception of

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

Unable to open the physical file "E:\Intelliscence\Backups\test (2011年07月19日)\Database\QBankDB.mdf". Operating system error 5: "5(Access is denied.)". (Microsoft SQL Server, Error: 5120)

I searched the solution of this problem and found one solution of access rights of database file but database file has already full control access rights. Now I want to attach this database or want to get script of this database. But How?

I know this is a duplicate question but all the solutions given in answers are not working for me that's why I am posting this question.

Please help me.

I am trying to attach a database in SQL Server 2008 and I have .mdf file of database but I am getting an exception of

TITLE: Microsoft SQL Server Management Studio
------------------------------
Attach database failed for Server 'Bilal-PC'. (Microsoft.SqlServer.Smo)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.50.2500.0+((KJ_PCU_Main).110617-0026+)&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 "E:\Intelliscence\Backups\QBank (2011年07月19日)\Database\QBankDB.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
------------------------------
BUTTONS:
OK
------------------------------

I searched the solution of this problem and found one solution of access rights of database file but database file has already full control access rights. Now I want to attach this database or want to get script of this database. But How?

I know this is a duplicate question but all the solutions given in answers are not working for me that's why I am posting this question.

Please help me.

I am trying to attach a database in SQL Server 2008 and I have .mdf file of database but I am getting an exception of

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

Unable to open the physical file "E:\Intelliscence\Backups\QBank (2011年07月19日)\Database\QBankDB.mdf". Operating system error 5: "5(Access is denied.)". (Microsoft SQL Server, Error: 5120)

I searched the solution of this problem and found one solution of access rights of database file but database file has already full control access rights. Now I want to attach this database or want to get script of this database. But How?

I know this is a duplicate question but all the solutions given in answers are not working for me that's why I am posting this question.

Please help me.