small scenario problem in replication?

Hi ,

I had a server system with two instances of SQL (MSSQLSERVER of 2005) and another instance (Sql2008 of Sql 2008 r2) . I am trying to replicate from (Sql2008 of Sql 2008 r2) to another client system(Sql 2008 r2). I checked that they both are connecting from SSMS. i added user to the client database with the schema db_owner. but the problem is after configruing replication
1. i added user as some Domain/Bhuvan to the client who is administrator to the server
2. But it is showing as error in replication monitor log as Login failed for the user Domian/Bcdd1$

How come it possible? how to overcome this?


more ▼

asked Jun 08, 2011 at 09:27 PM in Default

avatar image

220 19 19 24

My doubt is why this difference is coming Domain/Bhuvan Domian/Bcdd1$

Jun 08, 2011 at 09:33 PM Bhuvans

any suggestions regarding this

Jun 08, 2011 at 09:50 PM Bhuvans

can we do replication between two different domains

Jun 09, 2011 at 01:33 AM Bhuvans
(comments are locked)
10|1200 characters needed characters left

1 answer: sort voted first

This may be a starting point http://www.replicationanswers.com/InternetArticle.asp have you read through the replication content in Books OnLine?

more ▼

answered Jun 09, 2011 at 01:46 AM

avatar image

Fatherjack ♦♦
43.8k 79 101 118

hats ok, i had seen that

but how about my first problem. To avoid that error i am using user and password for replication. but i dont want use that.. cant i overcome that?

Jun 09, 2011 at 02:20 AM Bhuvans
(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.



asked: Jun 08, 2011 at 09:27 PM

Seen: 849 times

Last Updated: Jun 09, 2011 at 01:03 AM

Copyright 2018 Redgate Software. Privacy Policy