SQL Network Interfaces, error: 26

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…

Read Full
244 views 04:21 0 Comments

Find the SQL Server Cluster details

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…

Read Full
1431 views 19:47 0 Comments

Create login by CMD in SQL Server

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…

Read Full
669 views 19:20 4 Comments

Best Practices for SQL Database setting

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…

Read Full
189 views 18:52 0 Comments

Find IP and Port using SQL SSMS

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…

Read Full
505 views 20:39 2 Comments

Find user activity without any Auditing

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…

Read Full
695 views 20:31 0 Comments

Latest service pack to SQL Server

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…

Read Full
340 views 11:35 2 Comments