I upgraded plesk from 9.2.1 to 9.5.5 and MSSQL is not working,
in the error logs of mssql I have:
OS: Windows Server 2003
Any Ideas?
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: