SQL Server is a widely-used relational database system. If enabled in Connect, the Virtual SQL Server remoting endpoint allows users to access exposed data as if it were any SQL database. The Connect Virtual SQL Server endpoint can be accessed using various SQL Server-compatible client applications.

Connection examples

These examples below assume that a connection has been created in Connect, and that Users have been created with a password, and given proper permissions to access this connection.

ADO.NET SQL Client

Using the ADO.NET SQL Client, you can connect to the Virtual SQL Server service. Simply set the connection string to:

Server=myconnectserver;Database=myDataBase;User Id=myUsername;Password=myPassword;

JDBC SQL Client

The Microsoft JDBC Driver for SQL also allows you to connect to the Virtual SQL Server remoting endpoint in a Java project. To do so, set your JDBC URL or JDBC connection string to the following:

jdbc:sqlserver://myconnectserver;Database=myDatabase;user=myUsername;password=myPassword;