Attach/Dittach DB using Delphi

Thema durchsuchen

Ansicht

Themen-Optionen

Attach/Dittach DB using Delphi

Ein Thema von question · begonnen am 4. Dez 2013 · letzter Beitrag vom 4. Dez 2013

Vorheriger Beitrag

Nächster Beitrag

sx2008

Registriert seit: 15. Feb 2008
Ort: Baden-Württemberg
2.332 Beiträge

Delphi 2007 Professional

AW: Attach/Dittach DB using Delphi

4. Dez 2013, 20:08

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.

fork me on

Github