Service eligibility and regional restrictions
PuppyIP serves only compliant overseas businesses and their authorized personnel. Proxy services are not available in mainland China. The service may only be used for lawful business activities outside mainland China. Use of this service within mainland China is prohibited.
Hosting a proxy IP or server overseas does not change these restrictions. The service must not be provided to end users in mainland China through relaying, forwarding, sharing or resale. Before use, read the Terms of Service.
Key Takeaways
- AWS announced SQL Server 2022 support on October 14, 2026.
- Check the AWS Region and version table and confirm that the instance is selectable in the RDS console.
- The default proxy endpoint is private. The proxy and its database target must be in the same VPC.
- Test the database target status and the application login through the proxy separately.
Confirm that the Region and instance are eligible
The announcement applies to SQL Server 2022 instances managed by Amazon RDS. It does not cover self-managed SQL Server on EC2 or elsewhere. In the AWS Region and engine version table for RDS Proxy, find the instance's Region and check the SQL Server 2022 column.
In the RDS console, open Proxies and choose Create proxy. The database selector shows compatible targets. If the instance is missing, confirm the selected Region, engine version and instance settings before checking the network configuration.
Which connection uses standard IAM?
The application authenticates to the proxy with IAM. Its identity needs permission to connect as the corresponding database user. Use TLS and pass the IAM token in the driver's dedicated token property. AWS lists accessToken for JDBC and AccessToken for .NET SqlClient as examples.
For the proxy-to-SQL Server connection, the proxy uses a database username and password. Store the user's database credentials in Secrets Manager and allow the proxy's service role to read that secret. RDS Proxy does not support end-to-end IAM for SQL Server. Keep the default authentication scheme for the database connection at None so the proxy reads the secret.
When should you point the application at the proxy?
Place the proxy and target database in the same VPC. The default proxy endpoint is private. The application runtime needs to resolve its hostname and reach it. Verify the application-to-proxy route and the proxy-to-database route separately. Limit security group access to the required sources and ports.
In an isolated test environment, confirm that the proxy target is available, then point one application instance at the proxy endpoint. Keep the appropriate database name and driver, enable TLS, and use the application identity to connect and perform an authorized test read. Verify it before switching production traffic. Keep the original connection settings for rollback and leave tokens and passwords out of logs.
How do you tell which connection is failing?
If you cannot reach the endpoint, check DNS, routing and security groups from the application runtime. Reaching a public database endpoint from your laptop does not establish that the private proxy endpoint is reachable from there.
If the application reaches the proxy but authentication fails, check IAM permissions, the database username, TLS and the driver's token property. If the proxy target is unhealthy, check database reachability, the proxy's access to the matching secret, and whether the database credentials are valid. Test each connection in a controlled environment before changing multiple settings.
Sources
Frequently Asked Questions
Does connection pooling eliminate interruptions during failover?
RDS Proxy reuses database connections and reconnects to the standby during SQL Server Multi-AZ failover. The application still needs to test timeouts, retries and transaction recovery. Interruptions depend on the configuration and workload.
Can I use standard IAM with a client that has only a password field?
The client driver must support a dedicated token property and use TLS. Upgrade or replace a client that lacks the property before testing IAM connections.
How does AWS bill for RDS Proxy with SQL Server 2022?
AWS charges by the underlying instance’s vCPUs per hour. Use the AWS price for your Region and instance capacity to estimate the charge. Your actual bill depends on your usage.