preloader-matrix

Alfasith

FCB::Open failed: Could not open file D:TempDBtempdb.mdf for file number 1. OS error: 3(The system cannot find the path specified.). SQL 2014

Hi,

Either of these below error persist in the SQL service stop then you need to check the Database location exist. (Particularly tempdb).

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

Unable to initialize SSL encryption because a valid certificate could not be found, and it is not possible to create a self-signed certificate.

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.

SQL Server could not spawn FRunCommunicationsManager thread. Check the SQL Server error log and the Windows event logs for information about possible related problems.

Solution:
1. Needs to check the existence of D:TempDBtempdb.mdf directory and file.
2. If not please create directory and then start the service.
3. Hope Service will get started. Then please change the directory location from the temporary drive to permanent drive.
This is a common issue in Azure temporary drive.
4. Change the directory of the master / physical DB through sp_helpfile.
  Consider we needs to change the location of DTempDB to ETempDB.
a. Using CMD prompt run as administrator select the directory of SQL installed.

default location:
cd C:Program FilesMicrosoft SQL ServerMSSQL12.MSSQLSERVERMSSQLBinn 

then following the following commands.

 SQLCMD -s .  
Please make sure you have (dot) .  at the end of this command.

SELECT name, physical_name, state_desc FROM sys.master_files ORDER BY database_id;
GO

Please check ion which location actually it locates to.
then select the DB and new location that you want to move the DB file.

ALTER DATABASE tempdb MODIFY FILE ( NAME = tempdev, FILENAME = ‘E:SQLTempDBtempdb.mdf’);
GO
ALTER DATABASE tempdb MODIFY FILE ( NAME = templog, FILENAME = ‘E:SQLTempDBtemplog.ldf’);
GO
Regards,

Leave a Reply

Your email address will not be published.