• If you are still using CentOS 7.9, it's time to convert to Alma 8 with the free centos2alma tool by Plesk or Plesk Migrator. Please let us know your experiences or concerns in this thread:
    CentOS2Alma discussion

mssql not working after upgrade

jonium

Basic Pleskian
I upgraded plesk from 9.2.1 to 9.5.5 and MSSQL is not working,
in the error logs of mssql I have:
Code:
013-09-13 11:55:39.07 Server      (c) 2005 Microsoft Corporation.
2013-09-13 11:55:39.07 Server      All rights reserved.
2013-09-13 11:55:39.07 Server      Server process ID is 6264.
2013-09-13 11:55:39.07 Server      Authentication mode is MIXED.
2013-09-13 11:55:39.09 Server      Logging SQL Server messages in file 'D:\Programmi (x86)\Parallels\Plesk\Databases\MSSQL\MSSQL.1\MSSQL\LOG\ERRORLOG'.
2013-09-13 11:55:39.09 Server      This instance of SQL Server last reported using a process ID of 6532 at 13/09/2013 11.46.50 (local) 13/09/2013 9.46.50 (UTC). This is an informational message only; no user action is required.
2013-09-13 11:55:39.09 Server      Registry startup parameters:
2013-09-13 11:55:39.10 Server      	 -d D:\Programmi (x86)\Parallels\Plesk\Databases\MSSQL\MSSQL.1\MSSQL\DATA\master.mdf
2013-09-13 11:55:39.10 Server      	 -e D:\Programmi (x86)\Parallels\Plesk\Databases\MSSQL\MSSQL.1\MSSQL\LOG\ERRORLOG
2013-09-13 11:55:39.10 Server      	 -l D:\Programmi (x86)\Parallels\Plesk\Databases\MSSQL\MSSQL.1\MSSQL\DATA\mastlog.ldf
2013-09-13 11:55:39.14 Server      SQL Server is starting at normal priority base (=7). This is an informational message only. No user action is required.
2013-09-13 11:55:39.14 Server      Detected 4 CPUs. This is an informational message; no user action is required.
2013-09-13 11:55:39.90 Server      Using dynamic lock allocation.  Initial allocation of 2500 Lock blocks and 5000 Lock Owner blocks per node.  This is an informational message only.  No user action is required.
2013-09-13 11:55:40.67 Server      Database mirroring has been enabled on this instance of SQL Server.
2013-09-13 11:55:40.87 spid4s      Starting up database 'master'.
2013-09-13 11:55:41.35 spid4s      SQL Trace ID 1 was started by login "sa".
2013-09-13 11:55:41.51 spid4s      Starting up database 'mssqlsystemresource'.
2013-09-13 11:55:41.60 spid4s      The resource database build version is 9.00.3042. This is an informational message only. No user action is required.
2013-09-13 11:55:42.03 spid8s      Starting up database 'model'.
2013-09-13 11:55:42.04 spid4s      Server name is 'ORMAG-ED0173E2A'. This is an informational message only. No user action is required.
2013-09-13 11:55:42.09 spid4s      Starting up database 'msdb'.
2013-09-13 11:55:42.24 spid8s      Clearing tempdb database.
2013-09-13 11:55:42.35 spid8s      Error: 5123, Severity: 16, State: 1.
2013-09-13 11:55:42.35 spid8s      CREATE FILE encountered operating system error 5(Accesso negato.) while attempting to open or create the physical file 'D:\Programmi (x86)\Parallels\Plesk\Databases\MSSQL\MSSQL.1\MSSQL\DATA\tempdb.mdf'.
2013-09-13 11:55:42.82 spid8s      Error: 17207, Severity: 16, State: 1.
2013-09-13 11:55:42.82 spid8s      FCB::Open: Operating system error 5(Accesso negato.) occurred while creating or opening file 'D:\Programmi (x86)\Parallels\Plesk\Databases\MSSQL\MSSQL.1\MSSQL\DATA\tempdb.mdf'. Diagnose and correct the operating system error, and retry the operation.
2013-09-13 11:55:42.87 spid8s      Error: 17204, Severity: 16, State: 1.
2013-09-13 11:55:42.87 spid8s      FCB::Open failed: Could not open file D:\Programmi (x86)\Parallels\Plesk\Databases\MSSQL\MSSQL.1\MSSQL\DATA\tempdb.mdf for file number 1.  OS error: 5(Accesso negato.).
2013-09-13 11:55:42.87 spid8s      Error: 5120, Severity: 16, State: 101.
2013-09-13 11:55:42.87 spid8s      Unable to open the physical file "D:\Programmi (x86)\Parallels\Plesk\Databases\MSSQL\MSSQL.1\MSSQL\DATA\tempdb.mdf". Operating system error 5: "5(Accesso negato.)".
2013-09-13 11:55:42.90 Server      A self-generated certificate was successfully loaded for encryption.
2013-09-13 11:55:42.96 Server      Server is listening on [ 'any' <ipv4> 1433].
2013-09-13 11:55:42.96 Server      Server local connection provider is ready to accept connection on [ \\.\pipe\SQLLocal\MSSQLSERVER ].
2013-09-13 11:55:42.98 Server      Server named pipe provider is ready to accept connection on [ \\.\pipe\sql\query ].
2013-09-13 11:55:42.99 spid8s      Error: 1802, Severity: 16, State: 4.
2013-09-13 11:55:42.99 spid8s      CREATE DATABASE failed. Some file names listed could not be created. Check related errors.
2013-09-13 11:55:42.99 spid8s      Error: 5123, Severity: 16, State: 1.
2013-09-13 11:55:42.99 spid8s      CREATE FILE encountered operating system error 5(Accesso negato.) while attempting to open or create the physical file 'D:\Programmi (x86)\Parallels\Plesk\Databases\MSSQL\MSSQL.1\MSSQL\DATA\tempdb.mdf'.
2013-09-13 11:55:42.99 spid8s      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.
2013-09-13 11:55:42.99 spid8s      SQL Trace was stopped due to server shutdown. Trace ID = '1'. This is an informational message only; no user action is required.
2013-09-13 11:55:42.98 Server      Dedicated administrator connection support was not started because it is not available on this edition of SQL Server. This is an informational message only. No user action is required.

OS: Windows Server 2003

Any Ideas?
 
Last edited:
Back
Top