Archive for 2019

SQL Network Interfaces, error: 26 – Error Locating Server/Instance Specified Users often see “SQL Network Interfaces, error: 26 – Error Locating Server/Instance Specified” error message while connecting to SQL Server. Steps to…

Scenario A cluster includes two or more physical servers, called nodes; identical configuration is recommended. One is identified as the active node, on which a SQL Server instance is running the production workload, and…

Scenario You have got the SQL database engine installed but no SSMS installed on it. In this scenario how you will connect to the target database engine and create a…

1. Database Owner: ‘sa’ As per my understanding, the Database Owner always should be ‘sa’. We can change ‘sa’ login name as per our organization standard login available in SQL…

Introduction In SQL Server, managing user access and permissions is crucial for maintaining the security and integrity of a database. Often, there is a need to retrieve a list of…

Introduction How to run a SQL query using command prompt without SQL SSMS Open CMD from Run and run the below command (CMD) to connect with Database engine. sqlcmd -S…

Find IP and Port using SQL SSMS Find IP and Port of a SQL Server from a client machine. The script will not provide all the information if you are…

How to find out user activity on database without any particular Auditing Sometime you may need to find out who ran some script or who is accessing the database or…

Apply latest service pack to standalone SQL Server We have given a Microsoft SQL Server 2016 (RTM) – 13.0.1601.5 (X64) Enterprise Edition (64-bit) on Windows Server 2012 R2 Standard 6.3…

Scenario Sometimes you need to gather the SQL instance details in a proper format such as Server Name, Instance, Service account name. Today I am sharing a script that will…