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.
| 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 BIf 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 MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
 |
|
|
cyril
Starting Member
3 Posts |
Posted - 2013-04-05 : 01:18:57
|
| No |
|
|
|
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 MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
|
|
|
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 |
|
|
|
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. |
|
|
|
|
|
|
can't connect to distributor