Enable microsoft SQL for clients

[moppentappers]

Hello,

I have installed plesk 9.2.1 on a windows 2003 server along with Microsoft SQL 2005 enterprise edition.
I chose to let plesk use the MSSQL database but now it seems that this causes that users can't use Microsoft SQL.
When I go to a client, only mysql is available while I have allowed unlimited Microsoft SQL databases.
How can I solve this problem?

Thanks in advance,

Glenn

 

[tkhutova tkhutova]

Check the following points:
- make sure you registered MSSQL instance under Plesk CP > Home > Database servers;
- this MSSQL instance is suposed to be used sa default one:
Plesk CP > Home > Database servers > MSSQL > Preferences > select 'Use this server as default for Microsoft SQL Server';
- check all available permissions and limits for Clients/Domains in Plesk CP to make sure they have sufficient rights manage databases.

 

[moppentappers]

http://img10.imageshack.us/img10/2741/35556822.png
http://img10.imageshack.us/my.php?image=35556822.png
http://img40.imageshack.us/my.php?image=34740550.png
http://img40.imageshack.us/my.php?image=73829337.png

Everything is correct as it seems, hope you can tell me why the MSSQL is not listed.

 

[Gideon-82]

you need an additional license (Plesk Power Pack) to enable MSSQL.