• Please be aware: Kaspersky Anti-Virus has been deprecated
    With the upgrade to Plesk Obsidian 18.0.64, "Kaspersky Anti-Virus for Servers" will be automatically removed from the servers it is installed on. We recommend that you migrate to Sophos Anti-Virus for Servers.
  • The Horde webmail has been deprecated. Its complete removal is scheduled for April 2025. For details and recommended actions, see the Feature and Deprecation Plan.
  • We’re working on enhancing the Monitoring feature in Plesk, and we could really use your expertise! If you’re open to sharing your experiences with server and website monitoring or providing feedback, we’d love to have a one-hour online meeting with you.

MSSQL Problem

CahitE

Basic Pleskian
I have some domains which use mssql yesterday suddenly my mssql server has stopped.
and then i tryed to restart it but nothing worked . When i remove temp dbs from the data directory my mssql start to working but this time i got this error when i want to remove or modify old dbs
on the plesk panel :

When i want to create a new subscription on my plesk admin panel it returns me an error as this :



Delete database user failed: Database 'roportaj' cannot be opened due to inaccessible files or insufficient memory or disk space. See the SQL Server errorlog for details.
---------------------- Debug Info -------------------------------
0: DatabaseManagerMSSQL.php:52
DatabaseManagerMSSQL->dropUserImpl(string 'erm123', string 'roportaj')
1: DatabaseManager.php:106
DatabaseManager->deleteDatabase(object of type Database)
2: class.DataBasesList.php:239
DataBasesList->remove(array)
3: removeDataBases.php3:41


And on the my little admin :



Error -2147467259

Cannot open user default database. Login failed.

Provider=sqloledb;Data Source=localhost;User Id=xxxx;Password=xxxxxx;
 
One more note i tryed webservmngr for to reconfigure the hosts which has mssql db and checked folder and file permissions for network services
 
Back
Top