| Author |
Topic |
|
boligoma
Starting Member
5 Posts |
 Posted - 2003-02-12 : 17:17:42
|
| I recently installed Service Pack 3 on SQL Server 2k and I'm running jobs that execute DTS that connect to an Interbase DB via ODBC. When you run manually the DTS it works fine.The jobs are returning the following error:[ODBC Interbase 4.1 Driver] [Interbase] unavailable databaseBefore the installation of SP3 I have no problems in running the jobs. I didn't install the MSDE part because it is only for new SQL instances. Does this MSDE part have anything to do with the SQL Agent conection?... or I'm totally lost??thanks |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-02-12 : 17:41:55
|
| If your installation is MSDE, then should install the MSDE service pack. If your installation is SQL Server, then install the SQL Server service pack 3 (and the analysis service service pack if that was installed). I do not know why you are encountering this problem after the installation of service pack 3. Have you tried deleting your job and then recreating it? |
 |
|
|
boligoma
Starting Member
5 Posts |
Posted - 2003-02-12 : 17:46:48
|
| Yes, I tried it and it stills shows me the same error.Edited by - boligoma on 02/12/2003 17:57:22 |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-02-12 : 18:03:50
|
| I suggest that you uninstall service pack 3 and then install service pack 2 along with the latest cumulative security patch (this protects you from the SQL slammer). Microsoft is going to re-release service pack 3 (although they haven't given us a date), so I would wait for this re-release and see if it fixes your problem. If uninstalling service pack 3 doesn't fix your problem, then your problem is not with sp3. |
|
|
|
royv
Constraint Violating Yak Guru
455 Posts |
Posted - 2003-02-13 : 08:53:35
|
| tduggan, do you have a link where i could read about the re-release of service pack 3 ?***************************************Death must absolutely come to enemies of the code! |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-02-13 : 13:26:44
|
| I do not have a link. We received this information via our Microsoft representative (we are a Premier customer). They have recommended that we do not install service pack 3 until the re-release of it due to the bugs that were introduced with service pack 3. |
|
|
|
boligoma
Starting Member
5 Posts |
Posted - 2003-02-14 : 11:40:28
|
| Yes, in fact it was due to the SP3 that the SQL Agent didn't connect to the Interbase DB. I restored SQL and installed SP2 with the latest fix and it ran witout problems.Let just hope the new release of SP3 doesn't take too much and that these little details have been fixed.thanks again!!!!! |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-02-14 : 17:48:35
|
| I'm glad that solved your problem. Each day it seems that someone posts a problem that they have had after they have installed service pack 3, so we're definitely going to hold off installing this one. We have no need for service pack 3 since we have so far not encountered any of the bugs that service pack 3 has fixed. |
|
|
|
mjones
Starting Member
1 Post |
Posted - 2003-02-14 : 18:57:58
|
| I emailed my Microsft Technical Account Manager (TAM) asking about the validity of the re-release of SP3. It appears it isn't true. His reply was:Mike,I just got confirmation from the SQL team that the post on sqlteam.com is not true. Microsoft is not re-releasing SQL 2000 SP3.The SQL team thanks you for bringing the post to their attention.Thanks.Tom. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-02-18 : 12:16:20
|
| Hmmm, that's different than what our Microsoft representative told us. Maybe they are going to release it as service pack 4. At any rate, we will not be installing service pack 3 due to the numerous bugs service pack 3 has created.Edited by - tduggan on 02/18/2003 12:23:06 |
|
|
|
|
SQL Agent after installing SP3