We currently provide 1 service, with 2 questions for deploying new MSSQL databases.
In the first question we query an hardcoded SQL Instance and database, for all entries in that given table – the list of all MSSQL servers, that the enduser can use.
So the user might select MSSQL1 as the server.
Now i want to execute an MSSQL query on that MSSQL server, but it seems, i can only use the “Advanced placeholder” in my query – not the actual server.
Basically i want this query “SELECT name from master.sys.server_principals WHERE name NOT LIKE ‘##%’ AND name NOT LIKE ‘NT %'” to be executed on the MSSQL server, that the user selected in the first question.