April 9, 2004 at 12:04 pm
This is my first post and I am hoping someone can help me. My DTS jobs are not working. From a Workstation (my desktop)I can both execute the package and schedule it. However I can't schedule using Enterprise manager from the server nor will the job run when scheduled. The error I get is:
Microsoft SQL-DMO (ODBC SQLState:42000)
[Microsoft][ODBC SQL Server Driver] [SQL Server] Login failed for user (null)'. Reason: Not associated with a trusted SQL Server Connection.
I am logging in with a domain name user. I realize this is some type of security issue but the user has System Admin rights as well as Domain admin rights. Can anyone think of anything I can look at? Any ideas? I am fairly new to SQL administration and this has me scratching my head. Thanks in advance for any assistance you can give.
April 9, 2004 at 12:11 pm
Right clikc on server in EM on your server machine and check registration properties. Either use SQL user with enough privileges or use yourself (windows authenitcation) if you have permission to run the package.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply