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 |
|
yaman
Posting Yak Master
213 Posts |
 Posted - 2009-06-30 : 09:41:40
|
| sir , I am creating two types Link Server and used in two procedures.One link server is based on user authentication & another one is based on windows authentication of sql server .I am scheduled my both procedures which is using .Problem is that :- one procedure is execute & fetch data using link server( Windows authencation Link server ) BUT my second procedure is failed to fetch data from source .my quetion is scheduling is based on user logon in SQL .Pls help me out .Yaman |
|
|
tosscrosby
Aged Yak Warrior
676 Posts |
Posted - 2009-06-30 : 09:51:17
|
| Depends. I execute various packages with a specific windows based login, specified at package creation and applicable to the specific server being queried. My scheduled jobs run using the SQL Server Agent services login ID, again depending on how I set it up. What is the detailed error message you are receiving?Terry-- Procrastinate now! |
 |
|
|
yaman
Posting Yak Master
213 Posts |
Posted - 2009-06-30 : 09:57:27
|
Error LOGON FAILED FOR USER'NT AUTHORITY\ANONYMOUS LOGON'.quote:
Originally posted by tosscrosby
Depends. I execute various packages with a specific windows based login, specified at package creation and applicable to the specific server being queried. My scheduled jobs run using the SQL Server Agent services login ID, again depending on how I set it up. What is the detailed error message you are receiving?Terry-- Procrastinate now!
Yaman |
|
|
|
|
|
|
Job scheduling