The server principal is not able to access the database “master” under the current security context.
The server principal is not able to access the database “master” under the current security context.
SQL Server
Create DACPAC from SQL Server Database
DACPAC file is essential when migrating your on-premise SQL Server database to Azure. This is because Azure SQL database does not support regular SQL Server backups (.bak) files for restorations and requires a separate type of backup file called BAKPAC – Data-Tier Application Export (.bacpac file). Moreover, to create a BACPAC file, you must first create a DACPAC file to ensure that your database is ready for a BACPAC export. This article will show how to take a DACPAC extract of an on-premise SQL Server database.
Create DACPAC from SQL Server Database Read More »
Export SSIS project from SQL Server
In this article, I will describe how to export SSIS projects from SQL Server in bulk using SSIS Catalog Migration Wizard in just a few clicks.
Export SSIS project from SQL Server Read More »
Top 5 Azure Data Studio Extensions in 2024 [Updated]
Azure Data Studio is an open-source data management tool that enables working with SQL Server, Azure SQL DB, and Azure Synapse from Windows, macOS, and Linux. It is a one-stop shop to query, design, and manage your databases and data warehouses, on-premise or in the cloud. In this article, we will see 5 most interesting features of Azure Data Studio for SQL developers.
Top 5 Azure Data Studio Extensions in 2024 [Updated] Read More »
The Certificate Chain was Issued by an Authority that is not Trusted
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). The certificate chain was issued by an authority that is not trusted
The Certificate Chain was Issued by an Authority that is not Trusted Read More »
Create BACPAC File From SQL Database
BACPAC is a zip file containing SQL Server database metadata and data from the database. This is kind of a database backup that is mainly used to restore the on-premise database to Azure SQL.
This article describes how to export BACPAC of SQL server database for Azure SQL migration.
Create BACPAC File From SQL Database Read More »