SQL Server Performance Forum – Threads Archive

replication which is better

To my knowledge replication can me implemented (using sql server 2005 standard edition)
1.using sql server management studio
2.using RMO programming
3.using transact sql procedures. Correct me if i am wrong.
i am new to this topic. which would be the best way to implement replication. I am working with merge replication using sql server management studio.
Which doesnt seem to work. Would anyone provide a link or guide me in creating a merger replication on same server but different database.
Please help me with it.

if you are new , use sql server management studio. those wizard will guide you towards your task.
http://www.microsoft.com/technet/prodtechnol/sql/2005/technologies/replictn.mspx
http://databases.about.com/cs/sqlserver/a/aa041303a.htm —————————————-
Contributing Editor, Writer & Forums Moderator
http://www.SQL-Server-Performance.Com Visit my Blog at
http://dineshasanka.spaces.live.com/

As mentioned SSMS is the best choice… Check the BOL topic "Setting Up Replication (SQL Server Management Studio) "
http://msdn2.microsoft.com/en-us/library/ms151866.aspx And also you can use sql 2000 merge replication setup guide…there are few changes…
http://www.mssqlcity.com/Articles/Replic/SetupMR/SetupMR.htm When you are setting up what is the error you are getting? MohammedU.
Moderator
SQL-Server-Performance.com

I have created my replication on local system server and my merge replication will transfer form one database to other with in the same server.
Here is the message with i get when i run my merge replication The job failed. Unable to determine if the owner (xyzsadi) of job 1234567-testdb_merge-Pubs_merge-1234567-2 has server access (reason: Could not obtain information about Windows NT group/user ‘xyzsadi’, error code 0x5. [SQLSTATE 42000] (Error 15404) The statement has been terminated. [SQLSTATE 01000] (Error 3621)). What should i do????I have tried alot but didnt get it to work at all

Based on the error it looks like it is security issue…
Check ‘xyzsadi’ login access to SQL and OS…
MohammedU.
Moderator
SQL-Server-Performance.com

]]>