Microsoft SQL Server (Early Access) on Data Management for VMware Tanzu

Enabled Microsoft SQL Server Editions and Versions

Data Management for VMware Tanzu enables you to provision databases that run Microsoft SQL Server Editions of Enterprise, Standard, and Developer of version Microsoft SQL Server 2019.

Note: Before you create Microsoft SQL Server databases, you need to download and create the database templates. Foe more information, see Downloading and Using Database Templates for Microsoft SQL Server.

Configuration

When you use Data Management for VMware Tanzu to create a Microsoft SQL Server database, you configure certain Microsoft SQL Server properties.

Database Configuration

The Database Configuration properties, which you configure while creating a Microsoft SQL Server database, identify the name of the default database, the database server port number, and the database administrator user credentials.

Property Name	Description
Database Name	The name of the default database.
Database Port No	The port number on which the database server runs. The default is 1433. (Read-only)
Username	The database administrator user name.
Password	The password for the database adminstrator. Apart from alphanumeric characters, the password can only include the special characters, ?, !, @, #, $, %, ^, and *.

Note: The default values for these properties are provided through the user interface, but you should change them as required. Data Management for VMware Tanzu supports password changes made using a database client, and not the console or API. You must change this password using a database client. If you change the password in this manner, the new password is not reflected in Data Management for VMware Tanzu. The password must not contain the character &.

Connecting to a Microsoft SQL Server Database

To access a Microsoft SQL ServerL database, the host on which the client application is running must have connectivity to the Application Network configured for the database.

You can use any SQL client application to connect to a database in your Microsoft SQL Server database. To connect, you must be able to identify the FQDN of the Microsoft SQL Server host, the port on which the server is running, and the database name. You must also have the Microsoft SQL Server admin credentials on hand. You can obtain this information from the Data Management for VMware Tanzu console. See Locating the Database Connection Parameters.