Database Creation

AppDNA stores data in a Microsoft SQL Server database. The Database Creation step in the Configure AppDNA Environment wizard configures the database.

Note: The wizard creates the new database in the default database file location set in SQL Server. To store the database files in a different location, change the default location in SQL Server before you run the wizard.

Server name – Enter this as Machine\Instance, where Machine is the name of the machine that hosts the SQL Server installation and Instance is the SQL Server instance if a named instance is in use. If a named instance is not in use, omit the backslash (\). If the SQL Server uses a non-standard port, specify it using the Machine,Port notation, where Port is the custom port number.

Database name – The name of the new database. If the database administrator has created an empty database for you to use, enter its name here. Otherwise accept the default name, AppDNADB, or enter a name that does not already exist within the SQL Server instance.

Database authentication – The credentials for connecting to SQL Server when creating the database. The user account must have the sysadmin server role.

  • Windows authentication – This type of authentication uses the logged on Windows user account when connecting to SQL Server. When using this type of authentication, the logged on user must have a Windows user account that has a password set.
  • SQL Server authentication – Enter the user name and password to use to connect to SQL Server and create the database and database tables.

Database Creation