help needed in replication..

Hi All,

I am new to Sql Server.I have to create snapshot replication between SQL 2000 and 2005.The Publisher should be sql 2000 and the subscriber is sql 2005.I need ur valuable inputs as how to start.

Hi,

I would start with the replication section of SQL BOL (http://msdn2.microsoft.com/en-us/library/ms151198.aspx) for general information on snapshot replication. To use multiple version of SQL in a replication topology, you can refer to this page (http://msdn2.microsoft.com/en-us/library/ms143241.aspx) for more information.

Thanks,

Peng

|||

Hi Peng,

Thanks for you reply..

I have a few more queries on snapshot replication

Steps followed:

1)created distributor and publisher at the SQL Server 2000 end.

3)Create a Publication Database at SQL Server 2000 end.

2)Created subscribtion for the Publication at the SQL Server 2005 end.

Will these steps do for a Snap-shot replication?

Do i need to configure a distributor at the SQL Server 2005 end also?

How do i check whether the replication is success?

If i try to synchronize from the SQL server 2000 side,Its asking for a username,password...and its not accepting what ever login,passwd i give..

The Error Message i get is :

A Connection could not be established to <server 2005>

Reason:Login failed for the user “<user name>”.The user is not associated with a trusted SQL Server connection.

…………….

pls help me with this.

thankx