In SAS Visual Investigator, you complete a profile on the Properties page in order to connect to a database data source. Part of this process is to select a setting for a Test button to ensure that the connection is successful.

After a successful connection, if you attempt to create an entity and use data from that data source connection, you might see the following error message in the user interface:

This error occurs when the database type is Microsoft SQL Server.

To work around this issue, you must explicitly grant either access to or ownership of the schema for the tables. 

Click the Hot Fix tab in this note for a link to instructions about accessing and applying the software update.

Operating System and Release Information

An update for this issue is available for SAS Visual Investigator 10.4. For instructions on how to access and apply software updates, see the Updating Your SAS Viya software section in the SAS Viya 3.4 for Linux Deployment Guide at