My Secondary server in SQL login missing smsdbrole_mp.How can i add?? I am getting below error when i m doing it- already exists in the current database. (Microsoft SQL Server, Error: 15023)SiddheshM MCTS

I hope you need to add secondary server computer account to SMS_SiteToSiteConnection_<primary server site code> to get the access. Anoop C Nair - Twitter @anoopmannur MY BLOG: http://anoopmannur.wordpress.com SCCM Professionals This posting is provided AS-IS with no warranties/guarantees and confers no rights.

Anoop ... yes it is there..SiddheshM MCTS

Can you check this ? http://technet.microsoft.com/en-us/library/bb633288.aspxSCCM This posting is provided "AS IS" with no warranties or guarantees, and confers no rights. |Please remember to click Mark as Answer on the post that helps you, and to click Unmark as Answer if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread.

it is giving same error..SiddheshM MCTS

Dear Siddesh, Please Make sure secondary server computer account is added to SMS_SiteToSiteConnection_primarysitecode local group on primary server. You can refer this link. You can also follow this Blog article by Kaido for creating a Secondary SQL Login Account. Hope this will be helpful.... Zulqarnain Ali | MCTS, MCSA | Please remember to click Mark as Answer on the post that helps you, and to click Unmark as Answer if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread.

Please see: About the Management Point Database Connection Account http://technet.microsoft.com/en-us/library/bb632370.aspx If you configure this account, you must manually add it to the smsdbrole_MP role in the Configuration Manager site database so that the management point obtains the required rights and permissions. If you do not configure this account, the management point's computer$ account is assumed to be in a trusted forest and Configuration Manager 2007 attempts to add it automatically to the smsdbrole_MP. Therefore you should not add the account into the role since it is trusted by default. Do you encounter any problem when the management point try to access the site database?Please remember to click Mark as Answer on the post that helps you, and to click Unmark as Answer if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread.