Hello,
I am running a tabular model deployment for one of our customers and i get below error,
i think the issue is due to the fact that they have multiple instances in their SQL Server and the Environment Parameters are set up like below,
SQL_SERVER_NAME 12.1.2.12\IFSPRODBI
and it finds the backslash as an escape character.
Is there a workaround for this? Does IFS support multiple SQL Instances setup like above?
Hi
Yes tabular model support sql server with multiple instances.
But to get this working there is a small manual intervention needed.
After the env setup, go to the Integration catalog project and open the configure window.
Find the port associated with the instance you are interested in and specify the SQL server name in this pattern <hostname>,<port>.
this needs to be done after every time you run the env setup assistant as the assistant will override these values.
Best regards,
Subash
Hi
Thank you very much! You are a real lifesaver :)
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.