IT Assistant and SQL Server 2000

Question

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.

tester25 · Answer

Are you using SQL Server 2000 SP3a for desktop? There are three versions of SQL Server 2000 SP3 available from Microsoft's website.

http://www.microsoft.com/downloads/details.aspx?familyid=90DCD52C-0488-4E46-AFBF-ACACE5369FA3&displaylang=en

Which one are you using?

ulli0815 · Answer

Hello tester25, i'm using the version for SQL Server 2000, SQL2KSP3.exe (SP3a).

tartler · Answer

Hi,

2 days ago I installed IT Assistant 5.0/7.3 on a new server with MSDE 2000 SP4 on Windows Server 2003 SP1 (german environment). I get the same error.

Before that I had IT Assistant 7.2 with MSDE 2000 SP3/SP3a (?) on Window XP SP2 an the error did not occur. I'm sure that I never configured anything with MSDE in both environments.

I would be pleased if anyone could help...

Frank

ulli0815 · Answer

Hi Frank,

it seems, that only some German versions didn't work correct.
But i haven't any problem with MSDE.
I've installed the MSDE by the IT Assistant Installation(7.1), but no SQL-Servicepack. Systemcontrol software shows 8.00.2039 for the SQL Desktop Engine.

tester25 · Answer

Frank,

Can you tell us exactly how you got your system to the way it is? Important things for us to know are if you installed MSDE2000 and then SP4 for it or if you installed SP3 before that and then moved to SP4... Thanks much.

tartler · Answer

Hi,

I had installed MSDE 2000 with integrated SP4 (to be downloaded from http://www.microsoft.com/downloads/details.aspx?displaylang=de&FamilyID=8e2dfc8d-c20e-4446-99a9-b7f0213f8bc5, file SQL2000.AS-KB884525-SP4-x86-GER.EXE).

I installed it using command line

setup.exe SAPWD="MyPassword" TARGETDIR="D:\Programme\Microsoft SQL Server MSSQL"

But I can't tell if IT Assistant installation asked for the MSDE password!?

Regards, Frank

tester25 · Answer

I tried to reproduce the issue but was unable to. Here's what I did:

1. Installed Windows 2003 with SP1 German Standard Server Edition
2. Install ITA 7.2 Gold (Allow MSDE2000 to be installed)
3. Start ITA and allow J2SE Runtime Environment 5.0 Update 3 to be installed
4. Discover at least one object (anything)
5. Close ITA
6. Download and install MSDE 2000 SP3a (sql2kdesksp3.exe) from http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=90dcd52c-0488-4e46-afbf-acace5369fa3
7. Start ITA
8. Click on the "Warnungen" menu, select "Filter"
9. Right click on "Warnungsmabnahmenfilter" and select "Neur Warnungsmabnahmenfilter"
10. Continue through the wizard and select the one system that you discovered. Go through to the end.
11. Click on "Fertig stellen" to finish it

No error messages appeared and the new filter was created.

Any suggestions?

tartler · Answer

Hi tester25,

there are some differences to the way I installed it, so this is my way:

- Install Windows Server 2003 SP1 german

- install MSDE 2000 SP4 (not SP3)

- install ITA 7.3 (not 7.2)

- start ITA (and allow JRE 1.5.0.3 to be installed)

- select Manage/Updates (translated from german Verwalten/Softwareaktualisierungen)

- select a package

- select register (Compliance?) "Uebereinstimmung"

- select a group to be compared

- click on butten compare

- error appears:

-----

error code 1051 (Fehlercode 1051

error message: error in SQL Report (Fehlermeldung: Fehler im SQL-Bericht

-----

Details:

DBConnection::executeWithResultSet:Stmt execution error.22003: [Microsoft][ODBC SQL Server Driver][SQL Server]Arithmetischer Überlauffehler beim Konvertieren von expression in den Datentyp datetime

Regards,

Frank

ulli0815 · Answer

Hi together, can you try to create a filter or compare a group before you install SQL SP3 or SP4?

tester25 · Answer

Frank,

Thank you. I'll give this a try. But there is no such thing as ITA 7.3. If you can find the link for the download and share it with me then I will believe you.

I did things a little bit differently and still wasn't able to reproduce the issue:

1. Installed Windows 2003 with SP1 German Standard Server Edition
2. Installed MSDE 2000 from the ITA install (Didn't install ITA yet though)

3. Installed MSDE 2000 SP4

4. Installed ITA 7.2 Gold
5. Start ITA and allow J2SE Runtime Environment 5.0 Update 3 to be installed
6. Discover at least one object (anything)
7. select Manage/Updates (translated from german Verwalten/Softwareaktualisierungen)

8. select a package

9. select register (Compliance?) "Uebereinstimmung"

10. select a group to be compared

11. click on butten compare

Error message didn't appear. Comparison worked successfully.

Thank you for trying to help me find this issue. I don't doubt that this issue exists, but it just seems difficult for me to reproduce.

Systems Management General

Was this post helpful?