Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-11-01 : 08:32:31
|
| Sherry writes "Windows 2000 / Sql Server 2000We changed the account running sqlserver and sqlagent from the local system account to a domain account. The domain account was added to the local administrators group. When we restarted SQL server, any database that was on the D drive came up as (suspect). After looking at the logs, we saw the pattern. Databases on C were fine. Databases on D were suspect. The error in the log is 'FCB::Open Failed: Could not open device d:\sqldata\sgtrs.mdf for virtual device. I can see the d drive with both windows explorer and file manager. Logged in as the domain account, I can create a .txt file on the d drive. When I try to create a test database on the d drive, it gives this error: Error:5123 Create file encountered operating system error 5. Access is denied. We looked at the ACL for the files, and directories, but they all had full control.Perplexed, we put it back and all is fine. But why?" |
|
|
|
|
|
Error 5123 Access is denied