I'm having trouble connecting my deployer to a SQL Server named instance. It keeps saying 'login failed', even though I can log in to the database with SQL Server Studio using those same credentials.
I've tried the following:
<Property Name="serverName" Value="SERVER\INSTANCE"/>
This gives the error: Login failed for user TridionBrokerUser
<Property Name="serverName" Value="SERVER"/> <Property Name="instanceName" Value="INSTANCE"/>
This gives a different error, something like 'cannot open connection'.
Also tried forward slashes instead of backslashes (the client is on Linux), but nothing works.
Is this scenario supported at all? If so, how?