January 9, 2007 at 9:15 am
Is it possible to map a SQL login as the local login and have it use a windows login as the remote login? I can't seem to get it to work. I have a SQL login I use for my web apps to get information, but we just moved a linked server to Windows 2003 Server and now certain processes won't run unless the user is the domain admin. I run some of these processes from the web apps via xp_cmdshell, but since they are not connecting to the linked server via the administrator, it is failing. How can I link sql login with a domain windows login as the remote (just for now so we can get things working)?
Thanks,
Adam
January 9, 2007 at 12:53 pm
I did not understand your question completely but....
If you want to map the login to run the xp_cmdshell on the remote server you can map it to 'sa'... I don't think you can map it WIDOWS login...
Becareful when you are using xp_cmdshell thourgh app...
Check the following two articles...
http://support.microsoft.com/kb/555017
http://support.microsoft.com/?kbid=834849
MohammedU
Microsoft SQL Server MVP
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply