Some User Databases gone suspect during SQL Server 2000 Service account change

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 7,2000 » Administration » Some User Databases gone suspect during SQL...

Some User Databases gone suspect during SQL Server 2000 Service account change

Rate Topic

Display Mode

Topic Options

Author

Message

sivaprasad

Posted Sunday, May 03, 2009 11:08 AM

SSC Veteran

Group: General Forum Members
Last Login: Friday, November 09, 2012 6:06 PM
Points: 284, Visits: 260

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

hemanth.damecharla

Posted Monday, May 04, 2009 5:28 AM

SSC-Addicted

Group: General Forum Members
Last Login: Wednesday, February 27, 2013 8:41 PM
Points: 448, Visits: 320

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

sivaprasad

Posted Thursday, May 07, 2009 10:57 AM

SSC Veteran

Group: General Forum Members
Last Login: Friday, November 09, 2012 6:06 PM
Points: 284, Visits: 260

Granting "Full Control" on the folders, solved the issue.

Sivaprasad S - [ SIVA ]http://sivasql.blogspot.com/

Post #712233

« Prev Topic | Next Topic »

Permissions