topic Re: Creating new item - sql database in SQL database

Creating new item - sql database

LSkerkova777 — Tue, 10 Dec 2024 11:59:04 GMT

Hallo,

please can I have a request? I want to create second sql database and after typing the name I get "An internal error occurred." Then I get the database but with an error. My first sql database is working properly. Please can you help me?

Thank you Lidka Skerkova

Re: Creating new item - sql database

SomaJagadeesh — Tue, 10 Dec 2024 18:51:09 GMT

Is this reproducible behavior ? looks like a intermittent error.
Is the same name you are trying to have for both databases

Re: Creating new item - sql database

Anonymous — Wed, 11 Dec 2024 06:49:45 GMT

Hi LSkerkova777

After testing, in worksapce can create two sql database without error.

you can the delete the database, and clean up your website's cache, then try to recreate it.

Best Regards!

Yolo Zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Re: Creating new item - sql database

LSkerkova777 — Wed, 11 Dec 2024 07:15:19 GMT

Hallo,

thank you for response. I have a trial version. I try to create second database multiple times, the result is the same. The name of the second database is different. I cleared the website's cache, the result is the same .. internal error

Re: Creating new item - sql database

LSkerkova777 — Fri, 13 Dec 2024 12:27:11 GMT

Hallo,

in this moment I found, what is wrong. My first database has connection string for server "A" and connection string for database "B". When I create the second database, I have new connection string for server "C" and connection for database "D". When I connect to new database in SSMS, it is ok for the first database with "A" and "B", but for the second it is wrong with "C" and "D", BUT it is ok when I use "A" and "D". And thats why I think that it is problem that in fabric the new database has wrong string for server, it should be the same as for the first database. What do you think please? Thank you Lidka

Re: Creating new item - sql database

sukkaur — Fri, 13 Dec 2024 17:26:51 GMT

LSkerkova777 - Can you please verify if you have Private Link enabled at the tenant level or not? If Private link is enabled you would not be able to create a new database till Jan end. Apologies for the inconvenience

that this has caused at your end.

Best Regards

Re: Creating new item - sql database

LSkerkova777 — Fri, 13 Dec 2024 18:00:17 GMT

Hallo, I have trial version and I have a warning at the top of the window - Private Link is not supported in workspaces assigned to free Fabric trial capacities. To access items while using Private Link, you need to buy a paid Fabric capacity.

With regards Lidka