MSSQL Server cannot start or a new database cannot be created

Created:

2016-12-12 03:46:42 UTC

Modified:

2017-08-18 09:01:29 UTC

0

Was this article helpful?


Have more questions?

Submit a request

MSSQL Server cannot start or a new database cannot be created

Applicable to:

  • Plesk 12.5 for Windows

Symptoms

  • MS SQL cannot start:

    Windows could not start the SQL Server (MSSQLSERVER2016) service on Local Computer.

    Error 1067: The process terminated unexpectedly.
  • The following error can be found in %plesk_dir%Databases\\MSSQL\\MSSQL12.MSSQLSERVERXXXX\\MSSQL\\Log\\ERRORLOG :

    2016-11-21 00:47:16.23 spid4s      Unable to open the physical file "C:\\Program Files (x86)\\Plesk\\Databases\\MSSQL\\MSSQL13.MSSQLSERVER2016\\MSSQL\\DATA\\master.mdf". Operating system error 5: "5(Access is denied.)".
    2016-11-21 00:47:16.23 spid4s Error: 17204, Severity: 16, State: 1.
    2016-11-21 00:47:16.23 spid4s FCB::Open failed: Could not open file C:\\Program Files (x86)\\Plesk\\Databases\\MSSQL\\MSSQL13.MSSQLSERVER2016\\MSSQL\\DATA\\mastlog.ldf for file number 2. OS error: 5(Access is denied.).
  • Cannot create a new database:

    Error: Create new database failed: mssqlmng failed: Directory lookup for
    the file "C:\\Program Files
    (x86)\\Plesk\\Databases\\MSSQL\\MSSQL13.MSSQLSERVER2016\\MSSQL\\DATA\\example.mdf"
    failed with the operating system error 5(Access is denied.). CREATE
    DATABASE failed. Some file names listed could not be created. Check related
    errors. at (VADOConnection::execute line 78) at execute console command
    --create-database(vconsoleapp::start line 122) at execute "C:\\Program Files
    (x86)\\Plesk\\admin\\bin\\mssqlmng.exe" --create-database
    "--server=.\\MSSQLSERVER2016" "--login=sa" "--password=*"
    "--database=example" "--max-size=-1" "--max-size-unit=MB"
    "--max-log-size=-1" "--max-log-size-unit=MB"(vconsoleapp::run line 139)
    (Error code 1)

Cause

Infussicient permissions on DATA folder.

Resolution

  1. Open Services snap-in: Run > services.msc

  2. Find SQL Server service, open its properties and procees to Log On tab. Remember the username under which the server runs.

  3. Open %plesk_dir%Databases\\MSSQL\\MSSQL13.MSSQLSERVER2016\\MSSQL\\DATA folder properties, procees to Security tab and grant the user Full Control permissions

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