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

Announcements

No record found.

News and Announcements icon
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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the March Top 10 Community Leaders

These are the community rock stars!

Leaderboard > Customer experience | Sales, Customer Insights, CRM

#1
ManoVerse Profile Picture

ManoVerse 192 Super User 2026 Season 1

#2
11manish Profile Picture

11manish 129

#3
CU11031447-0 Profile Picture

CU11031447-0 100

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans