topic Do I need SQL Server credentials for SQL Server or OLEDB Connection in Connectivity & Data Prep https://community.qlik.com/t5/Connectivity-Data-Prep/Do-I-need-SQL-Server-credentials-for-SQL-Server-or-OLEDB/m-p/74171#M403 <HTML><HEAD></HEAD><BODY><P>Hello. I am attempting to connect to SQL server databases where I have read-only access via windows authentication. Can you connect to SQL Server databases via Windows Authentication or do I need to use a SQL Account? </P></BODY></HTML> Thu, 08 Mar 2018 17:19:11 GMT zbeauchemin 2018-03-08T17:19:11Z Do I need SQL Server credentials for SQL Server or OLEDB Connection https://community.qlik.com/t5/Connectivity-Data-Prep/Do-I-need-SQL-Server-credentials-for-SQL-Server-or-OLEDB/m-p/74171#M403 <HTML><HEAD></HEAD><BODY><P>Hello. I am attempting to connect to SQL server databases where I have read-only access via windows authentication. Can you connect to SQL Server databases via Windows Authentication or do I need to use a SQL Account? </P></BODY></HTML> Thu, 08 Mar 2018 17:19:11 GMT https://community.qlik.com/t5/Connectivity-Data-Prep/Do-I-need-SQL-Server-credentials-for-SQL-Server-or-OLEDB/m-p/74171#M403 zbeauchemin 2018-03-08T17:19:11Z Re: Do I need SQL Server credentials for SQL Server or OLEDB Connection https://community.qlik.com/t5/Connectivity-Data-Prep/Do-I-need-SQL-Server-credentials-for-SQL-Server-or-OLEDB/m-p/74172#M404 <HTML><HEAD></HEAD><BODY><P>You can do both the ways. It's depends on your use.<SPAN style="font-size: 13.3333px;">Whats's the challenge? Via windows you have to setup usename &amp; password.</SPAN></P></BODY></HTML> Thu, 08 Mar 2018 18:02:46 GMT https://community.qlik.com/t5/Connectivity-Data-Prep/Do-I-need-SQL-Server-credentials-for-SQL-Server-or-OLEDB/m-p/74172#M404 isingh30 2018-03-08T18:02:46Z Re: Do I need SQL Server credentials for SQL Server or OLEDB Connection https://community.qlik.com/t5/Connectivity-Data-Prep/Do-I-need-SQL-Server-credentials-for-SQL-Server-or-OLEDB/m-p/74173#M405 <HTML><HEAD></HEAD><BODY><P>Hi Zach,</P><P></P><P>Please find my below comments:-</P><P></P><P>It can be either both the ways....</P><P></P><P>1. C<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">onnect to SQL Server databases via Windows Authentication:-Yes you can connect directly <SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"> via Windows Authentication</SPAN></SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">2. <SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">do I need to use a SQL Account:-Your admin team member will provide you the user name and password for SQL.</SPAN></SPAN></P><P><SPAN style="color: #3d3d3d; font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;"><BR /></SPAN></P><P>Regards,</P><P>Ajay</P></BODY></HTML> Thu, 08 Mar 2018 18:20:24 GMT https://community.qlik.com/t5/Connectivity-Data-Prep/Do-I-need-SQL-Server-credentials-for-SQL-Server-or-OLEDB/m-p/74173#M405 ajaysingh285 2018-03-08T18:20:24Z Re: Do I need SQL Server credentials for SQL Server or OLEDB Connection https://community.qlik.com/t5/Connectivity-Data-Prep/Do-I-need-SQL-Server-credentials-for-SQL-Server-or-OLEDB/m-p/74174#M406 <HTML><HEAD></HEAD><BODY><P>If you are using Qlik Sense, it gives you the option when you set up the data connection to choose Windows authentication or user name.</P></BODY></HTML> Thu, 08 Mar 2018 20:21:18 GMT https://community.qlik.com/t5/Connectivity-Data-Prep/Do-I-need-SQL-Server-credentials-for-SQL-Server-or-OLEDB/m-p/74174#M406 chrishayes 2018-03-08T20:21:18Z