I cannot connect to SQL server using windows authentication.
The windows user “svc_ignition” is a DB admin on the SQL server, it is the user running the ignition service and is an admin on the server hosting the ignition service (windows server 2003 R2).
I have tried all steps as discribed in the posts below. I have installed the sqljdbc_auth.dll in the tomcat and JRE bin folders. I have added the following statement to the ignition.conf file:
wrapper.java.library.path.2=C:\Program Files\Microsoft SQL Server JDBC Driver 3.0\sqljdbc_3.0\enu\auth\x86
Please help. I can connect to this db using SQL Studio and windows authentication. There is something about the ignition service that cannot. I was able to connect using SQL authentication from ignition to trouble shoot, but this is not allowed in my environment. Saying it is better to just use SQL authentication is just poor design on the part of ID and ignition.
Please help me fix this.