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)

for help, click: http://go.microsoft.com/fwlink?prodname=microsoft+sql+server&prodver=10.50.1600.1+((kj_rtm).100402-1540+)&evtsrc=microsoft.sqlserver.management.smo.exceptiontemplates.failedoperationexceptiontext&evtid=attach+database+server&linkid=20476

------------------------------ 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

Popular posts from this blog

javascript - RequestAnimationFrame not working when exiting fullscreen switching space on Safari -

Python ctypes access violation with const pointer arguments -