- 2 minutes to read

SQL Server Troubleshooting

Troubleshooting guides for SQL Server in Nodinite environments.

Authentication and Connectivity

SPN – Service Principal Names — Hub: how SQL Server and IIS SPNs differ, when SPNs are required, and the shared setspn commands
SQL Server SPNs (MSSQLSvc) — Register SPNs for default and named instances, failover clusters, Always On listeners, and linked servers; validate 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 Sysadmin Requirements — Understand when sysadmin is required, what breaks without it, and how to align with DBA security policies
SQL Server Options — Recommended SQL Server settings, compatibility levels, and edition guidance including SQL Server 2025 Express (50 GB per Log Database)
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