|
|
You're in the
sql server replication
group:Replicating Data between SQL Server 2000 and SQL Server 2005
sql server replication:
Server 2000 databases, located on our hosting companies machine, and our reporting/datawarehouse server, located here in the office. So, I have 2 versions of SQL, Connection over the internet and 2 different domains (untrusted connection). I have been able to replicate between SQL Server 2005 to SQL Server 2005 inside of my domain, including using FTP. However, whenever I try to pull in a transactional replication from my 2000 server via the internet and FTP, I am getting various errors. Has anyone done anything similiar to this? Any help would be greatly appreciated. One last bit of information: Hosting machine runs with Windows 2000 Advanced Server, SQL Server 2000 SP3A and my machines are running Windows 2003 Server/XP Pro SP2 and SQL Server 2005. Thanks in advance for any information you can give. -- Scott E. Hunley Sr. Programmer/Analyst & Architect (MCAD)
I just tried to run the process again, as a pull subscription on the SQL
Server 2005 database in my domain and I got the following error: 2005-11-30 17:37:02.699 Snapshot files will be downloaded via ftp 2005-11-30 17:37:02.799 Connecting to ftp site '28053-DB' 2005-11-30 17:37:04.342 Agent message code 20033. The process could not retrieve file '28053-DB_inventory_master_inventory_master_articles\20051130120007\Purchase_Order_Line_Items_1.sch' from the FTP site '28053-DB'. This is better than previous attempts. At least it looks like it is trying to download the files. Any Ideas? Thanks. -- Scott E. Hunley (MCAD) Measure Twice, Cut Once... [quoted text, click to view] "Hilary Cotter" wrote:
> What errors 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 > > "Scott Hunley" <ScottHunley@discussions.microsoft.com> wrote in message > news:EA172267-E6DB-4686-A9F8-67C074FED590@microsoft.com... > >I am currently trying to implement a replication strategy between n-many > >SQL > > Server 2000 databases, located on our hosting companies machine, and our > > reporting/datawarehouse server, located here in the office. So, I have 2 > > versions of SQL, Connection over the internet and 2 different domains > > (untrusted connection). > > > > I have been able to replicate between SQL Server 2005 to SQL Server 2005 > > inside of my domain, including using FTP. However, whenever I try to pull > > in > > a transactional replication from my 2000 server via the internet and FTP, > > I > > am getting various errors. Has anyone done anything similiar to this? > > Any > > help would be greatly appreciated. > > > > One last bit of information: Hosting machine runs with Windows 2000 > > Advanced Server, SQL Server 2000 SP3A and my machines are running Windows > > 2003 Server/XP Pro SP2 and SQL Server 2005. > > > > Thanks in advance for any information you can give. > > > > > > -- > > Scott E. Hunley > > Sr. Programmer/Analyst & Architect (MCAD) > > Robertson Marketing Group > >
What errors 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] "Scott Hunley" <ScottHunley@discussions.microsoft.com> wrote in message news:EA172267-E6DB-4686-A9F8-67C074FED590@microsoft.com... >I am currently trying to implement a replication strategy between n-many >SQL > Server 2000 databases, located on our hosting companies machine, and our > reporting/datawarehouse server, located here in the office. So, I have 2 > versions of SQL, Connection over the internet and 2 different domains > (untrusted connection). > > I have been able to replicate between SQL Server 2005 to SQL Server 2005 > inside of my domain, including using FTP. However, whenever I try to pull > in > a transactional replication from my 2000 server via the internet and FTP, > I > am getting various errors. Has anyone done anything similiar to this? > Any > help would be greatly appreciated. > > One last bit of information: Hosting machine runs with Windows 2000 > Advanced Server, SQL Server 2000 SP3A and my machines are running Windows > 2003 Server/XP Pro SP2 and SQL Server 2005. > > Thanks in advance for any information you can give. > > > -- > Scott E. Hunley > Sr. Programmer/Analyst & Architect (MCAD) > Robertson Marketing Group
OK, ftp into your ftp server and look for
'/ftp/28053-DB_inventory_master_inventory_master_articles/20051130120007/Purchase_Order_Line_Items_1.sch If it is there make sure your client path is /ftp. If its not there be sure to configure your publication for ftp to dump to the ftp root. -- 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] "Scott Hunley" <ScottHunley@discussions.microsoft.com> wrote in message news:168447D0-C7E5-46B6-B2CF-73FC79A78D1F@microsoft.com... >I just tried to run the process again, as a pull subscription on the SQL > Server 2005 database in my domain and I got the following error: > > 2005-11-30 17:37:02.699 Snapshot files will be downloaded via ftp > 2005-11-30 17:37:02.799 Connecting to ftp site '28053-DB' > 2005-11-30 17:37:04.342 Agent message code 20033. The process could not > retrieve file > '28053-DB_inventory_master_inventory_master_articles\20051130120007\Purchase_Order_Line_Items_1.sch' > from the FTP site '28053-DB'. > > This is better than previous attempts. At least it looks like it is > trying > to download the files. > > Any Ideas? > > > Thanks. > > -- > Scott E. Hunley (MCAD) > Measure Twice, Cut Once... > > > "Hilary Cotter" wrote: > >> What errors 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 >> >> "Scott Hunley" <ScottHunley@discussions.microsoft.com> wrote in message >> news:EA172267-E6DB-4686-A9F8-67C074FED590@microsoft.com... >> >I am currently trying to implement a replication strategy between n-many >> >SQL >> > Server 2000 databases, located on our hosting companies machine, and >> > our >> > reporting/datawarehouse server, located here in the office. So, I have >> > 2 >> > versions of SQL, Connection over the internet and 2 different domains >> > (untrusted connection). >> > >> > I have been able to replicate between SQL Server 2005 to SQL Server >> > 2005 >> > inside of my domain, including using FTP. However, whenever I try to >> > pull >> > in >> > a transactional replication from my 2000 server via the internet and >> > FTP, >> > I >> > am getting various errors. Has anyone done anything similiar to this? >> > Any >> > help would be greatly appreciated. >> > >> > One last bit of information: Hosting machine runs with Windows 2000 >> > Advanced Server, SQL Server 2000 SP3A and my machines are running >> > Windows >> > 2003 Server/XP Pro SP2 and SQL Server 2005. >> > >> > Thanks in advance for any information you can give. >> > >> > >> > -- >> > Scott E. Hunley >> > Sr. Programmer/Analyst & Architect (MCAD) >> > Robertson Marketing Group >> >> >>
Hillary, I got the FTP issue resolved and replication is working correctly on
the Development box. The production box however, is giving an Error about Heterogeneous Subscription or something... Have you ever seen this error: =================================== SQL Server could not create a subscription for Subscriber 'MY-SQLSERVER'. (New Subscription Wizard) =================================== An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo) ------------------------------ Could not subscribe to publication 'inventory_master_articles' because heterogeneous Subscriber 'MY-SQLSERVER' only supports the @sync_method parameter value 'bcp character' . Changed database context to 'inventory_master'. (.Net SqlClient Data Provider) ------------------------------ For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=08.00.0818&EvtSrc=MSSQLServer&EvtID=14095&LinkId=20476 ------------------------------ Server Name: ##.##.###.###,1433 Error Number: 14095 Severity: 16 State: 1 Procedure: sp_addsubscription Line Number: 530 ------------------------------ I used the scripts from the Development box to create the publications, since the wizard kept failing. But the only difference between the two boxes i can see is Microsoft CRM 3.0 is installed on the Production box. Any thoughts or ideas? Thanks, Scott -- Scott E. Hunley (MCAD) Measure Twice, Cut Once... [quoted text, click to view] "Hilary Cotter" wrote:
> OK, ftp into your ftp server and look for > '/ftp/28053-DB_inventory_master_inventory_master_articles/20051130120007/Purchase_Order_Line_Items_1.sch > > If it is there make sure your client path is /ftp. > > If its not there be sure to configure your publication for ftp to dump to > the ftp root. > > > -- > 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 > > "Scott Hunley" <ScottHunley@discussions.microsoft.com> wrote in message > news:168447D0-C7E5-46B6-B2CF-73FC79A78D1F@microsoft.com... > >I just tried to run the process again, as a pull subscription on the SQL > > Server 2005 database in my domain and I got the following error: > > > > 2005-11-30 17:37:02.699 Snapshot files will be downloaded via ftp > > 2005-11-30 17:37:02.799 Connecting to ftp site '28053-DB' > > 2005-11-30 17:37:04.342 Agent message code 20033. The process could not > > retrieve file > > '28053-DB_inventory_master_inventory_master_articles\20051130120007\Purchase_Order_Line_Items_1.sch' > > from the FTP site '28053-DB'. > > > > This is better than previous attempts. At least it looks like it is > > trying > > to download the files. > > > > Any Ideas? > > > > > > Thanks. > > > > -- > > Scott E. Hunley (MCAD) > > Measure Twice, Cut Once... > > > > > > "Hilary Cotter" wrote: > > > >> What errors 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 > >> > >> "Scott Hunley" <ScottHunley@discussions.microsoft.com> wrote in message > >> news:EA172267-E6DB-4686-A9F8-67C074FED590@microsoft.com... > >> >I am currently trying to implement a replication strategy between n-many > >> >SQL > >> > Server 2000 databases, located on our hosting companies machine, and > >> > our > >> > reporting/datawarehouse server, located here in the office. So, I have > >> > 2 > >> > versions of SQL, Connection over the internet and 2 different domains > >> > (untrusted connection). > >> > > >> > I have been able to replicate between SQL Server 2005 to SQL Server > >> > 2005 > >> > inside of my domain, including using FTP. However, whenever I try to > >> > pull > >> > in > >> > a transactional replication from my 2000 server via the internet and > >> > FTP, > >> > I > >> > am getting various errors. Has anyone done anything similiar to this? > >> > Any > >> > help would be greatly appreciated. > >> > > >> > One last bit of information: Hosting machine runs with Windows 2000 > >> > Advanced Server, SQL Server 2000 SP3A and my machines are running > >> > Windows > >> > 2003 Server/XP Pro SP2 and SQL Server 2005. > >> > > >> > Thanks in advance for any information you can give. > >> > > >> > > >> > -- > >> > Scott E. Hunley > >> > Sr. Programmer/Analyst & Architect (MCAD) > >> > Robertson Marketing Group > >> > >> > >> > >
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 |