LicenseWatch FAQ

How should LicenseWatch connect to the SQL Server?

During setup you can choose between 2 connection methods:

• Use Windows NT Integrated security also known as Windows Authentication
• Use a specific user name and password also known as SQL Server Authentication

It is strongly recommended to use SQL Server Authentication. If you use Windows Authentication, then all the users that access the LicenseWatch UI must have privileges to access the database server. This will, in our experience, cause a lot of headache for the local system administrator.

When choosing SQL Server Authentication we recommend using the existing database user, sa. Alternatively, you must create a new database user with administrator privileges.