MSSQL does not start: Access is denied while attempting to open or create the physical file tempdb.mdf.

Created:

2016-11-16 13:05:11 UTC

Modified:

2017-06-22 14:31:31 UTC

2

Was this article helpful?


Have more questions?

Submit a request

MSSQL does not start: Access is denied while attempting to open or create the physical file tempdb.mdf.

Applicable to:

  • Plesk 11.5 for Windows
  • Plesk 12.0 for Windows

Symptoms

MSSQL server 2005 does not start with the following error:

    Error: 1802, Severity: 16, State: 4.
CREATE DATABASE failed. Some file names listed could not be created. Check related errors.
Error: 5123, Severity: 16, State: 1.
CREATE FILE encountered operating system error 5(Access is denied.) while attempting to open or create the physical file 'c:\\Program Files (x86)\\Parallels\\Plesk\\Databases\\MSSQL\\MSSQL.1\\MSSQL\\DATA\ empdb.mdf'.
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.

Cause

SQL Server service account does not have any longer permissions to access the database files or write files.

Resolution

  1. Check account name under Services.msc-> SQL Server service.

  2. Check if this account has write permissions to c:\Program Files (x86)\Parallels\Plesk\Databases\MSSQL\MSSQL.1\MSSQL\DATA\ or other path mentioned in error. Assign read/write/modify permission SQL server service account to the mentioned folder.

Have more questions? Submit a request
Please sign in to leave a comment.