Sometimes when we navigate to target database in Azure Portal, it might return “URI malformed” error with below callstack:
"URIError: URI malformed
at decodeURIComponent (<anonymous>)
at https://ms.portal.azure.com/Content/Dynamic/-CDJTGN00vty.js:1:40037
at Array.forEach (<anonymous>)
at new e (https://ms.portal.azure.com/Content/Dynamic/-CDJTGN00vty.js:1:39938)
at new t (https://ms.portal.azure.com/Content/Dynamic/-CDJTGN00vty.js:1:41390)
at t.batch (https://ms.portal.azure.com/Content/Dynamic/MYbNINXhLuLV.js:61:508)
at https://ms.portal.azure.com/Content/Dynamic/MYbNINXhLuLV.js:140:3630
at https://ms.portal.azure.com/Content/Dynamic/MYbNINXhLuLV.js:2:4295
at Object.next (https://ms.portal.azure.com/Content/Dynamic/MYbNINXhLuLV.js:2:4400)
at a (https://ms.portal.azure.com/Content/Dynamic/MYbNINXhLuLV.js:2:3034)"
If we use SSMS or Azure Data Studio to connect the Azure SQL Server, we can see the database and the data within the database though.
In Azure we have different naming rules and restrictions for different Azure resources, referring to Naming rules and restrictions for Azure resources. The naming rules and restrictions for Azure SQL Database listed below:
- the name lenghth should be less than 128
- can’t use:<>*%&:/? or control characters.
- can’t end with period or space.
However if we create the database in SSMS or Azure Data Studio with CREATE DATABASE statement, the limitation is differnt, refer to Database identifiers.
For example, we can create database with name of “TestAzureNaming%RulesAndRestrictions” with below T-SQL statement:
CREATE DATABASE [TestAzureNaming%RulesAndRestrictions] ( EDITION = 'Basic');
Solutions:
ALTER DATABASE [TestAzureNaming%RulesAndRestrictions] MODIFY NAME = [TestAzureNamingRulesAndRestrictions];
文档信息
- 本文作者:Robin Chen
- 本文链接:https://crushonme.github.io/2025/05/08/Why-cannot-access-the-database-in-Azure-Portal/
- 版权声明:自由转载-非商用-非衍生-保持署名(创意共享4.0许可证)
Document Information
- Author :Robin Chen
- Link : https://crushonme.github.io/2025/05/08/Why-cannot-access-the-database-in-Azure-Portal/
- Copyright:Attribution-NonCommercial-NoDerivatives-No additional restrictions(CC BY-NC-ND 4.0)
Gitalking ...