DBTuna for SQL Server Requirements

DBTuna for SQL Server will monitor any SQL Server database later in version than SQL Server 2000 service pack 3.

Requirements for the DBTuna monitoring user:

SQL Server Authentication: If your SQL Server database allows mixed-mode authentication, then the DBTuna user can use a SQL Server username/password authenticated account, or you can use the default sa account. If you create a new account, then make sure it has access to all databases (so that you can run explain plans, and browse objects etc.)

Windows Authentication: If you would like to use a Windows authenticated account to connect to the SQL Server database, the following is required:

• When creating the agent in agent manager, do not specify a username and password.
• Configure the DBTuna agent windows service to log on as the desired windows account with SQL Server access. Go to the Windows Services GUI from Control Panel. Select the DBTuna Agent service and right click to display the properties. Click on "Log On" and then enter the credentials for the user.
• Configure the DBTuna GUI windows service to log on as the desired windows account with SQL Server access. Go to the Windows Services GUI from Control Panel. Select the DBTuna GUI service and right click to display the properties. Click on "Log On" and then enter the credentials for the user.

N.B. If you are running your DBTuna software on Linux or Solaris, then you must use SQL Server authentication.