Hi,
As you can see there are lot of errors in the error log.
FCB::Open failed: Could not open file D:\PROD\MSSQL.3\MSSQL\DATA\model.mdf for file number 1. OS error: 32(The process cannot access the file because it is being used by another process.).
Can you check which process is using this.
2009-08-03 23:48:28.15 spid25s Error: 17207, Severity: 16, State: 1.
2009-08-03 23:48:28.15 spid25s FCB::Open: Operating system error 2(The system cannot find the file specified.) occurred while creating or opening file 'D:\PROD\MSSQL.3\MSSQL\DATA\AspState.mdf'. Diagnose and correct the operating system error, and retry the operation.
2009-08-03 23:48:28.21 spid25s Error: 17204, Severity: 16, State: 1.
2009-08-03 23:48:28.21 spid25s FCB::Open failed: Could not open file D:\PROD\MSSQL.3\MSSQL\DATA\AspState.mdf for file number 1. OS error: 2(The system cannot find the file specified.).
2009-08-03 23:48:28.26 spid25s Error: 5120, Severity: 16, State: 101.
2009-08-03 23:48:28.26 spid25s Unable to open the physical file "D:\PROD\MSSQL.3\MSSQL\DATA\AspState.mdf". Operating system error 2: "2(The system cannot find the file specified.)".
2009-08-03 23:48:28.74 spid25s Error: 17207, Severity: 16, State: 1.
2009-08-03 23:48:28.74 spid25s FileMgr::StartLogFiles: Operating system error 2(The system cannot find the file specified.) occurred while creating or opening file 'D:\PROD\MSSQL.3\MSSQL\DATA\AspState_1.LDF'. Diagnose and correct the operating system error, and retry the operation.
2009-08-03 23:48:28.74 spid25s File activation failure. The physical file name "D:\PROD\MSSQL.3\MSSQL\DATA\AspState_1.LDF" may be incorrect.
2009-08-03 23:48:28.74 spid25s Starting up database 'ESS_ARCHIVE'.
2009-08-03 23:48:28.74 spid25s Error: 17207, Severity: 16, State: 1.
2009-08-03 23:48:28.74 spid25s FCB::Open: Operating system error 2(The system cannot find the file specified.) occurred while creating or opening file 'D:\PROD\MSSQL.3\MSSQL\DATA\ESS_ARCHIVE.mdf'. Diagnose and correct the operating system error, and retry the operation.
2009-08-03 23:48:28.74 spid25s Error: 17204, Severity: 16, State: 1.
2009-08-03 23:48:28.74 spid25s FCB::Open failed: Could not open file D:\PROD\MSSQL.3\MSSQL\DATA\ESS_ARCHIVE.mdf for file number 1. OS error: 2(The system cannot find the file specified.).
2009-08-03 23:48:28.74 spid25s Error: 5120, Severity: 16, State: 101.
2009-08-03 23:48:28.74 spid25s Unable to open the physical file "D:\PROD\MSSQL.3\MSSQL\DATA\ESS_ARCHIVE.mdf". Operating system error 2: "2(The system cannot find the file specified.)".
2009-08-03 23:48:28.76 spid25s Error: 17207, Severity: 16, State: 1.
2009-08-03 23:48:28.76 spid25s FileMgr::StartLogFiles: Operating system error 2(The system cannot find the file specified.) occurred while creating or opening file 'D:\PROD\MSSQL.3\MSSQL\Data\ESS_ARCHIVE_7.ldf'. Diagnose and correct the operating system error, and retry the operation.
2009-08-03 23:48:28.76 spid25s File activation failure. The physical file name "D:\PROD\MSSQL.3\MSSQL\Data\ESS_ARCHIVE_7.ldf" may be incorrect.
From the error log either the sqlserverservice account does not have sufficient permissions on folder
for databases aspstate and ess_archive. Try to resolve this by giving sufficient permissions.
2009-08-04 10:36:52.99 spid12s The current event was not reported to the Windows Events log. Operating system error = 31(A device attached to the system is not functioning.). You may need to clear the Windows Events log if it is full.
Can you take backup of windows logs and clear the logs. Because as it indicates that the windows log is full any errors will not be logged which makes it impossible to trace and sort any issues and also there is a device related error try to check what is it.
2009-08-04 10:37:04.56 Server The SQL Network Interface library could not deregister the Service Principal Name (SPN) for the SQL Server service. Error: 0x45b, state: 4. Administrator should deregister this SPN manually to avoid client authentication errors.
And finally there is a SPN problem which might be blocking your connection.
Refer http://www.sqlservercentral.com/Forums/Topic622068-146-1.aspx#bm623115
And also check whether firewall is blocking your connectivity.
[font="Verdana"]Thanks
Chandra Mohan[/font]