topic I am getting a connection fail error while connecting to MSSQLserver. in Installing and Upgrading https://community.qlik.com/t5/Installing-and-Upgrading/I-am-getting-a-connection-fail-error-while-connecting-to/m-p/2378379#M2576 <P>I am getting a connection fail error while connecting to MSSQLserver.</P><P></P><P></P><P>I have entered the database name, Server Name, port number, Username and left the scheme and password column blank since I have not set any password . When tested the connection, it s throws error. you must change the database settings</P><P></P><P></P><P><span class="lia-inline-image-display-wrapper" image-alt="0695b00000Sry62AAB.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/138788i9DA172528FAE707A/image-size/large?v=v2&amp;px=999" role="button" title="0695b00000Sry62AAB.png" alt="0695b00000Sry62AAB.png" /></span></P> Fri, 15 Nov 2024 22:44:45 GMT SANTOSH1657711471 2024-11-15T22:44:45Z I am getting a connection fail error while connecting to MSSQLserver. https://community.qlik.com/t5/Installing-and-Upgrading/I-am-getting-a-connection-fail-error-while-connecting-to/m-p/2378379#M2576 <P>I am getting a connection fail error while connecting to MSSQLserver.</P><P></P><P></P><P>I have entered the database name, Server Name, port number, Username and left the scheme and password column blank since I have not set any password . When tested the connection, it s throws error. you must change the database settings</P><P></P><P></P><P><span class="lia-inline-image-display-wrapper" image-alt="0695b00000Sry62AAB.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/138788i9DA172528FAE707A/image-size/large?v=v2&amp;px=999" role="button" title="0695b00000Sry62AAB.png" alt="0695b00000Sry62AAB.png" /></span></P> Fri, 15 Nov 2024 22:44:45 GMT https://community.qlik.com/t5/Installing-and-Upgrading/I-am-getting-a-connection-fail-error-while-connecting-to/m-p/2378379#M2576 SANTOSH1657711471 2024-11-15T22:44:45Z Re: I am getting a connection fail error while connecting to MSSQLserver. https://community.qlik.com/t5/Installing-and-Upgrading/I-am-getting-a-connection-fail-error-while-connecting-to/m-p/2378380#M2577 <P>Hello,</P><P>Could you please change the Db version to 'Open source JTDS' as the below to see if it work?</P><P><span class="lia-inline-image-display-wrapper" image-alt="0695b00000Ss4EMAAZ.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/127930i602D53A241FB7278/image-size/large?v=v2&amp;px=999" role="button" title="0695b00000Ss4EMAAZ.png" alt="0695b00000Ss4EMAAZ.png" /></span></P> Thu, 14 Jul 2022 02:07:30 GMT https://community.qlik.com/t5/Installing-and-Upgrading/I-am-getting-a-connection-fail-error-while-connecting-to/m-p/2378380#M2577 Anonymous 2022-07-14T02:07:30Z Re: I am getting a connection fail error while connecting to MSSQLserver. https://community.qlik.com/t5/Installing-and-Upgrading/I-am-getting-a-connection-fail-error-while-connecting-to/m-p/2378381#M2578 <P>I have tried to Open source JTDS, but still it throws an error that change the database settings​</P> Thu, 14 Jul 2022 03:17:47 GMT https://community.qlik.com/t5/Installing-and-Upgrading/I-am-getting-a-connection-fail-error-while-connecting-to/m-p/2378381#M2578 SANTOSH1657711471 2022-07-14T03:17:47Z Re: I am getting a connection fail error while connecting to MSSQLserver. https://community.qlik.com/t5/Installing-and-Upgrading/I-am-getting-a-connection-fail-error-while-connecting-to/m-p/2378382#M2579 <P>so, maybe your db settings are not correct, regarding to your snapshot, your input user is 'Administrator', I guess it's a windows username and you want to use the sql-server windows authenticate? if yes, then that's the problem, here it should be a Sql-server Authenticate, so please input the correct login/password , thanks</P><P>&nbsp;</P> Thu, 14 Jul 2022 08:05:01 GMT https://community.qlik.com/t5/Installing-and-Upgrading/I-am-getting-a-connection-fail-error-while-connecting-to/m-p/2378382#M2579 Anonymous 2022-07-14T08:05:01Z Re: I am getting a connection fail error while connecting to MSSQLserver. https://community.qlik.com/t5/Installing-and-Upgrading/I-am-getting-a-connection-fail-error-while-connecting-to/m-p/2378383#M2580 <P>Yes, Its my windows Authentication. The SQL server uses windows Authenticate to log on, therefore I have used the same setting to configure it.</P><P>I have tried using SQL server Authentication, however it fails to connect to the server with a msg " that <span class="lia-inline-image-display-wrapper" image-alt="0695b00000Ss6uPAAR.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/145206i784FB3C9E9A7BA72/image-size/large?v=v2&amp;px=999" role="button" title="0695b00000Ss6uPAAR.png" alt="0695b00000Ss6uPAAR.png" /></span> I have not entered the password for the default user name "sa" . I am able to connect to the server using windows Authentication by using MSSQL server management studio.</P><P>&nbsp;</P><P>&nbsp;</P> Thu, 14 Jul 2022 10:16:44 GMT https://community.qlik.com/t5/Installing-and-Upgrading/I-am-getting-a-connection-fail-error-while-connecting-to/m-p/2378383#M2580 SANTOSH1657711471 2022-07-14T10:16:44Z Re: I am getting a connection fail error while connecting to MSSQLserver. https://community.qlik.com/t5/Installing-and-Upgrading/I-am-getting-a-connection-fail-error-while-connecting-to/m-p/2378384#M2581 <P>The issue is resolved now after corrected settings. Thanks ​</P> Fri, 15 Jul 2022 03:01:05 GMT https://community.qlik.com/t5/Installing-and-Upgrading/I-am-getting-a-connection-fail-error-while-connecting-to/m-p/2378384#M2581 SANTOSH1657711471 2022-07-15T03:01:05Z