unable to connect another data base in same server which is azure sql - through ssms

Question

Issue description:

Msg 40515, Level 15, State 1, Line 66

Reference to database and/or server name in 'sriniazpracticedbserver.database.windows.net.TARGET.dbo.data_trg' is not supported in this version of SQL Server.

Completion time: 2024-05-17T11:12:27.1510005+05:30

Answer 1

Hi @Srinivas Mantri In Azure SQL database, to create a database, a login must be one of the following:

• The server-level principal login
• The Azure AD administrator for the local Azure SQL Server
• A login that is a member of the dbmanager database role

Referring from this similar thread: Reference to database and/or server name is not supported in this version of SQL Server.

Best regards,

Cosmog Hong

---

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Answer 2

If I understand your question corrcetly, it seems like you are trying to do a cross-database/server reference. This is not possible in Azure SQL Database to do with three/four-part notation. You can do it if you set up external tables.

Checkout the command CREATE EXTERNAL TABLE. Make sure that you are reading the description for Azure SQL Database. (This command exists in other editions of SQL Server as well, but with quite different functionality.)