UNSOLVED
IT Assistant and SQL Server 2000
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.
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.
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
- 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. 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
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 itNo error messages appeared and the new filter was created.
Any suggestions?
- 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 1051error 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 datetimeRegards,
Frank - 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 SP44. 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 package9. select register (Compliance?) "Uebereinstimmung"10. select a group to be compared11. click on butten compareError 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.
tester25
626 Posts
1013
0
Posted April 13th, 2006 15:00
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?