Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
kaus
Posting Yak Master
179 Posts |
 Posted - 2004-07-27 : 12:31:02
|
| Have been having some problems with SQL Server Agent. We're running SQL 2000 version 8.00.760 (to sp 3 I believe) and recently converted our server to Server 2003 Standard edition. Scheduled jobs (other than backups --thankfully) are failing -- Get popups saying 'Procedure Entry Point GetTextExtentPointI could not be located in the dynamic link library MSDART.DLL). The application log is also full of MSSQLSERVERAGENT errors. Are there any problems between SQL 2000 and Server 2003 ?? The jobs are Active X Scripts that write out XML files -- they run ok when I execute them manually but dont run as scheduled. Full text indexing is not working eitherThanksPete |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-07-27 : 13:00:34
|
| You need to install SL Server 2000 service pack 3a in order to use SQL Server 2000 on Windows Server 2003. You should also install the latest security patch as it includes bug fixes as well.Tara |
 |
|
|
kaus
Posting Yak Master
179 Posts |
Posted - 2004-07-27 : 13:09:47
|
| Thanks |
|
|
|
kaus
Posting Yak Master
179 Posts |
Posted - 2004-07-28 : 11:52:55
|
| I applied the sp3a but still have same problem. I can run the packages on my client machine (Windows XP) but not on the server Server 2003 -- it keeps erroring on the MSDART.dll -- perhaps there are different versions of this dll on the server and client which are causing this ?? Can I put the dll from my client on to the server without problems ?? ThanksPete |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-07-28 : 13:50:18
|
| You could certainly try it. The only information that I could find in MS' knowledge base was this:http://support.microsoft.com/default.aspx?scid=kb;en-us;842014Perhaps you could try installing MDAC 2.8 to see if it fixes your SQL Agent problem.If MDAC 2.8 doesn't work, I think that you'll need to reinstall SQL Server 2000 then immediately service pack 3a.Tara |
|
|
|
kaus
Posting Yak Master
179 Posts |
Posted - 2004-07-28 : 14:01:42
|
| Thanks - I'll give the MDAC 2.8 a shot -- I dont want to reinstall SQL Server, but it was installed before Server 2003 -- maybe it got out of sorts |
|
|
|
kaus
Posting Yak Master
179 Posts |
|
|
|
|
|
SQLServer Agent Problems