Setting Up Database Access for a Cluster

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.
  1. Open SQL Server Management Studio and connect to the database server instance used by the cluster.
  2. In the Management Studio left pane, expand the Security item, then expand the Logins item.
  3. Right-click in the Logins area and choose New Login. The Login - New dialog box appears.
  4. 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
  5. 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.
  6. In the Management Studio left pane, right-click the top-level server item and choose Properties. The Server Properties dialog box appears.
  7. Under Server Authentication, select SQL Server and Windows Authentication mode, and click OK.
  8. 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.