topic Microsoft SQL Server 2017 compatibility? in Connectivity & Data Prep https://community.qlik.com/t5/Connectivity-Data-Prep/Microsoft-SQL-Server-2017-compatibility/m-p/87655#M450 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P></P><P>Our DBA is in the process of moving our databases over to a SQL Server 2017 server. He set them up in compatibility mode. However, while it appears like I can connect to the database, I have not been able to get it to load the data without errors. I have not changed any of the SQL in the load script, just the data connection which works against our databases sitting on SQL Server 2016. Has anyone else had this issue, or do you know if support for SQL Server 2017 will be coming soon? (Currently running QS Server April 2018)</P><P></P><P>Thanks!</P></BODY></HTML> Fri, 13 Jul 2018 21:43:32 GMT chadwatson 2018-07-13T21:43:32Z Microsoft SQL Server 2017 compatibility? https://community.qlik.com/t5/Connectivity-Data-Prep/Microsoft-SQL-Server-2017-compatibility/m-p/87655#M450 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P></P><P>Our DBA is in the process of moving our databases over to a SQL Server 2017 server. He set them up in compatibility mode. However, while it appears like I can connect to the database, I have not been able to get it to load the data without errors. I have not changed any of the SQL in the load script, just the data connection which works against our databases sitting on SQL Server 2016. Has anyone else had this issue, or do you know if support for SQL Server 2017 will be coming soon? (Currently running QS Server April 2018)</P><P></P><P>Thanks!</P></BODY></HTML> Fri, 13 Jul 2018 21:43:32 GMT https://community.qlik.com/t5/Connectivity-Data-Prep/Microsoft-SQL-Server-2017-compatibility/m-p/87655#M450 chadwatson 2018-07-13T21:43:32Z Re: Microsoft SQL Server 2017 compatibility? https://community.qlik.com/t5/Connectivity-Data-Prep/Microsoft-SQL-Server-2017-compatibility/m-p/87656#M451 <HTML><HEAD></HEAD><BODY><P>After some research we found that our service account did not have rights to all of the databases that it needed rights to. Once we fixed that we had no issues connecting to SQL Server 2017.</P></BODY></HTML> Tue, 17 Jul 2018 16:28:12 GMT https://community.qlik.com/t5/Connectivity-Data-Prep/Microsoft-SQL-Server-2017-compatibility/m-p/87656#M451 chadwatson 2018-07-17T16:28:12Z