Publication Configuration Error

Hey Everyone,

I am trying to setup publishing on SQL Server 2000 Enterprise. I will be subscribing from a SQL Mobile 2005 database so I have installed the SQL Server 2000 SP3a Replication Components, .NET Framework 2.0, and the SQL Server 2005 Mobile Edition Server Tools.

I was able to go through the 2005 Mobile Web Synchronization Wizard with no problems. However, when I try to run the Configure Publishing and Distribution Wizard, I get the following message at the end:

SQL Server Enterprise Manager could not configure 'GISSERV' as the Distributor for 'GISSERV'
Error 14114: '(null)' is not configured as a Distributor.

The first option I choose is Make 'GISSERV' it's own Distributor. Then, I select the snapshot folder that I shared. And on the third screen, I've tried going with the standard default settings and customizing those settings.

Has anyone else come across this error? Is there anyone else out there replicating from SQL Server 2000 to SQL Server 2005 Mobile?

Thanks in advance,

Lee

Is this merge replication? If so, this configuration is not supported, you cannot have a SQL 2005 subscriber with a SQL 2000 publisher/distributor.

http://msdn2.microsoft.com/ms143241(en-US,SQL.90).aspx

|||

Thanks for the link. I'm going to have to find another way of doing this. I was led to believe that it was possible by this article:

http://www.microsoft.com/sql/editions/sqlmobile/connectivity-tools.mspx

But regardless of what my subscriber is running, I still should not be getting this error, should I?

Thanks,

Lee

|||hold on, i wasn't paying attention when you said SQL Server Mobile 2005. Let me double-check.|||

Yes, SQL 2005 Mobile is supported for a SQL 2000 publisher/distributor, I was incorrect.

Regarding the error message, have you renamed your machine along the way, or restored master database from a backup of another machine? Regardless, here's the KB article that most like fixes the situation:

http://support.microsoft.com/default.aspx?scid=kb;en-us;302223