Team Pro Setup Instructions for MS SQL 2005

Using Team Pro with MS SQL 2005

 

This page contains Team Pro setup instructions for MS SQL 2005.  Instructions for other databases can be found here:

 

MS SQL 7.0
MS SQL 2000
MS SQL 2005
MySQL 4.1.x
MySQL 5.0
 
Oracle 8, 8i, 9i and 10g

 

 

Once you have your SQL Server in place, and have the SQL client software installed on all Team Client PCs, you are ready to set up your Team Pro database.

 

The following basic steps are required for setting up your SQL Server and SQL Database.

 

Create the SQL Database Login for Team

 

To create the SQL Database login for Team:

  1. Select the Security folder from the SQL Server tree
  2. Right-click on Logins
  3. Select New Login...
  4. In the General Tab, create a new login with:

    Name = team (lowercase)

    SQL Server Authentication = checked

    Password = <enter your password>

    Database = master

    Language = (default)

  5. Select OK to create the login.

 

Create the SQL Database

 

To create your SQL Database:

  1. Select the Databases folder from the SQL Server Tree.
  2. Right-click on Databases and select New Database.
  3. In the General Page, create the database with:

    Database Name = teamlog

    Owner = <default>

    Initial Size (MB) = 100

  4. Select OK to create your database.

    Note: You can use the defaults for all other settings when creating the database.

 

Create the Team Schema and Database User

 

To create the schema and database user:

  1. Select the Databases folder from the SQL Server Tree and expand to show databases.
  2. Select the team database (i.e. teamlog) and expand.
  3. Select the Security folder and expand.
  4. Right-click on Users and select New User.
  5. In the General Page, enter the following:

    User name = team

    Login name = team

    Default Schema = team

  6. Select OK to save.
  7. Still under the Security folder, select Schemas.
  8. Right-click on Schemas and select New Schema.
  9. On the General Page, enter the following:

    Schema name = team

    Schema owner = team

  10. Select OK to save.

 

Set Access and Permissions for the Database

 

To set proper access and permissions for the database:

  1. Select the Databases folder from the SQL Server tree.
  2. Right-click on the teamlog database and select Properties.
  3. On the Permissions Page, grant the following Permissions for the team user:

    Connect

    Create table

    Delete

    Execute

    Insert

    Select

    Update

  4. Select OK.

 

Set the Default Database for the Team User

 

To set the default database for the Team user:

  1. Select the Security folder from the SQL Server Tree.
  2. Select Logins.
  3. Right-click on the team login and select Properties.
  4. On the General Page, set the Default database to teamlog.
  5. On the User Mapping Page, verify that the following are set:
    • the teamlog database should be selected
    • the User should be set to team
    • the Default Schema should be set to team
    • public should be the only membership selected in the Database role Membership settings
  6. Select OK to save changes.

 

Test Your Connection Using the Server Management Studio

 

Test your connection using the Microsoft SQL Server Management Studio as follows:

  1. Run the Microsoft SQL Server Management Studio and login using your team login.
  2. Select the server corresponding to your team login.
  3. Select New Query from the toolbar.
  4. Enter the following command in the Query Tab:

    select @@version

  5. Select Execute from the toolbar and if you see information similar to:
Microsoft SQL Server 2005 - 9.00.1399.06 (Intel X86)
Oct 14 2005 00:33:37
Copyright (c) 1988-2005 Microsoft Corporation
Standard Edition on Windows NT 5.1 (Build 2600: Service Pack 2)

Your connection is good.

 

Connect Team To Your SQL Database and Upload Your Data

 

To connect Team to your SQL Database:

  1. Select TEAM Database Utility from the Alexsys Team Program Group or run TeamAdm.exe in the Alexsys Team server directory to open the Alexsys Team Database Utility.
  2. Login using the Team ADMIN User ID and password.
  3. Select the SQL Setup category.
  4. Select the Server Type (i.e. Microsoft SQL via ADO).
  5. Enter the Host Name.
  6. Enter the Server Name.
  7. Enter the User Name.
  8. Enter the Password.
  9. Select the Connect button.
  10. Once connected, select Upload to SQL to upload your existing standard Team database to your SQL database.
  11. Once uploaded, select Close to close the Alexsys Team Database Utility.

Tip: You must be running with the Standard database as the active database in order to upload your database to SQL. You do not want to make SQL your active database at this time.

 

Test Your Connection to SQL

 

Once you have uploaded your SQL database using the SQL Setup Utility, you can perform another test using Team without forcing all users to run SQL:

  1. Alter the  Team shortcut on your desktop by adding an /SQL parameter to the Target in the shortcut properties.  (i.e. "C:\Program Files\Alexsys\Team\Team.exe" /SQL)
  2. Start Team.
  3. Verify that Team is accessing the SQL database by selecting Help | System Information from the TeamView menu and selecting the Database Tab. You should see information for the SQL server you are accessing, similar to the figure below.
  4.  

    System Information - Database Tab - SQL Information Displayed

 

Make SQL the Active Database

 

Once your database has been uploaded to your SQL database and you have tested your connection to your SQL database using Team Pro, you can make SQL the active database to force all users to use Team Pro.

 

To make SQL the active database:

  1. Select TEAM Database Utility from the Alexsys Team Program Group or run TeamAdm.exe in the Alexsys Team server directory to open the Alexsys Team Database Utility.
  2. Login using the Team ADMIN User ID and password.
  3. Select the SQL Setup category.
  4. Connect to the SQL database by selecting the Connect button.
  5. Once connected, select SQL as the Active Database.
  6. Select Close to close the Alexsys Team Database Utility.
  7. Since SQL is now the active database, you can remove the /SQL argument from any Team shortcuts.