Hello,

I'm trying do use SQL Server 2000 SP3 with IT Assistant 7.1 and 7.2. First I've installed IT Assistant with remote SQL-database and then I've tried an installation on the database server.
In both cases I can't create filters. When I try to create a filter, I get an error message: "Errorcode:1051, Errormessage: Error in SQL-report" (translated from german error messages). In the details: Stmt execution error 22003. Overflow converting from expression to datatyp datetime.

Both servers (for IT Assistant and SQL server) are w2k3 with SP1. An installation with MSDE works fine. If I use SQL 2000 SP3 for the database the IT Assistant runs, but I can't create filters.

I guess, that the SQl version plays a role. I couldn't find any hints to the required SQL version, only that I shouldn't use SQL 7.0.

Is there anyone using IT Assistant >= 7.1 with SQL 2000 SP3 without problems?
Will filters working with SQL 2000 SP4?
There are other databases on the SQL server, so the update to SP4 isn't trivial.