AnsweredAssumed Answered

I am trying to connect to a MSSQL 2008 Server on a Windows Server 64 bit the standard connection to the database is not connecting. What do I need to do in order to connect to MSSQL 2008 Server on a Windows Server 64

Question asked by AlanWarnett258 on Jun 29, 2011
Latest reply on Aug 11, 2011 by RoyZolnoski782
My atom is deployed on a Windows Server 2003 32 bit server.  Previously we were connecting to SQL Server 2005 on this server (Test Instance), we have now created a new Server 2003 64 Bit running MSSQL 2008.  My application ( which is also running on the same Windows Server 2003 32 bit server ) is running fine (it connects using ODBC).  But I cannot get Boomi to connect to the new server/database.

Can you tell me the steps I need to take to get this working.  I have copied over the microsoft sqljdbc4.jar and placed it in the lib directory and tried to create a custom connection as well with the connection string " jdbc:sqljdbc4:sqlserver://htw-sql-prod-002:1433/AAD" but this did not work either.

Outcomes