Tag: SQL Server Networking
-
Troubleshooting Database Mirroring Issues in SQL Server
Database Mirroring is deprecated, but you will still see it in many production environments. It was officially marked deprecated in SQL Server 2012 and has remained in that state for well over a decade. In my own career as a DBA, it has been “deprecated” the entire time, yet still widely deployed and fully supported.…
Written by
-
How to Get the SQL Server IP Address
The firewall team, or a vendor, wants the exact IP address and port before they will open an allow-list rule, and the server has more than one address. Do not read it off ipconfig and do not assume 1433: ask SQL Server which address and port the connection actually arrived on. ⚡On a TCP connection,…
Written by
-
Check SQL Server Connection Encryption and Protocol
Modern SQL Server environments often use encrypted connections by default, but that does not always mean what people think it means. When troubleshooting connectivity problems, certificate errors, performance questions, or unexpected client behaviour, DBAs usually need to answer one very specific question: What protocol and encryption is this connection actually using right now? This post…
Written by
-
sqlcmd Examples for SQL Server
No SSMS on the box, or SSMS will not connect, and you need to run a query or a script file from a shell right now. sqlcmd does that from Command Prompt, PowerShell or a Linux shell. On any current install it also refuses the first connection with a certificate error until you add -C,…
Written by
-
SSMS Certificate Chain Not Trusted Error (Trust Server Certificate Fix)
🚨Part of the SQL Server Errors series, the exact messages and what actually causes them.In: Security You upgraded SSMS, sqlcmd or an application driver, and a connection that worked yesterday now fails with this. Nothing changed on the server: the client got stricter, and it now refuses the certificate it used to accept without checking.…
Written by
-
SQL Server Default Ports
Something cannot connect, or the firewall team wants a port number before they will open anything. Both questions have the same answer, and it is not a guess: ask the instance what it is listening on. TCP 1433 is right on a default instance nobody has touched, and it stops being right as soon as…
Written by
-
Enabling TCP Connections in SQL Server
A remote client cannot connect and the instance is running. The application reports Named Pipes Provider, error: 40 or SQL Network Interfaces, error: 26, and the first thing to rule out is the server not listening on TCP/IP at all. Check it with one query, turn it on in SQL Server Configuration Manager or PowerShell,…
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
- SQL Injection in Dynamic SQL: Use sp_executesql
- RESOURCE_SEMAPHORE When SQL Server Is Nowhere Near Its Memory Cap
- Dynamic Data Masking: What a WHERE Clause Still Reveals
- DBA Scripts: Get Log Shipping Status
- SQL Server Row-Level Security: The Filter Does Not Stop Cross-Tenant Writes
- View the Definition of a Stored Procedure in SQL Server
- Backups & Recovery (17)
- DBA Scripts (152)
- High Availability (HA) (13)
- Installation & Configuration (49)
- Maintenance (25)
- Migration & Upgrades (14)
- Monitoring (9)
- Performance Tuning (37)
- Security (Encryption & Permissions) (22)
- Storage & Capacity (16)
- T-SQL Fundamentals (15)
- Troubleshooting (95)
- Wait Types (235)