web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Customer experience | Sales, Customer Insights,...
Suggested Answer

How to connect / access on-premise Dynamics 365 CRM database

(0) ShareShare
ReportReport
Posted on by 20

Hello,

I want to access the database of our on-premise Dynamics 365 CRM and I don't exactly know how to do this. What kind of tool I need to download to access it and change some values.

I want to change a specific value which allows me to use the POP/SMTP Email configuration without using SSL. The option itself is greyed out, it forces me to use SSL.

"In Microsoft Dynamics CRM (on-premises), this field is set to Yes by default, but the configuration database setting “AllowNonSSLEmail” allows you to override this and set the value to False."

https://docs.microsoft.com/en-us/previous-versions/dynamicscrm-2015/deployment-administrators-guide/dn832133(v=crm.7)?redirectedfrom=MSDN

This site above doesn't describe in detail, where in the database exactly and how to connect or which tool to use.

Many thanks!

I have the same question (0)
  • Suggested answer
    Saad Kabarousse Profile Picture
    734 on at

    You can connect using Sql Server Management Studio, all you need is provide the @IP Adresse of your server and User credantials to access your Database.

  • David Choi Profile Picture
    20 on at

    Thank you for your response,

    I tried it but I think I'm still doing something wrong. Which server type, authication type?

    By user credentials, I think you mean the same one, which I use to login into the CRM itself, correct?

  • Suggested answer
    Saad Kabarousse Profile Picture
    734 on at

    pastedimage1571301286040v3.png

    For Login and password they should be for a user that has access to sql server instance in general the Administrator Credentials of the Server where the sql database is installed will pass with no problems.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > Customer experience | Sales, Customer Insights, CRM

#1
Tom_Gioielli Profile Picture

Tom_Gioielli 170 Super User 2025 Season 2

#2
#ManoVerse Profile Picture

#ManoVerse 70

#3
Jimmy Passeti Profile Picture

Jimmy Passeti 50 Most Valuable Professional

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans