Users often see “SQL Network Interfaces, error: 26 – Error Locating Server/Instance Specified” error message while connecting to SQL Server.
Go to All Programs >> Microsoft SQL Server 2017 >> SQL Server Configuration Manager >> SQL Server Services, and check if SQL Server service status is “Running”.
If SQL Server is ‘Stopped’ then Right-click on the SQL Server & click Start.
Hope your issue will solve. If you are still getting the same error, then check ‘TCP/IP in SQL Server Configuration’
Go to All Programs >> Microsoft SQL Server 2017 >> SQL Server Configuration Manager >>SQL Server Network Configuration >> Protocols for xxxx [Here xxxx will be your SQL Server name]
If TCP/IP is ‘Disabled‘ then Right-click on the TCP/IP & click Enable
Hope your issue will solve. If you are still getting the same error, then Enable Remote Connection
Right-click on the SQL Server node and select Properties.
Go to ‘Connections’ & “Allow remote connections to this server” if it is not allowed previously.
Hope your issue will solve.
DMV ‘sys.dm_exec_requests’ provides details on all of the processes running in SQL Server.
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 |
SELECT qs.Session_ID, Blocking_Session_ID, qs.Status, Wait_Type, Wait_Time, Wait_Resource, SUBSTRING(st.text, (qs.statement_start_offset/2)+1, ((CASE qs.statement_end_offset WHEN -1 THEN DATALENGTH(st.text) ELSE qs.statement_end_offset END - qs.statement_start_offset)/2) + 1) AS statement_text, GetDate() SnapshotDateTime, --Open_Transaction_Count, ss.PROGRAM_NAME, ss.HOST_NAME, ss.Login_Name FROM sys.dm_exec_requests AS qs INNER JOIN sys.dm_exec_sessions ss ON qs.session_id = ss.session_id CROSS APPLY sys.dm_exec_sql_text(qs.sql_handle) AS st WHERE Wait_Time > 0 ORDER BY Wait_Time DESC |
“Please let us know if there…