IBM Support

MS SQL Server 2008 fails to install with errors on an invalid login and missing files on the E: drive

Troubleshooting


Problem

MS SQL Server 2008 fails to install with errors on an invalid login and missing files on the E: drive

Symptom

The installation of Microsoft SQL Server fails when the computer name matches the user account performing the installation. This occurs for Microsoft SQL Server 2008 and 2008 R2 including Express editions.

When using SQLServer2008ExpressSP1.exe, the installation might appear to complete successfully, but the "SQL Server (CDWINDOWS)" service fails upon a restart afterwards. A number of odd error messages appear in the event log and in SQL Server log files. Some might refer to files on an E: drive, which actually may not even exist on the computer.

When doing an interactive installation manually, the installation fails with an error.

Error Message

Event log messages for source MSSQL$CDWINDOWS:

  • FCB::Open failed: Could not open file e:\sql10_main_t\sql\mkmastr\databases\objfre\i386\model.mdf for file number 1. OS error: 3(The system cannot find the path specified.).
  • FCB::Open failed: Could not open file e:\sql10_main_t\sql\mkmastr\databases\objfre\i386\MSDBData.mdf for file number 1. OS error: 3(The system cannot find the path specified.).
  • FileMgr::StartLogFiles: Operating system error 2(The system cannot find the file specified.) occurred while creating or opening file 'e:\sql10_main_t\sql\mkmastr\databases\objfre\i386\MSDBLog.ldf'. Diagnose and correct the operating system error, and retry the operation.
  • FileMgr::StartLogFiles: Operating system error 2(The system cannot find the file specified.) occurred while creating or opening file 'e:\sql10_main_t\sql\mkmastr\databases\objfre\i386\modellog.ldf'. Diagnose and correct the operating system error, and retry the operation.
  • Could not create tempdb. You may not have enough disk space available. Free additional disk space by deleting other files on the tempdb drive and then restart SQL Server. Check for additional errors in the event log that may indicate why the tempdb files could not be initialized.

Error message in the SQL Server's ERRORLOG and during an interactive installation:

  • '' is not a valid login or you do not have permission.

[{"Product":{"code":"SSRRVY","label":"IBM Sterling Connect:Direct for Microsoft Windows"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":"Not Applicable","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All","Edition":"","Line of Business":{"code":"LOB77","label":"Automation Platform"}}]

Log InLog in to view more of this document

This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.

Historical Number

NFX10028

Document Information

Modified date:
24 July 2020

UID

swg21558513

Page Feedback