unable to run store procedure on remote server (win2k3sp1, sql2k sp4)
- From: Justin <justin@xxxxxxxxxxxx>
- Date: Tue, 27 Dec 2005 15:45:06 +0800
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
.
- Follow-Ups:
- Prev by Date: Re: No data in Sql server 2005
- Next by Date: Re: unable to run store procedure on remote server (win2k3sp1, sql2k sp4)
- Previous by thread: Cannot login SQL Server with 'sa'
- Next by thread: Re: unable to run store procedure on remote server (win2k3sp1, sql2k sp4)
- Index(es):
Relevant Pages
|
