October 23, 2014 at 5:38 am
hi,
i was copy mdf and ldf file to disk and write dto disk and i have copy file from disk to drive e:
and i will attach file form drive e can not attach file.
errore
TITLE: Microsoft SQL Server Management Studio
------------------------------
Attach database failed for Server 'FARASSOO-PC'. (Microsoft.SqlServer.Smo)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.50.1600.1+((KJ_RTM).100402-1539+)&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Attach+database+Server&LinkId=20476
------------------------------
ADDITIONAL INFORMATION:
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)
------------------------------
Unable to open the physical file "E:\c#1\bimeh\table\bimeh_Data.MDF". Operating system error 5: "5(failed to retrieve text for this 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
------------------------------
please help me
October 23, 2014 at 6:30 am
Error code 5 is an access denied message. It means that the account that your SQL Server service is running under doesn't have access to the location where you have placed your database files.
System error codes can be looked up here:
http://msdn.microsoft.com/en-gb/library/windows/desktop/ms681382(v=vs.85).aspx
October 23, 2014 at 8:45 am
very very thanks my problem resolved to change location file sql .
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply