Azure SQL and Visio 2019 Plan 2 Database Reverse engineering wizard Fails

0 votes

I'm trying to reverse-engineer an Azure SQL server using Visio 2019. Using both our DB-admin user and my admin azure directory logins, I was able to create multiple User data sources to use in the wizard. When the tables and views I want to reverse-engineer are about to load in after the database credentials have been successfully verified, I get the following:

The database wizard for Visio raises an error:

"Error! Cannot extract column definition for the table/view . The definition is not

available or you may not have sufficient privileges."

with a text box that says:

"Could not find server "database name"* in sys.servers. Verify that the correct server name was specified. If necessary, execute the stored procedure sp_addlinkedserver to add the server to sys.servers."

Due to its nonexistence, I am unable to run sp.addlinkedserver or locate sys.servers. Sys.Sysservers does exist, though.

I gave the database name a star because it displays "DB 2," which is not the full name of the Database, instead of the target DB, "DB 2.0."

As I already mentioned, I think I have enough rights because I've tried both the admin username and password as well as my admin login using Azure Directory. Therefore, it might be related to the absence of the sys.servers table?

Is there a way to fulfil Visio's request to create the sys.servers table and the stored procedure sp.addlinkedserver? Is using Azure SQL recommended? Could the error be related to how our database is named?

Feb 14, 2023 in Azure by Damonlang
• 1,230 points
523 views

No answer to this question. Be the first to respond.

Your answer

Your name to display (optional):
Privacy: Your email address will only be used for sending these notifications.

Related Questions In Azure

0 votes
0 answers

Getting error message about master.sys.sysclsobjs while converting SQL Server database to Azure

I have a database with SQL Server ...READ MORE

Feb 14, 2023 in Azure by Damonlang
• 1,230 points
438 views
0 votes
1 answer

Where is the output of Azure SQL Database Auditing Stored?

1. Azure SQL Database Auditing Overview: Azure SQL ...READ MORE

answered Oct 18, 2023 in Azure by anonymous
• 3,360 points
590 views
0 votes
1 answer

How is azure SQL database auditing configured?

Azure SQL Database Auditing helps track database ...READ MORE

answered Oct 23, 2023 in Azure by anonymous
• 3,360 points
608 views
0 votes
1 answer
0 votes
1 answer

How to retrieve View definition on Synapse (Azure SQL DW)?

To authenticate with Azure SQL Database or ...READ MORE

answered Mar 4, 2022 in Azure by Edureka
• 13,620 points
1,724 views
0 votes
1 answer

Differences between Azure App Services and Cloud Services

App Services  Cloud Services Supported Platforms ASP.NET, Node.js, Java, PHP, ...READ MORE

answered Mar 1, 2022 in Azure by Edureka
• 12,690 points
652 views
0 votes
0 answers
0 votes
0 answers

Reset identity seed after deleting records in SQL Server

A SQL Server database table has had ...READ MORE

Aug 22, 2022 in Database by Kithuzzz
• 38,000 points
679 views
0 votes
1 answer

Calculate Time Intersection to Correlate Sequences of Independent Events

I think this solution requires a CROSS JOIN implementation. ...READ MORE

answered Oct 26, 2018 in Power BI by Upasana
• 8,620 points
787 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP