How to Replicate using OSQL?

From: NAZEER (anonymous_at_discussions.microsoft.com)
Date: 08/03/04 

Date: Tue, 3 Aug 2004 03:06:49 -0700

Hi,
I've installed a MSDE 2000 in a remote Computer. I want to
know how to create a publisher, a publication, a
distribution, and set subscriber from OSQL?

Now, I've installed SQL Server 2000 standard edition, and
I've registered the Remote Computer in my Enterprise
Manager. How ever when I run the "Create Publication
Wizard", I get an Information Message, that:

"SQL Server Agent on 'MyComputer' currently uses the
system account, which causes replication between servers
to fail. In the follwing dialog box, specify another
account for the service startup acccout".

Anyway, once I press OK, I come through a Dialog Box
called "SQL Server Agent Properties - MyComputer", where
in the General Tab "Service Startup Account" is disabled.
After I ignore it and come through another Dialog Box
called "Specify Snaphsot Folder". In that Dialog box, the
default value
was "\\RemoteComputer\C$......\MSSQL\ReplData", but I do
get another Information Message as saying:

"'\\RemoteComputer\C$......\MSSQL\ReplData' is not a valid
path, or it referes to a file isntead of folder. Enter
the Path to an existing folder." And this doesn't give to
go through the Wizard.

Why this is happening? how can I use Enterprise Manager
from another computer to configure Replication Scenario's
to a computer with MSDE 2000 Installed, Else If i Cant use
enterprise Manager, how can I use the osql tool to
configure replication. The SQL books online is Complicated
on osql, so please help me by telling how would you
configure this replication without Enterprise Manager on
Computer with only MSDE 2000 installed?

Regards,
Nazeer.

Relevant Pages

  • Replication between SQL 2000 CE and MSDE
    ... I have a pocket pc which has a SQL 2000 CE database on it. ... I have installed both MSDE and the tools from SQL ... in the enterprise manager since I don't have the enterprise server installed. ... Could somebody help me understand how to set the replication up and where to ...
    (microsoft.public.sqlserver.msde)
  • MSDE to MSDE replication with T-SQL/sp?
    ... How can we replicate data in one MSDE to the other MSDE without having to ... pay for MSSQL2000 full version to use the sql enterprise manager? ... It seems that Enterprise Manager or SQL-DMO based programs rely on ... Internet and found few resources about msde to msde replication. ...
    (microsoft.public.sqlserver.msde)
  • Re: getting ASPNET to work with MSDE
    ... > Since MSDE does not include the enterprise manager, ... > administration tasks to be performed are done so using OSQL. ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Transaction Replication und MSDE
    ... >>> ich hatte eine Transaction Replication mit 2x MSDE geplant. ... >>> geht leider aber nicht da MSDE nicht als Verleger oder Verteiler ... Versuch gerade per osql eine Merge Replication ... Leider scheint in sp_adddistributiondb ein kleiner Fehler ...
    (microsoft.public.de.sqlserver)
  • RE: VSnet.ide cannot see local SQL db, but Enterprise Manager can
    ... added a new login for the new MSDE instance, ... I cannot get the connection to my SQLServer instance working. ... > I can register this instance in Enterprise Manager, ...
    (microsoft.public.vsnet.ide)