• Our team is looking to connect with folks who use email services provided by Plesk, or a premium service. If you'd like to be part of the discovery process and share your experiences, we invite you to complete this short screening survey. If your responses match the persona we are looking for, you'll receive a link to schedule a call at your convenience. We look forward to hearing from you!
  • We are looking for U.S.-based freelancer or agency working with SEO or WordPress for a quick 30-min interviews to gather feedback on XOVI, a successful German SEO tool we’re looking to launch in the U.S.
    If you qualify and participate, you’ll receive a $30 Amazon gift card as a thank-you. Please apply here. Thanks for helping shape a better SEO product for agencies!
  • The BIND DNS server has already been deprecated and removed from Plesk for Windows.
    If a Plesk for Windows server is still using BIND, the upgrade to Plesk Obsidian 18.0.70 will be unavailable until the administrator switches the DNS server to Microsoft DNS. We strongly recommend transitioning to Microsoft DNS within the next 6 weeks, before the Plesk 18.0.70 release.
  • The Horde component is removed from Plesk Installer. We recommend switching to another webmail software supported in Plesk.

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