Unsolved
This post is more than 5 years old
6 Posts
0
15308
April 5th, 2006 10:00
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.
No Events found!
tester25
626 Posts
0
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?
ulli0815
6 Posts
0
April 24th, 2006 08:00
i'm using the version for SQL Server 2000, SQL2KSP3.exe (SP3a).
tartler
20 Posts
0
June 16th, 2006 08:00
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
6 Posts
0
June 20th, 2006 09:00
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
626 Posts
0
June 20th, 2006 13:00
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
20 Posts
0
June 21st, 2006 04:00
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
626 Posts
0
June 21st, 2006 16:00
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
20 Posts
0
June 22nd, 2006 04:00
Frank
ulli0815
6 Posts
0
June 22nd, 2006 06:00
can you try to create a filter or compare a group before you install SQL SP3 or SP4?
tester25
626 Posts
0
June 22nd, 2006 14:00
2. Installed MSDE 2000 from the ITA install (Didn't install ITA yet though)
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)