Common checklist in case if you need to install SQl Server in high security mode.

Common checklist in case we need to install SQL Server in high  safety & security mode. 

The certificate chain was issued by an authority that is not trusted SSMS connection

sometime while connecting to the database server using SSMS you get below error.

Issue:-

TITLE: Connect to Server
------------------------------

Cannot connect to 4X.6X.1X8.2X1,1433.

------------------------------
ADDITIONAL INFORMATION:

A connection was successfully established with the server, but then an error occurred during the login process. (provider: SSL Provider, error: 0 - The certificate chain was issued by an authority that is not trusted.) (Microsoft SQL Server, Error: -2146893019)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft%20SQL%20Server&EvtSrc=MSSQLServer&EvtID=-2146893019&LinkId=20476

------------------------------

The certificate chain was issued by an authority that is not trusted

------------------------------
BUTTONS:

OK
------------------------------


Problem:- 


Resolution:- In order to resolve this issue.

Method 1:-

If You are trying to access it through Data Connections in Visual Studio 2015, and getting the above Error, Then Go to Advanced and set  TrustServerCertificate=True for error to go away.



Method 2:- 
If You are trying to access it through SSMS, and getting the above Error, Then Go to Advanced and set  TrustServerCertificate=True for error to go away.

Method 3:- 

If you're using SQL Management Studio, please goto connection properties and click on "Trust server certificated"

SQL Server Managed Backup to Microsoft Azure cannot configure the default backup settings for the SQLServer instance because the container URL was invalid. It is also possible that your SAS credential is invalid.

Issue:-

Msg 45207, Level 17, State 6, Procedure managed_backup.sp_add_task_command, Line 102 [Batch Start Line 23]
SQL Server Managed Backup to Microsoft Azure cannot configure the default backup settings for the SQLServer instance because the container URL was invalid. It is also possible that your SAS credential is invalid.

How to Migrate SQL 2008 database to Azure SQL database using Azure Database Migration

In order to successfully migrate a SQL 2008 database to Azure SQL database using Azure Database Migration Service refer below blogs

---------------------------------------------------------------------------------------

https://azure.microsoft.com/en-us/services/database-migration/

https://azure.microsoft.com/en-us/services/sql-database/

https://azure.microsoft.com/en-us/services/database-migration/

https://docs.microsoft.com/en-us/azure/dms/dms-overview

https://docs.microsoft.com/en-us/azure/dms/faq

https://docs.microsoft.com/en-us/azure/dms/pre-reqs

https://docs.microsoft.com/en-us/azure/dms/pre-reqs

The Best Place To Get Azure Cloud Facts in one place

This page has around many Awesome facts about Azure Cloud

-----------------------------------------------------------------------------------------