question

Bhuvans avatar image
Bhuvans asked

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? regards Bhuvan
sql-server-2005replication
3 comments
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

My doubt is why this difference is coming Domain/Bhuvan Domian/Bcdd1$
0 Likes 0 ·
any suggestions regarding this
0 Likes 0 ·
can we do replication between two different domains
0 Likes 0 ·

1 Answer

·
Fatherjack avatar image
Fatherjack answered
This may be a starting point http://www.replicationanswers.com/InternetArticle.asp have you read through the replication content in Books OnLine?
1 comment
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

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?
0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.