Issue only default MSSQL shows for client, but multiple versions available

[nosupport]

Hello,

I am testing plesk and ran into the following issue - Windows 2022, new install of Plesk. I installed multiple versions of MSSQL and they are visible in the control panel:


I created a new plan and a new subscription. If I click on the subscription, I can create a new database and select from the available options:




However if I log in as the client and I try to create a database, it only provides me with the default options:



What would be the settings to allow users to also see all available options, except the default?

Thanks!

 

[Paul Hermans]

Hello,

There is a setting inside de Service Plan under TAB: Permissions that says "Database server selection".

Can you check if this permission is granted for the Subscription?

Greetings Paul

 

[webserverforum]

Thats correct, its the "Default Database Server" parameter under the Service Plan for "Microsoft SQL Server" that needs to select

 

[harshad.panchal@airan]

Failed to connect to the database server: SQLSTATE[08001]: [Microsoft][ODBC Driver 17 for SQL Server]Named Pipes Provider: Could not open a connection to SQL Server [2].