By default,
Enterprise Server for .NET connects to SQL Server using Windows authentication (SSPI), with the user's log on credentials. For cluster operations running
in a workgroup rather than a domain, configure each machine to connect using supplied SQL Server authentication credentials.
-
Open SQL Server Management Studio and connect to the database server instance used by the cluster.
-
In the Management Studio left pane, expand the
Security item, then expand the
Logins item.
-
Right-click in the
Logins area and choose
New Login.
The
Login - New dialog box appears.
-
Use the
Login - New dialog box to create an account with SQL Server authentication.
When configuring credentials, ensure that you clear the following options:
-
Enforce password policy
-
Enforce password expiration
-
User must change password at next logon
-
Right-click the account you created and select
Properties. On the
Login Properties dialog box, grant sufficient access to create databases and tables such asPublic and
Sysadmin. Click
OK to close the dialog box.
-
In the Management Studio left pane, right-click the top-level server item and choose
Properties.
The
Server Properties dialog box appears.
-
Under
Server Authentication, select
SQL Server and Windows Authentication mode, and click
OK.
-
Set the following system environment variable:
- REX_SQLCREDS
-
User ID=<database login>; password=<login password>
Reboot the machine to restart the database server and set the new system environment variable.