Error attaching mdf file to sql server 2008 R2 -
when want attach mdf file sql server 2008 r2 following error:
title: microsoft sql server management studio
attach database failed server 'babak-pc'. (microsoft.sqlserver.smo)
------------------------------ additional information:
an exception occurred while executing transact-sql statement or batch. (microsoft.sqlserver.connectioninfo)
unable open physical file "c:\madrase\madrase\entekhab_vahed\entekhab_vahed.mdf". operating system error 5: "5(failed retrieve text error. reason: 15105)". (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
in other system can attach mdf file. why receiving error?
check if sql server service account has full permission on drive / folder copied mdf file. (right click on drive / folder >> properties >> security)
Comments
Post a Comment