|
|
You're in the
sql server replication
group:Replication Problem
sql server replication:
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
Nazeer,
if you're replicating to another computer you'll need to do 2 things: (1) go to control panel, administrative tools, services and select the sql server agent service. Change the startup account to a domain user. To make things easy, put this account in the local admin's group (assuming builtin/administrators are in sysadmin also on sqlserver). Do the same on the subscriber, preferably with the same account. This is not the most granular way to set things up, and for more detailed info, have a look in the replication, security section of BOL. Initially let's just ensure you can get this up and working. (2) on the publisher share the repldata folder as \\computername\repldata and configure replication to use this share (right-click replication monitor, distributor properties, publishers tab, publisher elipsis...). HTH, Paul bison
Hi Paul,
Thanx for your solution, it did work out correctly. OK, there's one more problem, In case, If the Publisher is a MSDE 2000, how am I gone to create a publications, subsribtions etc.? and what is ment by "Row guide column"? Nazeer, [quoted text, click to view] >-----Original Message-----
>Nazeer, >if you're replicating to another computer you'll need to do 2 things: >(1) go to control panel, administrative tools, services and select the sql >server agent service. Change the startup account to a domain user. To make >things easy, put this account in the local admin's group (assuming >builtin/administrators are in sysadmin also on sqlserver). Do the same on >the subscriber, preferably with the same account. This is not the most >granular way to set things up, and for more detailed info, have a look in >the replication, security section of BOL. Initially let's just ensure you >can get this up and working. >(2) on the publisher share the repldata folder as \\computername\repldata >and configure replication to use this share (right-click replication >monitor, distributor properties, publishers tab, publisher elipsis...). >HTH, >Paul bison > > >.
I suggest you use the replication ActiveX controls as they have methods in
them which allow you to connect to the Publisher without having to register the subscribers in EM or using Client Network Utility. If you use SQL DMO you will still have to use Client Network Utility which is a violation of your licensing agreement for MSDE. -- Hilary Cotter Looking for a book on SQL Server replication? http://www.nwsu.com/0974973602.html [quoted text, click to view] "Paul Ibison" <Paul.Ibison@Pygmalion.Com> wrote in message news:%23quBWZffEHA.712@TK2MSFTNGP09.phx.gbl... > Nazeer, > > if you're using MSDE, you could use SQLDMO if you wanted to create the > publication programatically. If you need to do it graphically, the MSDE can > potentially be administered from Enterprise Manager - however, please first > check the licensing documents as I'm not too sure if this is permitted or > not. If you need to create a subscription on the MSDE box , you could use > windows synchronization manager. > > GUIDS are used in merge replication and updating subscriber scenarios. Merge > will create a rowguid column or use an existing column having the rowguid > attribute. In merge the guid doesn't change while it does for updating > subscribers but still, they are essentially just unique identifiers for a > row. > > HTH, > > Paul Ibison > >
Nazeer,
if you're using MSDE, you could use SQLDMO if you wanted to create the publication programatically. If you need to do it graphically, the MSDE can potentially be administered from Enterprise Manager - however, please first check the licensing documents as I'm not too sure if this is permitted or not. If you need to create a subscription on the MSDE box , you could use windows synchronization manager. GUIDS are used in merge replication and updating subscriber scenarios. Merge will create a rowguid column or use an existing column having the rowguid attribute. In merge the guid doesn't change while it does for updating subscribers but still, they are essentially just unique identifiers for a row. HTH, Paul Ibison
Hi,
I just want to know, is it possible to replicate some certain entries only. Now say, that there is a Server (assume that it's called as MiniServer) which Maintains "Purchase Orders". This Purchase Orders' Primary Key is "OrderID" and it's an autoincremental field. Also this MiniServer's Purchase Order Table's Last OrderID value is 50. This MiniServer Replicates it's Data to the MainServer at the end of Each office days. Just note that the MainServer's Purchase Order Table has it's Last OrderID = 25, and the MainServer needs all the OrderID more than 25 from the MiniServer.Is this possible with Replication? If so, how can I set it in SQL Server Replication? Awaiting your Response in Anticipation. Thanx in Advance. HIFNI NAZEER [quoted text, click to view] >-----Original Message-----
>Nazeer, > >if you're using MSDE, you could use SQLDMO if you wanted to create the >publication programatically. If you need to do it graphically, the MSDE can >potentially be administered from Enterprise Manager - however, please first >check the licensing documents as I'm not too sure if this is permitted or >not. If you need to create a subscription on the MSDE box , you could use >windows synchronization manager. > >GUIDS are used in merge replication and updating subscriber scenarios. Merge >will create a rowguid column or use an existing column having the rowguid >attribute. In merge the guid doesn't change while it does for updating >subscribers but still, they are essentially just unique identifiers for a >row. > >HTH, > >Paul Ibison > > >.
Hifni,
with merge replication, the it is not normally so difficult to achieve this setup. If you were using merge replication, only those records not yet transferred from MiniServer to MainServer will be replicated, so if 1-25 originated from MiniServer and are now on MainServer, they won't be replicated again. If the records 1-25 came originally from MainServer and are now on MiniServer, they won't be cycled backwards to MainServer, unless they have been modified on MiniServer. BTW there is no possibility of (identity & PK) OrderIDs overlapping - they are partitioned into ranges either during the publication setup or manually. HTH, Paul Ibison
Don't see what you're looking for? Try a search.
|
April 2003
June 2003
July 2003
August 2003
September 2003
October 2003
November 2003
December 2003
January 2004
February 2004
March 2004
April 2004
May 2004
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
November 2007
| home · blog · groups | Questions? Comments? Contact the dn |