May 17, 2006 at 12:40 pm
I constructed a fairly simple DTS package that exports a table to a flat file on the the same SQL Server.
When I attempt to schedule that package I receive the following error:
Microsoft SQL-DMO (ODBC SQL STATE: 42000)
[Microsoft][ODBC SQL Server Driver][SQL Server] Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.
Nothing has changed in my environment that I'm aware of. Any ideas would be appreciated.
May 17, 2006 at 12:47 pm
Once you schedule the package, SQL Server creates a job to execute the package. In EM, go to Management>>SQL Server Agent>>Jobs and find the job for your package. Look at the job properties and make sure the Owner is set correctly.
May 17, 2006 at 12:55 pm
Thanks John. The problem is that SQL Server is not creating the job.
BTW: This is SQL Server 7.0 Std Ed.
May 17, 2006 at 1:02 pm
Ah, I appologize. I did not read your question correctly. I was thinking that your error was during runtime.
May 18, 2006 at 8:14 am
I haven't used SQL 7.0 in a long time and I rarely use DTS, but I have seen that kind of error before when SQL security authentication is set to Windows only and you are trying to connect to SQL with a SQL Server login.
I may be way off but thought I would throw that out there..
May 18, 2006 at 8:24 am
David,
Thanks for the response. The server is set for Mixed Mode authentication, and I have jobs that have already been setup that are working fine.
Greg
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply