Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Replication (2005)
 can't connect to distributor

Author  Topic 

cyril
Starting Member

3 Posts

Posted - 2013-04-04 : 20:24:00
HI,

I'm trying to use Transactional replication between 2 servers called A and B.
A is the distributor and the publisher, and B is the subscriber.
subscription (on B) is configured to use impersonate process to connect to the distribution server (on A) and I think that's the issue. I see MSSQL login error as DOMAIN\B$ on A from B

If I don't use this account it seems that I must use an SQL account and not a windows account. Do you think it's the solution, or do I take the wrong way ?

thanks

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2013-04-05 : 01:07:48
are A and B servers in different domains?

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs
Go to Top of Page

cyril
Starting Member

3 Posts

Posted - 2013-04-05 : 01:18:57
No
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2013-04-05 : 01:24:27
then why should you use impersonation? are logins mapped to different roles in both servers?

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs
Go to Top of Page

cyril
Starting Member

3 Posts

Posted - 2013-04-05 : 01:54:25
I tried to use impersonation only cause I saw that lot of errors were fixed with it.
I have same windows logins mapped to same roles on both servers. However if I don't use impersonation to connect to distributor I can't use a window login instead and need an SQL account , right ?
I saw that Impersonation works if mssql instances of A and B are on the same host
Go to Top of Page

russell
Pyro-ma-ni-yak

5072 Posts

Posted - 2013-04-05 : 10:10:23
The account needs permission on the snapshot folder, not just the SQL instance.
Go to Top of Page
   

- Advertisement -