Tag Archives: SQL Server 6.5 troubleshooting

kernel udopen: operating system error 2 in SQL Server 6.5

 

 

One of my blog reader encountered below error, I have given him the below solution which has resolved this issue.

Error: (SQL Server 6.5)

2009/07/15 19:42:26.89 spid1    Activating disk ‘ITEMPRICE_DATA1’

2009/07/15 19:42:26.89 kernel   udopen: operating system error 2(The system cannot find the file specified.) during the creation/opening of physical device F:\DATA\ITEMPRICE_DATA1.DAT

2009/07/15 19:42:26.89 kernel   udactivate (primary): failed to open device F:\DATA\ITEMPRICE_DATA1.DAT for vdn 42

2009/07/15 19:42:26.89 spid1    Activating disk ‘ITEMPRICE_DATA2’

2009/07/15 19:42:26.89 kernel   udopen: operating system error 2(The system cannot find the file specified.) during the creation/opening of physical device F:\DATA\ITEMPRICE_DATA2.DAT

2009/07/15 19:42:26.89 kernel   udactivate (primary): failed to open device F:\DATA\ITEMPRICE_DATA2.DAT for vdn 43

Solution

1) Rebuilding System Databases by running setup again from the SQL Server Install CD and do a rebuild master.

2) If it’s a 6.5 box, you can go to the console and view the sa password in the registry. run regedit from the console:
HKEY_CURRENT_USER
Software
Microsoft
MSSQLServer
SQLEW
Registered
SQL 6.5
ServerName

3) Check for the directory whether F:\ has Data directory or not

4) Check if the drive was corrupted

4) Check the SQL Server Service running on which account, check the permission of that account

5) http://support.microsoft.com/kb/180500

6) http://support.microsoft.com/kb/236989

7) Go through BOL on SQL Server 6.5 startup parameters

8) Try to login using command prompt and execute Sp_Resetstatus, DBCC CheckDB etc

sqlservr -c -f -T3608 -T4022

9) Check all the databases status from sysdatabases