[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 811
  • Last Modified:

Configure Publish, Subscribers and Distribution command missing

I am trying to configure my SQL Server 2005 Standard Edition for publishing but when I right click on the Repication folder the "Configure Publish, Subscribers and Distribution" command is missing. Any clue as to why?
0
robertcarrier
Asked:
robertcarrier
  • 11
  • 9
1 Solution
 
imran_fastCommented:
It is not missing it is there but changed to Configure distribution only( the first one on the top)

Click on Configure Distribution and configure your distribution server

after then click on local publication to configure you publisher and publication
similarly click on local subscribtion to configure your subscriber and subscribtion database
0
 
robertcarrierAuthor Commented:
I don't have that command either. I have the following commands:
Update Replication Passwords...
New->Subscriptions...
Refresh

Any other ideas?
0
 
imran_fastCommented:
In sql server 2005 Management Studio after you connect to your database Engine log in as an administrator
you have the Replication folder below Server Objects on that right click what do you see
0
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
robertcarrierAuthor Commented:
Okay...
When I right click on the replication folder I see the following commands:

Update Replication Passwords...
New->Subscriptions...
Refresh

I do not have the Configure Distribution Menu Item.
0
 
imran_fastCommented:
Search for this in Index of books online of sql server 2005

replication [SQL Server], configuring
0
 
robertcarrierAuthor Commented:
I know how to configure replication, I don't have the required command for the first step.
0
 
imran_fastCommented:
Robert,
Let do it step by step.

What user you have used to connect ot management studio?
0
 
robertcarrierAuthor Commented:
Administrator
0
 
imran_fastCommented:
Give me 15 min.
0
 
imran_fastCommented:
Ok what about the local publication folder inside replication when you right click that what you see there.
0
 
robertcarrierAuthor Commented:
The only folder there is local subscriptions.
0
 
imran_fastCommented:
can you run this query and post the result here
select @@version
0
 
imran_fastCommented:
Please check one more time that you do have Standard Edition of Sql server 2005 not SQL Express Edition of 2005.
In general SQL 2005 Standard SKU should be able to do publication
0
 
robertcarrierAuthor Commented:
Microsoft SQL Server 2005 - 9.00.2047.00 (Intel X86)   Apr 14 2006 01:12:25   Copyright (c) 1988-2005 Microsoft Corporation  Standard Edition on Windows NT 5.2 (Build 3790: Service Pack 1)
0
 
imran_fastCommented:
Man there is service pack 2 for sql server 2005 please apply that one.
0
 
robertcarrierAuthor Commented:
Service pack level should have no effect, I have seen no sp on this this version that had the command.
0
 
robertcarrierAuthor Commented:
SQL Server 2005 SP1 was released on 4/18/2006. There is no Service Pack 2.
 
0
 
robertcarrierAuthor Commented:
Found the solution to my own problem. I was using managment studio express instead of managment studio.
Sorry, Thanks for your time.
0
 
imran_fastCommented:
yeah i mean sp1 and good luck man.
0
 
imran_fastCommented:
No objection from My side.
0
 
DarthModCommented:
PAQed with points refunded (500)

DarthMod
Community Support Moderator
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 11
  • 9
Tackle projects and never again get stuck behind a technical roadblock.
Join Now