# Ignition 7.3.1(on win7) SQLServer 2008 **URL:** \ **Category:** Ignition\ **Created:** [December 17, 2011, 12:14am UTC](https://forum.inductiveautomation.com/t/ignition-7-3-1-on-win7-sqlserver-2008/3771 "2011-12-17T00:14:49Z")\ **Posts on this page:** 11\ **Page:** 1
**Author:** ![Robert](https://avatars.discourse-cdn.com/v4/letter/r/e95f7d/32.png) [@Robert](https://forum.inductiveautomation.com/u/Robert)\ **Post date:** [December 17, 2011, 12:14am UTC](https://forum.inductiveautomation.com/t/ignition-7-3-1-on-win7-sqlserver-2008/3771/1 "2011-12-17T00:14:49Z")
SQLServer logs shows a successful connection. Ignition shows datasource as unknown. There is a TCP connection with keep alive packets from Ignition to SQLServer machine. There are also UDP packets going between them with a destination port of tcpnethaspsvr. Authentication is through the database not the domain. Any ideas what’s wrong? ---
**Author:** ![pphillips](https://avatars.discourse-cdn.com/v4/letter/p/da6949/32.png) [@pphillips](https://forum.inductiveautomation.com/u/pphillips)\ **Post date:** [December 17, 2011, 4:09pm UTC](https://forum.inductiveautomation.com/t/ignition-7-3-1-on-win7-sqlserver-2008/3771/2 "2011-12-17T16:09:25Z")
I presume you’re not talking about this: [inductiveautomation.com/support/kb/128](http://www.inductiveautomation.com/support/kb/128) There appears to be a Java 6 version 30 out that fixes this, but I haven’t tried it. ---
**Author:** ![diat150](https://avatars.discourse-cdn.com/v4/letter/d/a587f6/32.png) [@diat150](https://forum.inductiveautomation.com/u/diat150)\ **Post date:** [December 17, 2011, 7:11pm UTC](https://forum.inductiveautomation.com/t/ignition-7-3-1-on-win7-sqlserver-2008/3771/3 "2011-12-17T19:11:38Z")
yeah I had this happen the other day. downgraded to 27 and everything was fine. ---
**Author:** ![Robert](https://avatars.discourse-cdn.com/v4/letter/r/e95f7d/32.png) [@Robert](https://forum.inductiveautomation.com/u/Robert)\ **Post date:** [December 18, 2011, 4:12pm UTC](https://forum.inductiveautomation.com/t/ignition-7-3-1-on-win7-sqlserver-2008/3771/4 "2011-12-18T16:12:59Z")
Not the case here, I’m running 1.6.0\_21 ---
**Author:** ![Robert](https://avatars.discourse-cdn.com/v4/letter/r/e95f7d/32.png) [@Robert](https://forum.inductiveautomation.com/u/Robert)\ **Post date:** [December 19, 2011, 6:06pm UTC](https://forum.inductiveautomation.com/t/ignition-7-3-1-on-win7-sqlserver-2008/3771/5 "2011-12-19T18:06:36Z")
Upgraded to 7.3.2 problem still exists. One of the guys here thinks Ignition might be waiting for a response from the DB. Could that be the case? What sort of response should I be looking for? There is nothing showing in the log file even with the level set to ALL. It’s like it’s not even trying anything. ---
**Author:** ![Robert](https://avatars.discourse-cdn.com/v4/letter/r/e95f7d/32.png) [@Robert](https://forum.inductiveautomation.com/u/Robert)\ **Post date:** [December 19, 2011, 9:43pm UTC](https://forum.inductiveautomation.com/t/ignition-7-3-1-on-win7-sqlserver-2008/3771/6 "2011-12-19T21:43:19Z")
Does it make any difference what O/S the Gateway is install on? Do I need special SQLServer client software? ---
**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:** [December 19, 2011, 10:08pm UTC](https://forum.inductiveautomation.com/t/ignition-7-3-1-on-win7-sqlserver-2008/3771/7 "2011-12-19T22:08:37Z")
If you set the loggers to ALL and then force a reconnection to SQLServer (edit and save the connection), is there still nothing in the console? ---
**Author:** ![Robert](https://avatars.discourse-cdn.com/v4/letter/r/e95f7d/32.png) [@Robert](https://forum.inductiveautomation.com/u/Robert)\ **Post date:** [December 19, 2011, 10:23pm UTC](https://forum.inductiveautomation.com/t/ignition-7-3-1-on-win7-sqlserver-2008/3771/8 "2011-12-19T22:23:45Z")
only the message from the store and forward cache about skipping because there is nothing to do. ---
**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:** [December 19, 2011, 10:46pm UTC](https://forum.inductiveautomation.com/t/ignition-7-3-1-on-win7-sqlserver-2008/3771/9 "2011-12-19T22:46:12Z")
It looks like Java 6 update 29 was installed on Robert’s computer. You can check what version of Java is being used in the Gateway under System-\>Status. There is an entry for ‘Java Version.’ This often comes up when both 32bit and 64bit versions are installed on the computer at the same time. ---
**Author:** ![Robert](https://avatars.discourse-cdn.com/v4/letter/r/e95f7d/32.png) [@Robert](https://forum.inductiveautomation.com/u/Robert)\ **Post date:** [December 19, 2011, 11:43pm UTC](https://forum.inductiveautomation.com/t/ignition-7-3-1-on-win7-sqlserver-2008/3771/10 "2011-12-19T23:43:11Z")
😊 Like Bobby said, I had two versions of Java installed. The command line returned the 64 bit version, Ignition was using the 32 bit version. After updating to 1.6.0\_30, restarting several times to apply the windoze updates I downloaded this morning, waiting for it to restart only to tell me it has to reboot again a couple more times… 👿 It works! Thanks Bobby, ---
**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:** [December 20, 2011, 8:03pm UTC](https://forum.inductiveautomation.com/t/ignition-7-3-1-on-win7-sqlserver-2008/3771/11 "2011-12-20T20:03:07Z")
> [@](#): > > After updating to 1.6.0\_30... Ah, didn't know that was out, but good to note here. Looks like this problem was the primary fix for update 30, and is detailed in [this bug ticket](http://bugs.sun.com/bugdatabase/view_bug.do?bug_id=7103725) in the Java bug tracker.