<rajpatel50@hotmail.com> wrote in message
news:1184159165.754229.327650@w3g2000hsg.googlegroups.com...
> Hi All,
>
> I'm trying the following using SQL Server 2005 Developer. (also tried
> with SQL Express and have some issue)
>
> I'm trying to use a single server as a local distributor, publisher
> and subscriber for a proof of concept using merge replication.
>
> According to the link below, If I right-click the Replication node I
> should see an option to Configure Distribution. I see no such option.
>
> http://msdn2.microsoft.com/en-us/library/ms151192.aspx
>
> I have seen various step-by-step guides (e.g below) that say if I
> expand the Replication node I should see an option for Local
> Publications (All I see is one for local subscriptions)
>
> http://www.softwaregreenhouse.com/Home/tabid/36/articleType/ArticleView/articleId/6/Default.aspx
>
> I suspect the publications won't work until I resolve the distributor
> issue.
>
> Some more info that may be relevant:
>
> - If i run select @@servername it returns my servername
>
> - If i run sp_dboption 'BISRAM', 'merge publish' , 'true - I get the
> following:
>
> Msg 20028, Level 16, State 1, Procedure sp_MSmergepublishdb, Line 60
> The Distributor has not been installed correctly. Could not enable
> database for publishing.
> The replication option 'merge publish' of database 'BISRAM' has been
> set to false.
>
> - If I run dbo.sp_helpdistributor - I get a single record returnd with
> all NULL values. I guesss this should have a record? But how can I
> setup the distributor as the option is not available to me!
>
> Ideally i'd like to get this set-up so I can do it via the UI options
> and wizards instead of calling the SP's directly but for some reason I
> dont have access to these options. Is this a permissions issue?
>
> All thoughts, musings appreciated!
>
> Raj
>

On 11 Jul, 14:32, "Hilary Cotter" <hilary.cot...@gmail.com> wrote:
> can you run setup and see if the replication components have been installed?
> --
> Looking for a SQL Server replication book?http://www.nwsu.com/0974973602.html
>
> Looking for a FAQ on Indexing Services/SQL FTShttp://www.indexserverfaq.com<rajpate...@hotmail.com> wrote in message
>
> news:1184159165.754229.327650@w3g2000hsg.googlegroups.com...
>
>
>
> > Hi All,
>
> > I'm trying the following using SQL Server 2005 Developer. (also tried
> > with SQL Express and have some issue)
>
> > I'm trying to use a single server as a local distributor, publisher
> > and subscriber for a proof of concept using merge replication.
>
> > According to the link below, If I right-click the Replication node I
> > should see an option to Configure Distribution. I see no such option.
>
> >http://msdn2.microsoft.com/en-us/library/ms151192.aspx
>
> > I have seen various step-by-step guides (e.g below) that say if I
> > expand the Replication node I should see an option for Local
> > Publications (All I see is one for local subscriptions)
>
> >http://www.softwaregreenhouse.com/Home/tabid/36/articleType/ArticleVi...
>
> > I suspect the publications won't work until I resolve the distributor
> > issue.
>
> > Some more info that may be relevant:
>
> > - If i run select @@servername it returns my servername
>
> > - If i run sp_dboption 'BISRAM', 'merge publish' , 'true - I get the
> > following:
>
> > Msg 20028, Level 16, State 1, Procedure sp_MSmergepublishdb, Line 60
> > The Distributor has not been installed correctly. Could not enable
> > database for publishing.
> > The replication option 'merge publish' of database 'BISRAM' has been
> > set to false.
>
> > - If I run dbo.sp_helpdistributor - I get a single record returnd with
> > all NULL values. I guesss this should have a record? But how can I
> > setup the distributor as the option is not available to me!
>
> > Ideally i'd like to get this set-up so I can do it via the UI options
> > and wizards instead of calling the SP's directly but for some reason I
> > dont have access to these options. Is this a permissions issue?
>
> > All thoughts, musings appreciated!
>
> > Raj- Hide quoted text -
>
> - Show quoted text -

On 11 Jul, 14:53, rajpate...@hotmail.com wrote:
> On 11 Jul, 14:32, "Hilary Cotter" <hilary.cot...@gmail.com> wrote:
>
>
>
>
>
> > can you run setup and see if the replication components have been installed?
> > --
> > Looking for a SQL Server replication book?http://www.nwsu.com/0974973602.html
>
> > Looking for a FAQ on Indexing Services/SQL FTShttp://www.indexserverfaq.com<rajpate...@hotmail.com> wrote in message
>
> >news:1184159165.754229.327650@w3g2000hsg.googlegroups.com...
>
> > > Hi All,
>
> > > I'm trying the following using SQL Server 2005 Developer. (also tried
> > > with SQL Express and have some issue)
>
> > > I'm trying to use a single server as a local distributor, publisher
> > > and subscriber for a proof of concept using merge replication.
>
> > > According to the link below, If I right-click the Replication node I
> > > should see an option to Configure Distribution. I see no such option.
>
> > >http://msdn2.microsoft.com/en-us/library/ms151192.aspx
>
> > > I have seen various step-by-step guides (e.g below) that say if I
> > > expand the Replication node I should see an option for Local
> > > Publications (All I see is one for local subscriptions)
>
> > >http://www.softwaregreenhouse.com/Home/tabid/36/articleType/ArticleVi...
>
> > > I suspect the publications won't work until I resolve the distributor
> > > issue.
>
> > > Some more info that may be relevant:
>
> > > - If i run select @@servername it returns my servername
>
> > > - If i run sp_dboption 'BISRAM', 'merge publish' , 'true - I get the
> > > following:
>
> > > Msg 20028, Level 16, State 1, Procedure sp_MSmergepublishdb, Line 60
> > > The Distributor has not been installed correctly. Could not enable
> > > database for publishing.
> > > The replication option 'merge publish' of database 'BISRAM' has been
> > > set to false.
>
> > > - If I run dbo.sp_helpdistributor - I get a single record returnd with
> > > all NULL values. I guesss this should have a record? But how can I
> > > setup the distributor as the option is not available to me!
>
> > > Ideally i'd like to get this set-up so I can do it via the UI options
> > > and wizards instead of calling the SP's directly but for some reason I
> > > dont have access to these options. Is this a permissions issue?
>
> > > All thoughts, musings appreciated!
>
> > > Raj- Hide quoted text -
>
> > - Show quoted text -
>
> I re-installed and made sure they were installed (Selected Install to
> Hard Disk -or words to that effect)
>
> Is there another way to check that the relevant components have been
> installed?- Hide quoted text -
>
> - Show quoted text -