How to Access Dynamics CRM 2013 Database in SQL Server 2008 R2

All replies

• 

  

  0

  Sign in to vote

  HI

  If you have a setup of SQL CLient or SQL server on your development machine. You can do that using SQL Server Management Studio. Open it and you will be prompted to connect to Database Engine with windows credentials.

  Then you can find required db on Explorer left side.

  If your question is about how to access tables in code or sql queries. I would suggest to use FilteredViews for this purpose as those handle security privilges automatically

  Hope that helps

  • Proposed as answer by Payman BiukaghazadehEditor Wednesday, February 19, 2014 6:55 PM

  Wednesday, February 19, 2014 12:06 PM
• 

  

  0

  Sign in to vote

  To add a bit more on security: By default, CRM users will be granted SELECT permission on the FilteredViews (by membership of the ReportingGroup AD group) and no other permissions.

  ---

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

  Wednesday, February 19, 2014 9:21 PM

  Moderator
• 

  

  0

  Sign in to vote

  Thanks CRMDevlpr

  How I can find where is the database of Dynamics CRM. Because when I Open SQL server I can't see the any database related to MS Dynamics CRM.

  Thanks

  Thursday, February 20, 2014 4:54 AM
• 

  

  1

  Sign in to vote

  Microsoft Dynamics CRM creates at least two databases:

  • MSCRM_CONFIG. This database contains Microsoft Dynamics CRM metadata, such as configuration and location information that is specific to each organization database.
  • OrganizationName_MSCRM. This is the organization database where Microsoft Dynamics CRM data is stored, such as all records and activities. Microsoft Dynamics CRM Server 2013 supports multiple organizations so that you can have multiple-organization databases.

  Hope this helps.

  ProgCRMKen

  Thursday, February 20, 2014 5:40 AM
• 

  

  0

  Sign in to vote

  Thanks ProgCRMKen.

  My Server Name is ABC, if I am opening this I don't found any DB. How I in which instance of SQL Server CRM db exists?

  Thanks

  Thursday, February 20, 2014 7:09 AM
• 

  

  0

  Sign in to vote

  You should open the Dynamics CRM Deployment Manager. This would be available on the server where CRM is installed.

  You need to be a deployment administrator to be able to access this console.

  In this app you can see all of your CRM organizations. Selecting an organization will display the SQL Server where its database is attached.

  On that server look for <orgname>_MSCRM database for the data related to your organization.

  HTH

  Sam

  ---

  Dynamics CRM MVP | Inogic | http://inogic.blogspot.com| news at inogic dot com

  If this post answers your question, please click "Mark As Answer" on the post and "Mark as Helpful"

  • Proposed as answer by Sam - Inogic Thursday, February 20, 2014 7:52 AM
  • Marked as answer by Aladin92 Tuesday, March 4, 2014 6:08 AM
  • Unmarked as answer by Aladin92 Tuesday, March 4, 2014 7:31 AM
  • Marked as answer by Aladin92 Tuesday, March 4, 2014 7:31 AM

  Thursday, February 20, 2014 7:52 AM