This procedure guides you through the installation of IDERA Newsfeed only and none of the additional components used with SQLDM Mobile. Use this solution in a larger environment where your SQL Server team or environment is spread across multiple locations and you need an easier, more streamlined way to troubleshoot issues. The IDERA Newsfeed can help you capture or bookmark the team resolutions for future reference. You can implement this option without need to allot the additional hardware and IIS resources necessary to deploy a complete, mobile-available solution.
Before installing Newsfeed, review the associated architecture and components.
Install or upgrade to SQL Diagnostic Manager 10.4
The IDERA Newsfeed technology is supported by SQL Diagnostic Manager 7.0 and above versions. To successfully install and deploy IDERA Newsfeed, first install or upgrade to SQL Diagnostic Manager 10.4.
Start your IDERA Newsfeed install
Before installing Newsfeed, review the associated architecture and components. You can install the IDERA Newsfeed on any computer that meets or exceeds the product requirements. By default, the SQLDM Mobile and Newsfeed setup program installs the SQLDM Mobile and Newsfeed Service to the local computer.
To start installing IDERA Newsfeed:
- Log on with an administrator account to the computer on which you want to install the SQLDM Mobile and Newsfeed Service.
- Run
Setup.exe
in the root of the SQL Diagnostic Manager installation kit. - Click SQLDM Mobile and Newsfeed on the Quick Start window.
- On the Welcome window of the SQLDM Mobile and Newsfeed setup program, click Next.
- Review the license agreement. To accept this license agreement, click I accept the terms in the license agreement, and then click Next.
Begin configuring your install
You can use the default install location or specify a different path. For your first install, we recommend using the default location. By default, the SQLDM Mobile and Newsfeed Service is also installed in the same location.
On the Custom Setup window, choose the Mobile and Newsfeed components, and then click Next.
Add the Windows credentials to use for the SQLDM Mobile and Newsfeed Service account
You can specify the Local System account or a Windows user account. Make sure the specified account includes the required permissions.
To specify a service account:
- Select the Local System account or type the appropriate credentials in the provided fields.
- Click Test Credentials to validate the account.
- Click Next.
Select the SQL Server instance to use for the Repository database
The IDERA Newsfeed Repository is where the published status updates and other configuration settings are stored.
SQLdm Mobile requires Microsoft SQL Server 2005 or above running on the computer that hosts the Newsfeed Repository database.
To specify the SQL Server instance to install the SQL Diagnostic Manager Repository on:
- Select the SQL Server instance you want to use. The SQL Server menu lists SQL Server instances provided by your domain controller. If you do not see your SQL Server instance in the list , type the host name and instance in the space provided.
- Click Next.
Add the authentication credentials to create the Repository database
You can use either Windows or SQL Authentication to create the Newsfeed Repository database. Make sure the specified Windows account includes the required permissions.
To specify a service account:
- Choose the authentication that you want to use, and then type the appropriate credentials in the provided fields.
- Click Test Connection to validate the account can connect to the specified SQL Server instance.
- Click Next.
Add the authentication credentials to connect to the Repository database at run time
You can use either Windows or SQL Authentication to connect to the Newsfeed Repository database. Make sure the specified Windows account includes the required permissions.
To specify a service account:
- Choose the authentication that you want to use, and then type the appropriate credentials in the provided fields.
- Click Test Connection to validate the account can connect to the specified SQL Server instance.
- Click Next.
Select a location for the SQLDM Management Service
SQLDM Mobile uses its own Authentication Provider to enforce application security across your SQL Diagnostic Manager and IDERA Newsfeed deployments.
On the Authentication Provider window, specify the computer that hosts the SQLDM Management Service, and then click Next.
Complete the Newsfeed install
Click Install to indicate that you are ready to complete your install with the configurations you specified.