SQL Server Performance Forum – Threads Archive

Replication Security issue please help

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

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/

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

You can do using SSMS or query window…
Check BOL topic "sp_grantlogin" MohammedU.
Moderator
SQL-Server-Performance.com

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

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

]]>