Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Some User Databases gone suspect during SQL Server 2000 Service account change Expand / Collapse
Author
Message
Posted Sunday, May 3, 2009 11:08 AM


SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Monday, June 16, 2014 9:46 PM
Points: 284, Visits: 263

While replacing the SQL Server Service account with new Windows Domain account getting the below error message for the User Database files which are not on the default database path. It seems to be of the new service account does not have privileges on this folders.

2009-05-03 20:09:00.88 spid15 Starting up database 'UserDB_UAT'. 0
2009-05-03 20:09:00.88 spid15 udopen: Operating system error 5(error not found) during the creation/opening of physical device D:\UserDB_UAT\UserDB_UAT_Data.Mdf. 0
2009-05-03 20:09:00.88 spid15 FCB::Open failed: Could not open device D:\UserDB_UAT\UserDB_UAT_Data.Mdf for virtual device number (VDN) 1. 0
2009-05-03 20:09:00.88 spid15 Device activation error. The physical file name 'D:\UserDB_UAT\UserDB_UAT_Data.Mdf' may be incorrect. 0
2009-05-03 20:09:00.88 spid15 udopen: Operating system error 5(error not found) during the creation/opening of physical device D:\UserDB_UAT\UserDB_UAT_Log.Ldf. 0
2009-05-03 20:09:00.88 spid15 FCB::Open failed: Could not open device D:\UserDB_UAT\UserDB_UAT_Log.Ldf for virtual device number (VDN) 2. 0
2009-05-03 20:09:00.88 spid15 Device activation error. The physical file name 'D:\UserDB_UAT\UserDB_UAT_Log.Ldf' may be incorrect. 0
2009-05-03 20:09:00.88 spid15 Device activation error. The physical file name 'D:\UserDB_UAT\UserDB_UAT_Log.Ldf' may be incorrect.


Sivaprasad S - [ SIVA ]http://sivasql.blogspot.com/
Post #709066
Posted Monday, May 4, 2009 5:28 AM


SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Tuesday, March 18, 2014 1:42 AM
Points: 448, Visits: 322
Yes, it looks like the new service account does not have access to the folders specified. Try giving the new service account full access to the folders and see what happens. I am assuming that giving full permissions will resolve your issue.

-Hope is a heuristic search ~Hemanth
Post #709317
Posted Thursday, May 7, 2009 10:57 AM


SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Monday, June 16, 2014 9:46 PM
Points: 284, Visits: 263
Granting "Full Control" on the folders, solved the issue.

Sivaprasad S - [ SIVA ]http://sivasql.blogspot.com/
Post #712233
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse