{"id":999,"date":"2017-12-22T15:52:12","date_gmt":"2017-12-22T20:52:12","guid":{"rendered":"http:\/\/64.23.56.53\/wp\/?page_id=999"},"modified":"2017-12-23T23:54:32","modified_gmt":"2017-12-24T04:54:32","slug":"setup","status":"publish","type":"page","link":"http:\/\/alexsys.team\/index.php\/setup\/","title":{"rendered":"Setup Instructions"},"content":{"rendered":"
\n\t\t\n\t\t
\n

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.<\/p>\n

The following basic steps are required for setting up your SQL Server and SQL Database.<\/p>\n<\/div>

\n\t\t

Install\/Configure Microsoft SQL Server 7.0<\/h3>\n\t\t
\n\t\t\t

\n

Install Microsoft SQL Server v7.0 on to a server running Windows NT 4.0 Service Pack 4 or later.<\/p>\n

Prior to running Team with SQL 7.0, you must make sure that the MS SQL 7.0 Client software is installed on all client PCs that will be running Team Pro for SQL 7.0.<\/p>\n

Once the SQL Server is installed, use the Windows Start menu to select and start the SQL Enterprise Manager<\/strong> from the Microsoft SQL Server 7.0<\/strong> program group to set up your SQL database.<\/p>\n

Register Your SQL Server<\/strong><\/em><\/p>\n

To register your SQL Server:<\/p>\n

1. Click on your Server Group<\/strong> to open the Getting Started Taskpad<\/strong>.
2. Select Administer SQL Server<\/strong>.
3. Select Register a Server<\/strong>, then use the Wizard<\/strong> to:
a. Enter your Server Name<\/strong> and select Add><\/strong>.
b. Select the appropriate Authentication Mode<\/strong> (use the default).
c. Select the Server Group<\/strong> you want to register your server in.
 \n

Create the SQL Database<\/strong><\/em><\/p>\n

To create your SQL Database:<\/p>\n

1. Expand your MS Server Tree<\/strong> to Databases<\/strong> on your server.
2. Right-click on Databases and select New Database<\/strong>.
3. In the General Tab<\/strong>, enter your database name<\/strong> (ie. teamlog).
4. Select the Data Files<\/strong> tab.
5. Enter an initial database size<\/strong> = 100 MB.
6. Select OK<\/strong> to create your database.<\/p>\n

** you can use the defaults for all other settings when creating the database **<\/span><\/p>\n

 \n

Create the SQL Database Login for Team<\/strong><\/em><\/p>\n

To create the SQL Database login for Team:<\/p>\n

1. From the left browser panel, select the server<\/strong>.
2. Select the Security<\/strong> folder.
3. Right-click on Logins<\/strong>.
4. Select New Login…<\/strong>
5. From the General Tab<\/strong>, create a new login with:<\/p>\n

Name<\/strong> = team (lowercase)
SQL Server Authentication<\/strong> = checked
Password<\/strong> = team
Database<\/strong> = teamlog
Language<\/strong> = (default)<\/p>\n

6. Select OK<\/strong>.
 \n

Set Access and Permissions for the Database<\/strong><\/em><\/p>\n

To set proper access and permissions for the database:<\/p>\n

1. From the left browser panel, select the Security<\/strong> folder, then:
a. Select Logins<\/strong>.
b. Right-click on the team<\/strong> login and select Properties<\/strong>.
c. Select the Database Access Tab<\/strong>.
d. Select the teamlog<\/strong> database, then select public<\/strong> for the access.
2. From the left browser panel, select the Databases<\/strong> folder, then:Right-click on the teamlog<\/strong> database and select Properties<\/strong>.
Select the Permissions Tab<\/strong>.
Select all the permissions<\/strong> for the team<\/strong> login as follows:<\/p>\n

Create table<\/strong>
Create view<\/strong>
Create SP<\/strong>
Create Default<\/strong>
Create Rule<\/strong>
Backup DB<\/strong>
Backup Log<\/strong><\/p>\n

3. Select OK<\/strong>.
 \n

Test Your Connection Using Query Analyzer<\/strong><\/em><\/p>\n

Test your connection using the Windows Start menu to select and start the Query Analyzer<\/strong> from the Microsoft SQL Server 7.0<\/strong> program group.<\/p>\n

Once the program is started:<\/p>\n

1. Select your server<\/strong>.
2. Select Use SQL Server authentication<\/strong>.
3. Enter the Login Name <\/strong>: team<\/strong>.
4. Enter the Password<\/strong> : team<\/strong>.
5. Select OK<\/strong>.
6. Once the connection is established, test it by entering the following command in the Query Tab<\/strong>:
select @@version<\/strong><\/p>\n


7. Select the Execute Query<\/strong> button (green arrow) and if you see information similar to:
Microsoft SQL Server 7.00 – 7.00.623 (Intel X86)<\/span>
Nov 27 1998 22:20:07<\/span>
Copyright (c) 1988-1998 Microsoft Corporation<\/span>
Standard Edition in Windows NT 4.0 (Build 1381: Service Pack 4)<\/span><\/p>\n

Your connection is good.<\/p>\n

 \n

Connect Team To Your SQL Database<\/strong><\/em><\/p>\n

To connect Team to your SQL Database:<\/p>\n

1. Select Admin | Database Utility<\/strong> from the TeamView or Work Request menus or start TEAM Database Utility<\/strong> from the Alexsys Team Program Group to open the Alexsys Team Database Utility<\/strong>. Remember to log off of Team after you open the Database Utility.
2. Select the SQL Setup<\/strong> category from the Alexsys Team Database Utility window (see figure below).
 \n

Alexsys Team Database Utility – SQL Setup<\/strong><\/p>\n

\"\"<\/p>\n

3. Select the Server Type<\/strong> (i.e. MS-SQL).
4. Enter the Host Name<\/strong> (i.e. Server_2).
5. Enter the Server Name<\/strong> (i.e. Server_2).
6. Enter the Database Name<\/strong> (i.e. Log).
7. Enter the User Name<\/strong> (i.e. team in lowercase).
8. Enter the Password<\/strong>.
9. Select the Connect<\/strong> button.<\/p>\n

If Team can connect to your SQL database on the SQL server, Connected<\/strong> will be displayed in the area next to the Connect button.<\/p>\n

 \n

Upload Your Existing Team Database to SQL<\/strong><\/em><\/p>\n

When you are ready to run Team using your SQL database, you must connect Team to the SQL server and upload your database to SQL. Once this is done and you do one final test to check your connection to SQL using Team, you can force all users to run Team Pro by switching the active database to SQL.<\/p>\n

To connect to the SQL database and upload your existing data:<\/p>\n

1. Select Admin | Database Utility<\/strong> from the TeamView or Work Request menus or start TEAM Database Utility<\/strong> from the Alexsys Team Program Group to open the Alexsys Team Database Utility<\/strong>. Remember to log off of Team after you open the Database Utility.
2. Select the SQL Setup<\/strong> category from the Alexsys Team Database Utility window.
3. Select the Connect<\/strong> button.
4. Once connected, select the Upload to SQL<\/strong> button to upload your existing standard Team database to your SQL database.
  \n

\n

You must be running with the Standard<\/strong> 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.<\/em><\/p>\n

\n


5. Once uploaded, select Cancel<\/strong> to close the Alexsys Team Database Utility.
 \n

Test Your Connection to Team Pro<\/strong><\/em><\/p>\n

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:<\/p>\n

1. Alter the Team<\/strong> 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<\/strong> from the TeamView menu and selecting the Database Tab<\/strong> (see figure below). You should see information for the SQL server you are accessing.
 \n

System Information – Database Tab – SQL Information Displayed<\/strong><\/p>\n

<\/p>\n

 \n

Make SQL the Active Database<\/strong><\/em><\/p>\n

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.<\/p>\n

To make SQL the active database:<\/p>\n

1. Select Admin | Database Utility<\/strong> from the TeamView or Work Request menus or start TEAM Database Utility<\/strong> from the Alexsys Team Program Group to open the Alexsys Team Database Utility.  Remember to log off of Team after you open the Database Utility.
2. Select the SQL Setup<\/strong> category from the Alexsys Team Database Utility window.
3. Connect to the SQL database by selecting the Connect<\/strong> button.
4. Once connected, select SQL<\/strong> as the Active Database<\/strong> (see figure below).
 \n

Alexsys Team Database Utility – SQL Active Database<\/strong><\/p>\n

\"\"<\/p>\n

5. Select Close<\/strong> to close the Alexsys Team Database Utility.
6. Since SQL is now the active database, you can remove the \/SQL argument from any Team shortcuts.<\/p>\n<\/p>\n\t\t<\/div>\n\t\t

Install\/Configure Microsoft SQL Server 2000<\/h3>\n\t\t
\n\t\t\t

\n

Install Microsoft SQL Server 2000 on your server.<\/p>\n

Prior to running Team with SQL 2000, you must make sure that the MS SQL 2000 Client software is installed on all client PCs that will be running Team Pro for SQL 2000 and that you have the proper SQL licensing.<\/p>\n

Once the SQL Server is installed, use the Windows Start menu to select and start the SQL Server Enterprise Manager<\/strong> from the Microsoft SQL Server<\/strong> program group to set up your SQL database.<\/p>\n

 \n

Create the SQL Database<\/strong><\/em> \n

To create your SQL Database:<\/p>\n

1. Expand your MS Server Tree<\/strong> to Databases<\/strong> on your server.
2. Right-click on Databases<\/strong> and select New Database<\/strong>.
3. In the General Tab<\/strong>, enter your database name<\/strong> (ie. teamlog).
4. Select the Data Files<\/strong> tab.
6. Enter an initial database size<\/strong> = 100 MB.
6. Select OK<\/strong> to create your database.<\/p>\n

** you can use the defaults for all other settings when creating the database **<\/span><\/p>\n

 \n

Create the SQL Database Login for Team<\/em><\/strong><\/p>\n

To create the SQL Database login for Team:<\/p>\n

1. Select the Security<\/strong> folder from the SQL Server tree<\/strong>
2. Right-click on Logins<\/strong>.
3. Select New Login…<\/strong>
4. In the General Tab<\/strong>, create a new login with:<\/p>\n

Name<\/strong> = team (lowercase)
SQL Server Authentication<\/strong> = checked
Password<\/strong> = team
Database<\/strong> = teamlog
Language<\/strong> = (default)<\/p>\n

5. Select OK<\/strong> to create the login.
 \n

Set Access and Permissions for the Database<\/strong><\/em><\/p>\n

To set proper access and permissions for the database:<\/p>\n

1. Select the Database Access<\/strong> tab.
2. Select the teamlog<\/strong> database (check this database).
3. Select OK<\/strong>.
4. Enter your password<\/strong> (i.e. team).
5. Select the Database<\/strong> folder from the SQL Server tree<\/strong>.
6. Right-click on teamlog<\/strong> database and select Properties<\/strong>.
7. Select the Permissions Tab<\/strong>.
8. Select permissions for the team login as follows:<\/p>\n

Create table<\/strong>
Create view<\/strong>
Create SP<\/strong>
Create Default<\/strong>
Create Rule<\/strong>
Create Function<\/strong>
Backup DB<\/strong>
Backup Log<\/strong><\/p>\n

9. Select OK<\/strong>.
 \n

Test Your Connection Using Query Analyzer<\/strong><\/em><\/p>\n

Test your connection using the Windows Start menu to select and start the Query Analyzer<\/strong> from the Microsoft SQL Server<\/strong> program group.<\/p>\n

Once the program is started:<\/p>\n

1. Select your server<\/strong>.
2. Select Use SQL Server authentication<\/strong>.
3. Enter the Login Name<\/strong>: team<\/strong>.
4. Enter the Password<\/strong> : team<\/strong>.
5. Select OK<\/strong>.
6. Once the connection is established, test it by entering the following command in the Query Tab<\/strong>:<\/p>\n

select @@version<\/strong><\/p>\n

7. Select the Execute Query<\/strong> button (green arrow) and if you see information similar to:<\/p>\n

Microsoft SQL Server 2000 – 8.00.194 (Intel X86)<\/span>
Aug 6 2000 00:57:48<\/span>
Copyright (c) 1988-2000 Microsoft Corporation<\/span>
Standard Edition on Windows NT 5.0 (Build 2195: Service Pack 1)<\/span><\/p>\n

Your connection is good.<\/p>\n

 \n

Connect Team To Your SQL Database<\/strong><\/em><\/p>\n

To connect Team to your SQL Database:<\/p>\n

1. Select Admin | Database Utility<\/strong> from the TeamView or Work Request menus or start TEAM Database Utility<\/strong> from the Alexsys Team Program Group to open the Alexsys Team Database Utility. Remember to log off of Team after you open the Database Utility.
2. Select the SQL Setup<\/strong> category from the Alexsys Team Database Utility window (see figure below).
 \n

Alexsys Team Database Utility – SQL Setup<\/strong><\/p>\n

\"\"<\/p>\n

 \n

3. Select the Server Type<\/strong> (i.e. MS-SQL).
4. Enter the Host Name<\/strong> (i.e. Server_2).
5. Enter the Server Name<\/strong> (i.e. Server_2).
6. Enter the Database Name<\/strong> (i.e. Log).
7. Enter the User Name<\/strong> (i.e. team in lowercase).
8. Enter the Password<\/strong>.
9. Select the Connect<\/strong> button.<\/p>\n

If Team can connect to your SQL database on the SQL server, Connected<\/strong> will be displayed in the area next to the Connect button.<\/p>\n

 \n

Upload Your Existing Team Database to SQL<\/strong><\/em><\/p>\n

When you are ready to run Team using your SQL database, you must connect Team to the SQL server and upload your database to SQL. Once this is done and you do one final test to check your connection to SQL using Team, you can force all users to run Team Pro by switching the active database to SQL.<\/p>\n

To connect to the SQL database and upload your existing data:<\/p>\n

1. Select Admin | Database Utility<\/strong> from the TeamView or Work Request menus or start TEAM Database Utility<\/strong> from the Alexsys Team Program Group to open the Alexsys Team Database Utility<\/strong>. Remember to log off of Team after you open the Database Utility.
2. Select the SQL Setup<\/strong> category from the Alexsys Team Database Utility window.
3. Select the Connect<\/strong> button.
4. Once connected, select the Upload to SQL<\/strong> button to upload your existing standard Team database to your SQL database.
  \n

\n

You must be running with the Standard<\/strong> 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.<\/em><\/p>\n

\n

5. Once uploaded, select Cancel<\/strong> to close the Alexsys Team Database Utility.
 \n

Test Your Connection to Team Pro<\/em><\/strong><\/p>\n

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:<\/p>\n

1. Alter the Team<\/strong> 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<\/strong> from the TeamView menu and selecting the Database Tab<\/strong> (see figure below). You should see information for the SQL server you are accessing.
 \n

System Information – Database Tab – SQL Information Displayed<\/strong><\/p>\n

\"\"<\/p>\n

 \n

Make SQL the Active Database<\/strong><\/em><\/p>\n

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.<\/p>\n

To make SQL the active database:<\/p>\n

1. Select Admin | Database Utility<\/strong> from the TeamView or Work Request menus or start TEAM Database<\/strong> Utility from the Alexsys Team Program Group to open the Alexsys Team Database Utility. Remember to log off of Team after you open the Database Utility.
2. Select the SQL Setup<\/strong> category from the Alexsys Team Database Utility window.
3. Connect to the SQL database by selecting the Connect<\/strong> button.
4. Once connected, select SQL<\/strong> as the Active Database<\/strong> (see figure below).
 \n

Alexsys Team Database Utility – SQL Active Database<\/strong><\/p>\n

\"\"<\/p>\n

5. Select Close<\/strong> to close the Alexsys Team Database Utility.
6. Since SQL is now the active database, you can remove the \/SQL argument from any Team shortcuts.<\/p>\n

 \n<\/p>\n\t\t<\/div>\n\t\t

Install\/Configure Microsoft SQL 2005<\/h3>\n\t\t
\n\t\t\t

\n

Create the SQL Database Login for Team<\/strong><\/em><\/p>\n

To create the SQL Database login for Team:<\/p>\n

1. Select the Security<\/strong> folder from the SQL Server tree<\/strong>
2. Right-click on Logins<\/strong>
3. Select New Login…<\/strong>
4. In the General Tab<\/strong>, create a new login with:<\/p>\n

Name<\/strong> = team (lowercase)
SQL Server Authentication<\/strong> = checked
Password<\/strong> =
Database<\/strong> = master
Language<\/strong> = (default)<\/p>\n

5. Select OK<\/strong> to create the login.
 \n

Create the SQL Database<\/strong><\/em><\/p>\n

To create your SQL Database:<\/p>\n

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

Database Name<\/strong> = teamlog
Owner<\/strong> =
Initial Size (MB)<\/strong> = 100<\/p>\n

4. Select OK<\/strong> to create your database.
Note:<\/strong> You can use the defaults for all other settings when creating the database.<\/span>
 \n

Create the Team Schema and Database User<\/strong><\/em><\/p>\n

To create the schema and database user:<\/p>\n

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

User name<\/strong> = team
Login name<\/strong> = team
Default Schema<\/strong> = team<\/p>\n

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

Schema name<\/strong> = team
Schema owner<\/strong> = team<\/p>\n

10. Select OK<\/strong> to save.
 \n

Set Access and Permissions for the Database<\/strong><\/em><\/p>\n

To set proper access and permissions for the database:<\/p>\n

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

Connect<\/strong>
Create table<\/strong>
Delete<\/strong>
Execute<\/strong>
Insert<\/strong>
Select<\/strong>
Update<\/strong><\/p>\n

4. Select OK<\/strong>.
 \n

Set the Default Database for the Team User<\/strong><\/em><\/p>\n

To set the default database for the Team user:<\/p>\n

1. Select the Security<\/strong> folder from the SQL Server Tree.
2. Select Logins<\/strong>.
3. Right-click on the team<\/strong> login and select Properties<\/strong>.
4. On the General Page<\/strong>, set the Default database<\/strong> to teamlog<\/strong>.
5. On the User Mapping Page<\/strong>, verify that the following are set:<\/p>\n

• the teamlog<\/strong> database should be selected
• the User<\/strong> should be set to team<\/strong>
• the Default Schema<\/strong> should be set to team<\/strong>
• public<\/strong> should be the only membership selected in the Database role Membership settings<\/p>\n

6. Select OK<\/strong> to save changes.
 \n

Test Your Connection Using the Server Management Studio<\/strong><\/em><\/p>\n

Test your connection using the Microsoft SQL Server Management Studio as follows:<\/p>\n

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

select @@version<\/strong><\/p>\n

5. Select Execute<\/strong> from the toolbar and if you see information similar to:<\/p>\n

Microsoft SQL Server 2005 – 9.00.1399.06 (Intel X86)<\/span>
Oct 14 2005 00:33:37<\/span>
Copyright (c) 1988-2005 Microsoft Corporation<\/span>
Standard Edition on Windows NT 5.1 (Build 2600: Service Pack 2)<\/span><\/p>\n

Your connection is good.<\/p>\n

 \n

Connect Team To Your SQL Database and Upload Your Data<\/strong><\/em><\/p>\n

To connect Team to your SQL Database:<\/p>\n

1. Select TEAM Database Utility<\/strong> 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<\/strong> User ID and password.
3. Select the SQL Setup<\/strong> category.
4. Select the Server Type<\/strong> (i.e. Microsoft SQL via ADO).
5. Enter the Host Name<\/strong>.
6. Enter the Server Name<\/strong>.
7. Enter the User Name<\/strong>.
8. Enter the Password<\/strong>.
9. Select the Connect<\/strong> button.
10. Once connected, select Upload to SQL<\/strong> to upload your existing standard Team database to your SQL database.
11. Once uploaded, select Close<\/strong> to close the Alexsys Team Database Utility.<\/p>\n

Tip:<\/strong> 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.
 \n

Test Your Connection to SQL<\/strong><\/em><\/p>\n

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:<\/p>\n

1. Alter the Team<\/strong> 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<\/strong> from the TeamView menu and selecting the Database Tab<\/strong>. You should see information for the SQL server you are accessing, similar to the figure below.
 \n

System Information – Database Tab – SQL Information Displayed<\/strong><\/p>\n

http:\/\/alexsys.team\/wp-content\/uploads\/2017\/12\/dbinfosql2000.gif\"\"<\/p>\n

 \n

Make SQL the Active Database<\/strong><\/em><\/p>\n

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.<\/p>\n

To make SQL the active database:<\/p>\n

1. Select TEAM Database Utility<\/strong> from the Alexsys Team Program Group or run TeamAdm.exe<\/strong> in the Alexsys Team server directory to open the Alexsys Team Database Utility.
2. Login using the Team ADMIN<\/strong> User ID and password.
3. Select the SQL<\/strong> Setup category.
4. Connect to the SQL database by selecting the Connect<\/strong> button.
5. Once connected, select SQL<\/strong> as the Active Database<\/strong>.
6. Select Close<\/strong> 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.<\/p>\n<\/p>\n\t\t<\/div>\n\t\t

Install\/Configure MySQL 4.1.x<\/h3>\n\t\t
\n\t\t\t

\n

General Instructions<\/strong><\/em><\/p>\n

Once you have your MySQL Server in place, and have the MySQL client software installed on all Team Client PCs, you are ready to set up your Team-SQL database.<\/p>\n

The following basic steps are required for setting up your SQL Server and SQL Database:<\/p>\n

• Create the SQL Database and Set Permissions
• Test Your Connection using the ODBC Data Source Administrator
• Connect Team to Your SQL Database and Upload Your Data
• Test Your Connection to Team-SQL
• Make SQL the Active Database<\/p>\n


Create the SQL Database and Set Permissions<\/strong><\/em><\/p>\n

To create the SQL Database:<\/p>\n

1. Run mysql<\/strong> by running C:\\mysql\\bin\\mysql.exe<\/em>
2. From the mysql><\/strong> prompt, enter:<\/p>\n

create database team;<\/em><\/p>\n


3. From the mysql><\/strong> prompt, enter:<\/p>\n

grant all on team.* to ‘team’@’%’ identified by ‘team’;<\/em><\/p>\n


4. From the mysql><\/strong> prompt, enter:<\/p>\n

flush privileges;<\/em>
 \n

Test Your Connection using the ODBC Data Source Administrator<\/strong><\/em><\/p>\n

To test your connection:<\/p>\n

1. Use the Windows Control Panel and select Administrative Tools<\/strong>.
2. Select Data Sources (ODBC) to run the ODBC Data Source Administrator.
3. Select the Drivers<\/strong> tab and confirm that MySQL ODBC Driver<\/strong> is there. (If not, you will have to download and install the latest ODBC driver from http:\/\/www.mysql.com\/products<\/a>)
4. Select the User DSN<\/strong> tab.
5. Select Add<\/strong>.
6. Select MySQL ODBC Driver<\/strong>.
7. Select Finish<\/strong> and enter the following:<\/p>\n

Database Name<\/strong> = team
User<\/strong> = team
Password<\/strong> =<\/p>\n

8. Select Test Data Source<\/strong> and if you see information similar to:<\/p>\n

Data Source “Connected Successfully to ‘mysqld-4.1.2-alpha-nt’ !!!<\/p>\n

Your connection is good.<\/p>\n

 \n

Connect Team to Your SQL Database and Upload Your Data<\/strong><\/em><\/p>\n

To connect Team to your SQL Database:<\/p>\n

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

Tip:<\/strong> 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.<\/p>\n

Note:<\/strong> When uploading your Standard Team database to your MySQL database, if the upload fails while uploading any table that includes BLOBs (i.e. the LogAtt table) try increasing the Max Allowed Packet settings to 16MB.<\/p>\n

If you have to change these settings, remember to Restart your MySQL Service.
 \n

Test Your Connection to Team-SQL<\/strong><\/em><\/p>\n

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:<\/p>\n

1. Alter the Team<\/strong> shortcut on your desktop by adding an \/SQL<\/strong> 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<\/strong> from the TeamView menu and selecting the Database Tab<\/strong>. You should see information for the SQL server you are accessing.
 \n

Make SQL the Active Database<\/strong><\/em><\/p>\n

Once your database has been uploaded to your SQL database and you have tested your connection to your SQL database using Team-SQL, you can make SQL the active database to force all users to use Team-SQL.<\/p>\n

To make SQL the active database:<\/p>\n

1. Select TEAM Database Utility<\/strong> from the Alexsys Team Program Group or run TeamAdm.exe<\/strong> in the Alexsys Team server directory to open the Alexsys Team Database Utility.
2. Login using the Team ADMIN<\/strong> User ID and password.
3. Select the SQL<\/strong> Setup category.
4. Connect to the SQL database by selecting the Connect<\/strong> button.
5. Once connected, select SQL<\/strong> as the Active Database<\/strong>.
6. Select Close<\/strong> 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.<\/p>\n<\/p>\n\t\t<\/div>\n\t\t

Install\/Configure MySQL 5.0<\/h3>\n\t\t
\n\t\t\t

\n

General<\/strong> Instructions<\/strong><\/em><\/p>\n

Once you have your MySQL Server in place, and have the MySQL client software installed on all Team Client PCs, you are ready to set up your Team-SQL database.<\/p>\n

The following basic steps are required for setting up your SQL Server and SQL Database:<\/p>\n

• Create the SQL Database
• Create the SQL Database User and Set Permissions
• Test Your Connection using the ODBC Data Source Administrator
• Connect Team to Your SQL Database and Upload Your Data
• Test Your Connection to Team-SQL
• Make SQL the Active Database<\/p>\n

 \n

Create the SQL Database and Set Permissions<\/strong><\/em><\/p>\n

To create the SQL Database:<\/p>\n

1. Run MySQL Command Line Client<\/strong>
2. From the mysql><\/strong> prompt, enter:<\/p>\n

create database team;<\/em>
 \n

Create the SQL Database User and Set Permissions<\/strong><\/em><\/p>\n

To create your SQL database user and set permissions:<\/p>\n

1. Run MySQL Administrator<\/strong>.
2. Select User Administration<\/strong>.
3. Select the New User<\/strong> button below the User Information Tab<\/strong>.
4. Enter the following information in the User Information Tab<\/strong>:<\/p>\n

MySQL User<\/strong> = team
Password<\/strong> =
Confirm Password<\/strong> =<\/p>\n

5. Select Apply Changes<\/strong>.
6. Select the Schema Privileges Tab<\/strong>.
7. Select your team Schemata<\/strong>.
8. Select <<<\/strong> to grant full access for the team user.
9. Select Apply Changes<\/strong>.
 \n

Test Your Connection using the ODBC Data Source Administrator<\/strong><\/em><\/p>\n

To test your connection:<\/p>\n

1. Use the Windows Control Panel and select Administrative Tools<\/strong>.
2. Select Data Sources (ODBC)<\/strong> to run the ODBC Data Source Administrator<\/strong>.
3. Select the Drivers<\/strong> tab and confirm that MySQL ODBC Driver<\/strong> is there. (If not, you will have to download and install the latest ODBC driver from http:\/\/www.mysql.com\/products<\/a>)
4. Select the User DSN<\/strong> tab.
5. Select Add<\/strong>.
6. Select MySQL ODBC Driver<\/strong>.
7. Select Finish<\/strong> and enter the following:<\/p>\n

Database Name<\/strong> = team
User<\/strong> = team
Password<\/strong> =<\/p>\n

8. Select Test<\/strong> and if you see information similar to:<\/p>\n

Success; connection was made!<\/p>\n

Your connection is good.<\/p>\n

 \n

Connect Team to Your SQL Database and Upload Your Data<\/strong><\/em><\/p>\n

To connect Team to your SQL Database:<\/p>\n

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

Tip:<\/strong> 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.<\/p>\n

Note:<\/strong> When uploading your Standard Team database to your MySQL database, if the upload fails while uploading any table that includes BLOBs (i.e. the LogAtt table) try increasing the Max Allowed Packet settings to 16MB.<\/p>\n

If you have to change these settings, remember to Restart your MySQL Service.<\/em>
 \n

Test Your Connection to Team-SQL<\/strong><\/em><\/p>\n

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:<\/p>\n

1. Alter the Team<\/strong> shortcut on your desktop by adding an \/SQL<\/strong> 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<\/strong> from the TeamView menu and selecting the Database Tab<\/strong>. You should see information for the SQL server you are accessing.
 \n

Make SQL the Active Database<\/strong><\/em><\/p>\n

Once your database has been uploaded to your SQL database and you have tested your connection to your SQL database using Team-SQL, you can make SQL the active database to force all users to use Team-SQL.<\/p>\n

To make SQL the active database:<\/p>\n

1. Select TEAM Database Utility from the Alexsys Team Program Group or run TeamAdm.exe<\/strong> in the Alexsys Team server directory to open the Alexsys Team Database Utility<\/strong>.
2. Login using the Team ADMIN<\/strong> User ID and password.
3. Select the SQL<\/strong> Setup category.
4. Connect to the SQL database by selecting the Connect<\/strong> button.
5. Once connected, select SQL<\/strong> as the Active Database<\/strong>.
6. Select Close<\/strong> 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.<\/p>\n<\/p>\n\t\t<\/div>\n\t\t

Setup Instructions for Oracle 8.05, 8i,9i and 10g<\/h3>\n\t\t
\n\t\t\t

\n

Oracle 8.05, 8i, 9i and 10g<\/strong> instructions can also be downloaded as a PDF<\/a>.<\/p>\n

Once you have your Oracle Server in place, and have the SQL client software installed on all Team Client PCs, you are ready to set up your Team Pro for Oracle database.<\/p>\n

\n

When running Team Pro for Oracle, it is important to know that the lookup field values are all case sensitive.<\/strong><\/p>\n

\n

The following basic steps are required for setting up your SQL Server and SQL Database.<\/p>\n

• Requirements,
• Create the Table Space,
• Create the SQL Database Login and Permissions for Team,
• Test Your Client PC’s Connection Using Net8 Easy Config,
• Connect Team to Your SQL Database,
• Upload Your Existing Team Database to SQL,
• Test Your Connection to Team Pro, and
• Make SQL the Active Database.
 \n

Requirements<\/strong><\/em><\/p>\n

• Oracle 8.05 server or later.
• Oracle 8.05 Client or later (version should match database version) on ALL PC’s that will access this database.
• Minimum of 300 MB of disk storage for Team tables.
 \n

Create the Table Space<\/strong><\/em><\/p>\n

To create the Oracle table space for Team:<\/p>\n

1. Using the Oracle Storage Manager<\/strong>, create a Table Space for Team called TEAMDB.
2. Select the following size and growth option settings<\/strong>:
General:
 \n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n
General:<\/strong><\/span><\/td>\n <\/td>\n<\/tr>\n
 Setting:<\/strong><\/td>\nValue: <\/strong><\/td>\n<\/tr>\n
 Name:<\/td>\n TEAMDB<\/td>\n<\/tr>\n
 Status:<\/td>\n Online<\/td>\n<\/tr>\n
 Datafiles:<\/td>\n D:\\ORACLEDB\\TEAMDB (Site Specific)<\/td>\n<\/tr>\n
 Type:<\/td>\n Permanent<\/td>\n<\/tr>\n
 Extents:<\/strong><\/span><\/td>\n <\/td>\n<\/tr>\n
 Setting:<\/strong><\/td>\n Value:<\/strong><\/td>\n<\/tr>\n
 Initial Size:<\/td>\n 1024K<\/td>\n<\/tr>\n
 Next Size:<\/td>\n 1024K<\/td>\n<\/tr>\n
 Minimum Size:<\/td>\n 0<\/td>\n<\/tr>\n
 Increase by:<\/td>\n 50%<\/td>\n<\/tr>\n
 Minimum Number:<\/td>\n 1<\/td>\n<\/tr>\n
 Maximum Number:<\/td>\n Unlimited (radio button)<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n



Create the SQL Database Login and Permissions for Team<\/strong><\/em><\/p>\n

Create one login that will be used by Team to connect to the database. Team manages its users internally. Team users are not aware of the database connection process. Team connects to the Oracle database using the user established during initial setup. On startup, Team connects to Oracle and logs in using the dedicated Team login. After Database connection and login, Team then presents Team’s login screen. The user is validated within Team and is then permitted to proceed if the UserID and Login are correct.<\/p>\n

To create the login and set permissions for Team:<\/p>\n

1. Using the Oracle Security Manager<\/strong>, create a login called TEAM<\/strong>.
2. Team needs full access<\/strong> to create, delete, alter, read and write tables. Here are the recommended settings:<\/p>\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n
General<\/strong><\/span><\/td>\n <\/td>\n<\/tr>\n
Setting:<\/strong><\/td>\nValue:<\/strong><\/td>\n<\/tr>\n
Name:<\/td>\nTEAM<\/td>\n<\/tr>\n
Profile:<\/td>\nDEFAULT<\/td>\n<\/tr>\n
Authentication:<\/td>\nPassword<\/td>\n<\/tr>\n
Password:<\/td>\n(choose one)<\/td>\n<\/tr>\n
Expire Password Now:<\/td>\nunchecked<\/td>\n<\/tr>\n
Table Spaces:<\/strong><\/span><\/td>\n <\/td>\n<\/tr>\n
Setting:<\/strong><\/td>\nValue:<\/strong><\/td>\n<\/tr>\n
Default:<\/td>\nTEAMDB<\/td>\n<\/tr>\n
Temporary:<\/td>\nTEAMDB<\/td>\n<\/tr>\n
Status<\/td>\nunlocked<\/td>\n<\/tr>\n
Roles \/ Privileges:<\/strong><\/span><\/td>\n <\/td>\n<\/tr>\n
Privilege Type:Roles<\/strong><\/td>\n <\/td>\n<\/tr>\n
Granted:<\/td>\n <\/td>\n<\/tr>\n
CONNECT:<\/td>\nAdmin Option Checked Default Checked<\/td>\n<\/tr>\n
DBA:<\/td>\nAdmin Option Checked Default Checked<\/td>\n<\/tr>\n
EXP_FULL_DATABASE:<\/td>\nAdmin Option Checked Default Checked<\/td>\n<\/tr>\n
HS_ADMIN_ROLE:<\/td>\nAdmin Option Checked Default Checked<\/td>\n<\/tr>\n
RESOURCE:<\/td>\nAdmin Option Checked Default Checked<\/td>\n<\/tr>\n
Privilege Type:System Privileges<\/strong><\/td>\n <\/td>\n<\/tr>\n
Granted:<\/td>\n <\/td>\n<\/tr>\n
ALTER DATABASE<\/td>\nAdmin Option Checked<\/td>\n<\/tr>\n
CREATE ANY TYPE<\/td>\nAdmin Option Checked<\/td>\n<\/tr>\n
UNLIMITED TABLESPACE<\/td>\nAdmin Option Checked<\/td>\n<\/tr>\n
UPDATE ANY TABLE<\/td>\nAdmin Option Checked<\/td>\n<\/tr>\n
Object Privileges<\/strong><\/td>\n <\/td>\n<\/tr>\n
No changes made<\/td>\n <\/td>\n<\/tr>\n
Quotas<\/strong><\/td>\n <\/td>\n<\/tr>\n
None set<\/td>\n <\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n



Test Your Client PC’s Connection Using Net8 Easy Config<\/strong><\/em><\/p>\n

To check that you can connect to your Oracle server, without running Team:<\/p>\n

1. Run the Oracle Net8 Easy Config<\/strong> from the Oracle for Windows 95 program group from a client PC.
2. Select Test<\/strong> as your Action.
3. Select your service<\/strong> (i.e. TEAM.WORLD).
4. Select the Next ><\/strong> button.
5. Enter your database logon information<\/strong>: \n

For example:<\/p>\n

 Username <\/span><\/strong> team
 Password <\/span><\/strong> team
 
6. Select the Test<\/strong> button.
7. If everything is configured properly, you will have a connection test that is successful.
8. Select the Done<\/strong> button.
9. Select the Finish<\/strong> button to complete your test and exit the Net8 Easy Config program.
 \n

Connect Team To Your SQL Database<\/strong><\/em><\/p>\n

To connect Team to your SQL Database:<\/p>\n

1. Select Admin | Database Utility<\/strong> from the TeamView or Work Request menus or start TEAM Database Utility<\/strong> from the Alexsys Team Program Group to open the Alexsys Team Database Utility<\/strong>. Remember to log off of Team after you open the Database Utility.
2. Select the SQL Setup<\/strong> category from the Alexsys Team Database Utility window (see figure below).
 \n

Alexsys Team Database Utility – SQL Setup<\/strong><\/p>\n

\"\"<\/p>\n

3. Select the Server Type<\/strong> (i.e. Oracle).
4. Enter the Oracle TNS<\/strong> (i.e. Team).
5. Enter the User Name<\/strong> (i.e. team in lowercase).
6. Enter the Password<\/strong>.
7. Select the Connect<\/strong> button.<\/p>\n

If Team can connect to your SQL database on the SQL server, Connected will be displayed in the area next to the Connect button.<\/p>\n

 \n

Upload Your Existing Team Database to SQL<\/strong><\/em><\/p>\n

When you are ready to run Team using your SQL database, you must connect Team to the SQL server and upload your database to SQL. Once this is done and you do one final test to check your connection to SQL using Team, you can force all users to run Team Pro by switching the active database to SQL.<\/p>\n

To connect to the SQL database and upload your existing data:<\/p>\n

1. Select Admin | Database Utility<\/strong> from the TeamView or Work Request menus or start TEAM Database Utility<\/strong> from the Alexsys Team Program Group to open the Alexsys Team Database Utility<\/strong>. Remember to log off of Team after you open the Database Utility.
2. Select the SQL Setup<\/strong> category from the Alexsys Team Database Utility window.
3. Select the Connect<\/strong> button.
4. Once connected, select the Upload to SQL<\/strong> button to upload your existing standard Team database to your SQL database.<\/p>\n

 \n

\n

You must be running with the Standard<\/strong> 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.<\/p>\n

\n

  \n

5. Once uploaded, select Cancel<\/strong> to close the Alexsys Team Database Utility.
 \n

Test Your Connection to Team Pro<\/strong><\/em><\/p>\n

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:<\/p>\n

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

System Information – Database Tab – Oracle Information Displayed<\/strong><\/p>\n

\"\"<\/p>\n

Make SQL the Active Database<\/p>\n

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.<\/p>\n

 \n

Make SQL the active database<\/strong><\/em><\/p>\n

1. Select Admin | Database Utility<\/strong> from the TeamView or Work Request menus or start TEAM Database Utility<\/strong> from the Alexsys Team Program Group to open the Alexsys Team Database Utility<\/strong>. Remember to log off of Team after you open the Database Utility.
2. Select the SQL Setup<\/strong> category from the Alexsys Team Database Utility window.
3. Connect to the SQL database by selecting the Connect<\/strong> button.
4. Once connected, select SQL<\/strong> as the Active Database<\/strong> (see figure below).
 \n

Alexsys Team Database Utility – SQL Active Database<\/strong><\/p>\n

\"\"<\/p>\n

 \n

5. Select Close<\/strong> to close the Alexsys Team Database Utility.
6. Since SQL is now the active database, you can remove the \/SQL argument from any Team shortcuts.<\/p>\n

 \n<\/p>\n\t\t<\/div><\/div><\/div><\/div><\/div>\n\t\t\n\t\t\n\t<\/section>\n","protected":false},"excerpt":{"rendered":"","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"page-front-page-revolution.php","meta":[],"_links":{"self":[{"href":"http:\/\/alexsys.team\/index.php\/wp-json\/wp\/v2\/pages\/999"}],"collection":[{"href":"http:\/\/alexsys.team\/index.php\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"http:\/\/alexsys.team\/index.php\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"http:\/\/alexsys.team\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/alexsys.team\/index.php\/wp-json\/wp\/v2\/comments?post=999"}],"version-history":[{"count":18,"href":"http:\/\/alexsys.team\/index.php\/wp-json\/wp\/v2\/pages\/999\/revisions"}],"predecessor-version":[{"id":1027,"href":"http:\/\/alexsys.team\/index.php\/wp-json\/wp\/v2\/pages\/999\/revisions\/1027"}],"wp:attachment":[{"href":"http:\/\/alexsys.team\/index.php\/wp-json\/wp\/v2\/media?parent=999"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}