Desperately need help w/ 29045 error 
Author Message
 Desperately need help w/ 29045 error

I'm having troubles with merge replication in a SQLCE 2.0
PocketPC 2002 application.  The exact error is as follows:

1st window
Error Code: 80045091
Message: Intializing SQL Server Reconciler has failed.
Native Error: 29045
Source Microsoft SQL Server 2000 Windows CE Edition

2nd window
Error Code: 80045091
Message: The remote server does not exist or has not been
designated as a valid publisher.
Source: Merge Process

I also get this error when I try to run the NorthwindCE
sample app provided by MS, even after having followed
their directions on how to set it up.  Here's my setup:

1st box
-Windows XP SP1a
-VisualStudio.NET 2003 Final Beta
-PocketPC 2003 emulator
         |
         |
2nd box
-Windows XP SP1a
-IIS 5.1
-IIS lockdown applied
-SQL 2000 SP3 Server Tools
          |
          |
3rd box
-Windows 2000 Avanced Server SP2
-SQL Server 2000 SP3
-SQL snapshot share: \\uslvta31\SQLSnapshots

IIS is using anonymous authentication with a domain
account.  The account has read access to the snapshot
folder on the SQL Server, along with PAL access to the
publications (and access to the DBs themselves, of
course).

Here's what gets written to the Replication Agent log:
2003/02/20 15:32:55 Hr=00000000 Count   of active RSCBs
        =  0
<STATS Period_Start="2003/02/20 09:34:59"
Period_Duration="21475"       Syncs="4" SubmitSQLs="0"
RDAPushes="0" RDAPulls="0" AVG_IN_File_Size="332"
AVG_OUT_File_Size="0" Completed_Operations="0"
Incomplete_Operations="4" Total_Sync_Thread_Time="0"
Total_Pool_Thread_Time_IN="0"
Total_Pool_Thread_Time_OUT="0" Total_Sync_Queue_Time="0"
Total_Pool_Queue_Time_IN="0"
Total_Pool_Queue_Time_OUT="0" />
2003/02/20 15:32:55 Thread=FF8 RSCB=38 Command=OPWC
Hr=00000000 Total Compressed bytes in =  261
2003/02/20 15:32:55 Thread=FF8 RSCB=38 Command=OPWC
Hr=00000000 Total Uncompressed bytes in =  332
2003/02/20 15:32:55 Thread=FF8 RSCB=38 Command=OPWC
Hr=00000000 Responding to OpenWrite, total bytes =  261
2003/02/20 15:32:55 Thread=FF8 RSCB=38 Command=OPWC
Hr=00000000 C:\Program Files\Microsoft SQL Server CE 2.0
\Server\3538DA80-D7EB-11C2-8000-0459D57ADA81 0
2003/02/20 15:32:55 Thread=28C RSCB=38 Command=SYNC
Hr=00000000 Synchronize entered 0
2003/02/20 15:32:55 Thread=28C RSCB=38 Command=SYNC
Hr=00000000 Synchronize responding 0
2003/02/20 15:32:55 Thread=28C RSCB=38 Command=SYNC
Hr=00000000 The remote server does not exist or has not
been designated as a valid Publisher. -2147198719
2003/02/20 15:32:56 Thread=28C RSCB=38 Command=SCHK
Hr=80045901 SyncCheck responding 0
2003/02/20 15:32:56 Thread=28C RSCB=38 Command=SCHK
Hr=00000000 Removing    this RSCB 0
2003/02/20 15:35:13 Hr=00000FF8 Pool thread exiting 1
2003/02/20 15:35:13 Hr=0000028C Sync thread exiting 1

Here's what I have already tried:
-Troubleshooting flowcharts in SQL CE Books Online
-Registering sscesa20.dll and sscerepl20.dll on IIS box

I've seen other posts in this newsgroup with this same
problem, but none of the suggestions work.  Please help
if you can.  I am totally stumped.

thanks,

chris



Tue, 09 Aug 2005 23:37:42 GMT
 Desperately need help w/ 29045 error

Hi Chris,

First off, thank you very much for providing so much information in your
intial post.  I believe you transposed your error number, it should be
80045901, according to the Repl log you posted below.  The error is
definately an "Access Denied" error.

Is your publication in the default instance of the SQL Server or is it
another instance?  If it is another instance, verify that you are passing
server\instancename to the Publisher property.

--
--
Kevin Boske
SQL Server CE Team
Microsoft
----------------------------------------------------------------------------
----------------------------------------
Everything you need to know about SQL Server CE:

http://www.microsoft.com/sql/ce/techinfo/default.asp
----------------------------------------------------------------------------
----------------------------------------


Quote:
> I'm having troubles with merge replication in a SQLCE 2.0
> PocketPC 2002 application.  The exact error is as follows:

> 1st window
> Error Code: 80045091
> Message: Intializing SQL Server Reconciler has failed.
> Native Error: 29045
> Source Microsoft SQL Server 2000 Windows CE Edition

> 2nd window
> Error Code: 80045091
> Message: The remote server does not exist or has not been
> designated as a valid publisher.
> Source: Merge Process

> I also get this error when I try to run the NorthwindCE
> sample app provided by MS, even after having followed
> their directions on how to set it up.  Here's my setup:

> 1st box
> -Windows XP SP1a
> -VisualStudio.NET 2003 Final Beta
> -PocketPC 2003 emulator
>          |
>          |
> 2nd box
> -Windows XP SP1a
> -IIS 5.1
> -IIS lockdown applied
> -SQL 2000 SP3 Server Tools
>           |
>           |
> 3rd box
> -Windows 2000 Avanced Server SP2
> -SQL Server 2000 SP3
> -SQL snapshot share: \\uslvta31\SQLSnapshots

> IIS is using anonymous authentication with a domain
> account.  The account has read access to the snapshot
> folder on the SQL Server, along with PAL access to the
> publications (and access to the DBs themselves, of
> course).

> Here's what gets written to the Replication Agent log:
> 2003/02/20 15:32:55 Hr=00000000 Count of active RSCBs
> =  0
> <STATS Period_Start="2003/02/20 09:34:59"
> Period_Duration="21475" Syncs="4" SubmitSQLs="0"
> RDAPushes="0" RDAPulls="0" AVG_IN_File_Size="332"
> AVG_OUT_File_Size="0" Completed_Operations="0"
> Incomplete_Operations="4" Total_Sync_Thread_Time="0"
> Total_Pool_Thread_Time_IN="0"
> Total_Pool_Thread_Time_OUT="0" Total_Sync_Queue_Time="0"
> Total_Pool_Queue_Time_IN="0"
> Total_Pool_Queue_Time_OUT="0" />
> 2003/02/20 15:32:55 Thread=FF8 RSCB=38 Command=OPWC
> Hr=00000000 Total Compressed bytes in =  261
> 2003/02/20 15:32:55 Thread=FF8 RSCB=38 Command=OPWC
> Hr=00000000 Total Uncompressed bytes in =  332
> 2003/02/20 15:32:55 Thread=FF8 RSCB=38 Command=OPWC
> Hr=00000000 Responding to OpenWrite, total bytes =  261
> 2003/02/20 15:32:55 Thread=FF8 RSCB=38 Command=OPWC
> Hr=00000000 C:\Program Files\Microsoft SQL Server CE 2.0
> \Server\3538DA80-D7EB-11C2-8000-0459D57ADA81 0
> 2003/02/20 15:32:55 Thread=28C RSCB=38 Command=SYNC
> Hr=00000000 Synchronize entered 0
> 2003/02/20 15:32:55 Thread=28C RSCB=38 Command=SYNC
> Hr=00000000 Synchronize responding 0
> 2003/02/20 15:32:55 Thread=28C RSCB=38 Command=SYNC
> Hr=00000000 The remote server does not exist or has not
> been designated as a valid Publisher. -2147198719
> 2003/02/20 15:32:56 Thread=28C RSCB=38 Command=SCHK
> Hr=80045901 SyncCheck responding 0
> 2003/02/20 15:32:56 Thread=28C RSCB=38 Command=SCHK
> Hr=00000000 Removing this RSCB 0
> 2003/02/20 15:35:13 Hr=00000FF8 Pool thread exiting 1
> 2003/02/20 15:35:13 Hr=0000028C Sync thread exiting 1

> Here's what I have already tried:
> -Troubleshooting flowcharts in SQL CE Books Online
> -Registering sscesa20.dll and sscerepl20.dll on IIS box

> I've seen other posts in this newsgroup with this same
> problem, but none of the suggestions work.  Please help
> if you can.  I am totally stumped.

> thanks,

> chris



Wed, 10 Aug 2005 01:59:25 GMT
 Desperately need help w/ 29045 error
I'm pretty sure it is, but I am by no means an SQL Server
DBA.  USLVTA31 (the SQL server name) is listed as the
Publisher and Distributor in the SQL Agent "Run agent"
properties.  How would I go about determining this
definitively?

thanks for you help,

chris

Quote:
>-----Original Message-----
>Hi Chris,

>First off, thank you very much for providing so much
information in your
>intial post.  I believe you transposed your error

number, it should be
Quote:
>80045901, according to the Repl log you posted below.  
The error is
>definately an "Access Denied" error.

>Is your publication in the default instance of the SQL
Server or is it
>another instance?  If it is another instance, verify

that you are passing
Quote:
>server\instancename to the Publisher property.

>--
>--
>Kevin Boske
>SQL Server CE Team
>Microsoft



Wed, 10 Aug 2005 03:16:03 GMT
 Desperately need help w/ 29045 error
You can check the Properties for the SQL Server registration in the SQL
Enterprise Manager.

However, unless you specifically installed a named instance, I think we can
rule that out.

Can you post the replication properties you are setting?  (no passwords or
logins, please)

--
Kevin Boske
SQL Server CE Team
Microsoft
----------------------------------------------------------------------------
----------------------------------------
Everything you need to know about SQL Server CE:

http://www.microsoft.com/sql/ce/techinfo/default.asp
----------------------------------------------------------------------------
----------------------------------------
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm.
----------------------------------------------------------------------------
----------------------------------------


I'm pretty sure it is, but I am by no means an SQL Server
DBA.  USLVTA31 (the SQL server name) is listed as the
Publisher and Distributor in the SQL Agent "Run agent"
properties.  How would I go about determining this
definitively?

thanks for you help,

chris

Quote:
>-----Original Message-----
>Hi Chris,

>First off, thank you very much for providing so much
information in your
>intial post.  I believe you transposed your error

number, it should be
Quote:
>80045901, according to the Repl log you posted below.
The error is
>definately an "Access Denied" error.

>Is your publication in the default instance of the SQL
Server or is it
>another instance?  If it is another instance, verify

that you are passing
Quote:
>server\instancename to the Publisher property.

>--
>--
>Kevin Boske
>SQL Server CE Team
>Microsoft



Wed, 10 Aug 2005 10:06:38 GMT
 Desperately need help w/ 29045 error
OK, yes it is in the default instance.

Here's the code that I am using to set the properties of
the SQLCEReplication object:

repl = new SqlCeReplication();

repl.Publisher = "165.75.9.6";
repl.PublisherDatabase = "Beacon";
repl.Publication = "Mobile Beacon Users";
repl.SubscriberConnectionString
= "Provider=Microsoft.SQLSERVER.OLEDB.CE.2.0;Data
Source=" + dbFile;
repl.Subscriber = "MySubscriber";
repl.PublisherSecurityMode =
SecurityType.NTAuthentication;
repl.ExchangeType = ExchangeType.BiDirectional;

And then, of course, there's also the code in the
NorthwindCE sample application as well, but I won't post
that since it is freely available.

Thanks for you replies, Kevin.

chris

Quote:
>-----Original Message-----
>You can check the Properties for the SQL Server

registration in the SQL
Quote:
>Enterprise Manager.

>However, unless you specifically installed a named

instance, I think we can
Quote:
>rule that out.

>Can you post the replication properties you are

setting?  (no passwords or
Quote:
>logins, please)

>--
>Kevin Boske
>SQL Server CE Team
>Microsoft
>---------------------------------------------------------
-------------------
>----------------------------------------
>Everything you need to know about SQL Server CE:

>http://www.microsoft.com/sql/ce/techinfo/default.asp
>---------------------------------------------------------
-------------------
>----------------------------------------
>This posting is provided "AS IS" with no warranties, and
confers no rights.
>Use of included script samples are subject to the terms
specified at
>http://www.microsoft.com/info/cpyright.htm.



Fri, 12 Aug 2005 21:49:03 GMT
 Desperately need help w/ 29045 error
Chris,

Everything looks correct, however, have you tried by passing the DNS name of
the SQL Server instead of the IP address?  Also, check your network
properties on your server and make sure that you have TCP/IP enabled and
1433 as your default port for TCP/IP protocol.

--
--
Kevin Boske
SQL Server CE Team
Microsoft
----------------------------------------------------------------------------
----------------------------------------
Everything you need to know about SQL Server CE:

http://www.microsoft.com/sql/ce/techinfo/default.asp
----------------------------------------------------------------------------
----------------------------------------


Quote:
> OK, yes it is in the default instance.

> Here's the code that I am using to set the properties of
> the SQLCEReplication object:

> repl = new SqlCeReplication();
> repl.InternetUrl =

> repl.Publisher = "165.75.9.6";
> repl.PublisherDatabase = "Beacon";
> repl.Publication = "Mobile Beacon Users";
> repl.SubscriberConnectionString
> = "Provider=Microsoft.SQLSERVER.OLEDB.CE.2.0;Data
> Source=" + dbFile;
> repl.Subscriber = "MySubscriber";
> repl.PublisherSecurityMode =
> SecurityType.NTAuthentication;
> repl.ExchangeType = ExchangeType.BiDirectional;

> And then, of course, there's also the code in the
> NorthwindCE sample application as well, but I won't post
> that since it is freely available.

> Thanks for you replies, Kevin.

> chris

> >-----Original Message-----
> >You can check the Properties for the SQL Server
> registration in the SQL
> >Enterprise Manager.

> >However, unless you specifically installed a named
> instance, I think we can
> >rule that out.

> >Can you post the replication properties you are
> setting?  (no passwords or
> >logins, please)

> >--
> >Kevin Boske
> >SQL Server CE Team
> >Microsoft
> >---------------------------------------------------------
> -------------------
> >----------------------------------------
> >Everything you need to know about SQL Server CE:

> >http://www.microsoft.com/sql/ce/techinfo/default.asp
> >---------------------------------------------------------
> -------------------
> >----------------------------------------
> >This posting is provided "AS IS" with no warranties, and
> confers no rights.
> >Use of included script samples are subject to the terms
> specified at
> >http://www.microsoft.com/info/cpyright.htm.



Sat, 13 Aug 2005 02:34:27 GMT
 Desperately need help w/ 29045 error
TCP/IP is setup properly.

I've tried both the FQDN and the IP address of the SQL
Server for the Publisher property (in both my test app as
well as NorthwindCE), but both produce the same 29045
error.

It may be helpful to you to know that I originally was
playing around with RDA, and that it worked flawlessly.

chris

Quote:
>-----Original Message-----
>Chris,

>Everything looks correct, however, have you tried by

passing the DNS name of
Quote:
>the SQL Server instead of the IP address?  Also, check
your network
>properties on your server and make sure that you have
TCP/IP enabled and
>1433 as your default port for TCP/IP protocol.

>--
>--
>Kevin Boske
>SQL Server CE Team
>Microsoft
>---------------------------------------------------------
-------------------
>----------------------------------------
>Everything you need to know about SQL Server CE:

>http://www.microsoft.com/sql/ce/techinfo/default.asp
>---------------------------------------------------------
-------------------
>----------------------------------------



>> OK, yes it is in the default instance.

>> Here's the code that I am using to set the properties
of
>> the SQLCEReplication object:

>> repl = new SqlCeReplication();
>> repl.InternetUrl =

>> repl.Publisher = "165.75.9.6";
>> repl.PublisherDatabase = "Beacon";
>> repl.Publication = "Mobile Beacon Users";
>> repl.SubscriberConnectionString
>> = "Provider=Microsoft.SQLSERVER.OLEDB.CE.2.0;Data
>> Source=" + dbFile;
>> repl.Subscriber = "MySubscriber";
>> repl.PublisherSecurityMode =
>> SecurityType.NTAuthentication;
>> repl.ExchangeType = ExchangeType.BiDirectional;

>> And then, of course, there's also the code in the
>> NorthwindCE sample application as well, but I won't
post
>> that since it is freely available.

>> Thanks for you replies, Kevin.

>> chris

>> >-----Original Message-----
>> >You can check the Properties for the SQL Server
>> registration in the SQL
>> >Enterprise Manager.

>> >However, unless you specifically installed a named
>> instance, I think we can
>> >rule that out.

>> >Can you post the replication properties you are
>> setting?  (no passwords or
>> >logins, please)

>> >--
>> >Kevin Boske
>> >SQL Server CE Team
>> >Microsoft
>> >------------------------------------------------------
---
>> -------------------
>> >----------------------------------------
>> >Everything you need to know about SQL Server CE:

>> >http://www.microsoft.com/sql/ce/techinfo/default.asp
>> >------------------------------------------------------
---
>> -------------------
>> >----------------------------------------
>> >This posting is provided "AS IS" with no warranties,
and
>> confers no rights.
>> >Use of included script samples are subject to the
terms
>> specified at
>> >http://www.microsoft.com/info/cpyright.htm.

>.



Sat, 13 Aug 2005 03:10:16 GMT
 Desperately need help w/ 29045 error
I finally figured out the problem.  I was using the FQDN
of the server for the Publisher property when I should
have just been using the server name itself.

chris

Quote:
>-----Original Message-----
>TCP/IP is setup properly.

>I've tried both the FQDN and the IP address of the SQL
>Server for the Publisher property (in both my test app
as
>well as NorthwindCE), but both produce the same 29045
>error.

>It may be helpful to you to know that I originally was
>playing around with RDA, and that it worked flawlessly.

>chris



Sat, 13 Aug 2005 22:26:14 GMT
 
 [ 8 post ] 

 Relevant Pages 

1. Replication error 29045

2. Error 29045 in Merge Replication

3. 29045 Initialization of reconciler failed Error

4. Error 29045

5. Reconciler Error 29045

6. Replication native error 29045

7. Error 29045

8. newbie: native error 29045

9. Error 29045

10. Replication Error 29045 : Initialization of reconciler failed ???

11. 29045: Initializing SQL Server Reconciler has failed

12. newbi : 29045 ErrorCode


 
Powered by phpBB® Forum Software