Remote Login errors
-
HI,
I am trying to setup merge replicaton , for the first time it worked fine but when i implemented on real server it gives error that rempote login doesnt exists.
So i disabled the published and subscriber and setup again .
But still it giving me error that remote login doesnt exists.
thanx
from
Killer
-
You must check your server name before create the publication, please check with @@SERVERNAME, the server name must be in the list.
If the server name not in the list, you must add the server name with the "sp_addserver". For complete reference please follow the BOL.
-
Hi,
Ichecked everything.I have remote server ( subscriber) and mapped logins.
but still i am getting the same error.
from
Killer
-
Could you please to specified the error message?
-
sql server could not configure database as distributor for database( i am making distrubutor on my local database only)
error 14114 (null) is not configured as distributor.
i solved the error and recreated the remote server but stil now it is giving me error.
the second error is the remote login not mapped.
but i wanted to know that do i have to make the remote server of the subscriber database or the local database.
and do i have to make the remote login on subscriber also.
hope u understand.
from
Killer
-
Dear Raj,
I'm sure that is because the servername, please refer to the BOL in the section sp_addserver
-
Dear Deni,
I used to the below to create a linked server or remote server
exec sp_addserver 'ipaddress' or computername
EXEC sp_addremotelogin 'ipaddress or computername', 'sa', 'sa'
GO
EXEC sp_remoteoption 'ipaddress or computername', 'sa', 'sa', trusted, true
GO
EXEC sp_configure 'remote access', 1
RECONFIGURE
I wanted to ask u that do i have to create the remote server on the server which i will give as subscription database in the replication.
secondly the remote user should be present on both the server.
hope u understand.
from
Killer
-
I think the 'local' option in the sp_addserver must be specified, because you configure the replication in the local machine, right?
-
Hi,
Now the error is as follows
Error: 18483 : could not connect to server(server name) because distributor_admin is not defined as remote login at the server.
from
Killer
-
Now you add the user id (distributor_admin) to the remote server as a remote login
-
Hi Dear,
I added the distributor_admin as remote login.
But still i am deep in the hell.
the Error is :
error :21007 Cannot add the remote Distributor. Make sure that the local server is configured as a Publisher at the Distributor.
hope i will be out of this hell
from
Killer
-
Have you looked through this KB article?
http://support.microsoft.com/?id=321822
When your deep in hell, the best thing I find is to roll everything back to the point where it's like nothing happened, then start over again.
--------------------
Colt 45 - the original point and click interface
-
Also, have you run SELECT @@SERVERNAME on both servers and verified that the name is not set to null?
--------------------
Colt 45 - the original point and click interface -
Hi,
I had disabled the replication 3 times but still the same error.
i looked in that artical before i posted my question.
from
Killer
-
Hi Phill,
If u seen the discussion the u might have read then u might have seen that i am out of that problem.
I means to say that if @@servername is null then i have not faced another error and so on.
But thanx this doesn't helped me
from
Killer
Viewing 15 posts - 1 through 15 (of 34 total)
You must be logged in to reply to this topic. Login to reply