TestTCPNetworkConnection.sql on Azure SQL Database
- Dominant language
- TSQL
- Stars
- 61
- Forks
- 32
- PR merge metrics
- No merged PRs in 30d
Description
https://github.com/Azure/sqlmi/blob/main/how-to/how-to-test-tcp-connection-from-mi/TestTCPNetworkConnection.sql
When I try this on an Azure SQL Database (not managed instance), I get the error below. How do we test outbound ports on an Azure SQL Database?
```
Msg 40515, Level 15, State 1, Line 16
Reference to database and/or server name in 'msdb.dbo.sysjobs_view' is not supported in this version of SQL Server.
```
Contributor guide
No contributing guide indexed for this repository
Research direction
Start with TestTCPNetworkConnection.sql at the linked Azure sqlmi path and reproduce the reported 40515 error on Azure SQL Database. Determine whether the script can support this environment and document a valid way to test outbound ports, or clearly record the limitation.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- azure, sql
- Domain
- cloud, databases, networking
- Issue type
- Bug
- Difficulty
- 4/5
- Estimated time
- 3-5 days
- Activity status
- Stale
- Clarity
- Needs clarification
- Newbie friendliness
- 25/100