MS SQL Server: Connecting with Windows Authentication

This requires being connected to your database server and Data Admin privileges.

iDashboards connects to MS SQL Server databases using SQL Server Authentication, by default. This will assist in the process of connecting to MS SQL Server using Windows Authentication.

Configuring iDashboards as a Network Account

Connecting SQL Server with Windows Authentication

Configuring iDashboards as a Network Account

All Tomcat services are registered to run as the System User called the Local System account, by default. When configured with this account iDashboards cannot connect to SQL Server using Windows Authentication, only SQL Server Authentication. The first step is to prepare a network account (typically a Service Account) and add it to your SQL Server user with at least read permissions to the database(s) that you wish to connect to. Next to configure the service to logon as that account:

1. Click Start -> Run, type in services.msc
   • You can also launch services by: Start -> Control Panel -> Administrative Tools -> Services
   • You can also launch services by: Right click Task Bar -> Task Manager -> Services then either: at the bottom Open Services or right click anywhere in the Services tab and Open Services
2. Depending on the nature of your installation, your service may be named one of the following:
   
   • iDashboards Evaluation Server
   • iDashboards Server
   • Apache Tomcat
3. Right click the service name and select Properties
4. Click Log On and fill in the information for the new service account (see below screenshot)
   • You can click Browse if necessary to search for the User
     
5.  To apply the new credentials click OK and close the Properties
6. Restart the service and iDashboards is now logging in as your configured service account

Configuring iDashboards as a Network Account

Connecting SQL Server with Windows Authentication

Once you have configured the application to log on as a network account with at least read permissions to your desired database(s), you can make a data source connection in iDashboards using Windows Authentication. Follow these steps to make the connection:

1. Login to iDashboards Admin or Data Hub and click Data Sources
2. Download: Microsoft SQL Server JDBC Driver
3. Copy the driver, which is implemented as a .jar file, to the following location:
4. <iDashboards Installation Folder>\ivizgroup\drivers
5. Restart the iDashboards service (iDashboardsSRV)
6. Login to iDashboards Admin or Data Hub
7. Select Data Sources
8. Click New
9. Set the Data Source Type to MS SQL Server 2000-2016
10. In the Create a Data Source window, enter the highlighted information:ReadUser: Leave blank to use Windows Authentication
    Password/Confirm Password: Leave blank to use Windows Authentication
11. Click Save, your data source is now available

For More Information:

• iDashboards Admin Manual 10. Managing Data Sources
• Microsoft Windows Connecting Through Windows Authentication

Disclaimer: iDashboards Technical Support Engineers are not Database Administrators who know in depth knowledge of them and their quirks. We often learn these skills on the job and have limited knowledge. We do our best to help you with your software in determining if: you are not leveraging the software in the best way for your data or you found a bug in the software, because we want to assist you in your success.

If the above is unable to resolve the issue, then please contact iDashboards Support for further assistance.

Configuring iDashboards as a Network Account

Connecting SQL Server with Windows Authentication