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

Interestingly, they are using the same domain login account.
so I suspect it is to do with the w2k3 setup etc.

Justin


John Bell wrote: 
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

  • gdm hangs
    ... gdm will hang 9 of 10 times when logging out. ... with or without the client having been connected to the Server. ... # Timed login, useful for kiosks. ... Must output the chosen host on stdout, ...
    (Debian-User)
  • RE: OWA 2003 with ISA 2004
    ... OWA externally. ... i can login by any user. ... 825763 How to configure Internet access in Windows Small Business Server ... g. Reproduce this issue and send the logs to me. ...
    (microsoft.public.windows.server.sbs)
  • Re: Compromised Server? Anyone recognize the suspect Services?
    ... there are a bunch of logins for Website Accounts created by the ... The login accounts are for web sites that are on the ... Server management is ... right under Network Connections there were 3 ...
    (microsoft.public.windows.server.networking)
  • Re: MS Project Server 2003 login error
    ... > How are they trying to login again? ... > log on", and you are using Windows Authentication, then make sure they're not ... it will authenticate them through to the server. ... Cheryl ...
    (microsoft.public.project.pro_and_server)
  • Re: I cant login to Sql no matter what i try! im ignorant and i need help :)
    ... It sounds like your server is configured for Windows authentication ... >requested in login 'T254DN_Staging'. ...
    (microsoft.public.dotnet.framework.aspnet.security)