My customer have two server which is QlikView Server and SQL Server. The QlikView server need to load and get the data from SQL server, but the SQL server already change the port number to 9797 rather than port number 1433. Therefore, I cannot find the SQL Server in my QlikView Server by using OLE DB connection link. Can I custom the port number in the QlikView Server when I need to connect to SQL Server?
Connect using TCP/IP, specify an IP-address and add a comma and the correct port number.
If you already have a connection string, you will find examples of how to modify your connection string on this extremely useful site (link points to the SQL Server area): SQL Server connection strings - ConnectionStrings.com
