You can add, Edit, Clone, and delete your datastores here. You can also create a backup, and with the Table management option, you can see the tables you already have in your datastore.
SQL Express
If you use SQL Express, please add the \sqlexpress after the machine name.
Create a new database.
- If you don't have a LoadGen database already, click the
sign. - Enter a name for the database.
- Check your data and log file location and settings.
- Click OK.
- Your database is created.
Deviate from standard TCP port (1433)
To configure your database connection, use a specific port, such as 1450, and append a comma and the port number directly after the database server name in your connection string. For example:
SQL001,1450
This syntax instructs the client to connect to myServerName on port 1450. It's important to note that the comma (,) separates the server name and port number, not a colon (:).
By default, SQL Server listens on port 1433. Specifying a different port is necessary when your SQL Server instance is configured to use a non-default port. To allow successful connections, ensure that the specified port is open and not blocked by firewalls.
MultiSubnetFailover Feature
What is MultiSubnetFailover?
MultiSubnetFailover is a SQL Server connection feature that enables faster failover in multi-subnet environments. When enabled, the SQL client attempts to connect to multiple IP addresses simultaneously, reducing connection time in clustered or Always On availability group scenarios.
When to Use MultiSubnetFailover
- SQL Server Always On Availability Groups across multiple subnets
- Failover Cluster Instances spanning different subnets
- Geographically distributed SQL Server deployments
- Network environments with multiple network paths
How to Enable
When you click on Datastores from the Tools ribbon, a new tab will open with your Datastores. Select your datastore and select the Add SQL MultiSubnetFailover checkbox.