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?
