New Database in exist Managed Instance

Question

Rohit Kulkarni 731

Hello Team,

I am trying to create a new database in existing. Managed instance.

User's image

But i am getting error Please refer the screenshot.

Please advise.

Regards

Rohit

Olaf Helper 47,436 Reputation points

2023-02-14T12:21:57.79+00:00

There is no "screenshot below". Please post the error message as plain text.
GeethaThatipatri-MSFT 29,542 Reputation points Microsoft Employee Moderator

2023-02-21T00:03:42.7866667+00:00

@Rohit Kulkarni Following up to see if the below suggestion was helpful. If this answers your query, do click Accept Answer, if you have any further query do let us know.

1 answer

Olaf Helper 47,436 Reputation points

2023-02-14T12:21:57.79+00:00

There is no "screenshot below". Please post the error message as plain text.
GeethaThatipatri-MSFT 29,542 Reputation points Microsoft Employee Moderator

2023-02-21T00:03:42.7866667+00:00

@Rohit Kulkarni Following up to see if the below suggestion was helpful. If this answers your query, do click Accept Answer, if you have any further query do let us know.

Answer 1

RahulRandive 10,486 Volunteer Moderator

Thanks for your question.

As a workaround, please try creating database using SSMS, PowerShell or CLI command and it will work.

SSMS command

CLI Commands to create database.

Hope this help!

Rohit Kulkarni 731 Reputation points

2023-02-14T13:53:58.1433333+00:00

even i tried from SSMS. Please refer the screenshot below:

Please advise

Regards

Rohit
Rohit Kulkarni 731 Reputation points

2023-02-14T14:02:02.5133333+00:00

even i tried from SSMS and getting error:

Please advise

Regards

Rohit
RahulRandive 10,486 Reputation points Volunteer Moderator

2023-02-14T14:20:22.6233333+00:00

Thanks for sharing screenshot.

I mean try creating database from SSMS using T-SQL Command like below

CREATE DATABASE TestDB1;

or

CREATE DATABASE database_name [ COLLATE collation_name ]

Here is Syntax

https://learn.microsoft.com/en-us/sql/t-sql/statements/create-database-transact-sql?view=azuresqldb-mi-current&preserve-view=true&tabs=sqlpool#syntax-2
Rohit Kulkarni 731 Reputation points

2023-02-14T15:54:24.5566667+00:00

I need to mention as master right and run the script.

Please advise

Regards

Rohit
RahulRandive 10,486 Reputation points Volunteer Moderator

2023-02-14T16:10:21.0133333+00:00

Yes please and you can test this command on your non-production server first, it will just create a blank database for you.
RahulRandive 10,486 Reputation points Volunteer Moderator

2023-02-17T20:48:17.6233333+00:00

Hi Rohit,
I believe you should now be able to create a database from the Azure portal as well.

Thanks,