Creating a Windows domain account for the Spotfire database

Creating a Windows domain account for the database is the first step in setting up Kerberos authentication for database connections.

Before you begin

See Using Kerberos to log in to the Spotfire database for the list of prerequisites.

Procedure

Log in to Windows with one of the following accounts:
- A domain administrator
- A user who is a member of the built-in Account Operators domain group
- A user with equivalent privileges
Launch the Active Directory Users and Computers MMC snap-in and create a normal user account with the following properties:
- Use the same identifier in the Full name, User logon name, and User logon name (pre‐Windows 2000) fields.
  Note: Make sure to use only lowercase characters, and leave no spaces in these fields.
- Select the Password never expires check box.
- Clear the User must change password at next logon check box.
- Recommended: Select the Account is sensitive and cannot be delegated check box.

What to do next

SQL Server database: Edit and run the create_databases_ia.bat script. This creates a SQL Server database account and connects it to the previously created Windows domain account. For instructions, see Setting up the Spotfire database (SQL Server with Integrated Windows authentication).
If you are using Oracle database: Edit and run the create_databases.bat script. This will create a normal Oracle database account that authenticates with user name and password; for instructions on creating the database account, see Setting up the Spotfire database (Oracle).

JavaScript must be enabled in order to use this site.Please enable JavaScript in your browser and refresh the page.

Creating a Windows domain account for the Spotfire database

Creating a Windows domain account for the database is the first step in setting up Kerberos authentication for database connections.

Before you begin

See Using Kerberos to log in to the Spotfire database for the list of prerequisites.

Procedure

Log in to Windows with one of the following accounts:
- A domain administrator
- A user who is a member of the built-in Account Operators domain group
- A user with equivalent privileges
Launch the Active Directory Users and Computers MMC snap-in and create a normal user account with the following properties:
- Use the same identifier in the Full name, User logon name, and User logon name (pre‐Windows 2000) fields.
  Note: Make sure to use only lowercase characters, and leave no spaces in these fields.
- Select the Password never expires check box.
- Clear the User must change password at next logon check box.
- Recommended: Select the Account is sensitive and cannot be delegated check box.

What to do next

SQL Server database: Edit and run the create_databases_ia.bat script. This creates a SQL Server database account and connects it to the previously created Windows domain account. For instructions, see Setting up the Spotfire database (SQL Server with Integrated Windows authentication).
If you are using Oracle database: Edit and run the create_databases.bat script. This will create a normal Oracle database account that authenticates with user name and password; for instructions on creating the database account, see Setting up the Spotfire database (Oracle).