SQL Server Performance

replication which is better

Discussion in 'SQL Server 2005 Replication' started by sureshv, Mar 6, 2007.

  1. sureshv New Member

    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.
  2. dineshasanka Moderator

  3. MohammedU New Member

  4. sureshv New Member

    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
  5. MohammedU New Member

    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

Share This Page