May 3, 2009 at 11:08 am
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.
May 4, 2009 at 5:28 am
[font="Verdana"]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.[/font]
May 7, 2009 at 10:57 am
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply