How do I make reinstalled MSSQL to load plesk databases

[JuanT]

How do I make reinstalled MSSQL to associate databases with plesk users

I reinstalled SQL server 2005 on plesk 9.0 because it was not working.
The configuration was lost.

All the databases could be attached from backup to the server but how can I make it associate the databases with the plesk users?

Does anyone know a command to reconfigure mssql 2005 in order to load the database information from plesk users?


Thanx

 

[Benderr]

Hi,

You can add user to mssql database with mssqlmng.exe utility like this:

mssqlmng.exe --add-user --server="localhost" --login="sa" --password="123qwe" --database="mydomains_" --new-user-login="xoxo" --new-user-password="123qwe"

To get all mssql databases and appropriate database users from Plesk db use this command:

dbclient.exe --direct-sql --sql="select du.login,du.passwd, db.name from db_users du, data_bases db where du.db_id=db.id and db.type='mssql'"