Attach/Dittach DB using Delphi

[question]

Hi,
I have created a button called "DBAttached" using delphi and i would like to attached a MSSQL DB by clicking on this button. i am using the following query

Code:

CREATE DATABASE [database_name] ON 
( FILENAME = 'C:\Program Files....\test.MDF'), 
( FILENAME = 'C:\Program Files ....\test_log.LDF')
 FOR ATTACH ;

but when i run the program and click on the button , i get the error "test.MDF" kann nicht geöffnet werden. Betriebssystemfehler 5: "5(Zugriff verweigert)".
if i run the SQL server management studio as a administrator, then i can attached/dittached any DB using SQL server management studio only,
but how i can do the same using delphi as well?

[Klaus01]

Hi,

can you put the database to some other folder (progData)?
In Program-files folder you don't have write permissions.

Best regards
Klaus

[question]

Hi Klaus,
yes, i have tried from another directory(c:\user\public) as well but it has the same problem

[sx2008]

your user account must have the disk admin server role to attach/detach databases.
The security system of the MS SQL server is quite complex and you need some time to understand it.
http://www.mssqlcity.com/articles/adm/sql70roles.htm
The local windows administrator has by default all rights on the SQL server.
If you're in the context of an normal windows user account you don't have the rights to create/delete/backup/attach/detach databases.