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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2007-02-28 : 08:06:34
|
| Daniel writes "I run a query in sql query analyzer "(select * from openquery(External,'Select name from contact')". The connection is made using windows authentication as user 'XX', and it returns the expected results. If I place the same query in a job and run it, I receive an authentication error for user 'XX' shown in the detailed job history.P.S. I have changed the logon of the SQL agent from the Local system account to 'XX'.Any ideas please? (MSDE 2000 and Windows XP)." |
|
|
rlaubert
Yak Posting Veteran
96 Posts |
Posted - 2007-02-28 : 16:04:35
|
| Who is the owner of the job? I have this type of an issue with jobs atm... my domain account will not work with jobs have to use sa. But I am in the SQLAdmin group and it has System Admin priv.... still havent figured that one out yet.Raymond LaubertMCDBA, MCITP:Administration, MCT |
 |
|
|
|
|
|
authentication problem with linked server query