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?
robertcarrierAsked:
Who is Participating?
 
DarthModCommented:
PAQed with points refunded (500)

DarthMod
Community Support Moderator
0
 
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
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
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
 
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.