Tag Archives: instance name

SQL Server 2014 Health check DMV queries Day 2

This gallery contains 1 photo.

Hi guys in the Previous post i explained How we can get the SQL Server instance version and How we can know the installed date for SQL Server instance put today is DAY 2 and i will show new DMV in … Continue reading

Gallery | Tagged , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , | Leave a comment

Cannot fetch data from db2 to sql in Linked servers

Msg 2, Level 20, State 0, Line 0 A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL … Continue reading

Gallery | Tagged , , , , | Leave a comment

Failure during upgrade SQL2008R2 to SP1 (Errorcode 0x84B20001)

This gallery contains 1 photo.

TITLE: SQL Server Setup failure. —————————— SQL Server Setup has encountered the following error: A failure was detected for a previous installation, patch, or repair for instance ‘instance name‘ during configuration for features [SQL_Replication_Core_Inst,SQL_Engine_Core_Inst, MPT_AGENT_CORE_CNI,SQL_FullText_Adv,]. In order to apply this … Continue reading

Gallery | Tagged , , , , , , , | Leave a comment

Don’t use the SQL Browser service.

The SQL Browser service is not required to use SQL Server. You may recall that it was the target of the attackers. Turning off this service eliminates possible attacks. How SQL Browser works SQL Server Browser listens for all incoming … Continue reading

Gallery | Tagged , , , , , | Leave a comment