Error code
SQL Server 40615
SQL SERVER40615
Database Error Code· An error code returned by a database server such as PostgreSQL or MySQL.
What it means
cannot open server requested by the login — Azure SQL firewall rule missing.
How to fix it
- Add the client IP address to the Azure SQL firewall rules in the Azure portal or with sp_set_firewall_rule.
- Use the Allow Azure Services option for connections from other Azure resources.
- Verify the correct server name (e.g. server.database.windows.net) is in the connection string.
Not affiliated with SQL Server. Answer summarized from the manufacturer's manual linked above; consult that source for the authoritative procedure.
More SQL Server codes
- 4060cannot open database requested in login — database does not exist or access denied
- 10054an existing connection was forcibly closed by the remote host — network reset
- 102incorrect syntax near — the parser encountered an unexpected token
- 1105could not allocate space for object — the filegroup or disk is full
- 1205transaction was deadlocked and chosen as the deadlock victim — rolled back
- 156incorrect syntax near a keyword — a reserved word was used improperly
- 17142SQL Server service is paused — new connections are refused
- 18456login failed for user — authentication rejected
- 207invalid column name — the column does not exist on the referenced table
- 208invalid object name — the table or view does not exist
- 229execute permission denied on object — the user lacks the required privilege
- 233no process is on the other end of the pipe — connection broken