topic Re: Server does not exist on load in QlikView

Server does not exist on load

Anonymous — Thu, 13 Apr 2017 07:53:48 GMT

Hi there,

Not sure if anyone experienced this error before but I hope someone might be able to point me in the right direction.

I am connecting to a SQL database using service accounts to which "read and execute" permissions were granted. In the script, I can create the connection string successfully and I can see the SQL database and tables. However, once I run the reload via QMC, the model errors and the below error is on the log file.

"ErrorSource: Microsoft OLE DB Provider for SQL Server, ErrorMsg: [DBNETLIB][ConnectionOpen (Connect()).]Specified SQL server not found."

Can anyone maybe shed some light as to what the problem might be?

Your assistance will be much appreciated.

Re: Server does not exist on load

Peter_Cammaert — Thu, 13 Apr 2017 09:02:03 GMT

The QDS doesn't recognize your Data Source or Server name. Please post your Conneciton String. You can replace any explicit username or password values with x's.

Re: Server does not exist on load

Anonymous — Thu, 13 Apr 2017 09:30:54 GMT

Hi Peter,

Here's the string.

OLEDB CONNECT TO [Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=AFGroupComplaints_MSCRM;Data Source=AFJHB1CRM16DBQ1\SQL01;Use Procedure for Prepare=1;Auto Translate=True;Packet Size=4096;Workstation ID=DB87-27D5;Use Encryption for Data=False;Tag with column collation when possible=False];

Re: Server does not exist on load

avinashelite — Thu, 13 Apr 2017 10:28:40 GMT

check whether the QA service account has access for the Server

Re: Server does not exist on load

Peter_Cammaert — Thu, 13 Apr 2017 10:49:45 GMT

The QlikView server platform has no knowledge about your data source and no ability to figure out where AFJHB1CRM16DBQ1\SQL01 is located. Can you try with the IP-address of the server that is running your database?