i am getting the following error MSSQL$SQLEXPRESS Application log on my server

0

TDSSNIClient initialization failed with error 0x80092004, status code 0x1. Reason: Initialization failed with an infrastructure error. Check for previous errors. Cannot find object or property.

TDSSNIClient initialization failed with error 0x80092004, status code 0x80. Reason: Unable to initialize SSL support. Cannot find object or property.

Initializing the FallBack certificate failed with error code: 1, state: 20, error number: 0.

From comments:

Log Name: Application Source: MSSQL$SQLEXPRESS Date: 2016-06-01 9:36:25 AM Event ID: 17204 Task Category: Server Level: Error Keywords: Classic User: N/A Computer: XXXXXXXXXXXX.XXXX Description: FCB::Open failed: Could not open file E:\sql12_main_t.obj.x86Release\sql\mkmastr\databases\mkmastr.proj\MSDBData.mdf for file number 1. OS error: 21(The device is not ready.).

Log Name: Application Source: MSSQL$SQLEXPRESS Date: 2016-06-01 9:36:25 AM Event ID: 17204 Task Category: Server Level: Error Keywords: Classic User: N/A Computer: xxxx.x..xxx Description: FCB::Open failed: Could not open file E:\sql12_main_t.obj.x86Release\sql\mkmastr\databases\mkmastr.proj\model.mdf for file number 1. OS error: 21(The device is not ready.).

Log Name: Application Source: MSSQL$SQLEXPRESS Date: 2016-06-01 9:36:25 AM Event ID: 17207 Task Category: Server Level: Error Keywords: Classic User: N/A Computer: XXXXXXX.XXXXXXX.XXXXX Description: FileMgr::StartLogFiles: Operating system error 2(The system cannot find the file specified.) occurred while creating or opening file 'E:\sql12_main_t.obj.x86Release\sql\mkmastr\databases\mkmastr.proj\MSDBLog.ldf'. Diagnose and correct the operating system error, and retry the operation.

sql-server
sql-server-2005
sql
asked on Server Fault Jun 1, 2016 by Ravinder Singh Gill • edited Jun 1, 2016 by Katherine Villyard

1 Answer

0

SQL Server is telling you it can't find some of your system databases (model and MSDB).

Verify that the files exist and that SQL Server has permission to access them. SQL is looking in E:\sql12_main_t.obj.x86Release\sql\mkmastr\databases\mkmastr.proj, and that's where they should be.

If they're not there, restore them from backup. (Did someone delete them?)

answered on Server Fault Jun 1, 2016 by Katherine Villyard

User contributions licensed under CC BY-SA 3.0