cant use replication

ive installed sql 2005 enterprise and wanted to make a replication between 2 servers but when i rightclick the replication folder in the server management studio express - i can only create a subscriber. ive also tried going through tools but theres nothing in that menu.

ive wondered, is it maybe possible the i cant create a publisher because of the management studio express - do i also need a enterprise edition of the management studio?

ive also checked in add and remove programs - went to mssql 2005 and checked in change components and in there it ses that the replication components are installed =/

wud b gr8 if u cud help me, need this for an egsam i got on the 18th
thank you very very much in beforehand =P

sql server 2005 express edition only supports as subscriber...

May either you have connected to express edition sql server or ssms express may not support...

You may need to install regular client components from EE/SE/DE edtions cd...

Check the following link for SQL Server 2005 Features Comparison...

http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx

|||ive got the enterprise odition of mssql its just the management studio that is express.
in this case i need a different version of management studio?
where can i get it from? i havent got a cd - i downloaded it from the microsoft homepage

can someone PLEASE help me out here? even if its a "i doubt that it will work" =/
|||

Hi eniGMa,

You have to configure the Distributor firstly and then the Publisher.

Go to the Instance that you want to set Replication up. Right click on the Replication folder and click "Configure Distribution...".

After configuring the Distribution, configure the Publisher. Go to the Replication folder and click the + sign near it and expand the folder. Right click on the Local Publications folder and then click "New Publication" after setting it up you may configure the necessary Publications to Subscribers.

For more information visit the MSDN:

http://msdn2.microsoft.com/en-us/library/ms151198.aspx

Ekrem ?nsoy

MCP, MCDST, MCDBA, MCAD.Net, MCSD.Net, MCSA, MCSE

|||hi, ive checked the msdn page - the only thing i can create is a subscriber, nothing else
and when i click that, it tells me that it needs a publisher
|||

Hi eniGMa,

Replication system consists of Publisher, Distributor and Subscriber.

Publisher is the one what hosts the publications.

Distributor is the one which publishes the publications (from Publisher) to Subscribers.

Subscriber is the one what pulls (or pushed by the Publisher) data from Distributor.

Distributor and Publisher may be host on the same server if there is not huge workload on that SQL Server.

So according to this frame, you need to set Publisher and Distributor first.

You may configure these by help of the MSDN page which i posted before.

And then read my prior first answer again.

Ekrem ?nsoy
MCP, MCDST, MCDBA, MCAD.Net, MCSD.Net, MCSA, MCSE

|||thats egsactly my point - the only thing i can create is a subscriber
nothing else (ive read through the rest of the theory)

ive got the enterprise edition of mssql server installed, only thing where it sais express is the management studio (which i cant install from the sql server installation file, so i downloaded it from download.microsoft.com)

when i rightclick the replication folder - subscriber (no publisher and no distributor)
and when i click on tools (same thing)
|||

I see that you misconfigured setup of SQL Server.

Because you can install SSMS (SQL Server Management Studio) from the Components to Install menu which appears when you were setting up SQL Server.

When you see Components to Install dialog box, click Advanced and dig into the items to be installed.

After opening Advanced dialog box, you will see: "Workstation Components, Books Online, and Development Tools" There is SSMS in it. Expand the item and you'll see it.

My concern about your Replication problem is, you may be deselecting or forgetting selecting something when you were setting up the SQL Server. Replication choice is in the "SQL Server Database Services" item in the same Advanced dialog box.

Please check these items carefully while setting up SQL Server.

Try to set SQL Server up again by taking care of these things.

Ekrem ?nsoy

MCP, MCDST, MCDBA, MCAD.Net, MCSD.Net, MCSA, MCSE|||that worked - maybe it didnt work on the 1st time because ssms express was installed, when i installed it the 1st time and then i couldnt install it as an additional installation, even if removed afterwards

thnx a LOT!