Separate Database Login for DBA team RRS feed

  • Question

  • 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.


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

All replies

  • 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
  • Thanks David...

    I hope this will work..

    Saturday, June 30, 2012 4:04 AM