{"action":"created","issue":{"url":"https://api.github.com/repos/MicrosoftDocs/azure-docs/issues/17701","repository_url":"https://api.github.com/repos/MicrosoftDocs/azure-docs","labels_url":"https://api.github.com/repos/MicrosoftDocs/azure-docs/issues/17701/labels{/name}","comments_url":"https://api.github.com/repos/MicrosoftDocs/azure-docs/issues/17701/comments","events_url":"https://api.github.com/repos/MicrosoftDocs/azure-docs/issues/17701/events","html_url":"https://github.com/MicrosoftDocs/azure-docs/issues/17701","id":374463297,"node_id":"MDU6SXNzdWUzNzQ0NjMyOTc=","number":17701,"title":"User must be in master database error","user":{"login":"TJHAutoLtd","id":28254857,"node_id":"MDQ6VXNlcjI4MjU0ODU3","avatar_url":"https://avatars2.githubusercontent.com/u/28254857?v=4","gravatar_id":"","url":"https://api.github.com/users/TJHAutoLtd","html_url":"https://github.com/TJHAutoLtd","followers_url":"https://api.github.com/users/TJHAutoLtd/followers","following_url":"https://api.github.com/users/TJHAutoLtd/following{/other_user}","gists_url":"https://api.github.com/users/TJHAutoLtd/gists{/gist_id}","starred_url":"https://api.github.com/users/TJHAutoLtd/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/TJHAutoLtd/subscriptions","organizations_url":"https://api.github.com/users/TJHAutoLtd/orgs","repos_url":"https://api.github.com/users/TJHAutoLtd/repos","events_url":"https://api.github.com/users/TJHAutoLtd/events{/privacy}","received_events_url":"https://api.github.com/users/TJHAutoLtd/received_events","type":"User","site_admin":false},"labels":[{"id":836703193,"node_id":"MDU6TGFiZWw4MzY3MDMxOTM=","url":"https://api.github.com/repos/MicrosoftDocs/azure-docs/labels/cxp","name":"cxp","color":"bf1394","default":false},{"id":880598256,"node_id":"MDU6TGFiZWw4ODA1OTgyNTY=","url":"https://api.github.com/repos/MicrosoftDocs/azure-docs/labels/product-issue","name":"product-issue","color":"2fe09f","default":false},{"id":646553781,"node_id":"MDU6TGFiZWw2NDY1NTM3ODE=","url":"https://api.github.com/repos/MicrosoftDocs/azure-docs/labels/sql-database/svc","name":"sql-database/svc","color":"90ccff","default":false},{"id":836702742,"node_id":"MDU6TGFiZWw4MzY3MDI3NDI=","url":"https://api.github.com/repos/MicrosoftDocs/azure-docs/labels/triaged","name":"triaged","color":"0e8a16","default":false}],"state":"open","locked":false,"assignee":{"login":"Mike-Ubezzi-MSFT","id":37126106,"node_id":"MDQ6VXNlcjM3MTI2MTA2","avatar_url":"https://avatars0.githubusercontent.com/u/37126106?v=4","gravatar_id":"","url":"https://api.github.com/users/Mike-Ubezzi-MSFT","html_url":"https://github.com/Mike-Ubezzi-MSFT","followers_url":"https://api.github.com/users/Mike-Ubezzi-MSFT/followers","following_url":"https://api.github.com/users/Mike-Ubezzi-MSFT/following{/other_user}","gists_url":"https://api.github.com/users/Mike-Ubezzi-MSFT/gists{/gist_id}","starred_url":"https://api.github.com/users/Mike-Ubezzi-MSFT/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Mike-Ubezzi-MSFT/subscriptions","organizations_url":"https://api.github.com/users/Mike-Ubezzi-MSFT/orgs","repos_url":"https://api.github.com/users/Mike-Ubezzi-MSFT/repos","events_url":"https://api.github.com/users/Mike-Ubezzi-MSFT/events{/privacy}","received_events_url":"https://api.github.com/users/Mike-Ubezzi-MSFT/received_events","type":"User","site_admin":false},"assignees":[{"login":"Mike-Ubezzi-MSFT","id":37126106,"node_id":"MDQ6VXNlcjM3MTI2MTA2","avatar_url":"https://avatars0.githubusercontent.com/u/37126106?v=4","gravatar_id":"","url":"https://api.github.com/users/Mike-Ubezzi-MSFT","html_url":"https://github.com/Mike-Ubezzi-MSFT","followers_url":"https://api.github.com/users/Mike-Ubezzi-MSFT/followers","following_url":"https://api.github.com/users/Mike-Ubezzi-MSFT/following{/other_user}","gists_url":"https://api.github.com/users/Mike-Ubezzi-MSFT/gists{/gist_id}","starred_url":"https://api.github.com/users/Mike-Ubezzi-MSFT/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Mike-Ubezzi-MSFT/subscriptions","organizations_url":"https://api.github.com/users/Mike-Ubezzi-MSFT/orgs","repos_url":"https://api.github.com/users/Mike-Ubezzi-MSFT/repos","events_url":"https://api.github.com/users/Mike-Ubezzi-MSFT/events{/privacy}","received_events_url":"https://api.github.com/users/Mike-Ubezzi-MSFT/received_events","type":"User","site_admin":false}],"milestone":null,"comments":2,"created_at":"2018-10-26T16:44:47Z","updated_at":"2018-10-27T13:02:50Z","closed_at":null,"author_association":"NONE","body":"Msg 5001, Level 16, State 5, Procedure sp_set_firewall_rule, Line 1 [Batch Start Line 0]\nUser must be in the master database.\n\nreturned when trying to add a firewall rule for ABC database using\n\nEXECUTE sp_set_firewall_rule @name = N'ContosoFirewallRule',\n   @start_ip_address = '192.168.1.1', @end_ip_address = '192.168.1.10'\n\nfrom SQL management studio 17.5\n\n---\n#### Document Details\n\n⚠ *Do not edit this section. It is required for docs.microsoft.com ➟ GitHub issue linking.*\n\n* ID: 79891897-a11e-6e20-9d41-e4fbbb84311e\n* Version Independent ID: c8317b35-e80a-7f5d-51bf-7a26b2279595\n* Content: [Azure SQL Database and Data Warehouse firewall rules](https://docs.microsoft.com/en-us/azure/sql-database/sql-database-firewall-configure)\n* Content Source: [articles/sql-database/sql-database-firewall-configure.md](https://github.com/Microsoft/azure-docs/blob/master/articles/sql-database/sql-database-firewall-configure.md)\n* Service: **sql-database**\n* GitHub Login: @VanMSFT\n* Microsoft Alias: **vanto**"},"comment":{"url":"https://api.github.com/repos/MicrosoftDocs/azure-docs/issues/comments/433618450","html_url":"https://github.com/MicrosoftDocs/azure-docs/issues/17701#issuecomment-433618450","issue_url":"https://api.github.com/repos/MicrosoftDocs/azure-docs/issues/17701","id":433618450,"node_id":"MDEyOklzc3VlQ29tbWVudDQzMzYxODQ1MA==","user":{"login":"TJHAutoLtd","id":28254857,"node_id":"MDQ6VXNlcjI4MjU0ODU3","avatar_url":"https://avatars2.githubusercontent.com/u/28254857?v=4","gravatar_id":"","url":"https://api.github.com/users/TJHAutoLtd","html_url":"https://github.com/TJHAutoLtd","followers_url":"https://api.github.com/users/TJHAutoLtd/followers","following_url":"https://api.github.com/users/TJHAutoLtd/following{/other_user}","gists_url":"https://api.github.com/users/TJHAutoLtd/gists{/gist_id}","starred_url":"https://api.github.com/users/TJHAutoLtd/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/TJHAutoLtd/subscriptions","organizations_url":"https://api.github.com/users/TJHAutoLtd/orgs","repos_url":"https://api.github.com/users/TJHAutoLtd/repos","events_url":"https://api.github.com/users/TJHAutoLtd/events{/privacy}","received_events_url":"https://api.github.com/users/TJHAutoLtd/received_events","type":"User","site_admin":false},"created_at":"2018-10-27T13:02:50Z","updated_at":"2018-10-27T13:02:50Z","author_association":"NONE","body":"I should add that I am connected using SQL authentication and leaving all other connection parameters as default, this rule did work but I now have 6 db that all show the same error when attempting to set db - level firewall rules"}}
{"actor":{"display_login":"TJHAutoLtd"}}