Category Archives: Sql Server

SQL Server Tutorials, SQL Server Tutorials for Beginners, SQL Server Online Course, Microsoft SQL Server Learning, Microsoft Online Learing

Cannot execute as the database principal because the principal dbo does not exist, this type of principal cannot be impersonated, or you do not have permission.

Cannot execute as the database principal because the principal dbo does not exist, this type of principal cannot be impersonated, or you do not have permission. Hi friends in this post we will discuss about an error during removing database replication, I got following error: Cannot execute as the database principal because the principal dbo does

Connecting to the Integration Services service on the computer failed with following error Access is denied

Connecting to the Integration Services service on the computer failed with following error Access is denied Hi friend in this post we will discuss about error when i try to connect SQL Server integration services from SQL Server management studio. I receive following error: Connecting to the Integration Services service on the computer failed with

TRANSFER MAINTENANCE PLANS FROM ONE SQL SERVER TO OTHER

TRANSFER MAINTENANCE PLANS FROM ONE SQL SERVER TO OTHER Hi friends, in this post we will discuss about how to TRANSFER MAINTENANCE PLANS FROM ONE SQL SERVER TO OTHER. Maintenance plans are nothing but SSIS packages which SQL Server creates itself under MSDB database. And best thing is that we can import/export them from one SQL

sqlcmd command not found on Ubuntu

sqlcmd command not found on Ubuntu Hi friends, in this post we will discuss about a error which comes when we installed MSSQL TOOLS on Ubuntu. Error is: sqlcmd command not found on Ubuntu. I installed MSSQL Tools as told by microsoft blog step by step, but sqlcmd is not working and gives error. I googled

Install MSSQL Tools on Ubuntu

Install MSSQL Tools on Ubuntu Hi friends, in this post we will learn how to Install MSSQL Tools on Ubuntu. BCP, SQLCMD and Microsoft ODBC drivers are installed by following below steps. Earlier we had discussed how to Install SQL Server on Ubuntu. sqlcmd: Command-line query utility. bcp: Bulk import-export utility. Steps to Install SQL Server Tools on Ubuntu:

Install SQL Server on Ubuntu

Install SQL Server on Ubuntu Hi friends, in this post we will learn how to Install SQL Server on Ubuntu. Recently SQL Server team releases SQL Server vNext CTP 1.1 for Linux. It’s the same SQL Server database engine that runs on windows with some of many features and services. Installation of SQL Server on Ubuntu is