December 17, 2008 at 11:13 pm
Hi,
I'm setting up replication on my test servers.
server1 - publisher+distributor
server 2- subscriber
authentication mode-sql server authentication
I'm following steps given at one of excellent sqlservercentral articles..
http://www.sqlservercentral.com/articles/Replication/sql2000replicationarchitecture/1154/
Step at which i'm getting stuck - 5th step once i Click FINISH.
I'm getting following error
SQL Server Enterprise manager could not configure '10.32.160.54' as the distributor for '10.32.160.54'
Error 18483: Could not connect to server 'ottqwq5ccrm01' because 'distriburor_admin' is not defined as a remote login at the server.
I've created this login and grated system administrator login still the same error.
Can someone guide me on this particular error.
I intend to test snapshot replication first which few tables, then transaction with Push and pull seperately and finally merge.
Thanks in advance.
December 17, 2008 at 11:28 pm
just wanted to add that the ip address and the server name in the error message are of server1.
December 17, 2008 at 11:39 pm
wow!! what an error!
In my enterprise manager, i had added the server's IP instead of name. It seemed it got confused that distributor is located on a different server and hence asking me to provide distributor_login as a remote_login which, obviously, i wasnt able to do.
I just added the same server in enterprise manager with its name and it didnt stop at that stage!!
December 18, 2008 at 12:42 am
Hi I've setup the snapshot replication.
I'm getting this error:
The process could not create file '\\OTTQWQ5CCRM01\Repl\unc'.
Can someone guide me the cause of this. All i can see is "access denied".
I've changed the owner of the job to an account which is administrator on the server.
December 18, 2008 at 5:32 am
It seems i'll get all possible errors thats possible :hehe:
I changed the account running sql server agent to LocalSystem and that resolved the issue. (i'm still unsure why it was resolved doing this, as it just needed permission to write to a local shared folder. Just to add 'everyone' has full permission on the shared folder.)
I'm able to generate the snapshots now.
The issue now is the distribution agent is unable to connect to the subscriber. I tried both push and pull subscriptions and both failed 🙁
I further found that from server A i wasnt able to connect to server B. Though i was able to ping using server name and IP address, it wont connect. Later i learnt that server B is running on named pipes.
I added an alias of server B on server A and that is also resolved.
I thought this was probably the reason why the subscriptions were not pushed to server B. But even after this the issue remains a challenge.
Any assistance on this will be highly appreciated.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply