SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2005 Forums
 Replication (2005)
 can't connect to distributor
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

cyril
Starting Member

3 Posts

Posted - 04/04/2013 :  20:24:00  Show Profile  Reply with Quote
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

India
52317 Posts

Posted - 04/05/2013 :  01:07:48  Show Profile  Reply with Quote
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 - 04/05/2013 :  01:18:57  Show Profile  Reply with Quote
No
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

India
52317 Posts

Posted - 04/05/2013 :  01:24:27  Show Profile  Reply with Quote
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 - 04/05/2013 :  01:54:25  Show Profile  Reply with Quote
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

USA
5072 Posts

Posted - 04/05/2013 :  10:10:23  Show Profile  Visit russell's Homepage  Reply with Quote
The account needs permission on the snapshot folder, not just the SQL instance.
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.11 seconds. Powered By: Snitz Forums 2000