This example illustrates how a connection is established from Invantive Cloud using the Microsoft SQL Server TDS protocol to an Invantive UniversalSQL database on the same Invantive Cloud. ## Prerequisites Ensure the following prerequisites are met: - A database has been registered on Invantive Cloud. - The IP address from which Invantive Cloud connects is whitelisted. ## Select Microsoft SQL Server Create a new database using the Microsoft SQL Server protocol: ![[20260422-cloud-database-type.png]] ## 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-cloud-sql-server.png]] ## Database Properties After the database has been registered, the database is displayed: ![[20260422-cloud-database-properties.png]] The server properties are displayed on the data container (actual values can vary): ![[20260422-cloud-database-features.png]] Please note that Feature 1 lists "On-premises SQL Server". This does not signal the server mode of Invantive UniversalSQL Server, but the type of SQL Server: Azure SQL Server or traditional on-premises. Invantive UniversalSQL Server identifies as a traditional SQL Server instance. ## Tables and Views The Available Objects uses Microsoft SQL Server-specific statements that are mapped onto Invantive UniversalSQL operations to display the list of available tables and views: ![[20260422-cloud-tables.png]] ## Stored Logic Similarly, the Available Objects displays the list of available stored logic such as the procedure `get_partitions` from the package `dcr_metadata`: ![[20260422-cloud-packages.png]] ## Simple Query The table `Projects` in the data container `dmy` (Sample database) can be queried using standard Invantive UniversalSQL syntax: ![[20260422-cloud-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-cloud-concat-query.png]]