Скачать или смотреть ServiceNow Database Discovery Part 9: Complete SQL Server Setup & Authentication Troubleshooting!!

ServiceNow Database Discovery - SQL Server Complete Implementation & Real Troubleshooting

In this comprehensive 30-minute tutorial, I walk you through the complete end-to-end process of configuring ServiceNow Database Discovery for SQL Server, including solving the most common authentication issues that stop discovery dead in its tracks.

What You'll Learn:

Complete SQL Server Express setup for ServiceNow Discovery
How to diagnose and fix Mixed Mode authentication problems
Real troubleshooting of missing database discovery patterns
Live discovery execution and ECC Queue analysis
CMDB results and relationship mapping walkthrough
Key SQL Commands Covered:

Authentication Mode Check:

sql

SELECT CASE SERVERPROPERTY('IsIntegratedSecurityOnly')

WHEN 1 THEN 'Windows Authentication Only (PROBLEM!)'

WHEN 0 THEN 'Mixed Mode Authentication (GOOD)'

END AS [Authentication Mode];

Enable Mixed Mode Authentication:

sql

EXEC xp_instance_regwrite N'HKEY_LOCAL_MACHINE',

N'Software\Microsoft\MSSQLServer\MSSQLServer',

N'LoginMode', REG_DWORD, 2;

Create Discovery User:

sql

CREATE LOGIN [sn_discovery] WITH

PASSWORD = 'YourSecurePassword123!',

CHECK_POLICY = OFF,

CHECK_EXPIRATION = OFF;



GRANT VIEW SERVER STATE TO [sn_discovery];

GRANT VIEW ANY DEFINITION TO [sn_discovery];



USE [master];

CREATE USER [sn_discovery] FOR LOGIN [sn_discovery];

ALTER ROLE [db_datareader] ADD MEMBER [sn_discovery];

Verify User Permissions:

sql

SELECT name FROM sys.server_principals WHERE name = 'sn_discovery';

SELECT name FROM sys.database_principals WHERE name = 'sn_discovery';

Service Management Commands:

cmd

net stop "MSSQL$SQLEXPRESS"

net start "MSSQL$SQLEXPRESS"

sc query "MSSQL$SQLEXPRESS"

Common Issues Solved:

Authentication Mode: Windows-only vs Mixed Mode configuration
Missing Pattern Applications: Discovery and Service Mapping Patterns v1.7.0+
Windows 2022 Server compatibility requirements
Credential testing and validation in ServiceNow
Prerequisites:

ServiceNow instance with Discovery license
MID Server configured and operational
SQL Server Express or Standard Edition
Windows Server (demonstrated on Windows 2022)
Pattern Applications Required:

Discovery and Service Mapping Patterns (v1.7.0+)
Visibility Content (v6.12.1+)

Official ServiceNow Documentation: Database Discovery Guide: https://www.servicenow.com/docs/bundl...

Community Discussion: Share your database discovery challenges in the comments! Include:

Your ServiceNow version
Database platform and version
Specific error messages
Pattern application versions
Coming Next in the Series:

MySQL Discovery on Linux (Part 10)
Oracle Database Discovery with RAC Clusters
Cloud Database Discovery (AWS RDS, Azure SQL)
Connect & Subscribe: Hit the notification bell for more ServiceNow ITOM tutorials focused on real-world implementation challenges and solutions.

#ServiceNow #DatabaseDiscovery #SQLServer #ITOM #ServiceMapping #CMDB #ITOperations #TechnicalTutorial