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

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: log in screen
    ... I did login into the server from the server side, ... Logon Remote Web Workplace and then click the link: ... I'd like to provide the following information about the SBS Remote Web ...
    (microsoft.public.windows.server.sbs)
  • Re: schtasks
    ... Multiple connections to a server or shared resource by the same user, ... on the machine I issued this command I was login as Joe, ... >>However I also discovered that if the remote machines were already login ...
    (microsoft.public.win2000.cmdprompt.admin)
  • Re: Remote Access Confusion
    ... I was finally able to get into the Administrator login from the Server. ... I am trying to enable remote access for my ...
    (microsoft.public.windows.server.sbs)
  • Re: Trouble registering a server
    ... When I log in to the remote machine using Remote Desktop Connection, ... I am told by the owner of the server that he set me up with Admin rights. ... >> login for my windows username so that, ...
    (microsoft.public.sqlserver.setup)
  • Re: restrict ssh access
    ... > We have one ssh server which receives about 6000 failed attempts to ... > unsuccessful login attempts per client IP address? ... the remote server is also running OpenSSH. ...
    (comp.security.ssh)