Attach database failed for server -
i trying attach database in sql server 2008 , have .mdf file of database getting exception of
attach database failed server 'bilal-pc'. (microsoft.sqlserver.smo)
unable open physical file "e:\intelliscence\backups\test (2011-07-19)\database\qbankdb.mdf". operating system error 5: "5(access denied.)". (microsoft sql server, error: 5120)
i searched solution of problem , found 1 solution of access rights of database file database file has full control access rights. want attach database or want script of database. how?
i know duplicate question solutions given in answers not working me that's why posting question.
please me.
the error message seems pretty straightforward: access denied. need make sure sql server service account has adequate permissions on e:\intelliscence\backups\qbank (2011-07-19)\database\, or move mdf/ldf files data/log folders instance (where shouldn't problem).
Comments
Post a Comment