Cisco Cisco TelePresence Management Suite (TMS) Version 15 Troubleshooting Guide

Page of 6
Configure TMS to Use Windows Authentication for
External SQL Server
Document ID: 117817
Contributed by Shannon Beard, Cisco TAC Engineer.
Jul 09, 2014
Contents
Introduction
     Requirements
     Components Used
Configure Windows Authentication for TMS connection to the TMSNG (and TMSPE) databases
     Configuration
Introduction
In order to configure the Telepresence Management Suite (TMS) to use Windows Authentication for External
Structured Query Language (SQL) Server, you must change the IIS application user identity to a network
service account. This document describes how to configure TMS to use Windows Authentication for the
External SQL Server.
Requirements
There are no specific requirements for this document.
Components Used
The information in this document is based on these software and hardware versions:
Windows Server 2003, Windows Server 2008 R2 running Active Directory
• 
Windows Server running SQL Server 2005 or later.
• 
Windows Server 2003 (IIS 6) or Windows Server 2008 R2 (IIS 7) running TMS software.
• 
The information in this document was created from the devices in a specific lab environment. All of the
devices used in this document started with a cleared (default) configuration. If your network is live, make sure
that you understand the potential impact of any command.
Configure Windows Authentication for TMS connection to
the TMSNG (and TMSPE) databases
If a customer would like to use Windows Authentication for TMS connection to the TMSNG and TMS
Provisioning Extension (TMSPE) databases; you must change the IIS application user identity to a network
service account to create a login in SQL.