Localhost 446 0 server certificate does NOT include an ID which matches the server name

  • All forum topics
  • Previous Topic
  • Next Topic

Localhost 446 0 server certificate does NOT include an ID which matches the server name

  • Mark as New
  • Bookmark
  • Subscribe
  • Mute
  • Subscribe to RSS Feed
  • Permalink
  • Print
  • Email to a Friend
  • Report Inappropriate Content

‎10-04-2021 09:56 AM

From PowerBi Desktop, when connecting to a SQL Server using the servers FQDN and using either Windows Authentiation or Microsoft Account (with Microsoft Account being our perfered method), we get the error "Server Name provided does not match the server name on the SQL Server SSL Certificate".  We are not using any kind of SQL Server encryption and I have confirmed that this is not enabled in PBI Desktop.  Ultimitally we want to use the "Microsoft Account" authentication and Powerbi will not allow us to bypass this error when signed in with the Microsoft Account.

Why am I getting this error and what needs to be done to get rid of it.  

  • All forum topics
  • Previous Topic
  • Next Topic

3 REPLIES 3

Localhost 446 0 server certificate does NOT include an ID which matches the server name

Helpful resources

The Power BI Community Show

Watch the playback when Priya Sathy and Charles Webb discuss Datamarts! Kelly also shares Power BI Community updates.

Ted's Dev Camp - July 28, 2022

Watch Session 24 of Ted's Dev Camp along with past sessions!

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

merci pour ta réaction..

Donc la version 1.6.1.18 de prestashop est compatible avec php 7.2 et 7.1 en l'occurence?

pourtant j'ai tenter un install qui a échouer..
Peut-être qu'il me manque des parametre dans php.ini?

Une idée..

Edit: je viens de tester avec php en version 7.1 et l'install est passé. Mais la connexion au BO bloque.. sur la capture que j'ai poster plus haut..

voici mon error log de apache: 

[Mon Mar 26 12:30:02.711740 2018] [mpm_winnt:notice] [pid 13440:tid 580] AH00428: Parent: child process 22304 exited with status 255 -- Restarting. [Mon Mar 26 12:30:02.964540 2018] [ssl:warn] [pid 13440:tid 580] AH01909: localhost:446:0 server certificate does NOT include an ID which matches the server name [Mon Mar 26 12:30:02.977606 2018] [mpm_winnt:notice] [pid 13440:tid 580] AH00455: Apache/2.4.29 (Win64) OpenSSL/1.0.2n PHP/7.1.15 configured -- resuming normal operations [Mon Mar 26 12:30:02.977606 2018] [mpm_winnt:notice] [pid 13440:tid 580] AH00456: Apache Lounge VC14 Server built: Nov 5 2017 12:14:48 [Mon Mar 26 12:30:02.977606 2018] [core:notice] [pid 13440:tid 580] AH00094: Command line: 'C:\\Bitnami\\wampstack-7.1.15-0\\apache2\\bin\\httpd.exe -d C:/Bitnami/wampstack-7.1.15-0/apache2 -f C:\\Bitnami\\wampstack-7.1.15-0\\apache2\\conf\\httpd.conf' [Mon Mar 26 12:30:02.978607 2018] [mpm_winnt:notice] [pid 13440:tid 580] AH00418: Parent: Created child process 10340 [Mon Mar 26 12:30:03.279486 2018] [ssl:warn] [pid 10340:tid 512] AH01909: localhost:446:0 server certificate does NOT include an ID which matches the server name [Mon Mar 26 12:30:03.406312 2018] [ssl:warn] [pid 10340:tid 512] AH01909: localhost:446:0 server certificate does NOT include an ID which matches the server name [Mon Mar 26 12:30:03.419347 2018] [mpm_winnt:notice] [pid 10340:tid 512] AH00354: Child: Starting 64 worker threads. [Mon Mar 26 12:30:08.191887 2018] [mpm_winnt:notice] [pid 13440:tid 580] AH00428: Parent: child process 10340 exited with status 255 -- Restarting. [Mon Mar 26 12:30:08.458684 2018] [ssl:warn] [pid 13440:tid 580] AH01909: localhost:446:0 server certificate does NOT include an ID which matches the server name [Mon Mar 26 12:30:08.472751 2018] [mpm_winnt:notice] [pid 13440:tid 580] AH00455: Apache/2.4.29 (Win64) OpenSSL/1.0.2n PHP/7.1.15 configured -- resuming normal operations [Mon Mar 26 12:30:08.472751 2018] [mpm_winnt:notice] [pid 13440:tid 580] AH00456: Apache Lounge VC14 Server built: Nov 5 2017 12:14:48 [Mon Mar 26 12:30:08.472751 2018] [core:notice] [pid 13440:tid 580] AH00094: Command line: 'C:\\Bitnami\\wampstack-7.1.15-0\\apache2\\bin\\httpd.exe -d C:/Bitnami/wampstack-7.1.15-0/apache2 -f C:\\Bitnami\\wampstack-7.1.15-0\\apache2\\conf\\httpd.conf' [Mon Mar 26 12:30:08.473243 2018] [mpm_winnt:notice] [pid 13440:tid 580] AH00418: Parent: Created child process 26400 [Mon Mar 26 12:30:08.796129 2018] [ssl:warn] [pid 26400:tid 544] AH01909: localhost:446:0 server certificate does NOT include an ID which matches the server name [Mon Mar 26 12:30:08.938531 2018] [ssl:warn] [pid 26400:tid 544] AH01909: localhost:446:0 server certificate does NOT include an ID which matches the server name [Mon Mar 26 12:30:08.950570 2018] [mpm_winnt:notice] [pid 26400:tid 544] AH00354: Child: Starting 64 worker threads.

Edited March 26, 2018 by sinzen
EDIT (see edit history)

How do you fix server certificate does not include an ID which matches the server name?

How to Fix the “Server Certificate Does NOT Include an ID Which Matches the Server Name” Issue (In 3 Steps).
Step 1: Open the xampp/apache/conf/extra Directory. The first step is to open up the correct Apache directory in a file browser. ... .
Step 2: Edit the httpd-ssl. conf File. ... .
Step 3: Restart Apache..

Does not include an ID which matches the server name?

This happen due to server name on certificate does not matches with the server name defined in the webserver configuration. To resolve this you can change the server name to localhost in your webserver configuration.

What does it mean when it says hostname does not match server certificate?

If the certificate is issued for a hostname other than the one used or if the certificate cannot be authenticated (for example if it's self-signed and you don't trust the CA), then it will fail with the error "hostname does not match the server certificate".

Why Apache is not running in xampp?

The most common cause for the XAMPP Apache server not starting issue is because the default port no 80 may already be in use by another program like Skype, Teamviewer etc. For example, in my previous blog post with the solution for XAMPP and Windows User Account Control warning message issue, Mr.