October 9, 2008 at 8:44 am
Can anyone tell me what i need to do to get this working:
I've setup a linked server using MSIDXS for my remote Index Server which is on the same LAN as the SQL server.
When I write a little T-SQL to query the index server using the Windows AUTH account to logon to the sql server everything works fine.
When I write the same T-SQL query while logged in as 'SA' i get an ACCESS DENIED error.
I've tried mapping the SA account inside the linked server properties but it doesn't seem to make any difference.
HELP !!!!!!!!!!!!!!!!!!!!!
October 9, 2008 at 3:00 pm
I'm not sure why you would want to do this.
I'm assuming SA is activated on both servers? Are you mapping sa (local) to sa (linked) or impersonating?
SQL might have qualms about letting the SA user do this.
I'm having kinda the opposite problem getting windows auth to work.
My two cents, not sure if this'll give you anything.
October 10, 2008 at 2:40 am
The second server doesn't have sql installed, i'm only trying to connect to a remote index server. I've got a workaround which is setting the index server up on the same machine as the sql server but it's not ideal....any ideas????
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply