Need help?Do you have a question about the Cisco TMS SQL DATABASE and is the answer not in the manual?
Explains the numbering, structure, and applicability of tips within the document.
Details the various SQL Server versions relevant to Cisco TMS, including MSDE and Express editions.
Discusses command-line and GUI tools for managing SQL Server, such as osql and SSMS.
Explains which SQL Server versions were included with Cisco TMS installers historically.
Outlines the SQL Server versions compatible with different Cisco TMS releases.
Details the default naming and location of Cisco TMS database files (mdf, ldf).
Explains the concept of default and named SQL Server instances and how they are used.
Provides methods to find the name of a SQL Server instance using Windows Services or osql.
Describes SQL Server authentication modes (Windows vs. Mixed Mode) and TMS requirements.
Helps determine when to use a full SQL Server edition instead of free Express versions based on usage.
Details the syntax and usage of the osql command-line tool for Cisco TMS operations.
Provides practical examples of using osql for common Cisco TMS database tasks.
Guides on how to configure SQL Server to allow remote connections from other computers.
Explains how to configure Windows Firewall for SQL Server 2005, considering single and multiple instances.
Details firewall configuration for SQL Server 2000, including port usage and scenarios.
Provides instructions on how to perform full backups of the Cisco TMS database using the osql utility.
Explains how to restore the Cisco TMS database from a backup using the osql utility.
Guides on automating database backups using SQL 2005 Express and the expressmaint utility.
Describes how to detach and reattach Cisco TMS database files using osql for moving or copying.
Outlines the steps for upgrading from MSDE 2000 to SQL Server 2005 Express for Cisco TMS.
Details the manual installation of SQL Server 2005 Express as an upgrade path for Cisco TMS.
Describes the advantages of performing a quicker manual SQL Server installation.
Lists the disadvantages of performing a manual SQL Server installation for Cisco TMS.
Explains how to use the Cisco TMS installer to perform the SQL Server upgrade.
Provides SQL scripts to update indexes and statistics after database upgrades for performance.
Details how to reset or change the 'sa' user password for the Cisco TMS SQL Server.
To Next Page
General