Re: Replication Errors running SQL Server 2005 beta
- From: Tim <Tim@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Fri, 1 Jul 2005 07:04:06 -0700
I should have an initial publication. I created a new publication and made
sure the snapshot was created. Here are the steps I performed:
1. Created a New publication with the following characteristics
a. Snapshot Publication
b. Selected a table to view
c. Placed no filter on the table.
d. Selected to create the snapshot immediately and schedule Snapshot Agent
to run every hour.
e. The Snapshot Agent will run under the Administrator account.
f. Connect to the Publisher “By impersonating the process account”
g. At the end of the wizard, selected to create the publication
h. Gave the publication a name “Test”
2. After Creating the Publication, I opened the Publication properties and
selected the Snapshot page. I made the following changes from the default:
a. Snapshot format – Character (I made this change since the device is not
running SQL Server, but rather SQL Server CE.)
b. Specified the directory at E:\TestDir to place the snapshot files in.
3. After making these changes, I go to the View Snapshot Agent Status dialog
box and start the agent. The agent generated the snapshot. I verify this by
going to E:\TestDir and found that directories and files were created.
4. Next, I go to the Configure Web Synchronization Wizard and make the
following selections:
a. Specify that SQL Server Mobile Edition is the type of subscriber.
b. Specifies to create a new virtual directory with the name
“testvirtualdirectory” and set the path to the E:\TestDir directory.
c. The system asks if I want to copy and register the SQL Mobile Server
Agent and I respond with a yes.
d. SSL is NOT required
e. Clients connect anonymously. The system will use the Administrator
account to access the virtual directory.
f. I unchecked the check box checked that stated: “The virtual directory
will be used for SQL Server merge replication with a UNC snapshot share.”
I am still getting the same error. One thing I noticed is my database name
contains a space in it. Should this cause a problem? Thanks again for your
help.
Tim
"Darren Shaffer" wrote:
> have you created a publication in SQL Server 2005?
>
> if so, pls check the Replication Monitor and verify that you did in fact
> create an initial snapshot on your publication. the error message indicates
> that the publication cannot be found by the SQLMobile Server Tools.
> try regenerating the snapshot.
> --
> Darren Shaffer
> ..NET Compact Framework MVP
> Principal Architect
> Connected Innovation
> www.connectedinnovation.com
>
> "Tim" <Tim@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
> news:9FF90571-8CB9-46ED-8CD0-831910422769@xxxxxxxxxxxxxxxx
> >I am trying to get replication working with the latest version of SQL
> >Server
> > 2005 beta. I can't get my PocketPC 2003 emulator to complete a
> > synchronization with the database. I am getting an error stating
> > "Initializing SQL Server Reconciler has failed." If I look at the
> > additional
> > errors, they read:
> > Publication "Test" does not exist.
> > {call sp_Mcheckshapshotstatus (N'Test')}
> > Invalid object name 'dbo.sysmergepublications'
> >
> > The code I am using is:
> > _repl = new SqlCeReplication();
> > _repl.InternetUrl = "http://cmop-ent/cmop/sqlcesa30.dll";
> > _repl.Publisher = "cmop-ent";
> > _repl.PublisherDatabase = "TEST-CMOP OLTP";
> > _repl.PublisherLogin = "sa";
> > _repl.PublisherPassword = "<password>";
> > _repl.Publication = "Test";
> > _repl.Subscriber = "TestSubscriber1";
> > _repl.SubscriberConnectionString = "Data Source = MyDatabase.sdf";
> >
> > _repl.AddSubscription(AddOption.CreateDatabase);
> >
> > _repl.Synchronize();
> >
> > _repl.Dispose();
> >
> > If I hit the "http://cmop-ent/cmop/sqlcesa30.dll";, it reads "SQL Server
> > Mobile Server Agent 3.0" so I think that is set up correctly.
> >
> > Does anyone have any insight into one is causing my trouble. I appreciate
> > your help.
> >
> >
>
>
>
.
- Follow-Ups:
- References:
- Re: Replication Errors running SQL Server 2005 beta
- From: Darren Shaffer
- Re: Replication Errors running SQL Server 2005 beta
- Prev by Date: Re: Primary Index
- Next by Date: Re: Replication Errors running SQL Server 2005 beta
- Previous by thread: Re: Replication Errors running SQL Server 2005 beta
- Next by thread: Re: Replication Errors running SQL Server 2005 beta
- Index(es):
Relevant Pages
|
