SBDavid
Aug 14th, 2009
Aug 14th, 2009
SQL Express not showing up in Plesk
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
> 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”.
