topic Just started Qlik and cannot connect to SQL Server in Connectivity & Data Prep https://community.qlik.com/t5/Connectivity-Data-Prep/Just-started-Qlik-and-cannot-connect-to-SQL-Server/m-p/1312800#M2747 <HTML><HEAD></HEAD><BODY><P>I have SQL Server 2016 installed locally on a laptop and I connect using Windows Authentication.&nbsp; My account has sysadmin rights.</P><P>I opened Qlik Sense Desktop and started to create a new app.&nbsp; I selected Add Data and then Microsoft SQL Server.</P><P>I entered the laptop name as the Host Name - same as the SQL server name.&nbsp; Left the port at 1433.&nbsp; Entered the db name.&nbsp; Changed WIndows Integrated Security to Yes and left the Name for the connection as is.</P><P>I got this message -</P><P><IMG alt="Qlik Data Connection error.png" class="jive-image image-1" src="/legacyfs/online/171804_Qlik Data Connection error.png" style="height: auto;" /></P><P>I've also tried creating a SQL user and entering that username and password in the Data Connection screen - same result.</P><P></P><P>What am I missing?</P><P></P><P>Thanks.</P></BODY></HTML> Fri, 28 Jul 2017 19:44:20 GMT 2017-07-28T19:44:20Z Just started Qlik and cannot connect to SQL Server https://community.qlik.com/t5/Connectivity-Data-Prep/Just-started-Qlik-and-cannot-connect-to-SQL-Server/m-p/1312800#M2747 <HTML><HEAD></HEAD><BODY><P>I have SQL Server 2016 installed locally on a laptop and I connect using Windows Authentication.&nbsp; My account has sysadmin rights.</P><P>I opened Qlik Sense Desktop and started to create a new app.&nbsp; I selected Add Data and then Microsoft SQL Server.</P><P>I entered the laptop name as the Host Name - same as the SQL server name.&nbsp; Left the port at 1433.&nbsp; Entered the db name.&nbsp; Changed WIndows Integrated Security to Yes and left the Name for the connection as is.</P><P>I got this message -</P><P><IMG alt="Qlik Data Connection error.png" class="jive-image image-1" src="/legacyfs/online/171804_Qlik Data Connection error.png" style="height: auto;" /></P><P>I've also tried creating a SQL user and entering that username and password in the Data Connection screen - same result.</P><P></P><P>What am I missing?</P><P></P><P>Thanks.</P></BODY></HTML> Fri, 28 Jul 2017 19:44:20 GMT https://community.qlik.com/t5/Connectivity-Data-Prep/Just-started-Qlik-and-cannot-connect-to-SQL-Server/m-p/1312800#M2747 2017-07-28T19:44:20Z