| Groups | Blog | Home |
sql server replication : Trans Replication over VPN
I need to set up Transactional replication between two SQL 2005 servers. The servers are in different domains (they belong to different companies), but a VPN connection has been established. I can see both servers from my SQL Mgmt Studio and each server can "see" the other one. I am having some problems getting the subscriptions created, both on the Publisher and the Subscriber. I have tried both Pull and Push subs, but they don't work. I think that my problem is a permissions/access/rights issue. I have searched around (including this forum) for "vpn", but I cannot find a simple, straightforward article on how to configure replication. And the new BOL just seems to bounce me back and forth between articles that don't provide enough info. If anyone knows of any articles or links that would be appreciated. Thanks
It should be possible. What error message are you getting?
-- Hilary Cotter Looking for a SQL Server replication book? http://www.nwsu.com/0974973602.html Looking for a FAQ on Indexing Services/SQL FTS http://www.indexserverfaq.com [quoted text, click to view] "dw" <dw@discussions.microsoft.com> wrote in message news:0328C046-1DB7-4437-B2F3-3B0AE4E59630@microsoft.com... > Hello - > > I need to set up Transactional replication between two SQL 2005 servers. > The servers are in different domains (they belong to different companies), > but a VPN connection has been established. I can see both servers from my > SQL Mgmt Studio and each server can "see" the other one. > > I am having some problems getting the subscriptions created, both on the > Publisher and the Subscriber. I have tried both Pull and Push subs, but > they > don't work. I think that my problem is a permissions/access/rights issue. > I > have searched around (including this forum) for "vpn", but I cannot find a > simple, straightforward article on how to configure replication. And the > new > BOL just seems to bounce me back and forth between articles that don't > provide enough info. > > If anyone knows of any articles or links that would be appreciated. > > Thanks > - will
I don't have it here in front of me now (I'm away from the office), but the
error was something like the account could not login/access the Distributor. This is from the subscriber, which is trying to run a pull subscription. [quoted text, click to view] "Hilary Cotter" wrote:
> It should be possible. What error message are you getting? > > -- > Hilary Cotter > Looking for a SQL Server replication book? > http://www.nwsu.com/0974973602.html > > Looking for a FAQ on Indexing Services/SQL FTS > http://www.indexserverfaq.com > > "dw" <dw@discussions.microsoft.com> wrote in message > news:0328C046-1DB7-4437-B2F3-3B0AE4E59630@microsoft.com... > > Hello - > > > > I need to set up Transactional replication between two SQL 2005 servers. > > The servers are in different domains (they belong to different companies), > > but a VPN connection has been established. I can see both servers from my > > SQL Mgmt Studio and each server can "see" the other one. > > > > I am having some problems getting the subscriptions created, both on the > > Publisher and the Subscriber. I have tried both Pull and Push subs, but > > they > > don't work. I think that my problem is a permissions/access/rights issue. > > I > > have searched around (including this forum) for "vpn", but I cannot find a > > simple, straightforward article on how to configure replication. And the > > new > > BOL just seems to bounce me back and forth between articles that don't > > provide enough info. > > > > If anyone knows of any articles or links that would be appreciated. > > > > Thanks > > - will > >
Set a larger value for the LoginTimeout parameter, and ensure that the
account you are using to connect to the distributor has sa rights on the publisher and distributor. -- Hilary Cotter Director of Text Mining and Database Strategy RelevantNOISE.Com - Dedicated to mining blogs for business intelligence. This posting is my own and doesn't necessarily represent RelevantNoise's positions, strategies or opinions. Looking for a SQL Server replication book? http://www.nwsu.com/0974973602.html Looking for a FAQ on Indexing Services/SQL FTS http://www.indexserverfaq.com [quoted text, click to view] "dw" <dw@discussions.microsoft.com> wrote in message news:6CAF903D-B97C-490B-993E-CD0951B60923@microsoft.com... >I don't have it here in front of me now (I'm away from the office), but the > error was something like the account could not login/access the > Distributor. > This is from the subscriber, which is trying to run a pull subscription. > > "Hilary Cotter" wrote: > >> It should be possible. What error message are you getting? >> >> -- >> Hilary Cotter >> Looking for a SQL Server replication book? >> http://www.nwsu.com/0974973602.html >> >> Looking for a FAQ on Indexing Services/SQL FTS >> http://www.indexserverfaq.com >> >> "dw" <dw@discussions.microsoft.com> wrote in message >> news:0328C046-1DB7-4437-B2F3-3B0AE4E59630@microsoft.com... >> > Hello - >> > >> > I need to set up Transactional replication between two SQL 2005 >> > servers. >> > The servers are in different domains (they belong to different >> > companies), >> > but a VPN connection has been established. I can see both servers from >> > my >> > SQL Mgmt Studio and each server can "see" the other one. >> > >> > I am having some problems getting the subscriptions created, both on >> > the >> > Publisher and the Subscriber. I have tried both Pull and Push subs, >> > but >> > they >> > don't work. I think that my problem is a permissions/access/rights >> > issue. >> > I >> > have searched around (including this forum) for "vpn", but I cannot >> > find a >> > simple, straightforward article on how to configure replication. And >> > the >> > new >> > BOL just seems to bounce me back and forth between articles that don't >> > provide enough info. >> > >> > If anyone knows of any articles or links that would be appreciated. >> > >> > Thanks >> > - will >> >> >>
I tried the larger LoginTimeout value....without success. I really think
that this is a permissions/access issue. If the two servers are on different domains I am unsure how to set up the account on the subscriber so it has sa rights on the server which is acting as the publisher/subscriber. I don't see how I can grant rights from one domain to another....of course, I am not a network expert. Is this possible? I read somewhere that you can set up some sort of pass through login/account, something about creating the same account name and password on both servers and using that. That still is confusing since the two accounts would be in different domains. thanks - will [quoted text, click to view] "Hilary Cotter" wrote:
> Set a larger value for the LoginTimeout parameter, and ensure that the > account you are using to connect to the distributor has sa rights on the > publisher and distributor. > > -- > Hilary Cotter > Director of Text Mining and Database Strategy > RelevantNOISE.Com - Dedicated to mining blogs for business intelligence. > > This posting is my own and doesn't necessarily represent RelevantNoise's > positions, strategies or opinions. > > Looking for a SQL Server replication book? > http://www.nwsu.com/0974973602.html > > Looking for a FAQ on Indexing Services/SQL FTS > http://www.indexserverfaq.com > > > > "dw" <dw@discussions.microsoft.com> wrote in message > news:6CAF903D-B97C-490B-993E-CD0951B60923@microsoft.com... > >I don't have it here in front of me now (I'm away from the office), but the > > error was something like the account could not login/access the > > Distributor. > > This is from the subscriber, which is trying to run a pull subscription. > > > > "Hilary Cotter" wrote: > > > >> It should be possible. What error message are you getting? > >> > >> -- > >> Hilary Cotter > >> Looking for a SQL Server replication book? > >> http://www.nwsu.com/0974973602.html > >> > >> Looking for a FAQ on Indexing Services/SQL FTS > >> http://www.indexserverfaq.com > >> > >> "dw" <dw@discussions.microsoft.com> wrote in message > >> news:0328C046-1DB7-4437-B2F3-3B0AE4E59630@microsoft.com... > >> > Hello - > >> > > >> > I need to set up Transactional replication between two SQL 2005 > >> > servers. > >> > The servers are in different domains (they belong to different > >> > companies), > >> > but a VPN connection has been established. I can see both servers from > >> > my > >> > SQL Mgmt Studio and each server can "see" the other one. > >> > > >> > I am having some problems getting the subscriptions created, both on > >> > the > >> > Publisher and the Subscriber. I have tried both Pull and Push subs, > >> > but > >> > they > >> > don't work. I think that my problem is a permissions/access/rights > >> > issue. > >> > I > >> > have searched around (including this forum) for "vpn", but I cannot > >> > find a > >> > simple, straightforward article on how to configure replication. And > >> > the > >> > new > >> > BOL just seems to bounce me back and forth between articles that don't > >> > provide enough info. > >> > > >> > If anyone knows of any articles or links that would be appreciated. > >> > > >> > Thanks > >> > - will > >> > >> > >> > >
Here are some of the error messages I am getting:
- The process could not connect to Subscriber 'SrvTest'. (Source: MSSQL_REPL, Error number: MSSQL_REPL0) - Named Pipes Provider: Could not open a connection to SQL Server [1326]. (Source: MSSQLServer, Error number: 1326) - An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (Source: MSSQLServer, Error number: 1326) - Login timeout expired (Source: MSSQLServer, Error number: HYT00) Get help: http://help/HYT00 I checked both servers to verify that they allow for remote connections, and they do. I tried using the "sa" account to connect to the subscriber...and that fails with the same errors. This is frustrating because I know I am close and once I get the right accounts it should work great. - will [quoted text, click to view] "Hilary Cotter" wrote:
> Set a larger value for the LoginTimeout parameter, and ensure that the > account you are using to connect to the distributor has sa rights on the > publisher and distributor. > > -- > Hilary Cotter > Director of Text Mining and Database Strategy > RelevantNOISE.Com - Dedicated to mining blogs for business intelligence. > > This posting is my own and doesn't necessarily represent RelevantNoise's > positions, strategies or opinions. > > Looking for a SQL Server replication book? > http://www.nwsu.com/0974973602.html > > Looking for a FAQ on Indexing Services/SQL FTS > http://www.indexserverfaq.com > > > > "dw" <dw@discussions.microsoft.com> wrote in message > news:6CAF903D-B97C-490B-993E-CD0951B60923@microsoft.com... > >I don't have it here in front of me now (I'm away from the office), but the > > error was something like the account could not login/access the > > Distributor. > > This is from the subscriber, which is trying to run a pull subscription. > > > > "Hilary Cotter" wrote: > > > >> It should be possible. What error message are you getting? > >> > >> -- > >> Hilary Cotter > >> Looking for a SQL Server replication book? > >> http://www.nwsu.com/0974973602.html > >> > >> Looking for a FAQ on Indexing Services/SQL FTS > >> http://www.indexserverfaq.com > >> > >> "dw" <dw@discussions.microsoft.com> wrote in message > >> news:0328C046-1DB7-4437-B2F3-3B0AE4E59630@microsoft.com... > >> > Hello - > >> > > >> > I need to set up Transactional replication between two SQL 2005 > >> > servers. > >> > The servers are in different domains (they belong to different > >> > companies), > >> > but a VPN connection has been established. I can see both servers from > >> > my > >> > SQL Mgmt Studio and each server can "see" the other one. > >> > > >> > I am having some problems getting the subscriptions created, both on > >> > the > >> > Publisher and the Subscriber. I have tried both Pull and Push subs, > >> > but > >> > they > >> > don't work. I think that my problem is a permissions/access/rights > >> > issue. > >> > I > >> > have searched around (including this forum) for "vpn", but I cannot > >> > find a > >> > simple, straightforward article on how to configure replication. And > >> > the > >> > new > >> > BOL just seems to bounce me back and forth between articles that don't > >> > provide enough info. > >> > > >> > If anyone knows of any articles or links that would be appreciated. > >> > > >> > Thanks > >> > - will > >> > >> > >> > >
Don't see what you're looking for? Try a search.
|
April 2003
June 2003
July 2003
August 2003
September 2003
October 2003
November 2003
December 2003
January 2004
February 2004
March 2004
April 2004
May 2004
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
November 2007
October 2008
| home · blog · groups | Questions? Comments? Contact the dn |