• 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 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