Sign in
Microsoft.com
 
Microsoft
 
 
 

locked
Separate Database Login for DBA team RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    We have implemented Dynamic CRM 2011 on premise . There is only one server for CRM and SQL database. Whenever I have to go on Server i have to use my Admin password to login . My DBA team also works on sql and they use admin passwrod which I dont want because they can also access the CRM application through the same Password.

    Please suggest how can I create a separate SQL login instance for our DBA team so they can only work on SQL not on CRM.

    Thanks



    • Edited by DynCRM Thursday, June 28, 2012 9:07 AM
    Thursday, June 28, 2012 6:05 AM

All replies

  • Question
    Sign in to vote
    0
    Sign in to vote

    You can create SQL logins independently from CRM. You can either create an explicit SQL login (where the login and password are maintained in SQL), or create a SQL login that is associated with an Active Directory account. The SQL login will then need to be granted rights within SQL - these can be Server Roles, or Database-specific (via Database Mappings). If you need more information, it may be best to post in the SQL Server forums 

    Microsoft CRM MVP - http://mscrmuk.blogspot.com  http://www.excitation.co.uk


    Thursday, June 28, 2012 10:41 AM
    Moderator
  • Question
    Sign in to vote
    0
    Sign in to vote

    Thanks David...

    I hope this will work..

    Saturday, June 30, 2012 4:04 AM