SQL Server Performance

Replication Security issue please help

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

  1. sureshv New Member

    i am working on merge replication.I am using sql server 2005 standard edition.Will things workout for me if i use this standard edition(just to know).

    2. i have been working on merge replication on the same server but different databases.the way i do it is as follows

    a.I create a database.

    b.Create a publication(is has successfully been created)

    c.Create a subscription(successfully created it)

    d.Now when i look at the replication monitor when i click on my merge replication

    under all subscription tab

    status shows:uninitialized subscription and

    Connection :it shows unknown

    when i double click that it takes me to synchrinization history which has nothing going on with in it.

    after adding some articles.when i run the snapshot agent from

    Local publications->my publication->view snap shot agent status->click start

    it tries to start but then comes with a message saying "The agent has never been run."

    and under local subscritpions->my subscription->view synchronization->

    when i click start it says "No agent status information is available".

    when i look at view history tab

    The job failed. Unable to determine if the owner (xyzmyname) of job 1234511-testdb_merge-merge-27G6Y91-merge_sub- 0 has server access (reason: Could not obtain information about Windows NT group/user 'xyzmyname', error code 0x5. [SQLSTATE 42000] (Error 15404) The statement has been terminated. [SQLSTATE 01000] (Error 3621)).

    What would be the casue if security permission.How should i set them.

    please let me know.





    Please
  2. dineshasanka Moderator

    http://support.microsoft.com/kb/834124 will give you the reasons for the same inssue in SQL Server 200 standard. same reasons may apply for SQL Server 2005 as well.

    To resolve this problem, use either of the following two methods.

    • Use the same Windows domain user account to run the SQL Server services and the SQL Server Agent services.
    • Create a Windows domain user account on the Publisher and on the Subscriber that have identical user names and passwords.



    ----------------------------------------
    Contributing Editor, Writer & Forums Moderator
    http://www.SQL-Server-Performance.Com

    Visit my Blog at
    http://dineshasanka.spaces.live.com/
  3. sureshv New Member

    how do i create Windows domain user account on the Publisher and on the Subscriber that have identical user names and passwords.

  4. MohammedU New Member

    You can do using SSMS or query window...
    Check BOL topic "sp_grantlogin"

    MohammedU.
    Moderator
    SQL-Server-Performance.com
  5. sureshv New Member

    i couldn't get you.would you please expalin or provide links on how to create Windows domain user account on the Publisher and on the Subscriber that have identical user names and passwords.

    Ur help is appreciated!!!
    thanks
  6. MohammedU New Member

    You ask your system engineer to create a login in the domain and you can grant the sql access to the same login in sql using the method mentioned above...

    If you are the the dba and system engineer... then...check the following...or you can use the widows help from your desktop or server...

    http://www.windowsnetworking.com/kb...dowsNTdomainuseraccountsfromcommand-line.html


    MohammedU.
    Moderator
    SQL-Server-Performance.com

Share This Page