Moving ESET RA SQL database

Hi everyone,

What I am trying to do is move my existing ESET database (running on SQL 2000, clustered) to a SQL 2005 server, clustered. I was able to do so effectively using the ERA Maintenance Tool ( I see the new ESET db on my new SQL server and it loks as if all tables are populated with data). However, when I attempt to modify the server configuration using the ERA Maintenance Tool and modify the database server settings with the new SQL server information, the ESET Server service will not restart. My guess is that I have the database connection string wrong, but I am unsure. Here is what I have tried:

Database Connection: Driver={SQL Server};Server=sqlservernameatabase=ESET

Database Connection: DSN=ESET (this is the name of a system DSN I have configured on the server)


Does anyone have any input?...Bueller?....Bueller

 

update: I think I may have determined the issue. It appears that whenever I used Windows Integrated auth, the connection fails. However, if I use SQL auth, then I am able to make a successful connection.

Can anyone confirm that Windows Integrated auth in SQL is not supported for establishing a db connection in ESET RA?