Cisco TMS SQL DATABASE

To Next Page

To Previous Page

Tips category – Networking

Cisco TMS Database Knowledge Tips Page 21 of 35

Extra reference links

How to configure an instance of SQL Server to listen on a specific TCP port or a dynamic port

Main Page

Table of Contents2
Tip Format5
TIP T100 -Different Types of SQL Server6
- Extra Reference Links6
- TIP T101 -SQL Server Management Tools7
- Extra Reference Links7
TIP T103 -SQL Versions Bundled with Cisco TMS8
TIP T104 -Cisco TMS SQL Version Compatibility9
TIP T105 -Cisco TMS Database and Files10
TIP T106 -The SQL Server Instance11
TIP T107 - Identifying the SQL Server Instance Name12
TIP T108 -SQL Authentication Modes13
- Extra Reference Links13
Tip T109 -When Do I Need a Full Version of SQL14
- Extra Reference Links14
TIP T109 -Using Osql for Cisco TMS Tasks15
- Simple Examples for Cisco TMS Use16
- Extra Reference Links16
TIP T200 -Enabling Remote Access to SQL17
- Extra Reference Links17
TIP T201 -SQL Server 2005 and Firewalls18
- Possible Scenarios18
- Using Windows Firewall for a Single Instance18
- Using Windows Firewall for Multiple Instances18
- Extra Reference Links19
TIP T202 -SQL Server 2000 and Firewalls20
- Possible Scenarios20
- Using Windows Firewall for Single Instance20
- Using Windows Firewall for Multiple Instances20
- To Find the Port a SQL Server Instance Is Currently Using20
- Extra Reference Links21
TIP T300 -Backing up the Cisco TMS Database Using Osql22
- Extra Reference Links22
TIP T301 -Restoring the Cisco TMS Database Using Osql23
- Restoring a Database to the same SQL Server23
- Restoring a Database to a Different SQL Server23
- Extra Reference Links24
TIP T302 -Automating Backups with SQL 2005 Express25
- Extra Reference Links26
TIP T303 -Detaching and Reattaching Databases27
- To Detach the Cisco TMS Database Using Osql27
- To Attach the Cisco TMS Database Using Osql27
- Extra Reference Links27
TIP T304 -Upgrading MSDE 2000 to SQL 2005 Express28
- Cisco TMS Customers Running MSDE 2000 and Cisco TMS Versions 9.0 through 10.028
- Cisco TMS Customers Running MSDE 2000 and Cisco TMS Versions 11.0 through 11.9.129
- Alternative 1 - Install SQL Server Manually29
- Pros29
- Cons30
- Alternative 2 - Use Cisco TMS Installer to Install SQL Server31
- Pros31
- Cons31
- SQL Code to Update Indexes and Statistics32
- Extra Reference Links33
TIP T305 -Resetting/Changing/Forgotten Sa Password34
- Extra Reference Links34
- Table of Contents Page 2 of35

Table of Contents

Related product manuals