Unable to install Jasper server in SQL Server 2016 SP1 with windows authentication

[narendrapothuganti7]

Hi Everyone,

From the release notes of Jasper Server 7.1, i have seen that JRS can be installed on SQL Server 2016. But, we are trying to install JRS 7.1.1 on SQL Server 2016 SP1 which uses windows authentication. We made sure that we have logged in with the correct domain user and trying to install JRS. Even though we are seeing the following issue in logs:

"Generic connection failure: [[TibcoSoftware][sqlServer JDBC Driver][sqlServer]Login failed. The login is from an untrusted domain and cannot be used with Windows authentication.]. Treating problem with JDBC connection as unrecoverable "

I got blocked here and need assistance from someone.

Regards,

Narendra.P

[danoldenkampgmail.com]

Well that sounds like your problem.

Set your SQL server to mixed mode.  When you are done with setup you can disable the SQL server accounts. 

Also make sure the user account used to install has local admin access.  (you don't have to grant Active directory access.  Just local to the server.)