27
New Plesk versions 8.6+ comes with MSDE (Microsoft SQL Desktop Edition) by default so you just need to follow the below mentioned steps in order to configure it.In earlier Plesk versions, MSDE needs to be installed. This can be done by downloading the MSDE from Microsoft site or installing “msde” virtuozzo template. Virtuozzo template can be installed to VPS using VZMC or “vzpkgadd” command. MSDE needs to be configured as:
1. Reset sa password to ‘NEW_PASSWORD’ using:
C:\> cd “C:\Program Files\Microsoft SQL Server\80\Tools\Binn”
If the Node is 64 bit then the path will be “C:\Program Files (x86)\Microsoft SQL Server\80\Tools\Binn”.
C:\Program Files\Microsoft SQL Server\80\Tools\Binn>osql -E -Q “exec sp_password NULL,’NEW_PASSWORD’,'sa’”
Password changed.
2. Got hostname of the VPS
C:\>hostname
VPSHOSTNAME
3. Used VPS’s hostname in connection settings in Plesk > Server > Databases > MSSQL Server > Server Name.
