Tag: Troubleshooting
-
Open SSMS as a Different Domain User
🛠️Part of the SSMS Complete Guide, installing, configuring and fixing SQL Server Management Studio.Related pillar: Security ⚡Shift + right-click SSMS → Run as different user, or runas /netonly /user:DOMAIN\user “path\to\Ssms.exe”. Use /netonly when the account is in another domain or is not allowed to log on to this machine. When working in corporate SQL Server…
Written by
-
Check When SQL Server Was Last Restarted
Knowing when SQL Server last restarted is one of the simplest checks a DBA can perform, and one of the most useful. It immediately answers questions around patching, failovers, configuration changes, and unexplained behaviour. Before assuming anything else, confirming uptime is always worth doing first. This post shows the most reliable way to check SQL…
Written by
-
Testing Remote Server Port Connectivity with PowerShell
An application cannot connect to SQL Server, and before anyone goes near a configuration file there is 1 question to settle: is the port reachable from this server, or is something in the path blocking it? ⚡The short version. Run Test-NetConnection -ComputerName <server> -Port 1433. TcpTestSucceeded : True and the port is open from here,…
Written by
-
How to Check Listening Ports on Windows
An application cannot connect, and before you look at firewalls, DNS or logins you need one fact: is SQL Server listening on this machine, and on which port? Ask Windows which ports the sqlservr process holds, then ask SQL Server which port it bound at startup. If the two agree and the client still fails,…
Written by
- Cannot Connect to WMI Provider: SQL Server Configuration Manager Will Not Open
- SQL Server Configuration Manager: Where to Find It and What a DBA Uses It For
- DBA Scripts: Get Failed Login Summary
- Query Was Fast Yesterday, Slow Today: Find What Changed
- The Current Transaction Cannot Be Committed (Error 3930)
- Sort and Hash Spills to TempDB: Find the Query and Fix the Grant
- Backups & Recovery (17)
- DBA Scripts (154)
- High Availability (HA) (13)
- Installation & Configuration (58)
- Maintenance (25)
- Migration & Upgrades (14)
- Monitoring (9)
- Performance Tuning (37)
- Security (Encryption & Permissions) (23)
- Storage & Capacity (17)
- T-SQL Fundamentals (15)
- Troubleshooting (102)
- Wait Types (235)