Agent for Service Pack 3

[boligoma]

Hi,

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 database

The SQLSERVERAGENT is running fine. Before the installation, I needed to make the agent able to interact with desktop in order that it could work with the Interbase DB.

 

[boligoma]

a few notes about it:

Before the installation of the SP3, I needed to make the agent able to interact with desktop in order that it could work with the Interbase DB.

 

[boligoma]

We 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,

 

[tlbroadbent]

MSDE is a desktop version of SQL Server and as such has nothing to do with the SQL Agent running on your server. I recommend reading SQL BOL or visting the Microsoft web site to learn about the editions of and components of SQL Server. If you want to get the best answer for your question read faq183-874 and thread183-468158.


Terry L. Broadbent - DBA
SQL Server Page:

http://tlbroadbent.home.attbi.com/sql/sql_articles.htm