SBDavid
Aug 18th, 2009
Aug 18th, 2009
How to reset SQL “sa” password and Integrate with Plesk Control panel
How to reset SQL “sa” password and Integrate with Plesk Control panel
The following steps will guide you to reset the SQL admin password and how to integrate it with Plesk control panel for hosting purpose.
Step 1: Login to the Windows server through RDP.
Step 2: Open CMD ( Start -> Run -> type: cmd then Enter)
Step 3: cd “c:\Program files\Microsoft SQL Server\80\Tools\Binn”
Step 4: Now execute the following command.
osql -E -Q “EXEC sp_password @new=’newpassword’, @loginame = ’sa’”
Now integrate SQL server with Plesk control panel.
Step 1: Login to Plesk control panel using the admin login.
Step 2: Select “Server >> Databases >> Add new database”.
Step 3: Create new MSSQL database server using SQL admin (known as “sa”) login details.
