# Windows 7 MSSS2008 First time set up **URL:** \ **Category:** Archived Topics\ **Created:** [February 23, 2011, 7:04pm UTC](https://forum.inductiveautomation.com/t/windows-7-msss2008-first-time-set-up/2683 "2011-02-23T19:04:23Z")\ **Posts on this page:** 6\ **Page:** 1
**Author:** ![Kfoldesi](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/kfoldesi/32/11327_2.png) [@Kfoldesi](https://forum.inductiveautomation.com/u/Kfoldesi)\ **Post date:** [February 23, 2011, 7:04pm UTC](https://forum.inductiveautomation.com/t/windows-7-msss2008-first-time-set-up/2683/1 "2011-02-23T19:04:23Z")
I can’t get connected. Just got the PC to set up for a new job. First time w/Windows 7. Installed sql 2008 r2 and tried to set up a connection to it on the same machine. I have: Enabled tcp/ip in SQL Server Network Configuration Manager Copied sqljdbc4 in C:\Program Files\Inductive Automation\Ignition\tomcat\webapps\ctx0\WEB-INF\lib Copied sqljdbc\_xa.dll in C:\Program Files\Java\jre6\bin Still I get : com.microsoft.sqlserver.jdbc.SQLServerException: This driver is not configured for integrated authentication. from Status/database/details in ignition. I’ve included a picture of my data connection settings. I can’t find the problem. Any idea’s? ---
**Author:** ![Kfoldesi](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/kfoldesi/32/11327_2.png) [@Kfoldesi](https://forum.inductiveautomation.com/u/Kfoldesi)\ **Post date:** [February 23, 2011, 7:05pm UTC](https://forum.inductiveautomation.com/t/windows-7-msss2008-first-time-set-up/2683/2 "2011-02-23T19:05:45Z")
Pic ![](https://us1.discourse-cdn.com/inductiveautomation/original/1X/a8285973a6db2c110c68c4145f148cf9936cf57f.jpg) ---
**Author:** ![Colby.Clegg](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/colby.clegg/32/3282_2.png) [@Colby.Clegg](https://forum.inductiveautomation.com/u/Colby.Clegg)\ **Post date:** [February 24, 2011, 2:20am UTC](https://forum.inductiveautomation.com/t/windows-7-msss2008-first-time-set-up/2683/3 "2011-02-24T02:20:49Z")
Unfortunately, getting integrated authentication working is very tricky. Sorry I didn’t see this post earlier in the day, I think one of the guys here wrote a guide to it… I’ll ask him to post tomorrow. Is SQL Authentication not an option here? It would be much easier, just switch SQL Server to “mixed mode” and make an account. Regards, ---
**Author:** ![Robert.McKenzie](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/robert.mckenzie/32/4134_2.png) [@Robert.McKenzie](https://forum.inductiveautomation.com/u/Robert.McKenzie)\ **Post date:** [February 24, 2011, 5:27pm UTC](https://forum.inductiveautomation.com/t/windows-7-msss2008-first-time-set-up/2683/4 "2011-02-24T17:27:52Z")
You can check out the information in this [post](http://www.inductiveautomation.com/forum/viewtopic.php?p=10375#p10375). You need to grab the sqljdbc\_auth.dll from the Microsoft hotfix. More info [here](http://inductiveautomation.com/forum/viewtopic.php?f=68&t=4792&p=10426&hilit=sqljdbc_auth.dll#p10426) as well. ---
**Author:** ![ecujak](https://avatars.discourse-cdn.com/v4/letter/e/839c29/32.png) [@ecujak](https://forum.inductiveautomation.com/u/ecujak)\ **Post date:** [November 16, 2011, 3:17pm UTC](https://forum.inductiveautomation.com/t/windows-7-msss2008-first-time-set-up/2683/5 "2011-11-16T15:17:54Z")
Showing that these topics no longer exist. I would like to see this work step. ---
**Author:** ![Robert.McKenzie](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/robert.mckenzie/32/4134_2.png) [@Robert.McKenzie](https://forum.inductiveautomation.com/u/Robert.McKenzie)\ **Post date:** [November 17, 2011, 6:32pm UTC](https://forum.inductiveautomation.com/t/windows-7-msss2008-first-time-set-up/2683/6 "2011-11-17T18:32:32Z")
Since those links are now broken, here is the relevant text: To use Windows Authentication, where the connection is authenticated using the identity of the user running the Ignition gateway, you must first install the Microsoft JDBC driver package. The driver package can be found at: [msdn.microsoft.com/en-us/sqlserver/aa937724.aspx](http://msdn.microsoft.com/en-us/sqlserver/aa937724.aspx) Burried in that package, you will find a sqljdbc\_auth.dll file. Copy the correct file for your architecture (64 vs 32 bit) into the following two directories: \Ignition\tomcat\webapps\main\WEB-INF\lib and \Java\\bin (ie: C:\Program Files\Java\jre6\bin, and make sure you use the folder for the right architecture) Then restart the Ignition service. Here is the full Knowledge Base Article: [Microsoft SQL Server Connection Guide for Ignition](http://www.inductiveautomation.com/support/kb/129)