New-DbaConnectionStringBuilder View Source zippy1981 , Chrissy LeMaire (@cl) Windows, Linux, macOS Synopsis Creates a SqlConnectionStringBuilder object for constructing properly formatted SQL Server connection strings
Description Creates a Microsoft.Data.SqlClient.SqlConnectionStringBuilder object from either an existing connection string or individual connection parameters. This allows you to programmatically build, modify, or validate connection strings without manually concatenating string values. The function handles authentication methods, encryption settings, connection pooling, and other SQL Server connection options, making it useful for scripts that need to connect to different SQL Server instances with varying configurations.
New-DbaFirewallRule View Source Andreas Jordan (@JordanOrdix), ordix.de Windows, Linux, macOS Synopsis Creates Windows firewall rules for SQL Server instances to allow network connectivity
Description Creates inbound Windows firewall rules for SQL Server instances, Browser service, and Dedicated Admin Connection (DAC) to allow network connectivity.
This automates the tedious post-installation task of configuring firewall access for SQL Server, eliminating the need to manually determine ports and create rules through Windows Firewall GUI or netsh commands.
Remove-DbaFirewallRule View Source Andreas Jordan (@JordanOrdix), ordix.de Windows, Linux, macOS Synopsis Removes Windows firewall rules for SQL Server Engine, Browser, and DAC connections from target computers.
Description Removes Windows firewall rules for SQL Server components from target computers, cleaning up network access rules when decommissioning instances or changing security configurations. This command only works with firewall rules that were previously created using New-DbaFirewallRule, as it relies on specific naming conventions and rule groups.
Resolve-DbaNetworkName View Source Klaas Vandenberghe (@PowerDBAKlaas) , Simone Bizzotto (@niphold) Windows, Linux, macOS Synopsis Resolves network names and returns detailed network information for SQL Server connection troubleshooting and validation.
Description Performs comprehensive network name resolution to gather detailed connection information for SQL Server instances and computers.
This function is essential when you need to verify connectivity, troubleshoot connection issues, or validate network configurations before connecting to SQL Server.
Uses multiple resolution methods including DNS lookups, ICMP ping tests, and WMI/CIM queries to ensure accurate results across different network configurations.
Set-DbaNetworkConfiguration View Source Andreas Jordan (@JordanOrdix), ordix.de Windows, Linux, macOS Synopsis Modifies SQL Server network protocol settings including TCP/IP, Named Pipes, and Shared Memory configurations.
Description Modifies SQL Server network protocol settings through WMI, allowing you to enable or disable network protocols and configure TCP/IP properties like static or dynamic ports. This replaces the need to manually use SQL Server Configuration Manager for network changes.
Common DBA scenarios include switching instances from dynamic to static ports for firewall rules, enabling TCP/IP for remote connections, or configuring specific IP addresses for multi-homed servers.
Set-DbaTcpPort View Source @H0s0n77 Windows, Linux, macOS Synopsis Configures SQL Server TCP port settings for specified instances and IP addresses.
Description Configures TCP port settings for SQL Server instances by modifying the network configuration through SQL Server Configuration Manager functionality. This replaces the manual process of opening SQL Server Configuration Manager to change port settings for security hardening or network compliance.
The function can target all IP addresses (IPAll setting) or specific IP addresses, disables dynamic port allocation, and sets static port numbers.
Test-DbaConnection View Source Chrissy LeMaire (@cl), netnerds.net Windows, Linux, macOS Synopsis Validates SQL Server connectivity and gathers comprehensive connection diagnostics
Description Tests SQL Server instance connectivity while collecting detailed connection and environment information for troubleshooting. Returns authentication details, network configuration, TCP ports, and local PowerShell environment data. Essential for diagnosing connectivity issues before running automation scripts or validating access across multiple instances. Combines SQL connection testing with network diagnostics including ping status, PSRemoting access, and DNS resolution.
dbatools