Sql Databases in Azure with Sharp/hashtag # character in their name don't show up on SQL Databases Dashboard in Azure Portal

Juraj Petras 1 Reputation point
2022-03-28T10:51:43.44+00:00
  1. Thru portal.azure.com I created a copy of an existing Azure SQL Database. The DB copy had name "abc-def_#1234" - including characters like - _ and #
  2. After the DB copy was created (with some problems see below) it didn't show up on the SQL Database dashboard on portal.azure.com
  3. It was only accessible thru the Sql Servers / Sql Databases menu.

I can constantly reproduce the problem on any DB server with any Database.

Moreover:
While the copy was being created - the copy progress was appearing to stuck in "... Deployment is in progress" showing status "BadRequest" as if never ended but the DB copy did actually get created:
187439-image.png

Also when trying to delete the copy of the DB with name "abc-def_#1234" an error occurred - even if the DB did get deleted:
187504-image.png

Azure SQL Database
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Alberto Morillo 33,536 Reputation points MVP
    2022-03-28T11:28:25.057+00:00

    There are some characters that you should not use on Azure SQL Database names because they will create issues not only with the portal but also with some features that Azure SQL provides. Please not only avoid the hash but also avoid characters like '.' or ']' or '['.

    0 comments No comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.