billchng

Hi Manish,

How is the issue going? Could you let me know the current status of this
issue and do you need our further assistance?


Bill Cheng
Microsoft Online Partner Support

Get Secure! - http://www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
--------------------
| Content-Class: urn:content-classes:message
| From: "Manish Buttan" <manish@ccipl.com>
| Sender: "Manish Buttan" <manish@ccipl.com>
| References: <584d01c341fc$3f93ca00$a401280a@phx.gbl>
<PH3eqhKRDHA.2012@cpmsftngxa09.phx.gbl>
<00e901c3457c$5bdda720$a501280a@phx.gbl>
<Rbm$q8jRDHA.2332@cpmsftngxa09.phx.gbl>
<009c01c35071$8b0baab0$a401280a@phx.gbl>
<VoDRSGOUDHA.1640@cpmsftngxa06.phx.gbl>
| Subject: RE: Error using Merge Replication via FTP
| Date: Tue, 29 Jul 2003 05:12:59 -0700
| Lines: 742
| Message-ID: <091d01c355ca$c05c6020$a501280a@phx.gbl>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="iso-8859-1"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4910.0300
| Thread-Index: AcNVysBZ+/vr21AJSYy5xYmMuh2qDQ==
| Newsgroups: microsoft.public.sqlserver.replication
| Path: cpmsftngxa06.phx.gbl
| Xref: cpmsftngxa06.phx.gbl microsoft.public.sqlserver.replication:41997
| NNTP-Posting-Host: TK2MSFTNGXA13 10.40.1.165
| X-Tomcat-NG: microsoft.public.sqlserver.replication
|
| Hi Bill,
|
| I specified the ftp folder exactly in the manner you had
| suggested to. But I still getting the same error. Is it to
| do with starting of the SQL Agent ?
|
| My publisher is started by the domain administrator. While
| my subscriber is started by a domain user.
|
| The FTP folder has the requisite rights (everyone-full
| control). And as I told you earlier i am able to browse
| via Internet Explorer. And I am also able to connect to
| the publisher via query ****yzer.
|
| I had gone through BOL for "Configuring a Publication to
| Allow Subscribers to Retrieve Snapshots Using FTP". But I
| did find one descrepancy between what was said in this URL
| (mk:@MSITStore:C:\Program%20Files\Microsoft%20SQL%
| 20Server\80\Tools\Books\replsql.chm::/replimpl_4cq8.htm)
| in BOL and my SQL publication property.
|
| In BOL, its mentioned that I will be able to select Allow
| snapshots to be downloaded using FTP on the subscription
| option tab in publication properties. I am not able to
| find any such label in my publication property. I am using
| SQL 2000 with SP 3 by the way. Is this some error in BOL
| or am I doing something incorrectly ?
|
| Thanks once again!
|
| Regards,
| Manish.
|
| >-----Original Message-----
| >Hi Manish,
| >
| >Have you checked my lastest reply? If not, please check
| it. I have included
| >for your reference.
| >
| >From: billchng@online.microsoft.com ("Bill Cheng [MSFT]")
| >Date: Thu, 10 Jul 2003 19:05:47 GMT
| >Subject: RE: Error using Merge Replication via FTP
| >Newsgroups: microsoft.public.sqlserver.replication
| >
| >Hi Manish,
| >
| >Here is some more information.
| >1. Try to set the snapshot folder to be the FTP home
| directory (by default,
| >\Microsoft SQL Server\Mssql\Repldata\Ftp) and configure
| the FTP home
| >directory as an FTP site instead of something like
| \\COMP0220\C$\FTP_REPL
| >and port number. You may check "Configuring a Publisher
| or Distributor to
| >Listen on TCP/IP" in SQL Server Books Online.
| >
| >You can specify the FTP paths and ports as the snapshot
| folder location
| >under Publication Properties so that a server already
| configured as an FTP
| >site is used as the snapshot folder location. Or you can
| set the snapshot
| >folder to be the FTP home directory (by default,
| \Microsoft SQL
| >Server\Mssql\Repldata\Ftp) and configure the FTP home
| directory as an FTP
| >site.
| >
| >How to specify FTP information (Enterprise Manager)
| >To set the snapshot folder as the FTP home directory
| >
| >On the Start menu, point to Programs, point to Microsoft
| Internet Server,
| >and then click Internet Service Manager.
| >
| >Click the server name corresponding to the FTP service.
| >
| >On the Properties menu, click Service Properties, and
| then on the
| >Directories tab, click Add.
| >
| >Enter the path to the FTP directory (for example,
| C:\Microsoft SQL
| >Server\Mssql\Repldata\Ftp), and then click Home
| Directory.
| >
| >
| >To configure the FTP home directory as an FTP site
| >
| >On the Start menu, point to Programs, point to Microsoft
| SQL Server 2000,
| >and then click Client Network Utility.
| >
| >On the General tab, ensure that TCP/IP appears in the
| Enabled protocols by
| >order list. If TCP/IP appears in the Disabled protocols
| list, select it,
| >and then click Enable.
| >
| >In Server alias, enter the name of the server.
| >
| >In Computer name, overwrite the existing name with the IP
| address.
| >
| >Your system administrator can provide you with the
| correct IP address.
| >
| >In Port number, overwrite the existing port number, if
| necessary.
| >
| >
| >This posting is provided "AS IS" with no warranties, and
| confers no rights.
| >
| >Regards,
| >
| >Bill Cheng
| >Microsoft Support Engineer
| >--------------------
| >| Content-Class: urn:content-classes:message
| >| From: "Manish Buttan" <manish@ccipl.com>
| >| Sender: "Manish Buttan" <manish@ccipl.com>
| >| References: <584d01c341fc$3f93ca00$a401280a@phx.gbl>
| ><PH3eqhKRDHA.2012@cpmsftngxa09.phx.gbl>
| ><00e901c3457c$5bdda720$a501280a@phx.gbl>
| ><Rbm$q8jRDHA.2332@cpmsftngxa09.phx.gbl>
| >| Subject: RE: Error using Merge Replication via FTP
| >| Date: Tue, 22 Jul 2003 09:51:49 -0700
| >| Lines: 539
| >| Message-ID: <009c01c35071$8b0baab0$a401280a@phx.gbl>
| >| MIME-Version: 1.0
| >| Content-Type: text/plain;
| >| charset="iso-8859-1"
| >| Content-Transfer-Encoding: 7bit
| >| X-Newsreader: Microsoft CDO for Windows 2000
| >| X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4910.0300
| >| Thread-Index: AcNQcYsJR/JD0mZ/TPKiuXmszLCPiQ==
| >| Newsgroups: microsoft.public.sqlserver.replication
| >| Path: cpmsftngxa06.phx.gbl
| >| Xref: cpmsftngxa06.phx.gbl
| microsoft.public.sqlserver.replication:41770
| >| NNTP-Posting-Host: TK2MSFTNGXA12 10.40.1.164
| >| X-Tomcat-NG: microsoft.public.sqlserver.replication
| >|
| >| Hi Bill,
| >|
| >| I did try giving Full Control to the directory. But I
| am
| >| still getting the same error.
| >|
| >| This was after I created an alias for the publisher at
| the
| >| subscriber end.
| >|
| >| By the way, I am able to connect from the subscriber to
| >| the publisher via query ****yzer.
| >|
| >| Regards,
| >| Manish
| >|
| >| >-----Original Message-----
| >| >Hi Manish,
| >| >
| >| >I understand that the browser by connecting to the
| same
| >| ftp path and it
| >| >connects without any problem. However, I still
| recommend
| >| that you set the
| >| >permissions on the ftproot and subdirectory to
| Everyone-
| >| Full Control. Since
| >| >replication issues are complex, we need to check this
| >| area. Otherwise, we
| >| >cannot go on.
| >| >
| >| >Please try to create an alias on the subscriber side
| to
| >| point to
| >| >publisher's TCP/IP address and make sure you can
| connect
| >| to the publisher
| >| >using Query ****yzer from subscriber.
| >| >
| >| >For example, if you set the Folder on Snapshot
| Location
| >| to C:\test, and
| >| >then the "Client Path to this folder from the FTP
| root"
| >| to "ftp". Try to
| >| >create a virtual folder under the Default FTP Site,
| named
| >| FTP and pointing
| >| >to C:\test\ftp. Does it work?
| >| >
| >| >
| >| >This posting is provided "AS IS" with no warranties,
| and
| >| confers no rights.
| >| >
| >| >Regards,
| >| >
| >| >Bill Cheng
| >| >Microsoft Support Engineer
| >| >--------------------
| >| >| Content-Class: urn:content-classes:message
| >| >| From: "Manish Buttan" <manish@ccipl.com>
| >| >| Sender: "Manish Buttan" <manish@ccipl.com>
| >| >| References: <584d01c341fc$3f93ca00$a401280a@phx.gbl>
| >| ><PH3eqhKRDHA.2012@cpmsftngxa09.phx.gbl>
| >| >| Subject: RE: Error using Merge Replication via FTP
| >| >| Date: Tue, 8 Jul 2003 11:11:31 -0700
| >| >| Lines: 429
| >| >| Message-ID: <00e901c3457c$5bdda720$a501280a@phx.gbl>
| >| >| MIME-Version: 1.0
| >| >| Content-Type: text/plain;
| >| >| charset="iso-8859-1"
| >| >| Content-Transfer-Encoding: 7bit
| >| >| X-Newsreader: Microsoft CDO for Windows 2000
| >| >| Thread-Index: AcNFfFvdj1qmbX4aTjiwK27UQciwAQ==
| >| >| X-MimeOLE: Produced By Microsoft MimeOLE
| V5.50.4910.0300
| >| >| Newsgroups: microsoft.public.sqlserver.replication
| >| >| Path: cpmsftngxa09.phx.gbl
| >| >| Xref: cpmsftngxa09.phx.gbl
| >| microsoft.public.sqlserver.replication:3605
| >| >| NNTP-Posting-Host: TK2MSFTNGXA13 10.40.1.165
| >| >| X-Tomcat-NG: microsoft.public.sqlserver.replication
| >| >|
| >| >| Hi Bill,
| >| >|
| >| >| Thank you for your reply.
| >| >|
| >| >| Both the publisher and subscriber are running SQL
| >| Service
| >| >| pack 3.
| >| >|
| >| >| I have checked over the browser by connecting to the
| >| same
| >| >| ftp path and it connects without any problem. So it
| >| cant
| >| >| be a permission problem.
| >| >|
| >| >| Below is the log file content at the subscriber end.
| I
| >| >| have partly masked the ip address for security
| reasons
| >| in
| >| >| the txt file.
| >| >|
| >| >|
| >| >|
| >| >| Microsoft SQL Server Merge Agent 8.00.760
| >| >| Copyright (c) 2000 Microsoft Corporation
| >| >| Microsoft SQL Server Replication Agent: RAKSHAK-
| >| >| InternetReplication-InternetReplication-COMP0220-
| >| >| InternetReplication- 0
| >| >|
| >| >| Percent Complete: 0
| >| >| Connecting to Subscriber 'COMP0220'
| >| >| Connecting to
| Subscriber 'COMP0220.InternetReplication'
| >| >|
| >| >| Server: COMP0220
| >| >| DBMS: Microsoft SQL Server
| >| >| Version: 08.00.0760
| >| >| user name: dbo
| >| >| API conformance: 2
| >| >| SQL conformance: 1
| >| >| transaction capable: 2
| >| >| read only: N
| >| >| identifier quote char: "
| >| >| non_nullable_columns: 1
| >| >| owner usage: 31
| >| >| max table name len: 128
| >| >| max column name len: 128
| >| >| need long data len: Y
| >| >| max columns in table: 1024
| >| >| max columns in index: 16
| >| >| max char literal len: 524288
| >| >| max statement len: 524288
| >| >| max row size: 524288
| >| >|
| >| >| [7/8/2003 11:26:02 PM]COMP0220.InternetReplication:
| >| {call
| >| >| sp_MSgetversion }
| >| >| [7/8/2003 11:26:02 PM]COMP0220.InternetReplication:
| {?
| >| >| =call sp_helpsubscription_properties (N'RAKSHAK',
| >| >| N'InternetReplication', N'InternetReplication')}
| >| >| Distributor security mode: 0, login name: sa,
| password:
| >| >| ********.
| >| >| [7/8/2003 11:26:02 PM]COMP0220.InternetReplication:
| {?
| >| >| =call sp_helpsubscription_properties (N'RAKSHAK',
| >| >| N'InternetReplication', N'InternetReplication')}
| >| >| Publisher security mode: 0, login name: sa,
| password:
| >| >| *********.
| >| >| Percent Complete: 0
| >| >| Connecting to Distributor 'RAKSHAK'
| >| >| Connecting to Distributor 'RAKSHAK.'
| >| >|
| >| >| Server: RAKSHAK
| >| >| DBMS: Microsoft SQL Server
| >| >| Version: 08.00.0760
| >| >| user name: dbo
| >| >| API conformance: 2
| >| >| SQL conformance: 1
| >| >| transaction capable: 2
| >| >| read only: N
| >| >| identifier quote char: "
| >| >| non_nullable_columns: 1
| >| >| owner usage: 31
| >| >| max table name len: 128
| >| >| max column name len: 128
| >| >| need long data len: Y
| >| >| max columns in table: 1024
| >| >| max columns in index: 16
| >| >| max char literal len: 524288
| >| >| max statement len: 524288
| >| >| max row size: 524288
| >| >|
| >| >| [7/8/2003 11:26:02 PM]RAKSHAK.: {call
| sp_MSgetversion }
| >| >| [7/8/2003 11:26:02 PM]RAKSHAK.: {call
| >| sp_helpdistpublisher
| >| >| (N'RAKSHAK') }
| >| >| [7/8/2003 11:26:02 PM]RAKSHAK.distribution: select
| >| >| datasource, srvid from master..sysservers where upper
| >| >| (srvname) = upper(N'RAKSHAK')
| >| >| [7/8/2003 11:26:02 PM]RAKSHAK.distribution: {call
| >| >| sp_MSadd_merge_anonymous_agent(N'0',
| >| >| N'InternetReplication', N'InternetReplication',
| >| >| N'InternetReplication', N'COMP0220',?, -1)}
| >| >| [7/8/2003 11:26:02 PM]RAKSHAK.distribution: {call
| >| >| sp_MShelp_profile (1, 4, N'')}
| >| >| Percent Complete: 0
| >| >| Connecting to Publisher 'RAKSHAK.InternetReplication'
| >| >| Initializing
| >| >|
| >| >| Server: RAKSHAK
| >| >| DBMS: Microsoft SQL Server
| >| >| Version: 08.00.0760
| >| >| user name: dbo
| >| >| API conformance: 2
| >| >| SQL conformance: 1
| >| >| transaction capable: 2
| >| >| read only: N
| >| >| identifier quote char: "
| >| >| non_nullable_columns: 1
| >| >| owner usage: 31
| >| >| max table name len: 128
| >| >| max column name len: 128
| >| >| need long data len: Y
| >| >| max columns in table: 1024
| >| >| max columns in index: 16
| >| >| max char literal len: 524288
| >| >| max statement len: 524288
| >| >| max row size: 524288
| >| >|
| >| >| Percent Complete: 1
| >| >| Connecting to Publisher 'RAKSHAK'
| >| >| [7/8/2003 11:26:02 PM]RAKSHAK.InternetReplication:
| set
| >| >| nocount on declare @dbname sysname select @dbname =
| >| db_name
| >| >| () declare @collation nvarchar(255) select
| @collation =
| >| >| convert(nvarchar(255), databasepropertyex(@dbname,
| >| >| N'COLLATION')) select collationproperty(@collation,
| >| >| N'CODEPAGE') as 'CodePage', collationproperty
| >| (@collation,
| >| >| N'LCID') as 'LCID', collationproperty(@collation,
| >| >| N'COMPARISONSTYLE') as 'ComparisonStyle'
| >| >| Connecting to Publisher 'RAKSHAK.InternetReplication'
| >| >|
| >| >| Server: RAKSHAK
| >| >| DBMS: Microsoft SQL Server
| >| >| Version: 08.00.0760
| >| >| user name: dbo
| >| >| API conformance: 2
| >| >| SQL conformance: 1
| >| >| transaction capable: 2
| >| >| read only: N
| >| >| identifier quote char: "
| >| >| non_nullable_columns: 1
| >| >| owner usage: 31
| >| >| max table name len: 128
| >| >| max column name len: 128
| >| >| need long data len: Y
| >| >| max columns in table: 1024
| >| >| max columns in index: 16
| >| >| max char literal len: 524288
| >| >| max statement len: 524288
| >| >| max row size: 524288
| >| >|
| >| >| [7/8/2003 11:26:02 PM]RAKSHAK.InternetReplication:
| >| {call
| >| >| sp_MSgetversion }
| >| >| Percent Complete: 3
| >| >| Retrieving publication information
| >| >| Percent Complete: 4
| >| >| Retrieving subscription information
| >| >| Connecting to
| Subscriber 'COMP0220.InternetReplication'
| >| >|
| >| >| Server: COMP0220
| >| >| DBMS: Microsoft SQL Server
| >| >| Version: 08.00.0760
| >| >| user name: dbo
| >| >| API conformance: 2
| >| >| SQL conformance: 1
| >| >| transaction capable: 2
| >| >| read only: N
| >| >| identifier quote char: "
| >| >| non_nullable_columns: 1
| >| >| owner usage: 31
| >| >| max table name len: 128
| >| >| max column name len: 128
| >| >| need long data len: Y
| >| >| max columns in table: 1024
| >| >| max columns in index: 16
| >| >| max char literal len: 524288
| >| >| max statement len: 524288
| >| >| max row size: 524288
| >| >|
| >| >|
| >| >| Server: COMP0220
| >| >| DBMS: Microsoft SQL Server
| >| >| Version: 08.00.0760
| >| >| user name: dbo
| >| >| API conformance: 2
| >| >| SQL conformance: 1
| >| >| transaction capable: 2
| >| >| read only: N
| >| >| identifier quote char: "
| >| >| non_nullable_columns: 1
| >| >| owner usage: 31
| >| >| max table name len: 128
| >| >| max column name len: 128
| >| >| need long data len: Y
| >| >| max columns in table: 1024
| >| >| max columns in index: 16
| >| >| max char literal len: 524288
| >| >| max statement len: 524288
| >| >| max row size: 524288
| >| >|
| >| >| [7/8/2003 11:26:03 PM]RAKSHAK.InternetReplication:
| exec
| >| >| sp_datatype_info 0, 3
| >| >| Percent Complete: 4
| >| >| Snapshot files will be downloaded via ftp
| >| >| Percent Complete: 7
| >| >| Connecting to ftp site '203.129.***.***'
| >| >| The schema script '' could not be propagated to the
| >| >| subscriber.
| >| >| [7/8/2003 11:26:03 PM]COMP0220.InternetReplication:
| >| {call
| >| >| sp_reinitmergepullsubscription (N'RAKSHAK',
| >| >| N'InternetReplication',
| >| N'InternetReplication', 'FALSE')}
| >| >| Reinitialized pull subscription to
| >| >| publication 'InternetReplication' from
| >| >| publisher 'RAKSHAK:InternetReplication'Percent
| >| Complete: 0
| >| >| The subscription has been marked for
| reinitialization.
| >| >| Reinitialization will occur the next time you
| >| synchronize
| >| >| this subscription.
| >| >| Percent Complete: 0
| >| >| The schema script '' could not be propagated to the
| >| >| subscriber.
| >| >| Percent Complete: 0
| >| >| Category:NULL
| >| >| Source: Merge Replication Provider
| >| >| Number: -2147201001
| >| >| Message: The schema script '' could not be
| propagated
| >| to
| >| >| the subscriber.
| >| >| Percent Complete: 0
| >| >| Category:AGENT
| >| >| Source: COMP0220
| >| >| Number: 0
| >| >| Message: The process could not connect to FTP
| >| >| site '203.129.***.***' using port 21.
| >| >| Percent Complete: 0
| >| >| Category:OS
| >| >| Source:
| >| >| Number: 12003
| >| >| Message: 550 ftp://203.129.***.***: The filename,
| >| >| directory name, or volume label syntax is incorrect.
| >| >|
| >| >| Disconnecting from Subscriber 'COMP0220'
| >| >| Disconnecting from Subscriber 'COMP0220'
| >| >| Disconnecting from Publisher 'RAKSHAK'
| >| >| Disconnecting from Publisher 'RAKSHAK'
| >| >| Disconnecting from Distributor 'RAKSHAK'
| >| >|
| >| >|
| >| >|
| >|
| __________________________________________________ _________
| >| >|
| >| >|
| >| >| Merge agent is giving a problem at the publisher
| end.
| >| This
| >| >| I can make out from the red error mark over the
| merge
| >| >| agent. But i am not able to generate a log of this,
| as
| >| >| agent properties does not open any new window (as it
| >| did
| >| >| in the subscriber).
| >| >|
| >| >| Regards,
| >| >| Manish.
| >| >|
| >| >|
| >| >|
| >| >|
| >| >|
| >| >|
| >| >|
| >| >|
| >| >|
| >| >|
| >| >|
| >| >|
| >| >|
| >| >|
| >| >|
| >| >|
| >| >| >-----Original Message-----
| >| >| >Hi Manish,
| >| >| >
| >| >| >Replication issues are usually complex to
| troubleshoot
| >| on
| >| >| newsgroups. I
| >| >| >would suggest that you open an incident with
| Microsoft
| >| >| Product Support
| >| >| >Services via
| >| >| >http://support.microsoft.com/default.aspx?
| scid=fh;EN-
| >| >| US;CNTACTMS, so that
| >| >| >we can have dedicated engineer to assist you.
| >| >| >
| >| >| >You may check the following:
| >| >| >1. Make sure all SQL Servers are in SP3, publisher,
| >| >| distributor, subscriber.
| >| >| >318592 FIX: Snapshots Created on SQL Server Service
| >| Pack
| >| >| 2 Cannot Be
| >| >| >Delivered
| >| >| >http://support.microsoft.com/?id=318592
| >| >| >
| >| >| >2. Could you first grant Everyone full control
| rights
| >| to
| >| >| the FTP directory
| >| >| >so to avoid permission issue?
| >| >| >
| >| >| >3. Please post the following information so we can
| >| >| perform further research.
| >| >| >a) Agent log file.
| >| >| >312292.KB.EN-US: HOW TO: Enable Replication Agents
| for
| >| >| Logging to Output
| >| >| >Files
| >| >| >
| >| >| >b) For more information on necessary information on
| >| >| troubleshooting
| >| >| >replication issues, you may check the following
| >| article:
| >| >| >315642.KB.EN-US INF: Information That PSS Needs to
| >| >| Troubleshoot SQL Server
| >| >| >Replication
| >| >| >http://support.microsoft.com/default.aspx?
| scid=KB;EN-
| >| >| US;315642
| >| >| >
| >| >| >
| >| >| >This posting is provided "AS IS" with no
| warranties,
| >| and
| >| >| confers no rights.
| >| >| >
| >| >| >Regards,
| >| >| >
| >| >| >Bill Cheng
| >| >| >Microsoft Support Engineer
| >| >| >--------------------
| >| >| >| Content-Class: urn:content-classes:message
| >| >| >| From: "Manish Buttan" <manish@ccipl.com>
| >| >| >| Sender: "Manish Buttan" <manish@ccipl.com>
| >| >| >| Subject: Error using Merge Replication via FTP
| >| >| >| Date: Fri, 4 Jul 2003 00:16:55 -0700
| >| >| >| Lines: 68
| >| >| >| Message-ID: <584d01c341fc$3f93ca00
| $a401280a@phx.gbl>
| >| >| >| MIME-Version: 1.0
| >| >| >| Content-Type: text/plain;
| >| >| >| charset="iso-8859-1"
| >| >| >| Content-Transfer-Encoding: 7bit
| >| >| >| X-Newsreader: Microsoft CDO for Windows 2000
| >| >| >| Thread-Index: AcNB/D+TnnrW4hj3RXGKHFaQufVLsQ==
| >| >| >| X-MimeOLE: Produced By Microsoft MimeOLE
| >| V5.50.4910.0300
| >| >| >| Newsgroups: microsoft.public.sqlserver.replication
| >| >| >| Path: cpmsftngxa09.phx.gbl
| >| >| >| Xref: cpmsftngxa09.phx.gbl
| >| >| microsoft.public.sqlserver.replication:3517
| >| >| >| NNTP-Posting-Host: TK2MSFTNGXA12 10.40.1.164
| >| >| >| X-Tomcat-NG:
| microsoft.public.sqlserver.replication
| >| >| >|
| >| >| >| Hi,
| >| >| >|
| >| >| >| I have configured a Distributor and Publisher in
| SQL
| >| >| 2000
| >| >| >| running SP 3. In this server, I have setup merge
| >| >| >| replication. This merge replication agent runs
| >| >| >| successfully inside the network when i use a
| network
| >| >| path.
| >| >| >| I am able to create and set subscriptions
| >| successfuly.
| >| >| >| Also any updates to the subscriber are reflected
| in
| >| the
| >| >| >| publisher whenever the subscriber synchronizes.
| >| >| >|
| >| >| >| I need to set replication to work over the
| Internet
| >| >| now. I
| >| >| >| am publishing data over the Internet using TCP/IP
| >| and
| >| >| FTP.
| >| >| >| I have taken care of all the pre-requisites to
| >| publish
| >| >| >| data over the Internet. This is as per SQL BOL -
| >| >| >| mk:@MSITStore:C:\Program%20Files\Microsoft%20SQL%
| >| >| >| 20Server\80
| >| \Tools\Books\replsql.chm::/replimpl_8a5s.htm
| >| >| >|
| >| >| >| I have created a FTP account at the
| >| >| Distributor/Publisher
| >| >| >| and have unchecked "Generate Snapshots in normal
| >| >| snapshot
| >| >| >| folder". Instead I have enabled "Generate
| Snapshots
| >| in
| >| >| the
| >| >| >| following location" option and have specified the
| >| home
| >| >| >| directory of the FPT server (\\COMP0220
| >| \C$\FTP_REPL).
| >| >| Also
| >| >| >| I have checked "Subscribers can access this
| folder
| >| >| using
| >| >| >| FTP". I have the specified appropriate FTP
| address,
| >| >| Client
| >| >| >| path to this foler, port, user and password.
| >| >| >|
| >| >| >| The publication gets created successfully. I have
| >| >| checked
| >| >| >| the FTP URL over a browser and it works properly.
| I
| >| >| have
| >| >| >| enabled anonymous access to the FTP site.
| >| >| >|
| >| >| >| The snapshot agent generates the snapshot in this
| >| >| folder
| >| >| >| without any problem.
| >| >| >|
| >| >| >| Now when I create a pull subscription, and say
| >| >| >| scynchronize using FTP, it fails and after
| checking
| >| the
| >| >| >| job history, these are the messages that were
| there -
| >| >| >|
| >| >| >|
| >| >| >| Category:NULL
| >| >| >| Source: Merge Replication Provider
| >| >| >| Number: -2147201001
| >| >| >| Message: The schema script '' could not be
| >| propagated
| >| >| to
| >| >| >| the subscriber.
| >| >| >|
| >| >| >| Category:AGENT
| >| >| >| Source: PARAM
| >| >| >| Number: 0
| >| >| >| Message: The process could not connect to FTP
| site
| >| >| >| 203.129.***.***' using
| >| >| >| port 21.
| >| >| >|
| >| >| >| Category:OS
| >| >| >| Source:
| >| >| >| Number: 12003
| >| >| >| Message: 550 ftp://203.129.***.***: The filename,
| >| >| >| directory name, or volume label syntax is
| incorrect.
| >| >| >|
| >| >| >| The schema script '' could not be propagated to
| the
| >| >| >| subscriber. The step failed.
| >| >| >|
| >| >| >|
| >| >| >|
| >| >| >| Can some please advice as to what is going wrong
| and
| >| >| >| where ? Thanks in advance!
| >| >| >|
| >| >| >| Regards,
| >| >| >| Manish.
| >| >| >|
| >| >| >|
| >| >| >
| >| >| >.
| >| >| >
| >| >|
| >| >
| >| >.
| >| >
| >|
| >
| >.
| >
|

billchng

Hi Manish,

Could you set the startup account of SQL Server, SQL Server Agent services
on publisher, distributor, subscriber computers to the domain administrator
to avoid permission issue? Remember to restart SQL Server and SQL Server
Agent after doing that?


Bill Cheng
Microsoft Online Partner Support

Get Secure! - http://www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
--------------------
| Content-Class: urn:content-classes:message
| From: "Manish Buttan" <manish@ccipl.com>
| Sender: "Manish Buttan" <manish@ccipl.com>
| References: <584d01c341fc$3f93ca00$a401280a@phx.gbl>
<PH3eqhKRDHA.2012@cpmsftngxa09.phx.gbl>
<00e901c3457c$5bdda720$a501280a@phx.gbl>
<Rbm$q8jRDHA.2332@cpmsftngxa09.phx.gbl>
<009c01c35071$8b0baab0$a401280a@phx.gbl>
<VoDRSGOUDHA.1640@cpmsftngxa06.phx.gbl>
<091d01c355ca$c05c6020$a501280a@phx.gbl>
<8e$OSBqWDHA.2108@cpmsftngxa06.phx.gbl>
| Subject: RE: Error using Merge Replication via FTP
| Date: Wed, 13 Aug 2003 06:30:01 -0700
| Lines: 912
| Message-ID: <0c8d01c3619e$ff4dc640$a601280a@phx.gbl>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="iso-8859-1"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4910.0300
| Thread-Index: AcNhnv9LOUIkVa3sS/W/FWGpTY8Wxg==
| Newsgroups: microsoft.public.sqlserver.replication
| Path: cpmsftngxa06.phx.gbl
| Xref: cpmsftngxa06.phx.gbl microsoft.public.sqlserver.replication:42553
| NNTP-Posting-Host: TK2MSFTNGXA14 10.40.1.166
| X-Tomcat-NG: microsoft.public.sqlserver.replication
|
| Hi Bill,
|
| I have given Everyone Full Control to the
| \MSSQL\REPLDATA\FTP. This is on a Windows 2000 advanced
| server. And this is where the publisher is. The SQL Server
| agent at the publisher is started by the domain
| administrator. What I mean by the domain administrator is,
| the Windows "administrator" login. This is the
| administrator of the entire domain. I hope I am making
| myself clear here. In case, you have any doubts, I can
| explain it to you with a scenario.
|
| At present my subscribers login to the same windows
| domain. The SQL Server agent at the subscribers start via
| a normal windows domain account. These users have access
| to the folder via normal network access and via FTP.
|
| Given this scenario, replication fails.
|
| Can you please tell me as to what the problem might be ?
|
| Regards,
| Karthik.
|
|
|
|
|
|
|
| >-----Original Message-----
| >Hi Manish,
| >
| >I understand that you can browse the FTP folder
| using "ftp://<servername>"
| >from subscriber computer. Could you connect to it
| anonymously? I understand
| >that you have granted Full-control rights to "<Program
| Files>\Microsoft SQL
| >Server\MSSQL\REPLDATA\FTP" to Everyone. However,
| according to my test, if
| >my SQL Server Agent service runs under an account that
| can access that FTP
| >folder and the FTP home directory is configured as
| allowing anonymous
| >access, the replication should succeed.
| >
| >I am not sure what you mean by "My publisher is started
| by the domain
| >administrator. While my subscriber is started by a domain
| user". Could you
| >configure SQL Server Agent service to start with a domain
| administrator on
| >both computers to avoid permission issue?
| >
| >
| >Bill Cheng
| >Microsoft Online Partner Support
| >
| >Get Secure! - http://www.microsoft.com/security
| >This posting is provided "as is" with no warranties and
| confers no rights.
| >--------------------
| >| Content-Class: urn:content-classes:message
| >| From: "Manish Buttan" <manish@ccipl.com>
| >| Sender: "Manish Buttan" <manish@ccipl.com>
| >| References: <584d01c341fc$3f93ca00$a401280a@phx.gbl>
| ><PH3eqhKRDHA.2012@cpmsftngxa09.phx.gbl>
| ><00e901c3457c$5bdda720$a501280a@phx.gbl>
| ><Rbm$q8jRDHA.2332@cpmsftngxa09.phx.gbl>
| ><009c01c35071$8b0baab0$a401280a@phx.gbl>
| ><VoDRSGOUDHA.1640@cpmsftngxa06.phx.gbl>
| >| Subject: RE: Error using Merge Replication via FTP
| >| Date: Tue, 29 Jul 2003 05:12:59 -0700
| >| Lines: 742
| >| Message-ID: <091d01c355ca$c05c6020$a501280a@phx.gbl>
| >| MIME-Version: 1.0
| >| Content-Type: text/plain;
| >| charset="iso-8859-1"
| >| Content-Transfer-Encoding: 7bit
| >| X-Newsreader: Microsoft CDO for Windows 2000
| >| X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4910.0300
| >| Thread-Index: AcNVysBZ+/vr21AJSYy5xYmMuh2qDQ==
| >| Newsgroups: microsoft.public.sqlserver.replication
| >| Path: cpmsftngxa06.phx.gbl
| >| Xref: cpmsftngxa06.phx.gbl
| microsoft.public.sqlserver.replication:41997
| >| NNTP-Posting-Host: TK2MSFTNGXA13 10.40.1.165
| >| X-Tomcat-NG: microsoft.public.sqlserver.replication
| >|
| >| Hi Bill,
| >|
| >| I specified the ftp folder exactly in the manner you
| had
| >| suggested to. But I still getting the same error. Is it
| to
| >| do with starting of the SQL Agent ?
| >|
| >| My publisher is started by the domain administrator.
| While
| >| my subscriber is started by a domain user.
| >|
| >| The FTP folder has the requisite rights (everyone-full
| >| control). And as I told you earlier i am able to browse
| >| via Internet Explorer. And I am also able to connect to
| >| the publisher via query ****yzer.
| >|
| >| I had gone through BOL for "Configuring a Publication
| to
| >| Allow Subscribers to Retrieve Snapshots Using FTP". But
| I
| >| did find one descrepancy between what was said in this
| URL
| >| (mk:@MSITStore:C:\Program%20Files\Microsoft%20SQL%
| >| 20Server\80
| \Tools\Books\replsql.chm::/replimpl_4cq8.htm)
| >| in BOL and my SQL publication property.
| >|
| >| In BOL, its mentioned that I will be able to select
| Allow
| >| snapshots to be downloaded using FTP on the
| subscription
| >| option tab in publication properties. I am not able to
| >| find any such label in my publication property. I am
| using
| >| SQL 2000 with SP 3 by the way. Is this some error in
| BOL
| >| or am I doing something incorrectly ?
| >|
| >| Thanks once again!
| >|
| >| Regards,
| >| Manish.
| >|
| >| >-----Original Message-----
| >| >Hi Manish,
| >| >
| >| >Have you checked my lastest reply? If not, please
| check
| >| it. I have included
| >| >for your reference.
| >| >
| >| >From: billchng@online.microsoft.com ("Bill Cheng
| [MSFT]")
| >| >Date: Thu, 10 Jul 2003 19:05:47 GMT
| >| >Subject: RE: Error using Merge Replication via FTP
| >| >Newsgroups: microsoft.public.sqlserver.replication
| >| >
| >| >Hi Manish,
| >| >
| >| >Here is some more information.
| >| >1. Try to set the snapshot folder to be the FTP home
| >| directory (by default,
| >| >\Microsoft SQL Server\Mssql\Repldata\Ftp) and
| configure
| >| the FTP home
| >| >directory as an FTP site instead of something like
| >| \\COMP0220\C$\FTP_REPL
| >| >and port number. You may check "Configuring a
| Publisher
| >| or Distributor to
| >| >Listen on TCP/IP" in SQL Server Books Online.
| >| >
| >| >You can specify the FTP paths and ports as the
| snapshot
| >| folder location
| >| >under Publication Properties so that a server already
| >| configured as an FTP
| >| >site is used as the snapshot folder location. Or you
| can
| >| set the snapshot
| >| >folder to be the FTP home directory (by default,
| >| \Microsoft SQL
| >| >Server\Mssql\Repldata\Ftp) and configure the FTP home
| >| directory as an FTP
| >| >site.
| >| >
| >| >How to specify FTP information (Enterprise Manager)
| >| >To set the snapshot folder as the FTP home directory
| >| >
| >| >On the Start menu, point to Programs, point to
| Microsoft
| >| Internet Server,
| >| >and then click Internet Service Manager.
| >| >
| >| >Click the server name corresponding to the FTP service.
| >| >
| >| >On the Properties menu, click Service Properties, and
| >| then on the
| >| >Directories tab, click Add.
| >| >
| >| >Enter the path to the FTP directory (for example,
| >| C:\Microsoft SQL
| >| >Server\Mssql\Repldata\Ftp), and then click Home
| >| Directory.
| >| >
| >| >
| >| >To configure the FTP home directory as an FTP site
| >| >
| >| >On the Start menu, point to Programs, point to
| Microsoft
| >| SQL Server 2000,
| >| >and then click Client Network Utility.
| >| >
| >| >On the General tab, ensure that TCP/IP appears in the
| >| Enabled protocols by
| >| >order list. If TCP/IP appears in the Disabled
| protocols
| >| list, select it,
| >| >and then click Enable.
| >| >
| >| >In Server alias, enter the name of the server.
| >| >
| >| >In Computer name, overwrite the existing name with the
| IP
| >| address.
| >| >
| >| >Your system administrator can provide you with the
| >| correct IP address.
| >| >
| >| >In Port number, overwrite the existing port number, if
| >| necessary.
| >| >
| >| >
| >| >This posting is provided "AS IS" with no warranties,
| and
| >| confers no rights.
| >| >
| >| >Regards,
| >| >
| >| >Bill Cheng
| >| >Microsoft Support Engineer
| >| >--------------------
| >| >| Content-Class: urn:content-classes:message
| >| >| From: "Manish Buttan" <manish@ccipl.com>
| >| >| Sender: "Manish Buttan" <manish@ccipl.com>
| >| >| References: <584d01c341fc$3f93ca00$a401280a@phx.gbl>
| >| ><PH3eqhKRDHA.2012@cpmsftngxa09.phx.gbl>
| >| ><00e901c3457c$5bdda720$a501280a@phx.gbl>
| >| ><Rbm$q8jRDHA.2332@cpmsftngxa09.phx.gbl>
| >| >| Subject: RE: Error using Merge Replication via FTP
| >| >| Date: Tue, 22 Jul 2003 09:51:49 -0700
| >| >| Lines: 539
| >| >| Message-ID: <009c01c35071$8b0baab0$a401280a@phx.gbl>
| >| >| MIME-Version: 1.0
| >| >| Content-Type: text/plain;
| >| >| charset="iso-8859-1"
| >| >| Content-Transfer-Encoding: 7bit
| >| >| X-Newsreader: Microsoft CDO for Windows 2000
| >| >| X-MimeOLE: Produced By Microsoft MimeOLE
| V5.50.4910.0300
| >| >| Thread-Index: AcNQcYsJR/JD0mZ/TPKiuXmszLCPiQ==
| >| >| Newsgroups: microsoft.public.sqlserver.replication
| >| >| Path: cpmsftngxa06.phx.gbl
| >| >| Xref: cpmsftngxa06.phx.gbl
| >| microsoft.public.sqlserver.replication:41770
| >| >| NNTP-Posting-Host: TK2MSFTNGXA12 10.40.1.164
| >| >| X-Tomcat-NG: microsoft.public.sqlserver.replication
| >| >|
| >| >| Hi Bill,
| >| >|
| >| >| I did try giving Full Control to the directory. But
| I
| >| am
| >| >| still getting the same error.
| >| >|
| >| >| This was after I created an alias for the publisher
| at
| >| the
| >| >| subscriber end.
| >| >|
| >| >| By the way, I am able to connect from the subscriber
| to
| >| >| the publisher via query ****yzer.
| >| >|
| >| >| Regards,
| >| >| Manish
| >| >|
| >| >| >-----Original Message-----
| >| >| >Hi Manish,
| >| >| >
| >| >| >I understand that the browser by connecting to the
| >| same
| >| >| ftp path and it
| >| >| >connects without any problem. However, I still
| >| recommend
| >| >| that you set the
| >| >| >permissions on the ftproot and subdirectory to
| >| Everyone-
| >| >| Full Control. Since
| >| >| >replication issues are complex, we need to check
| this
| >| >| area. Otherwise, we
| >| >| >cannot go on.
| >| >| >
| >| >| >Please try to create an alias on the subscriber
| side
| >| to
| >| >| point to
| >| >| >publisher's TCP/IP address and make sure you can
| >| connect
| >| >| to the publisher
| >| >| >using Query ****yzer from subscriber.
| >| >| >
| >| >| >For example, if you set the Folder on Snapshot
| >| Location
| >| >| to C:\test, and
| >| >| >then the "Client Path to this folder from the FTP
| >| root"
| >| >| to "ftp". Try to
| >| >| >create a virtual folder under the Default FTP Site,
| >| named
| >| >| FTP and pointing
| >| >| >to C:\test\ftp. Does it work?
| >| >| >
| >| >| >
| >| >| >This posting is provided "AS IS" with no
| warranties,
| >| and
| >| >| confers no rights.
| >| >| >
| >| >| >Regards,
| >| >| >
| >| >| >Bill Cheng
| >| >| >Microsoft Support Engineer
| >| >| >--------------------
| >| >| >| Content-Class: urn:content-classes:message
| >| >| >| From: "Manish Buttan" <manish@ccipl.com>
| >| >| >| Sender: "Manish Buttan" <manish@ccipl.com>
| >| >| >| References: <584d01c341fc$3f93ca00
| $a401280a@phx.gbl>
| >| >| ><PH3eqhKRDHA.2012@cpmsftngxa09.phx.gbl>
| >| >| >| Subject: RE: Error using Merge Replication via FTP
| >| >| >| Date: Tue, 8 Jul 2003 11:11:31 -0700
| >| >| >| Lines: 429
| >| >| >| Message-ID: <00e901c3457c$5bdda720
| $a501280a@phx.gbl>
| >| >| >| MIME-Version: 1.0
| >| >| >| Content-Type: text/plain;
| >| >| >| charset="iso-8859-1"
| >| >| >| Content-Transfer-Encoding: 7bit
| >| >| >| X-Newsreader: Microsoft CDO for Windows 2000
| >| >| >| Thread-Index: AcNFfFvdj1qmbX4aTjiwK27UQciwAQ==
| >| >| >| X-MimeOLE: Produced By Microsoft MimeOLE
| >| V5.50.4910.0300
| >| >| >| Newsgroups: microsoft.public.sqlserver.replication
| >| >| >| Path: cpmsftngxa09.phx.gbl
| >| >| >| Xref: cpmsftngxa09.phx.gbl
| >| >| microsoft.public.sqlserver.replication:3605
| >| >| >| NNTP-Posting-Host: TK2MSFTNGXA13 10.40.1.165
| >| >| >| X-Tomcat-NG:
| microsoft.public.sqlserver.replication
| >| >| >|
| >| >| >| Hi Bill,
| >| >| >|
| >| >| >| Thank you for your reply.
| >| >| >|
| >| >| >| Both the publisher and subscriber are running SQL
| >| >| Service
| >| >| >| pack 3.
| >| >| >|
| >| >| >| I have checked over the browser by connecting to
| the
| >| >| same
| >| >| >| ftp path and it connects without any problem. So
| it
| >| >| cant
| >| >| >| be a permission problem.
| >| >| >|
| >| >| >| Below is the log file content at the subscriber
| end.
| >| I
| >| >| >| have partly masked the ip address for security
| >| reasons
| >| >| in
| >| >| >| the txt file.
| >| >| >|
| >| >| >|
| >| >| >|
| >| >| >| Microsoft SQL Server Merge Agent 8.00.760
| >| >| >| Copyright (c) 2000 Microsoft Corporation
| >| >| >| Microsoft SQL Server Replication Agent: RAKSHAK-
| >| >| >| InternetReplication-InternetReplication-COMP0220-
| >| >| >| InternetReplication- 0
| >| >| >|
| >| >| >| Percent Complete: 0
| >| >| >| Connecting to Subscriber 'COMP0220'
| >| >| >| Connecting to
| >| Subscriber 'COMP0220.InternetReplication'
| >| >| >|
| >| >| >| Server: COMP0220
| >| >| >| DBMS: Microsoft SQL Server
| >| >| >| Version: 08.00.0760
| >| >| >| user name: dbo
| >| >| >| API conformance: 2
| >| >| >| SQL conformance: 1
| >| >| >| transaction capable: 2
| >| >| >| read only: N
| >| >| >| identifier quote char: "
| >| >| >| non_nullable_columns: 1
| >| >| >| owner usage: 31
| >| >| >| max table name len: 128
| >| >| >| max column name len: 128
| >| >| >| need long data len: Y
| >| >| >| max columns in table: 1024
| >| >| >| max columns in index: 16
| >| >| >| max char literal len: 524288
| >| >| >| max statement len: 524288
| >| >| >| max row size: 524288
| >| >| >|
| >| >| >| [7/8/2003 11:26:02 PM]
| COMP0220.InternetReplication:
| >| >| {call
| >| >| >| sp_MSgetversion }
| >| >| >| [7/8/2003 11:26:02 PM]
| COMP0220.InternetReplication:
| >| {?
| >| >| >| =call sp_helpsubscription_properties (N'RAKSHAK',
| >| >| >| N'InternetReplication', N'InternetReplication')}
| >| >| >| Distributor security mode: 0, login name: sa,
| >| password:
| >| >| >| ********.
| >| >| >| [7/8/2003 11:26:02 PM]
| COMP0220.InternetReplication:
| >| {?
| >| >| >| =call sp_helpsubscription_properties (N'RAKSHAK',
| >| >| >| N'InternetReplication', N'InternetReplication')}
| >| >| >| Publisher security mode: 0, login name: sa,
| >| password:
| >| >| >| *********.
| >| >| >| Percent Complete: 0
| >| >| >| Connecting to Distributor 'RAKSHAK'
| >| >| >| Connecting to Distributor 'RAKSHAK.'
| >| >| >|
| >| >| >| Server: RAKSHAK
| >| >| >| DBMS: Microsoft SQL Server
| >| >| >| Version: 08.00.0760
| >| >| >| user name: dbo
| >| >| >| API conformance: 2
| >| >| >| SQL conformance: 1
| >| >| >| transaction capable: 2
| >| >| >| read only: N
| >| >| >| identifier quote char: "
| >| >| >| non_nullable_columns: 1
| >| >| >| owner usage: 31
| >| >| >| max table name len: 128
| >| >| >| max column name len: 128
| >| >| >| need long data len: Y
| >| >| >| max columns in table: 1024
| >| >| >| max columns in index: 16
| >| >| >| max char literal len: 524288
| >| >| >| max statement len: 524288
| >| >| >| max row size: 524288
| >| >| >|
| >| >| >| [7/8/2003 11:26:02 PM]RAKSHAK.: {call
| >| sp_MSgetversion }
| >| >| >| [7/8/2003 11:26:02 PM]RAKSHAK.: {call
| >| >| sp_helpdistpublisher
| >| >| >| (N'RAKSHAK') }
| >| >| >| [7/8/2003 11:26:02 PM]RAKSHAK.distribution:
| select
| >| >| >| datasource, srvid from master..sysservers where
| upper
| >| >| >| (srvname) = upper(N'RAKSHAK')
| >| >| >| [7/8/2003 11:26:02 PM]RAKSHAK.distribution: {call
| >| >| >| sp_MSadd_merge_anonymous_agent(N'0',
| >| >| >| N'InternetReplication', N'InternetReplication',
| >| >| >| N'InternetReplication', N'COMP0220',?, -1)}
| >| >| >| [7/8/2003 11:26:02 PM]RAKSHAK.distribution: {call
| >| >| >| sp_MShelp_profile (1, 4, N'')}
| >| >| >| Percent Complete: 0
| >| >| >| Connecting to
| Publisher 'RAKSHAK.InternetReplication'
| >| >| >| Initializing
| >| >| >|
| >| >| >| Server: RAKSHAK
| >| >| >| DBMS: Microsoft SQL Server
| >| >| >| Version: 08.00.0760
| >| >| >| user name: dbo
| >| >| >| API conformance: 2
| >| >| >| SQL conformance: 1
| >| >| >| transaction capable: 2
| >| >| >| read only: N
| >| >| >| identifier quote char: "
| >| >| >| non_nullable_columns: 1
| >| >| >| owner usage: 31
| >| >| >| max table name len: 128
| >| >| >| max column name len: 128
| >| >| >| need long data len: Y
| >| >| >| max columns in table: 1024
| >| >| >| max columns in index: 16
| >| >| >| max char literal len: 524288
| >| >| >| max statement len: 524288
| >| >| >| max row size: 524288
| >| >| >|
| >| >| >| Percent Complete: 1
| >| >| >| Connecting to Publisher 'RAKSHAK'
| >| >| >| [7/8/2003 11:26:02 PM]
| RAKSHAK.InternetReplication:
| >| set
| >| >| >| nocount on declare @dbname sysname select @dbname
| =
| >| >| db_name
| >| >| >| () declare @collation nvarchar(255) select
| >| @collation =
| >| >| >| convert(nvarchar(255), databasepropertyex
| (@dbname,
| >| >| >| N'COLLATION')) select collationproperty
| (@collation,
| >| >| >| N'CODEPAGE') as 'CodePage', collationproperty
| >| >| (@collation,
| >| >| >| N'LCID') as 'LCID', collationproperty(@collation,
| >| >| >| N'COMPARISONSTYLE') as 'ComparisonStyle'
| >| >| >| Connecting to
| Publisher 'RAKSHAK.InternetReplication'
| >| >| >|
| >| >| >| Server: RAKSHAK
| >| >| >| DBMS: Microsoft SQL Server
| >| >| >| Version: 08.00.0760
| >| >| >| user name: dbo
| >| >| >| API conformance: 2
| >| >| >| SQL conformance: 1
| >| >| >| transaction capable: 2
| >| >| >| read only: N
| >| >| >| identifier quote char: "
| >| >| >| non_nullable_columns: 1
| >| >| >| owner usage: 31
| >| >| >| max table name len: 128
| >| >| >| max column name len: 128
| >| >| >| need long data len: Y
| >| >| >| max columns in table: 1024
| >| >| >| max columns in index: 16
| >| >| >| max char literal len: 524288
| >| >| >| max statement len: 524288
| >| >| >| max row size: 524288
| >| >| >|
| >| >| >| [7/8/2003 11:26:02 PM]
| RAKSHAK.InternetReplication:
| >| >| {call
| >| >| >| sp_MSgetversion }
| >| >| >| Percent Complete: 3
| >| >| >| Retrieving publication information
| >| >| >| Percent Complete: 4
| >| >| >| Retrieving subscription information
| >| >| >| Connecting to
| >| Subscriber 'COMP0220.InternetReplication'
| >| >| >|
| >| >| >| Server: COMP0220
| >| >| >| DBMS: Microsoft SQL Server
| >| >| >| Version: 08.00.0760
| >| >| >| user name: dbo
| >| >| >| API conformance: 2
| >| >| >| SQL conformance: 1
| >| >| >| transaction capable: 2
| >| >| >| read only: N
| >| >| >| identifier quote char: "
| >| >| >| non_nullable_columns: 1
| >| >| >| owner usage: 31
| >| >| >| max table name len: 128
| >| >| >| max column name len: 128
| >| >| >| need long data len: Y
| >| >| >| max columns in table: 1024
| >| >| >| max columns in index: 16
| >| >| >| max char literal len: 524288
| >| >| >| max statement len: 524288
| >| >| >| max row size: 524288
| >| >| >|
| >| >| >|
| >| >| >| Server: COMP0220
| >| >| >| DBMS: Microsoft SQL Server
| >| >| >| Version: 08.00.0760
| >| >| >| user name: dbo
| >| >| >| API conformance: 2
| >| >| >| SQL conformance: 1
| >| >| >| transaction capable: 2
| >| >| >| read only: N
| >| >| >| identifier quote char: "
| >| >| >| non_nullable_columns: 1
| >| >| >| owner usage: 31
| >| >| >| max table name len: 128
| >| >| >| max column name len: 128
| >| >| >| need long data len: Y
| >| >| >| max columns in table: 1024
| >| >| >| max columns in index: 16
| >| >| >| max char literal len: 524288
| >| >| >| max statement len: 524288
| >| >| >| max row size: 524288
| >| >| >|
| >| >| >| [7/8/2003 11:26:03 PM]
| RAKSHAK.InternetReplication:
| >| exec
| >| >| >| sp_datatype_info 0, 3
| >| >| >| Percent Complete: 4
| >| >| >| Snapshot files will be downloaded via ftp
| >| >| >| Percent Complete: 7
| >| >| >| Connecting to ftp site '203.129.***.***'
| >| >| >| The schema script '' could not be propagated to
| the
| >| >| >| subscriber.
| >| >| >| [7/8/2003 11:26:03 PM]
| COMP0220.InternetReplication:
| >| >| {call
| >| >| >| sp_reinitmergepullsubscription (N'RAKSHAK',
| >| >| >| N'InternetReplication',
| >| >| N'InternetReplication', 'FALSE')}
| >| >| >| Reinitialized pull subscription to
| >| >| >| publication 'InternetReplication' from
| >| >| >| publisher 'RAKSHAK:InternetReplication'Percent
| >| >| Complete: 0
| >| >| >| The subscription has been marked for
| >| reinitialization.
| >| >| >| Reinitialization will occur the next time you
| >| >| synchronize
| >| >| >| this subscription.
| >| >| >| Percent Complete: 0
| >| >| >| The schema script '' could not be propagated to
| the
| >| >| >| subscriber.
| >| >| >| Percent Complete: 0
| >| >| >| Category:NULL
| >| >| >| Source: Merge Replication Provider
| >| >| >| Number: -2147201001
| >| >| >| Message: The schema script '' could not be
| >| propagated
| >| >| to
| >| >| >| the subscriber.
| >| >| >| Percent Complete: 0
| >| >| >| Category:AGENT
| >| >| >| Source: COMP0220
| >| >| >| Number: 0
| >| >| >| Message: The process could not connect to FTP
| >| >| >| site '203.129.***.***' using port 21.
| >| >| >| Percent Complete: 0
| >| >| >| Category:OS
| >| >| >| Source:
| >| >| >| Number: 12003
| >| >| >| Message: 550 ftp://203.129.***.***: The filename,
| >| >| >| directory name, or volume label syntax is
| incorrect.
| >| >| >|
| >| >| >| Disconnecting from Subscriber 'COMP0220'
| >| >| >| Disconnecting from Subscriber 'COMP0220'
| >| >| >| Disconnecting from Publisher 'RAKSHAK'
| >| >| >| Disconnecting from Publisher 'RAKSHAK'
| >| >| >| Disconnecting from Distributor 'RAKSHAK'
| >| >| >|
| >| >| >|
| >| >| >|
| >| >|
| >|
| __________________________________________________ _________
| >| >| >|
| >| >| >|
| >| >| >| Merge agent is giving a problem at the publisher
| >| end.
| >| >| This
| >| >| >| I can make out from the red error mark over the
| >| merge
| >| >| >| agent. But i am not able to generate a log of
| this,
| >| as
| >| >| >| agent properties does not open any new window (as
| it
| >| >| did
| >| >| >| in the subscriber).
| >| >| >|
| >| >| >| Regards,
| >| >| >| Manish.
| >| >| >|
| >| >| >|
| >| >| >|
| >| >| >|
| >| >| >|
| >| >| >|
| >| >| >|
| >| >| >|
| >| >| >|
| >| >| >|
| >| >| >|
| >| >| >|
| >| >| >|
| >| >| >|
| >| >| >|
| >| >| >|
| >| >| >| >-----Original Message-----
| >| >| >| >Hi Manish,
| >| >| >| >
| >| >| >| >Replication issues are usually complex to
| >| troubleshoot
| >| >| on
| >| >| >| newsgroups. I
| >| >| >| >would suggest that you open an incident with
| >| Microsoft
| >| >| >| Product Support
| >| >| >| >Services via
| >| >| >| >http://support.microsoft.com/default.aspx?
| >| scid=fh;EN-
| >| >| >| US;CNTACTMS, so that
| >| >| >| >we can have dedicated engineer to assist you.
| >| >| >| >
| >| >| >| >You may check the following:
| >| >| >| >1. Make sure all SQL Servers are in SP3,
| publisher,
| >| >| >| distributor, subscriber.
| >| >| >| >318592 FIX: Snapshots Created on SQL Server
| Service
| >| >| Pack
| >| >| >| 2 Cannot Be
| >| >| >| >Delivered
| >| >| >| >http://support.microsoft.com/?id=318592
| >| >| >| >
| >| >| >| >2. Could you first grant Everyone full control
| >| rights
| >| >| to
| >| >| >| the FTP directory
| >| >| >| >so to avoid permission issue?
| >| >| >| >
| >| >| >| >3. Please post the following information so we
| can
| >| >| >| perform further research.
| >| >| >| >a) Agent log file.
| >| >| >| >312292.KB.EN-US: HOW TO: Enable Replication
| Agents
| >| for
| >| >| >| Logging to Output
| >| >| >| >Files
| >| >| >| >
| >| >| >| >b) For more information on necessary information
| on
| >| >| >| troubleshooting
| >| >| >| >replication issues, you may check the following
| >| >| article:
| >| >| >| >315642.KB.EN-US INF: Information That PSS Needs
| to
| >| >| >| Troubleshoot SQL Server
| >| >| >| >Replication
| >| >| >| >http://support.microsoft.com/default.aspx?
| >| scid=KB;EN-
| >| >| >| US;315642
| >| >| >| >
| >| >| >| >
| >| >| >| >This posting is provided "AS IS" with no
| >| warranties,
| >| >| and
| >| >| >| confers no rights.
| >| >| >| >
| >| >| >| >Regards,
| >| >| >| >
| >| >| >| >Bill Cheng
| >| >| >| >Microsoft Support Engineer
| >| >| >| >--------------------
| >| >| >| >| Content-Class: urn:content-classes:message
| >| >| >| >| From: "Manish Buttan" <manish@ccipl.com>
| >| >| >| >| Sender: "Manish Buttan" <manish@ccipl.com>
| >| >| >| >| Subject: Error using Merge Replication via FTP
| >| >| >| >| Date: Fri, 4 Jul 2003 00:16:55 -0700
| >| >| >| >| Lines: 68
| >| >| >| >| Message-ID: <584d01c341fc$3f93ca00
| >| $a401280a@phx.gbl>
| >| >| >| >| MIME-Version: 1.0
| >| >| >| >| Content-Type: text/plain;
| >| >| >| >| charset="iso-8859-1"
| >| >| >| >| Content-Transfer-Encoding: 7bit
| >| >| >| >| X-Newsreader: Microsoft CDO for Windows 2000
| >| >| >| >| Thread-Index: AcNB/D+TnnrW4hj3RXGKHFaQufVLsQ==
| >| >| >| >| X-MimeOLE: Produced By Microsoft MimeOLE
| >| >| V5.50.4910.0300
| >| >| >| >| Newsgroups:
| microsoft.public.sqlserver.replication
| >| >| >| >| Path: cpmsftngxa09.phx.gbl
| >| >| >| >| Xref: cpmsftngxa09.phx.gbl
| >| >| >| microsoft.public.sqlserver.replication:3517
| >| >| >| >| NNTP-Posting-Host: TK2MSFTNGXA12 10.40.1.164
| >| >| >| >| X-Tomcat-NG:
| >| microsoft.public.sqlserver.replication
| >| >| >| >|
| >| >| >| >| Hi,
| >| >| >| >|
| >| >| >| >| I have configured a Distributor and Publisher
| in
| >| SQL
| >| >| >| 2000
| >| >| >| >| running SP 3. In this server, I have setup
| merge
| >| >| >| >| replication. This merge replication agent runs
| >| >| >| >| successfully inside the network when i use a
| >| network
| >| >| >| path.
| >| >| >| >| I am able to create and set subscriptions
| >| >| successfuly.
| >| >| >| >| Also any updates to the subscriber are
| reflected
| >| in
| >| >| the
| >| >| >| >| publisher whenever the subscriber synchronizes.
| >| >| >| >|
| >| >| >| >| I need to set replication to work over the
| >| Internet
| >| >| >| now. I
| >| >| >| >| am publishing data over the Internet using
| TCP/IP
| >| >| and
| >| >| >| FTP.
| >| >| >| >| I have taken care of all the pre-requisites to
| >| >| publish
| >| >| >| >| data over the Internet. This is as per SQL
| BOL -
| >| >| >| >| mk:@MSITStore:C:\Program%20Files\Microsoft%
| 20SQL%
| >| >| >| >| 20Server\80
| >| >| \Tools\Books\replsql.chm::/replimpl_8a5s.htm
| >| >| >| >|
| >| >| >| >| I have created a FTP account at the
| >| >| >| Distributor/Publisher
| >| >| >| >| and have unchecked "Generate Snapshots in
| normal
| >| >| >| snapshot
| >| >| >| >| folder". Instead I have enabled "Generate
| >| Snapshots
| >| >| in
| >| >| >| the
| >| >| >| >| following location" option and have specified
| the
| >| >| home
| >| >| >| >| directory of the FPT server (\\COMP0220
| >| >| \C$\FTP_REPL).
| >| >| >| Also
| >| >| >| >| I have checked "Subscribers can access this
| >| folder
| >| >| >| using
| >| >| >| >| FTP". I have the specified appropriate FTP
| >| address,
| >| >| >| Client
| >| >| >| >| path to this foler, port, user and password.
| >| >| >| >|
| >| >| >| >| The publication gets created successfully. I
| have
| >| >| >| checked
| >| >| >| >| the FTP URL over a browser and it works
| properly.
| >| I
| >| >| >| have
| >| >| >| >| enabled anonymous access to the FTP site.
| >| >| >| >|
| >| >| >| >| The snapshot agent generates the snapshot in
| this
| >| >| >| folder
| >| >| >| >| without any problem.
| >| >| >| >|
| >| >| >| >| Now when I create a pull subscription, and say
| >| >| >| >| scynchronize using FTP, it fails and after
| >| checking
| >| >| the
| >| >| >| >| job history, these are the messages that were
| >| there -
| >| >| >| >|
| >| >| >| >|
| >| >| >| >| Category:NULL
| >| >| >| >| Source: Merge Replication Provider
| >| >| >| >| Number: -2147201001
| >| >| >| >| Message: The schema script '' could not be
| >| >| propagated
| >| >| >| to
| >| >| >| >| the subscriber.
| >| >| >| >|
| >| >| >| >| Category:AGENT
| >| >| >| >| Source: PARAM
| >| >| >| >| Number: 0
| >| >| >| >| Message: The process could not connect to FTP
| >| site
| >| >| >| >| 203.129.***.***' using
| >| >| >| >| port 21.
| >| >| >| >|
| >| >| >| >| Category:OS
| >| >| >| >| Source:
| >| >| >| >| Number: 12003
| >| >| >| >| Message: 550 ftp://203.129.***.***: The
| filename,
| >| >| >| >| directory name, or volume label syntax is
| >| incorrect.
| >| >| >| >|
| >| >| >| >| The schema script '' could not be propagated
| to
| >| the
| >| >| >| >| subscriber. The step failed.
| >| >| >| >|
| >| >| >| >|
| >| >| >| >|
| >| >| >| >| Can some please advice as to what is going
| wrong
| >| and
| >| >| >| >| where ? Thanks in advance!
| >| >| >| >|
| >| >| >| >| Regards,
| >| >| >| >| Manish.
| >| >| >| >|
| >| >| >| >|
| >| >| >| >
| >| >| >| >.
| >| >| >| >
| >| >| >|
| >| >| >
| >| >| >.
| >| >| >
| >| >|
| >| >
| >| >.
| >| >
| >|
| >
| >.
| >
|