2 Replies Latest reply: Mar 17, 2015 12:13 PM by deepti singh RSS

    "Create new connection" fails

    deepti singh

      Hi All,

       

            I recently downloaded Qlik Sense and am trying to develop my first dashboard. I first want to connect to a Database. I don't know whether

      1. I should do it in the QMC since its the first database connection that I am trying to make or

      2. I can directly go to Qlik Sense an in the Data Load Editor, "Create new connection".

       

      I tried both the above steps:

      1. In the first one, I can't see any "Add" button where I can give a new Database connection

      2. I tried the second one as well. I went to Qlik Sense>> Data Load Editor>> Create new connection>> OLE DB >> Selected the "Microsoft OLE DB Provider for SQL Server" (depending on the DB) >> Entered the Data Source info followed by the Specific user name and password>> Clicked on "Test connection". But it says connection failed. I even tried saving the Data source name but it says "You do not have access to the data source" though I am able to access it through Qlik View using the same credentials.
      Connection.JPG

      Test failed.JPG

      Connection error.JPG

      No Access.JPG

       

      Thanks,

      Deepti