Authentication types

The authentication type determines how the system validates a user's logon information. Alloy Discovery supports both Windows and standard SQL authentication:

Authentication Type Description


With Windows authentication, users do not need to type in their user name and password to log on to Alloy Discovery because the system authenticates users with their current Windows credentials. This authentication method can be used in Windows domain-based networks only.

Standard (SQL Server)

With standard SQL Server authentication, each user has to type in a user name and password to log on to Alloy Discovery. In this case, authentication occurs by matching supplied credentials against accounts residing on the SQL server. Standard SQL Server authentication can be used in any network.

In order to support standard authentication, the SQL Server must be configured to operate in the Mixed Mode.

IMPORTANT: Your Microsoft SQL Server can be installed either in Mixed Mode, which supports both Windows and standard SQL Server authentication, or in Windows Authentication Mode, which supports Windows authentication only. You can always switch the authentication mode for an already installed instance of SQL Server. For details, see Installation Guide: Authentication Types.