SQL Server

To setup SQL Server state store create a component of type . 请参阅，了解如何创建和应用状态存储配置。

Warning

If you wish to use Redis as an , append the following to the yaml.

  1.   - name: actorStateStore
  2.     value: "true"

Note: SQL Server state store also supports SQL Server running on VMs.

  • Connection String: the SQL Server connection string. For example: server=localhost;user id=sa;password=your-password;port=1433;database=mydatabase;
  • Schema: The database schema to use (default=dbo). Will be created if does not exist
  • Table Name: The database table name. Will be created if does not exist

When connecting with a dedicated user (not sa), these authorizations are required for the user - even when the user is owner of the desired database schema:

  • CREATE TABLE
  • CREATE TYPE