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

Hi Justin

If both servers and the logins are on the same domain then B should be ok!

It sounds like the accounts did not have logins on both servers?

John

"Justin" <justin@xxxxxxxxxxxx> wrote in message
news:%236%23cmMwCGHA.528@xxxxxxxxxxxxxxxxxxxxxxx
> Hi John
>
> thanks for the hint, though by dropping the linkedsrvlogin did not help in
> my case, I did managed to get around by manually addremotelogin and
> addlinkedsrvlogin and do some user mapping in them.
>
> now it works, so it seems to be the problem with addlinkedsrvlogin or
> maybe one of the three condition was not met, I suspect the condition b
> could be the cause, but I am not sure how to verify it. I figure it could
> very much to do with some security related setting/policy in my win2k3.
>
> thanks very much again.
> at least now I get something working.
>
> Cheers
> Justin
>
>
>
>
> John Bell wrote:
>> 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

  • Re: Event viewer security issue
    ... How to Restore the Default NTFS Permissions for Windows 2000 ... Microsoft Certified Professional ... "John" wrote in: ... |> After that, reboot the server. ...
    (microsoft.public.windows.server.general)
  • Re: ASP.NET User.Identity.Name value after a domain username chang
    ... Since .NET is just calling into Windows API calls to resolve the user name, ... I have an ASP.NET application that is on a Win2000 server in a domain ... I have a very confusing issue when the domain login of a user is ... I thought this might have been some caching issue on the client so I ...
    (microsoft.public.dotnet.framework.aspnet.security)
  • Re: CAN WE LOGIN TO A WINDOWS 2003 ACTIVE DIRECTORY DOMAIN OVER TH
    ... Having a user login to a windows 2003 server over the internet is not a good ...
    (microsoft.public.windows.server.active_directory)
  • Re: Win2003 Console Login Screen Black- Cant Log In
    ... it discovered the existing install, ... > I've got a Windows 2003 Standard server. ... This is also our Veritas Netbackup server. ... > black screen with only part of the login prompt showing. ...
    (microsoft.public.windows.server.general)
  • Re: CAN WE LOGIN TO A WINDOWS 2003 ACTIVE DIRECTORY DOMAIN OVER THE IN
    ... If I create a user in active directory in windows 2003 server, ... login to that user using windows xp login dialog box within the network ... and you can resolve DNS from the point of view of an INTERNAL ...
    (microsoft.public.windows.server.active_directory)