SQL Azure数据库的CA证书路径是什么？ [英] What is the CA certificate path for a SQL Azure database?

问题描述

我有一个.NET Web应用程序连接到托管在云端的数据库在Microsoft的SQL Azure平台上。现在，我想使用 Domo （第三方基于云的商业智能服务）进行一些报告对Azure数据库中的数据。 Domo顾问告诉我，他需要数据库服务器的CA证书路径（除了其他标准连接信息），以便连接到它。他建议我需要获得证书并将其应用于数据库服务器。但是，根据我在文档中阅读的内容，SQL Azure 始终使用SSL;否则不可能连接到它。鉴于我已经在我的应用程序（使用Entity Framework 6）成功地连接到它，必须有一个证书已经存在（Microsoft的），因此一个证书路径。 我如何找出证书路径是什么？数据库服务器名称的格式为 xxxxxxxxxx.database.windows.net 。

I have a .NET web application which connects to a database hosted in the cloud on Microsoft's SQL Azure platform. Now I'd like to use Domo, a third-party cloud-based business intelligence service, to do some reporting on the data in the Azure database. The Domo consultant has told me that he needs a CA certificate path for the database server (in addition to other standard connection info) in order to connect to it. He has suggested that I need to get a cert and apply it to the database server. However, according to what I have read in the documentation, SQL Azure always uses SSL; it is not possible to connect to it otherwise. Given that I am already connecting to it successfully in my application (using Entity Framework 6), there must be a cert already there (Microsoft's), and therefore a certificate path. How do I find out what the certificate path is? The database server name has the form xxxxxxxxxx.database.windows.net.

推荐答案

我能够确认SQL Azure数据库总是使用SSL，因此已经安装了一个证书。我通过将数据库服务器名称（xxxxx.database.windows.net）插入DigiCert.com上的在线SSL证书验证工具（ https://www.digicert.com/help/ ）。路径列在底部。

I was able to confirm that SQL Azure DB always uses SSL and therefore does have a cert already installed. I found the certificate path by plugging the database server name (xxxxx.database.windows.net) into the online SSL certificate verification tool at DigiCert.com (https://www.digicert.com/help/). The path was listed at the bottom.

这篇关于SQL Azure数据库的CA证书路径是什么？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！