SQL | ServerBuddies Support Blog

Archive for the tag 'SQL'

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.

SQL Express not showing up in Plesk

SQL Express not showing up in Plesk :

The SQL server won’t be listed under “Plesk >> Servers >> Database server”.

To solve this, login to the server via RDP.

Start >> Programs >> SQL Server Management Studio Express

Now, login to the SQL server with the below details.

server type : database engine

server name : hostname or IP address

Authentication : Windows Authentication

Do select Authentication type as Windows Authentication. Then create login for ’sa’ user.

security > logins > reset or create new

Or reset the ’sa’ password

security > logins > sa > properties

Also, navigate to

Programs > MS SQL server > Configuration Tools > SQL configuration manager > Network Configuration
> Protocols for MS SQL server

Enable the following :

1. Shared Memory

2. Named Pipes

3. TCP/IP

Once the above are done. Restart the below services.

MS sql server

Plesk sql server

Now you can find the database server under “Plesk >> servers >> database server”.