Getting Failed to add firewall rule error during SQL DB deployment using GitHub Hosted Runner
Open
idle
need-to-triage
- Dominant language
- TypeScript
- Stars
- 142
- Forks
- 73
- PR merge metrics
- No merged PRs in 30d
Description
Getting Failed to add firewall rule error during SQL DB deployment using GitHub Hosted Runner although 'Allow Azure Services And resources to access this server" is checked in the SQL server
Error: Failed to add firewall rule. Unable to detect client IP Address. Sqlcmd: Error: Microsoft ODBC Driver 17 for SQL Server : Login failed for user 'MCSSQLADMIN'..
Error: The process 'C:\Program Files\Microsoft SQL Server\Client SDK\ODBC\170\Tools\Binn\SQLCMD.exe' failed with exit code 1
Contributor guide
Assessment
This issue has not been assessed yet.