Need help.. I am getting errors.

[rajinnasik]

Hi All,

I am getting the following error while deleting the domain from Plesk Windows.

-----------------------------------------------------------------------------------------
Error: Unable to remove domains: Problems occured while removing domains: Delete database user failed: Login failed for user 'sa'.
-----------------------------------------------------------------------------------------

After that I went to Database in order to delete the database under that domain. I am getting the following errors while deleting databases.

-----------------------------------------------------------------------------------------
Delete database user failed: Login failed for user 'sa'.
---------------------- Debug Info -------------------------------
0: plib\DatabaseManagerMSSQL.php:52
DatabaseManagerMSSQL->dropUserImpl(string 'dodie', string 'payroll')
1: plib\DatabaseManager.php:105
DatabaseManager->deleteDatabase(object of type Database)
2: plib\class.DataBasesList.php:244
DataBasesList->remove(array)
3: htdocs\domains\databases\removeDataBases.php3:41
-----------------------------------------------------------------------------------------

Please help me to resolve this issue. I am very poor in windows however quite good in Linux.

 

[HostMantis]

Hi All,

I am getting the following error while deleting the domain from Plesk Windows.

-----------------------------------------------------------------------------------------
Error: Unable to remove domains: Problems occured while removing domains: Delete database user failed: Login failed for user 'sa'.
-----------------------------------------------------------------------------------------

After that I went to Database in order to delete the database under that domain. I am getting the following errors while deleting databases.

-----------------------------------------------------------------------------------------
Delete database user failed: Login failed for user 'sa'.
---------------------- Debug Info -------------------------------
0: plib\DatabaseManagerMSSQL.php:52
DatabaseManagerMSSQL->dropUserImpl(string 'dodie', string 'payroll')
1: plib\DatabaseManager.php:105
DatabaseManager->deleteDatabase(object of type Database)
2: plib\class.DataBasesList.php:244
DataBasesList->remove(array)
3: htdocs\domains\databases\removeDataBases.php3:41
-----------------------------------------------------------------------------------------

Please help me to resolve this issue. I am very poor in windows however quite good in Linux.

I may be wrong, but it sounds like the password for "sa" has possibly been changed and Plesk is trying to use the wrong password for MS SQL?

 

[cableguy]

yes, this is a sql login error

are you in charge of the sa account?

 

[rajinnasik]

I have administrator/full access to this windows server.
Can you please teach me how to do and what exact to do now?

 

[cableguy]

well, you need to find out how to configure the account which plesk would use (i don't know where that is since i never used it)

second, i would create a new account, make it sysadmin and use that instead of the built in sa account.

 

[HostMantis]

I'm not that familiar with Plesk, but this may point you in the right direction:

http://forums.powervps.com/showthread.php?t=300

 

[rajinnasik]

Thanks.
Any windows master here to help me ?

 

[rajinnasik]

I'm not that familiar with Plesk, but this may point you in the right direction:

http://forums.powervps.com/showthread.php?t=300

ok, I have done as suggested above. Still no luck

 

[supportfacility]

hmm, Resetting the sa pass should fix it. Have you tried to restart the services ?

 

[HostMantis]

ok, I have done as suggested above. Still no luck

Did you try resetting it from a command line?:

osql -E -Q "exec sp_password NULL,'new_password','sa'"

Where 'new_password' = the password you would like to change it to.

 

[rajinnasik]

hmm, Resetting the sa pass should fix it. Have you tried to restart the services ?

I restarted the plesk and sql services and it has been fixed.
Sorry for delay to reply. And thanks to Plexihost and supportfaciliti .

 

[HostMantis]

I restarted the plesk and sql services and it has been fixed.
Sorry for delay to reply. And thanks to Plexihost and supportfaciliti .

Glad you got it sorted out.

 

[supportfacility]

Yes good job.

 

[webhosting.am]

You should turn to the support stuff of your hosting company, they must solve that problem.

 

[supportfacility]

Please help me to resolve this issue. I am very poor in windows however quite good in Linux.

@jucky68
@webhosting.am
I think he is a support guy and wanted help with windows issue. Tho it is resolved.