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

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: Terminal Services Setup/Flaw
    ... This still allows everyone to hit the TS Server but denies the login to ... Terminal Server with this user and then .rdp into another server on the ... I found the Remote ...
    (microsoft.public.windows.terminal_services)
  • 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)