I got Microsoft SQL Server error 15170 while removing a SQL Server login on one of SQL Server Instance. Microsoft SQL Server Error 15170 suggests that the login which i want to drop owns one or more SQL Server Agent jobs. Here...
The SQL Server Agent runs scheduled SQL Server jobs and very useful to automate database tasks. Here i will show you how to install SQL Server Agent on RedHat Linux server. We will use offline method to install SQL tools...
I have described step by step process to install RedHat Enterprise Linux 7.3 and Offline installation of SQL Server 2017 on RHEL server in my last articles. Here I will explain step by step process to install SQL Server tools...
We all know Microsoft has announced to launch SQL Server product for Linux platform. SQL Server used to run only on Windows platform till SQL Server 2016 version. Now starting from SQL Server 2017, we can run & deploy our...
Red Hat Enterprise Linux (RHEL) is an Open Source Linux operating system developed by Red Hat. RHEL is most popular operating system in today’s world for major deployments. Here i will explain step by step process to install Red Hat...
Are you struggling to setup a server lab for your requirement? We can create multiple systems running with different flavour of operating systems in our computer or laptop. You don’t need to buy additional systems for these configurations. Here we...
Generally, Microsoft SQL Server error 15434 appears during removing a SQL Server login. This error generates when you try to drop a login that has an active open connection to SQL Server Instance. Here i will discuss all the aspects...
I got Microsoft SQL Server error 15141 while removing a SQL Server domain login on one of instance where AlwaysOn is configured. SQL Server Error 15141 suggests that the login which i want to drop owns AlwaysON endpoints. Here we...
SQL Server Always On is just a term given by Microsoft for Availability Group & Failover Cluster Instances that are used to achieve HA, DR & Scale out solution. Always On Failover Cluster Instance is same which we call SQL...
Here we will learn how to fix Microsoft SQL Server error 15138 & error 3729 that we receive while dropping a database user and a schema in SQL Server. Let us check the details to fix this issue one after...
A login was failed to drop from a SQL Server instance with an error code 15173. As Microsoft SQL Server error 15173 suggests that this login has granted some permissions to other logins. Let us check the details and then...
I came across Microsoft SQL Server error 15174 while dropping a login. As error suggests, the login which i want to drop is set as owner for databases. Let us check the database owner and then change the ownership to...
Sometimes AOAG configuration stuck in resolving state and its secondary Replica does not come online. When you check the Alwayson Availability Group configuration, you find it showing in resolving state after Automatic failover of AOAG Configuration. Let us get the...
Have you ever thought how SQL Server controls the size of packets which are send over the network. There is a server configuration option network packet size in SQL Server. The value of this configuration are used to control the...
Today, I got a requirement to limit the number of concurrent user connections on a SQL Server Instance. SQL Server provides an option user connections in server level configurations to set or limit the maximum number of simultaneous user connections...
