- 2 minutes to read

SQL Server Troubleshooting

Troubleshooting guides for SQL Server in Nodinite environments.

Authentication and Connectivity

SPN – Service Principal Names — Register Kerberos SPNs for SQL Server default instances, named instances, failover clusters, Always On listeners, and IIS application pools; includes automated detection with Microsoft Kerberos Configuration Manager
Connection Strings — Supported SQL Server connection string formats, Windows vs SQL authentication, and named instance syntax
Firewall — Required firewall rules and ports for SQL Server connectivity from Nodinite services

Always On Availability Groups (AOAG) — Configure and troubleshoot SQL Server Always On for Nodinite databases; covers listener setup and SPN requirements per replica node

Linked Servers — Configure linked servers between the Nodinite Configuration Database and remote Log Databases
Linked Server RPC and RPC Out — Enable RPC and RPC Out options required for linked server stored procedure execution

SQL Server Options — Recommended SQL Server settings, compatibility levels, and collation requirements for Nodinite databases
Agent Database — Troubleshoot the Nodinite Agent database; covers connection issues and schema validation
Automating removal of old Log Databases — Schedule automatic cleanup of historical Log Databases to manage disk growth
Manually removing old configuration data — Remove stale configuration entries left after service decommissioning
Manually update databases — Apply database schema updates manually when the automated installer cannot
Remove duplicate Endpoints — Clean up duplicate endpoint registrations that cause monitoring inconsistencies
Database Recovery Pending — Recover a SQL Server database stuck in the "Recovery Pending" state

Database Migration — Guides for moving Nodinite databases to new SQL Server instances or hosts