SQL Login -> Remote Windows Account

Question

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

mobasha SSCertifiable Points: 5334 More actions · Answer 1

i have faced the same problem, using sql login on both server did it.

..>>..

MobashA

Joseph Fallon SSCommitted Points: 1669 More actions · Answer 2

Thanks for that Mobasha.

That won't work for me though because I want to run a job on Server B that requires access to a network drive.

mobasha SSCertifiable Points: 5334 More actions · Answer 3

so u want serverA to use like a folder in serverB.

if so u can create table in serverB, use the linkserver to but a command from serverA to serverB,

create a trigger on serverB table and executing the command.

i know its not an easy thing but it might solve ur case.

..>>..

MobashA

Joseph Fallon SSCommitted Points: 1669 More actions · Answer 4

Thanks for the suggestion Mobasha

I think I have a solution now.

I created a sproc on Server B to run the job using EXECUTE AS TheWindowsLogin

I then just link the SQL Logins between the servers (using Impersonate) and grant execute on the new sproc to the SQL Login.

Thanks for your help.

🙂