| Groups | Blog | Home |
sql server replication : SQL 2005 Replication between 2 non trusted domains.
Let me paint the picture :-) I am a Windows Engineer and I have been asked to create a trust between two domains, this request has come from our SQL engineers who tells me this is required to set up SQL Replication. Basically there are 2 servers both having SQL 2005 installed on them, but the servers are in different domains. We need to set up replicaiton between them, I have found this article, but its for SQL 2000 and the SQL Engineer is telling me it can not be done on SQL 2005 without first creating a trust between the two domains. Im not saying I dont believe him, BUT I dont believe him. http://support.microsoft.com/kb/321822 If anyone has any instructions or documentation on this subject, I would be most grateful. Thanks in advance
Thanks for this.
I have asked the SQl Engineer if this has helped. He responded :- pass through doesn't work. it's down to the domain being passed . I can manually connect to the share, but SQL cann't as it's passing the domain name as well as the user name. I suggested it may be the lmcompatability level being different on the 2 servers, but I am told he has checked this. Any other help would be much appreciated. Andy [quoted text, click to view] "Hilary Cotter" wrote:
> Not true. Use pass-through authentication. Create the same accounts on all > domains with the same passwords. Use this as the account the agents run > under or the account you are running your merge or distribution agent under. > Note that you can use SQL authentication for this. > > If you are using pull subscribers the account the agent will run under needs > read and list file and folder rights to the snapshot share. If its pull this > will not be a concern. > > Sounds like your SQL DBAs are as confused as you are. > > -- > 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 > > > > "Andy McDonald" <AndyMcDonald@discussions.microsoft.com> wrote in message > news:340A8AE4-32B3-4E4F-9C8B-AA3BFF521EE7@microsoft.com... > > Hello. > > > > Let me paint the picture :-) > > > > I am a Windows Engineer and I have been asked to create a trust between > > two > > domains, this request has come from our SQL engineers who tells me this is > > required to set up SQL Replication. > > > > Basically there are 2 servers both having SQL 2005 installed on them, but > > the servers are in different domains. We need to set up replicaiton > > between > > them, I have found this article, but its for SQL 2000 and the SQL Engineer > > is > > telling me it can not be done on SQL 2005 without first creating a trust > > between the two domains. Im not saying I dont believe him, BUT I dont > > believe > > him. > > > > http://support.microsoft.com/kb/321822 > > > > If anyone has any instructions or documentation on this subject, I would > > be > > most grateful. > > > > Thanks in advance > > > > Andy > >
Hilary.
may be a slight problem there, each installation of SQL is actually a clustered installation and therefore the accounts used may be a domain account. I will check and get back to you. Thanks foryour help on this. [quoted text, click to view] "Hilary Cotter" wrote:
> BTW- make sure you are using local machine accounts not domain accounts for > this to work. > > -- > 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 > > > > "Andy McDonald" <AndyMcDonald@discussions.microsoft.com> wrote in message > news:9111EDF6-5E8E-4AC0-8D13-C5E309D25B96@microsoft.com... > > Thanks for this. > > > > I have asked the SQl Engineer if this has helped. > > > > He responded :- > > > > pass through doesn't work. it's down to the domain being passed . I can > > manually connect to the share, but SQL cann't as it's passing the domain > > name > > as well as the user name. > > > > I suggested it may be the lmcompatability level being different on the 2 > > servers, but I am told he has checked this. > > > > Any other help would be much appreciated. > > > > Andy > > > > > > "Hilary Cotter" wrote: > > > >> Not true. Use pass-through authentication. Create the same accounts on > >> all > >> domains with the same passwords. Use this as the account the agents run > >> under or the account you are running your merge or distribution agent > >> under. > >> Note that you can use SQL authentication for this. > >> > >> If you are using pull subscribers the account the agent will run under > >> needs > >> read and list file and folder rights to the snapshot share. If its pull > >> this > >> will not be a concern. > >> > >> Sounds like your SQL DBAs are as confused as you are. > >> > >> -- > >> 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 > >> > >> > >> > >> "Andy McDonald" <AndyMcDonald@discussions.microsoft.com> wrote in message > >> news:340A8AE4-32B3-4E4F-9C8B-AA3BFF521EE7@microsoft.com... > >> > Hello. > >> > > >> > Let me paint the picture :-) > >> > > >> > I am a Windows Engineer and I have been asked to create a trust between > >> > two > >> > domains, this request has come from our SQL engineers who tells me this > >> > is > >> > required to set up SQL Replication. > >> > > >> > Basically there are 2 servers both having SQL 2005 installed on them, > >> > but > >> > the servers are in different domains. We need to set up replicaiton > >> > between > >> > them, I have found this article, but its for SQL 2000 and the SQL > >> > Engineer > >> > is > >> > telling me it can not be done on SQL 2005 without first creating a > >> > trust > >> > between the two domains. Im not saying I dont believe him, BUT I dont > >> > believe > >> > him. > >> > > >> > http://support.microsoft.com/kb/321822 > >> > > >> > If anyone has any instructions or documentation on this subject, I > >> > would > >> > be > >> > most grateful. > >> > > >> > Thanks in advance > >> > > >> > Andy > >> > >> > >> > >
Not true. Use pass-through authentication. Create the same accounts on all
domains with the same passwords. Use this as the account the agents run under or the account you are running your merge or distribution agent under. Note that you can use SQL authentication for this. If you are using pull subscribers the account the agent will run under needs read and list file and folder rights to the snapshot share. If its pull this will not be a concern. Sounds like your SQL DBAs are as confused as you are. -- 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] "Andy McDonald" <AndyMcDonald@discussions.microsoft.com> wrote in message news:340A8AE4-32B3-4E4F-9C8B-AA3BFF521EE7@microsoft.com... > Hello. > > Let me paint the picture :-) > > I am a Windows Engineer and I have been asked to create a trust between > two > domains, this request has come from our SQL engineers who tells me this is > required to set up SQL Replication. > > Basically there are 2 servers both having SQL 2005 installed on them, but > the servers are in different domains. We need to set up replicaiton > between > them, I have found this article, but its for SQL 2000 and the SQL Engineer > is > telling me it can not be done on SQL 2005 without first creating a trust > between the two domains. Im not saying I dont believe him, BUT I dont > believe > him. > > http://support.microsoft.com/kb/321822 > > If anyone has any instructions or documentation on this subject, I would > be > most grateful. > > Thanks in advance > > Andy
It works for me. The trick is not to pass the domain name. So if your
domain name is domain1, and your account name is account1, use account1 not domain1\account1. -- 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] "Andy McDonald" <AndyMcDonald@discussions.microsoft.com> wrote in message news:9111EDF6-5E8E-4AC0-8D13-C5E309D25B96@microsoft.com... > Thanks for this. > > I have asked the SQl Engineer if this has helped. > > He responded :- > > pass through doesn't work. it's down to the domain being passed . I can > manually connect to the share, but SQL cann't as it's passing the domain > name > as well as the user name. > > I suggested it may be the lmcompatability level being different on the 2 > servers, but I am told he has checked this. > > Any other help would be much appreciated. > > Andy > > > "Hilary Cotter" wrote: > >> Not true. Use pass-through authentication. Create the same accounts on >> all >> domains with the same passwords. Use this as the account the agents run >> under or the account you are running your merge or distribution agent >> under. >> Note that you can use SQL authentication for this. >> >> If you are using pull subscribers the account the agent will run under >> needs >> read and list file and folder rights to the snapshot share. If its pull >> this >> will not be a concern. >> >> Sounds like your SQL DBAs are as confused as you are. >> >> -- >> 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 >> >> >> >> "Andy McDonald" <AndyMcDonald@discussions.microsoft.com> wrote in message >> news:340A8AE4-32B3-4E4F-9C8B-AA3BFF521EE7@microsoft.com... >> > Hello. >> > >> > Let me paint the picture :-) >> > >> > I am a Windows Engineer and I have been asked to create a trust between >> > two >> > domains, this request has come from our SQL engineers who tells me this >> > is >> > required to set up SQL Replication. >> > >> > Basically there are 2 servers both having SQL 2005 installed on them, >> > but >> > the servers are in different domains. We need to set up replicaiton >> > between >> > them, I have found this article, but its for SQL 2000 and the SQL >> > Engineer >> > is >> > telling me it can not be done on SQL 2005 without first creating a >> > trust >> > between the two domains. Im not saying I dont believe him, BUT I dont >> > believe >> > him. >> > >> > http://support.microsoft.com/kb/321822 >> > >> > If anyone has any instructions or documentation on this subject, I >> > would >> > be >> > most grateful. >> > >> > Thanks in advance >> > >> > Andy >> >> >>
BTW- make sure you are using local machine accounts not domain accounts for
this to work. -- 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] "Andy McDonald" <AndyMcDonald@discussions.microsoft.com> wrote in message news:9111EDF6-5E8E-4AC0-8D13-C5E309D25B96@microsoft.com... > Thanks for this. > > I have asked the SQl Engineer if this has helped. > > He responded :- > > pass through doesn't work. it's down to the domain being passed . I can > manually connect to the share, but SQL cann't as it's passing the domain > name > as well as the user name. > > I suggested it may be the lmcompatability level being different on the 2 > servers, but I am told he has checked this. > > Any other help would be much appreciated. > > Andy > > > "Hilary Cotter" wrote: > >> Not true. Use pass-through authentication. Create the same accounts on >> all >> domains with the same passwords. Use this as the account the agents run >> under or the account you are running your merge or distribution agent >> under. >> Note that you can use SQL authentication for this. >> >> If you are using pull subscribers the account the agent will run under >> needs >> read and list file and folder rights to the snapshot share. If its pull >> this >> will not be a concern. >> >> Sounds like your SQL DBAs are as confused as you are. >> >> -- >> 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 >> >> >> >> "Andy McDonald" <AndyMcDonald@discussions.microsoft.com> wrote in message >> news:340A8AE4-32B3-4E4F-9C8B-AA3BFF521EE7@microsoft.com... >> > Hello. >> > >> > Let me paint the picture :-) >> > >> > I am a Windows Engineer and I have been asked to create a trust between >> > two >> > domains, this request has come from our SQL engineers who tells me this >> > is >> > required to set up SQL Replication. >> > >> > Basically there are 2 servers both having SQL 2005 installed on them, >> > but >> > the servers are in different domains. We need to set up replicaiton >> > between >> > them, I have found this article, but its for SQL 2000 and the SQL >> > Engineer >> > is >> > telling me it can not be done on SQL 2005 without first creating a >> > trust >> > between the two domains. Im not saying I dont believe him, BUT I dont >> > believe >> > him. >> > >> > http://support.microsoft.com/kb/321822 >> > >> > If anyone has any instructions or documentation on this subject, I >> > would >> > be >> > most grateful. >> > >> > Thanks in advance >> > >> > Andy >> >> >>
Is this push or pull? With Push all authentication is done locally on the
publisher for the snapshot. The distribution agent can connect to the subscriber using a sql account. -- 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] "Andy McDonald" <AndyMcDonald@discussions.microsoft.com> wrote in message news:46968FDA-3C8D-4907-B339-9392B9A19CC0@microsoft.com... > Hilary. > > may be a slight problem there, each installation of SQL is actually a > clustered installation and therefore the accounts used may be a domain > account. > > I will check and get back to you. > > Thanks foryour help on this. > > "Hilary Cotter" wrote: > >> BTW- make sure you are using local machine accounts not domain accounts >> for >> this to work. >> >> -- >> 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 >> >> >> >> "Andy McDonald" <AndyMcDonald@discussions.microsoft.com> wrote in message >> news:9111EDF6-5E8E-4AC0-8D13-C5E309D25B96@microsoft.com... >> > Thanks for this. >> > >> > I have asked the SQl Engineer if this has helped. >> > >> > He responded :- >> > >> > pass through doesn't work. it's down to the domain being passed . I >> > can >> > manually connect to the share, but SQL cann't as it's passing the >> > domain >> > name >> > as well as the user name. >> > >> > I suggested it may be the lmcompatability level being different on the >> > 2 >> > servers, but I am told he has checked this. >> > >> > Any other help would be much appreciated. >> > >> > Andy >> > >> > >> > "Hilary Cotter" wrote: >> > >> >> Not true. Use pass-through authentication. Create the same accounts on >> >> all >> >> domains with the same passwords. Use this as the account the agents >> >> run >> >> under or the account you are running your merge or distribution agent >> >> under. >> >> Note that you can use SQL authentication for this. >> >> >> >> If you are using pull subscribers the account the agent will run under >> >> needs >> >> read and list file and folder rights to the snapshot share. If its >> >> pull >> >> this >> >> will not be a concern. >> >> >> >> Sounds like your SQL DBAs are as confused as you are. >> >> >> >> -- >> >> 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 >> >> >> >> >> >> >> >> "Andy McDonald" <AndyMcDonald@discussions.microsoft.com> wrote in >> >> message >> >> news:340A8AE4-32B3-4E4F-9C8B-AA3BFF521EE7@microsoft.com... >> >> > Hello. >> >> > >> >> > Let me paint the picture :-) >> >> > >> >> > I am a Windows Engineer and I have been asked to create a trust >> >> > between >> >> > two >> >> > domains, this request has come from our SQL engineers who tells me >> >> > this >> >> > is >> >> > required to set up SQL Replication. >> >> > >> >> > Basically there are 2 servers both having SQL 2005 installed on >> >> > them, >> >> > but >> >> > the servers are in different domains. We need to set up replicaiton >> >> > between >> >> > them, I have found this article, but its for SQL 2000 and the SQL >> >> > Engineer >> >> > is >> >> > telling me it can not be done on SQL 2005 without first creating a >> >> > trust >> >> > between the two domains. Im not saying I dont believe him, BUT I >> >> > dont >> >> > believe >> >> > him. >> >> > >> >> > http://support.microsoft.com/kb/321822 >> >> > >> >> > If anyone has any instructions or documentation on this subject, I >> >> > would >> >> > be >> >> > most grateful. >> >> > >> >> > Thanks in advance >> >> > >> >> > Andy >> >> >> >> >> >> >> >> >>
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
| home · blog · groups | Questions? Comments? Contact the dn |