Replication Problem
From: HIFNI (anonymous_at_discussions.microsoft.com)
Date: 08/07/04
- Next message: Paul Ibison: "Re: connectivity in sql server with two diff public ip address"
- Previous message: India: "connectivity in sql server with two diff public ip address"
- Next in thread: Paul Ibison: "Re: Replication Problem"
- Reply: Paul Ibison: "Re: Replication Problem"
- Messages sorted by: [ date ] [ thread ]
Date: Sat, 7 Aug 2004 01:21:17 -0700
Hi,
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.
NOTE: My computers are connected to a LAN
- Next message: Paul Ibison: "Re: connectivity in sql server with two diff public ip address"
- Previous message: India: "connectivity in sql server with two diff public ip address"
- Next in thread: Paul Ibison: "Re: Replication Problem"
- Reply: Paul Ibison: "Re: Replication Problem"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
