Re: No Option To Configure Distributor or Create Publications in SQL Server 2005
- From: rajpatel50@xxxxxxxxxxx
- Date: Wed, 11 Jul 2007 08:18:02 -0700
On 11 Jul, 14:53, rajpate...@xxxxxxxxxxx wrote:
On 11 Jul, 14:32, "Hilary Cotter" <hilary.cot...@xxxxxxxxx> 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...@xxxxxxxxxxx> wrote in message
news:1184159165.754229.327650@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
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 -
Ok This is now resolved (although I have no reason as to how/why).
I had originally installed SQLExpress followed by SQL Server 2005
Developer
I Uninstalled everything and then just installed SQL Server 2005
Developer.
I now have the options to Configure a distributer and create
publications.
.
- References:
- Prev by Date: Re: SQL Server 2005 Replication in Cluster Environment Setup
- Next by Date: Rube Goldberg triviality when adding rows that have non-NULL rowguid columns
- Previous by thread: Re: No Option To Configure Distributor or Create Publications in SQL Server 2005
- Next by thread: Rube Goldberg triviality when adding rows that have non-NULL rowguid columns
- Index(es):
Relevant Pages
|
