This example illustrates how a connection is established from Microsoft SQL Server Management Studio to an Invantive UniversalSQL database on Invantive Cloud. Invantive UniversalSQL Server has been tested with: - Microsoft SQL Server Management Studio 18 - Microsoft SQL Server Management Studio 19 - Microsoft SQL Server Management Studio 21 - Microsoft SQL Server Management Studio 22 - Microsoft SQL Server Management Studio 23 ## Prerequisites Ensure the following prerequisites are met: - A database has been registered on Invantive Cloud. - The IP address from which Microsoft SQL Server Management Studio connects is whitelisted. ## Login The SQL Server compatible server name is entered into the SQL Server login window, together with the Invantive Cloud credentials. Encryption is activated, since Invantive Cloud uses Invantive UniversalSQL Server with a certificate: ![[20260422-ssms-log-on.png]] ## Server Properties After connection has been established, the server properties display more details on the connection (actual values can vary): ![[20260422-ssms-server-properties.png]] ## Tables The Object Explorer uses Microsoft SQL Server-specific statements that are mapped onto Invantive UniversalSQL operations to display the list of available tables: ![[20260422-ssms-tables.png]] ## Views Similarly, the Object Explorer displays the list of available views: ![[20260422-ssms-views.png]] ## Stored Logic Similarly, the Object Explorer displays the list of available stored logic such as the procedure `get_partitions` from the package `dcr_metadata`: ![[20260422-ssms-stored-procedures.png]] ## Simple Query The table `Projects` in the data container `dmy` (Sample database) can be queried using standard Invantive UniversalSQL syntax: ![[20260422-ssms-simple-query.png]] ## Non-SQL Server Syntax The use of the pipe symbols instead of `concat` illustrates that all Invantive UniversalSQL syntax is available, not only Microsoft SQL Server compatible elements: ![[20260422-ssms-concat-query.png]] ## System Databases The system databases provide access to the service providers, such as `DataDictionary`: ![[20260422-ssms-data-dictionary-query.png]] ## Limitations As of release 26.0, the following are known limitations when used with Microsoft SQL Server Management Studio: - No standard reports. - No dashboards.