Re: Replication Errors running SQL Server 2005 beta

Tim,

Send me an email and I'll send you a document I've written
for a client that explains setting this up step by step.
ddshaff@xxxxxxxxxxx

The space in your database name may be a problem, but I
don't think that's why the server tools are not finding your
merge publication.
--
Darren Shaffer
..NET Compact Framework MVP
Principal Architect
Connected Innovation
www.connectedinnovation.com

"Tim" <Tim@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:676370E3-5F8E-4AAA-895E-B0835AAF3448@xxxxxxxxxxxxxxxx
>I was going through the SQL Server error log and noticed the following
>errors:
> 07/01/2005 08:57:32,spid57,Unknown,MSSQL_ENG -(208) <nl/>SQL Merge Agent
> encountered an error.<nl/><nl/>Publisher: CMOP-ENT<nl/>Publisher Database:
> TEST-CMOP OLTP<nl/>Publication: Test<nl/>Subscriber: TestSubscriber1 -
> 8f6b100c04d4<nl/>Subscriber Database: MyDatabase.sdf<nl/><nl/>Invalid
> object
> name 'dbo.sysmergepublications'.
> 07/01/2005 08:57:32,spid57,Unknown,Error: 70000<c/> Severity: 16<c/>
> State: 1.
> 07/01/2005 08:57:32,spid57,Unknown,MSSQL_ENG -(0) <nl/>SQL Merge Agent
> encountered an error.<nl/><nl/>Publisher: CMOP-ENT<nl/>Publisher Database:
> TEST-CMOP OLTP<nl/>Publication: Test<nl/>Subscriber: TestSubscriber1 -
> 8f6b100c04d4<nl/>Subscriber Database: MyDatabase.sdf<nl/><nl/>{call
> sp_MSchecksnapshotstatus (N'Test')}
> 07/01/2005 08:57:32,spid57,Unknown,Error: 70000<c/> Severity: 16<c/>
> State: 1.
> 07/01/2005 08:57:32,spid57,Unknown,MSSQL_REPL -(-2147201022) <nl/>SQL
> Merge
> Agent encountered an error.<nl/><nl/>Publisher: CMOP-ENT<nl/>Publisher
> Database: TEST-CMOP OLTP<nl/>Publication: Test<nl/>Subscriber:
> TestSubscriber1 - 8f6b100c04d4<nl/>Subscriber Database:
> MyDatabase.sdf<nl/><nl/>Publication 'Test' does not exist.
> 07/01/2005 08:57:32,spid57,Unknown,Error: 70000<c/> Severity: 16<c/>
> State: 1.
>
>
> "Tim" wrote:
>
>> 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.
>> > >
>> > >
>> >
>> >
>> >


.

Relevant Pages

  • Re: SQL Server 2005 replication monitor questions
    ... >> To get to the agents expand SQL Server Agent jobs, ... click on your publication in Enterprise ... >> bottom half you will see your snapshot and distribution agent. ... >> monitor it there (through replication monitor). ...
    (microsoft.public.sqlserver.replication)
  • RE: Replication Error
    ... > account that the SQL Agent runs under. ... > snapshot and merge job. ... >>> I have been trying to setup SQL Server Replication between two SQL Server ...
    (microsoft.public.sqlserver.replication)
  • Re: install/configure SQL Server 2000, SQL Server CE for merge rep
    ... Publication: NorthwindProducts ... PublisherDB: Northwind ... A snapshot of 1 articlewas generated. ... > check the replication monitor in SQL Server 2000 Enterprise Manager ...
    (microsoft.public.sqlserver.ce)
  • Re: Snapshot folder
    ... snapshot or distribution agent. ... Ignore the message SQL Server throws up as well. ... that if you are doing a pull subscription, the SQL Server agent on the ...
    (microsoft.public.sqlserver.replication)
  • Re: Cannot run snapshot agent from command line
    ... account which the SQL Server Agent runs under, ... Looking for a SQL Server replication book? ... But now i'm writing a script so I can start the Snapshot Agent from ...
    (microsoft.public.sqlserver.replication)
Loading