We’re running into a database connection issue when installing the software. The database server we are using is called “BLINKBD01\Bluelink” with IP 192.168.161.120. In SQL Server Management Studio we can connect to the database using the IP address but it requires the “\Bluelink” to connect (e.g. 192.168.161.120\Bluelink) and we can connect with the full name BLINKDB01\Bluelink.
If we use 192.168.161.120\Bluelink, the Agiloft installation returns “unkown server host name” error. If we just use the IP, it gives the error “Connection refused”. If we use the server name, it also returns “unkown server host name”. The SQL account we’re using has sysadmin privileges. We’ve completed the DTC configuration on the server, placed the sqljdbc_xa.dll in the BINN folder in the SQL folder and run the 2 sql scripts (aluser.sql and xa_install.sql).
Have you guys seen this before? Is it because we have a compound server name (\Bluelink)?