Sql Server

Installation and configuration of Microsoft SQL-Server for TeamViewer Manager

Table of contents:
1 2 3 4 5 6 Important steps for installing SQL Server 2005 ............................................................................................... 2 Final configuration steps for SQL Server 2005................................................................................................ 4 Configuration of existing SQL Server 2005 installations ................................................................................. 6 Important steps for installing SQL Server 2008 ............................................................................................... 8 Final configuration steps for SQL-Server 2008.............................................................................................. 12 Configuration of existing SQL Server 2008 installations ................................................................................ 14

© 2012 TeamViewer GmbH, as of 09/2012

Important: For security reasons, Microsoft recommends that you do not install SQL Server on a domain controller. You can find further information on the following websitehttp://technet.microsoft.com/engb/library/ms144228.aspx.

1

Important steps for installing SQL Server 2005

TeamViewer Manager uses SQL server authentication for accessing the database. During the installation, please activate Mixed Mode which enables both Windows Authentication and SQL server authentication. Moreover, when using Named Instances the SQL-Browser service has to be started. The followingpages illustrate the relevant steps for making the required setting during the installation process.

Registration Information In the installation step Registration Information you would have to uncheck the checkbox Hide

advanced configuration options to be able to take
the necessary configuration steps.

2

Instance Name In the installation step Instance Name you can choose betweenDefault instance and Named

instance. When choosing Named instance please
enter the instance name - it will be needed for the configuration of the TeamViewer Manager database later on. (Instance names allow multiple parallel installations of Microsoft SQL Server. In case you use the Express Edition, the standard instance name is SQLEXPRESS.)

Service Account Please activate the checkbox SQLBrowser in the installation step Service Account.

Authentication Mode In the step Authentication Mode please select

Mixed Mode and set a password (system
administrator account). This information will be needed later on for the database configuration of TeamViewer Manager. Please proceed with the next steps and finish the installation.

3

2 Final configuration steps for SQL Server 2005After the installation of Microsoft SQL-Server 2005 please make sure that remote computers can access the SQL server.  Open the SQL Server 2005-Surface Area Configuration (Start | All Programs | Microsoft SQL Server 2005 | Configuration Tools | SQL Server- Surface Area Configuration)  Please click on Surface Area Configuration for Services and Connections

4

 

Navigate to the node[Instance Name] | Database Engine | Remote Connections in the tree structure on the left side. Activate Local and remote connections as well as the sub item Using both TCP/IP and named pipes and click on Apply.



Switch back to [Instance Name] | Database Engine | Service and then click on Stop and Start one after
another to restart the SQL server and for the changes to take effect. Click on OKto close the dialog.

Detailed information by Microsoft can be found at: http://support.microsoft.com/kb/914277

5

3

Configuration of existing SQL Server 2005 installations

If you would like to use an existing installation of SQL Server 2005 you might have to change some settings as described below: How to activate the Mixed Mode:         Press Windows-R to open the Run......