Re: unable to run store procedure on remote server (win2k3sp1, sql2k sp4)

Hi

The notation is a bit confusing!!!

Check out sp_droplinkedsrvlogin in Books Online to drop them, and
sp_helplinkedsrvlogin to show them.

>From sp_addlinkedsrvlogin in BOL:
Rather than having to use sp_addlinkedsrvlogin to create a predetermined
login mapping, SQL Server can automatically use the Windows NT security
credentials (Windows NT username and password) of a user issuing the query
to connect to a linked server when all these conditions exist:

a.. A user is connected to SQL Server using Windows Authentication Mode.
b.. Security account delegation is available on the client and sending
server.
c.. The provider supports Windows Authentication Mode (for example, SQL
Server running on Windows NT).
John

"Justin" <justin@xxxxxxxxxxxx> wrote in message
news:OEYVDtuCGHA.344@xxxxxxxxxxxxxxxxxxxxxxx
> Hi John
>
> How do I drop the remote server login?
> e.g. from server A's sql query analyzer to do a query to run server B's
> store procedure. I don't think I can drop any server login in doing so.
>
> Justin
>
>
> John Bell wrote:
>> Hi
>>
>> Have you tried dropping the remote sever login and seeing what happens?
>>
>> John
>>
>>
>> "Justin" <justin@xxxxxxxxxxxx> wrote in message
>> news:%236hK2lrCGHA.3528@xxxxxxxxxxxxxxxxxxxxxxx
>>
>>>Hi all
>>>
>>>Need some help on this, and I could not find an answer after going
>>>through newsgroup/google.
>>>
>>>I have 2 servers, both on win2k3sp1, and sql2k sp4.
>>>I am having problem doing RPC of store procedures from either server to
>>>the other when I am using window authentication in query analyzer (both
>>>are on the same domain, using same domain user name login).
>>>
>>>the error I am getting is : could not connect to server 'dev2' because
>>>'null' is not defined as a remote login at the server. However if I use
>>>sql login in the query analyzer, things are fine.
>>>
>>>I've checked and make sure both are registered to each other as the
>>>remote server and checked RPC and using remote login mapping use "same
>>>name". I've also tried on local security policy to all impersonation of
>>>the particular domain user on each machine. I've rebooted both machines
>>>after the settings changes etc..
>>>
>>>It seems the remote login mapping is not working at all. any idea/help is
>>>very much appreaicated .
>>>
>>>thanks in advance.
>>>
>>>Justin
>>>
>>>
>>
>>

.

Relevant Pages