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
Right-click in the
Logins area and choose
Login - New dialog box appears.
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
OK to close the dialog box.
In the Management Studio left pane, right-click the top-level server item and choose
Server Properties dialog box appears.
Server Authentication, select
SQL Server and Windows Authentication mode, and click
Set the following system environment variable:
User ID=<database login>; password=<login password>
Reboot the machine to restart the database server and set the new system environment variable.