Unable to open physical file - Operating system error 5: 5(error not found) Microsoft SQL Server: Error 5120
I am trying to attach a database to SQL 2005. This database has not previously been attached. I have only just installed SQL.
I get the following message: Unable to open physical file "C:\ArrowSQL\Arr@Data\Arrow_data.mdf" Operating system error 5: "5(error not found)" (Microsoft SQL Server: Error 5120)".
I have loaded SQL and the database fiel and directory with the same user acccount which is a local adminstrator ont hsi machine. I have checked that I have read/write access to the file.
The machine runs Windows Vista Business. SQL has SP 2 loaded.
Use the below script to find the sql service account
declare @sqlser varchar(20)
EXEC master..xp_regread @rootkey='HKEY_LOCAL_MACHINE',@key='SYSTEM\CurrentControlSet\Services\MSSQLSERVER',
@value_name='objectname', @value=@sqlser OUTPUT
PRINT 'Account Starting SQL Server Service:' +convert(varchar(30),@sqlser)
After getting the service account try the below steps to provide privilege
- Right click on the folder C:\ArrowSQL\Arr@Data and click on properties
- Click on security tab
- Click on Add button and add sql service account
- Provide modify privilege and click ok
- Verify both mdf and ldf have modify privilege
- Attach the db!
You can also try the below alternate method to find service account
For SQL 2000MSSQLSERVER -- for default instanceMSSQL$instancename -- for named instance
- Goto RUN
- Type services.msc & press enter
- In service control manager find the below service w.r.t to your edition.
For SQL 2005 & SQL 2008SQL Server (MSSQLSERVER) -- for default instanceSQL Server (instancename) -- for named instance
- Check the "Log On as" for the SQL service and provide modify privilege to that ID in the folder.
For More Details, Click Here
Best International Wedding Rings - Titanium GirlsReplyDelete
T'S titanium glasses Thar and Stryker, titanium forging T'S Thar and silicone dab rig with titanium nail Stryker, T'S Thar and Stryker - T'S Thar and Stryker - T'S Thar 2020 edge titanium and Stryker - T'S Thar and Stryker - T'S Thar and Stryker - T'S Thar and Stryker - T'S Thar used ford fusion titanium and Stryker - T'S
1xbet - No 1xbet Casino | Live dealer casino onlineReplyDelete
1xbet is a reliable casino site 1xbet app that offers a great casino games from the best software 메이피로출장마사지 providers for https://octcasino.com/ the regulated gambling markets. worrione Rating: 8/10 · Review by a Tripadvisor user · Free · communitykhabar Sports
my blog sex toys,sex chair,sex toys,dildo,wholesale sex toys,male sex doll,sex toys,dildo,horse dildo you could try hereReplyDelete