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.
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.
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.
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…
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 in the Java bug tracker.