Installation and Configuration Guide - Amazon Web Services

mountainromeInternet and Web Development

Oct 31, 2013 (3 years and 7 months ago)

127 views



SPIRA
INSTALLATION AND CONFIGURATION GUIDE
©200
9


Revised:
November 1, 2013


Page
1

of
19

Spira
®

is a registered trademark of Spira Data Corp


1

Preface

Thi s gui de wi l l
descri be the techni cal detai l s requi red to
i nstal l and confi gure Spi ra components.

Thi s i s not a step
-
by
-
step gui de.


2

Contents

1

Preface

................................
................................
................................
................................
................................
.....................

1

2

Contents

................................
................................
................................
................................
................................
..................

1

3

Components
................................
................................
................................
................................
................................
............

2

3.1.1

Spi ra Express Corporate Message Server (CORP)

................................
................................
..............................

2

3.1.2

Mi crosoft SQL Server 2005 (SQL)
................................
................................
................................
..........................

2

3.1.3

Command Cl i ent (COM)

................................
................................
................................
................................
.........

2

3.1.4

Mobi l e Cli ent (MOB)

................................
................................
................................
................................
...............

2

3.1.5

Spi ra Cli ent Update Tool (UPD)

................................
................................
................................
.............................

3

4

Spira Express Corporate Message Server Installation Types

................................
................................
.......................

3

4.1

Standard Inst allation

................................
................................
................................
................................
..................

4

4.1.1

Confi gurati on Variabl es:
................................
................................
................................
................................
.........

4

4.1.2

Install

................................
................................
................................
................................
................................
.........

5

4.1.3

Confi gure Spi ra Express Message Server

................................
................................
................................
............

7

4.2

Single Server Installation

................................
................................
................................
................................
.........
10

4.3

Command Only

................................
................................
................................
................................
..........................
11

4.3.1

Confi gurati on Variabl es

................................
................................
................................
................................
........
11

4.3.2

Restore Databases
................................
................................
................................
................................
.................
11

4.3.3

Install Spira
Command
................................
................................
................................
................................
..........
11

4.3.4

Confi gurati on Tool
................................
................................
................................
................................
.................
12

4.3.5

Create a New Appl i cati on Node
................................
................................
................................
..........................
12

5

Install Spira Command

................................
................................
................................
................................
.......................
15

6

Install Spira Mobile

................................
................................
................................
................................
.............................
15

7

In
stall Spira Client Update Tool

................................
................................
................................
................................
........
16

8

SQL Server Configurations

................................
................................
................................
................................
.................
18

8.1.1

Server Setti ngs

................................
................................
................................
................................
.......................
18

8.1.2

Spi ra Database User Confi gurati on

................................
................................
................................
....................
19



SPIRA
INSTALLATION AND CONFIGURATION GUIDE
©200
9


Revised:
November 1, 2013


Page
2

of
19

Spira
®

is a registered trademark of Spira Data Corp




3

Components

3.1.1

Sp
ira

Express

Corporate Message Server (CORP)

ISO

Spi ra_Corporate_48xx.i so

Installer

Setup Spi ra Corporate.exe

Thi s i s the appl i cation server that rel ays and processes i ncomi ng messages from Mobi l e Cl i ents to the databases
for use by i n offi ce Command
Cl i ents.

Spi ra Corporate Instal l er i ncludes 2 components:

1.

Spi ra
Express
Corporate Message
Appl i cati on

(Wi ndows servi ces)
:

a.

Spi ra Message Processor

b.

Spi ra Message
Queui ng

2.

Corporate
Databases

a.

Spi ra (Appl i cati on Database)

b.

Spi raMessaging (Messagi ng Database)

Th
e
Appl i cati ons

wi l l be i nstall ed on the machi ne the i nstal ler i s executed from. Databases may be i nstal led l ocally
(CORP i s i nstal led on a SQL Server)
or remotel y

(dedi cated SQL server)
.

3.1.2

Microsoft SQL Server 2005
(
SQL
)

There i s no i nstal ler for the datab
ases.
Empty Databases are i ncl uded wi th the
“Spi ra Corporate” Instal ler sui te. A
SQL Authenti cati on user wi th admi n ri ghts to create databases wi l l be requi red duri ng
Spi ra Corporate i nstal l ation
to create:



Spira

: Appl i cati on database contai ning master
data



SpiraMessaging

: Messagi ng Database contai ni ng i ncoming and outgoi ng messages for mobi l e uni ts.

Customers runni ng a “Command Onl y” confi gurati on may be
provi si on
database B
ackup fi l es

to restore on a SQL
server
.

The customer i s responsi bl e for i nstall
ation and confi guration of SQL server whi ch may i ncl ude addi ti onal
confi gurati on of
MS S
QL Server Reporti ng Servi ces and/or IIS for Spi ra SSRS Reports.

3.1.3

Command Client (COM)

ISO

Spi ra_Command_48xx.i so

Installer

Setup Spi ra Command.exe

Thi s

i n offi ce
cl i ent
appl i cation accesses the
SQL Server d
atabase
s
,
Spira

and
SpiraMessaging
.


3.1.4

Mobile Client (MOB)

ISO

Spi ra_Mobi l e_48xx.i so

Installer

Setup Spi ra Mobi l e.exe



SPIRA
INSTALLATION AND CONFIGURATION GUIDE
©200
9


Revised:
November 1, 2013


Page
3

of
19

Spira
®

is a registered trademark of Spira Data Corp


Mobi l e fi el d
cl i ent appl i cation i s for
remote out of offi ce use
.

The Mobi l e appl i cation
stores data l ocally on i ts SQL
Express 2005 databases: Spi raLocal + Spi raMessagi ng
.

Spi ra.Express.Cl ient (tray i con)
synchroni zes
wi th the
Spi ra Express
Corporate Message
Processi ng server.

3.1.5

Spira Client Update Tool (UPD)

ISO

Spi ra_Update_48xx.i so

Installer

Spi ra.Update.Cl i ent.Instal l

Spi ra cl i ent update tool

i s for updati ng Mobi l e fi el d cl i ent appl i cati ons.

4

Spira Express Corporate Message Server
Installation Types

There are 3 typi cal i nstallati on confi gurati ons:

COMPONENTS

CORP

SQL

COM

MOB

NOTES

Standard
Installation

y

y

y

y

Standard Installation

Single Server


y

y

Y

Spira Corporate Services are installed on the
Database Server

Command Only


y

y


Database + Command Client application only



SPIRA
INSTALLATION AND CONFIGURATION GUIDE
©200
9


Revised:
November 1, 2013


Page
4

of
19

Spira
®

is a registered trademark of Spira Data Corp




4.1

Standard Installation


4.1.1

Configuration Variables
:

These vari abl es wi l l be used

for your i nstal l ation
. Reference val ues have been used
i n thi s gui de for you to fol l ow
.
Substi tute VALUE wi th your actu
al Test or Producti on
val ues as these wi l l di ffer than these reference val ues. Ie.
Your SQL server IP may not be 10.0.0.40.

4.1.1.1

CORP

VARIBABLE

VALUE

DESCRIPTION

Machi ne Name

CORP.spi radata.local


IP

10.0.0.50




SPIRA
INSTALLATION AND CONFIGURATION GUIDE
©200
9


Revised:
November 1, 2013


Page
5

of
19

Spira
®

is a registered trademark of Spira Data Corp


External HOSTNAME/IP

spi radata.net

or
66.216.119.46

External l y accessible Hostname/i p
of
that
resol ves to your fi rewal l whi ch
di rects traffi c to CORP.spi radata.local
aka 10.0.0.50
. For mobi l e uni ts to
communi cate to CORP.

PORT

9669

i
e. 9669

Customer #

SPI RA001

Customer Li censi ng Number
provi ded
by Spi ra


4.1.1.2

SQL

VARIBABLE

VALUE

DESCRIPTION

Machi ne Name

SQL.spi radata.l ocal


SQL I nstance

SQL.spi radata.l ocal
\
SQL2005


IP

10.0.0.
40


SQL
Admi ni strator
User

s
a

User that i s abl e to create databases
and tabl es.

SQL Admi n password

Password99


Spi raUser Name

Spi raUser

Has read/wri te access to Spi ra +
Spi raMessaging Databses onl y

Spi raUser password

password



4.1.2

Install

On your CORP server,

1.

Insert Spi ra_Corporate_48xx.i so CD i nto your server

or execute “Setup Spi ra Corporate.exe”

2.

Fol l ow on screen i nstructi ons…

a.

Wel come

i.

Cl i ck
Next

b.

Li cense Agreement

i.

Sel ect
I accept the terms in the license agreement
. Cl i ck
Next

c.

Customer Informati on

i.

Fi l l out your
Name

and
Organization
. Cl i ck
Next

d.

Setup Type

i.

Pi ck
Complete
. Cl i ck
Next
.



SPIRA
INSTALLATION AND CONFIGURATION GUIDE
©200
9


Revised:
November 1, 2013


Page
6

of
19

Spira
®

is a registered trademark of Spira Data Corp


e.

Database
Server


Fi l l out the requi red i nformati on wi th

Field

Input

Database Server that you are installing to:

SQL.spiradata.local
\
SQL2005

Login ID

sa

Pas s word

Pas s word99

Do not change the val ues of Databas e catal ogs. Thes e mus t remai n as the defaul ts:

i.

Spi ra

ii.

Spi raMessaging

Cl i ck
Next

f.

Spi ra Express

Creates the i ni ti al Appl i cati on ID wi th confi gurati ons for thi s CORP server

Fi l l out the requi red fi el ds wi th:

Field

Input

Host

spiradata.net

or 66.216.119.46

Port

9669

Local Server
\
Instance Name

SQL.spi radata.l
ocal
\
SQL2005

External
S
erver
\
Instance Name

SQL.spi radata.l ocal
\
SQL2005

Credenti al s to connect to Spi ra

Spi raUser

Credenti al s to connect to Spi raMessaging

password

Cl i ck
Next

g.

Ready to Instal l the Program

i.

Cl i ck
Install

h.

Instal l Shield Wi zard Compl eted

i.

Cl i ck
Finish

ii.

A sampl e Spi ra.tok wi l l be created on the desktop




SPIRA
INSTALLATION AND CONFIGURATION GUIDE
©200
9


Revised:
November 1, 2013


Page
7

of
19

Spira
®

is a registered trademark of Spira Data Corp


4.1.3

Configure Spira Express Message Server

4.1.3.1

Using a different Database

If you have a
speci fi c
Database

backup you wi sh to use, i e.
myCompany_yyyymmdd.BAK

you have 2 opti ons
when restori ng the database:

1.

Restore over Spi ra

(overwri te)

a.

easi est and si mpl est method

2.

Restore

as a di fferent database n
ame, i e.
MyCompanyWS

a.

speci fi c changes wi l l be requi red i n the confi gurati on tool

to refl ect the
nami ng di fference

4.1.3.2

C
onfigure SpiraUser

To confi gure a user i n Spi ra Command fol l ow the steps outl i ned i n chapter 4 of the Spi ra Hel p Manual
.

4.1.3.3

Configuration Tool

It i s recommended that confi gurati on i s al ways created and mai ntai ned at one (the same) computer. Token
(confi gurat
i on fi l es) may be generated for l oadi ng and use on other standal one Command Cl i ents or Mobi l e
Cl i ents.

A Spi ra ‘Appl i cati on Node’ i s a GUID that contai ns setti ngs i n the regi stry under
HKEY_LOCAL_MACHINE
\
SOFTWARE
\
Spira Data Corp
\

An ‘Appl i cati on Node’ typi
cal l y contai ns 1 Database Connecti on.

Confi gurati on Tool i s used to:

1.

Create a New Appl i cati on Node and Token fi l e (fi rst ti me, command onl y)

2.

Mai ntai n/Update Appl i cati on Nodes and Database Connecti ons

4.1.3.4

Create a New Application Node

1.

Execute C:
\
Program Fi l es
\
Spi ra Data Corp
\
Spi ra Command
\
Spi ra.Confi guration.Tool.exe

2.

Cl i ck ‘New’

a.

‘Browse For Fol der’ popup

3.

Pi ck ‘Desktop’

a.

A new Node i s created

4.

Appl i cati on ID i s popul ated wi th a new GUID

5.

Fri endl y ID Name shows ‘
00000000
-
0000
-
0000
-
0000
-
000000000000


a.

On a Standard In
stal l ati on wi th mul ti pl e nodes, thi s hel ps i denti fy each of your nodes wi th a
fri endl y name, i e. Spi raProducti on or Spi raTest

b.

You may change thi s to “Spi raWS”

6.

App Versi on shows 4.8.16.347

a.

The App Versi on shoul d al ways match the Database versi on i n t_Produc
tVersi on.

7.

Corp Server Host/IP + Port are not requi red i n a Command Onl y i nstal lation

a.

In a standard i nstallation, thi s woul d be the hostname/IP of the appl i cati on server that Mobi l e
fi el d cl i ents wi l l connect to

8.

Li censi ng URL i s used for appl i cati on l icen
sing. Obtai n thi s from your Spi ra representati ve.





SPIRA
INSTALLATION AND CONFIGURATION GUIDE
©200
9


Revised:
November 1, 2013


Page
8

of
19

Spira
®

is a registered trademark of Spira Data Corp


4.1.3.5

Create a New Database Configuration


1.

Cl i ck
Start
, poi nt to
Programs
, poi nt to
Spira Data Corp
, and then cl i ck
Spira C
onfiguration Tool
.

2.

Check the
App Versi on fi el d,

and ensured that

the versi on of thi s i
nstal ler

i s entered
, i e. 4.8.12.6

a.

The App Versi on MUST match the Appl i cati on Database versi on (i n t_ProductVersi on) to faci l itate
proper updates for Command + Mobi l e appl i cations.

3.

Type i n the
Customer #
fi el d provi ded by Spi ra:
SPIRA001
.

4.

Cl i ck Add under
Database Confi gurati ons secti on

a.

Change the Confi gurati on Name to the name of the company or di vi si on

5.

Ensure your Databases are correct:

a.

Cl i ck on tab
Internal Application
. Veri fy the val ues are correctl y poi nti ng to
Spira
. Cl i ck
Test
.
A popup shoul d show

that the connecti on was successful.

b.

Cl i ck on tab External Appl i cati on. Cl i ck
Same as Internal
.

i.

IF you are usi ng a
different application database

than the defaul t i nstal l ed by Spi ra
Corporate 48xx.i so make sure that Spi ra the database defaul t
Spira

Appl
i cati on are
changed to
MyCompanyWS
.
Cl i ck
Test

to ensure the database i s accessible

c.

Cl i ck on tab Internal Messagi ng. Veri fy the val ues are correctl y poi nti ng to
SpiraMessaging
.
Cl i ck
Test
. A popup shoul d show that the connecti on was successful.

d.

Cl i ck o
n Tab
External Messaging
. Cl i ck
Same as Internal
.

e.

Check
Default Configuration

6.

Cl i ck
Save

7.

Verfi fy that:

a.

Application ID

onl y has one (1) i tem i n the drop down l i st

b.

Database Configuration

l i st onl y has one (1) i tem

8.

Cl i ck
Create Token
. A popup di al og box sho
ws the one (1) avai l able confi guration(s),
Spira
. Cl i ck OK.
Spira Token File

save di al og shows.
Name the fi l e. Cl i ck
Save
.

a.

Spi ra recommends a nami ng conventi on of:

<version>_<hostname>_<databasename>_<port#>.tok

b.

Ensure that thi s token, wi th App Versi on = 4.8.12.6 i s onl y l oaded onto Command or Mobi l e uni ts
of the respecti ve versi on.

9.

Your token i s now ready for use on new Command and Mobi l e i nstal lati ons





SPIRA
INSTALLATION AND CONFIGURATION GUIDE
©200
9


Revised:
November 1, 2013


Page
9

of
19

Spira
®

is a registered trademark of Spira Data Corp


4.1.3.6

Getting your Server Running

Fi rewal l Confi gurati on

1.

Ensure

that your HOST IP and Port correctl y forward to your CORP server

On your Corporate Server:

1.

Cl i ck on
Start > Run
. Type:
services.msc

2.

In the l i st of wi ndows servi ces, fi nd:

a.

Spi ra Message Processor

b.

Spi ra Message Queui ng

3.

Ri ght
-
Cl i ck each servi ce, cl i ck
Star
t
.

Notes:



Spi ra Servi ces are setup to startup automati cal l y on machi ne startup



A manual servi ce restart i s requi red on:

o

Confi gurati on Tool changes (i e. New IP, port, database)

o

Database restore

o

Swi tchi ng from Ti cket Type: Si ngl e pool to Uni que by Type

On yo
ur Spi ra Command Cl i ent:

1.

Start

>
R
un

2.

Startup Spi ra Command. Confi gure your system as outl i ned i n the Spi ra Hel p Manual.
Here i s a hi gh l evel
of the cri ti cal screens:

a.

Setup > Company

b.

Setup > Job Types

c.

Data > Control Sequence

3.

Cl i ck on
Data > Offline Store
.

Cl i ck
Generate
. Cl i ck
Publish
. An offl i ne store i s now avai l able on your
Spi ra Express Corporate Message server for Mobi l e uni ts to pi ck up.

a.

You may veri fy successful ly
Baseline.ols
publ i sh by goi ng on your CORP server and checki ng
fol der to see i f the
fi l e exi sts wi th the current date/ti me:

C:
\
Documents and Settings
\
All Users
\
Application Data
\
Spira Data
Corp
\
Offlinestore
\
{Applicati on ID GUID}
\


Your CORP system i s now ready for a mobi l e to connect




SPIRA
INSTALLATION AND CONFIGURATION GUIDE
©200
9


Revised:
November 1, 2013


Page
10

of
19

Spira
®

is a registered trademark of Spira Data Corp


4.2

Single Server Installation



In thi s confi gurati on, i nstall the Spi ra Express Corporate Message Server on the SQL Server.





SPIRA
INSTALLATION AND CONFIGURATION GUIDE
©200
9


Revised:
November 1, 2013


Page
11

of
19

Spira
®

is a registered trademark of Spira Data Corp


4.3

Command Only


4.3.1

Configuration Variables

Spira.BAK

Appl i cati on Database

SpiraMessaging.BAK

Messagi ng Database


4.3.2

Restore Databases

1.

Obtai n your Databases from Spi ra:

a.

Spi ra.bak

b.

Spi raMessaging.bak

2.

Copy the backups to your SQL server

3.

Startup SQL Management Studi o (or tool of choi ce)

4.

Log i nto the SQL Server usi ng a “sa” or sysadmi n account

5.

Restore Spi ra.bak as “
Spira


6.

Restore Spi raMessagi
ng.bak as “
SpiraMessaging


Set Up SQL Authenti cati on user
(OPTIONAL)


To create a SQL authenti cati on user for Spi ra + Spi raMessaging databases fol low the steps outl i ned i n secti on
0





SPIRA
INSTALLATION AND CONFIGURATION GUIDE
©200
9


Revised:
November 1, 2013


Page
12

of
19

Spira
®

is a registered trademark of Spira Data Corp


Spira Database
User

Confi gurati on
.


4.3.3

Install Spira Command

1.

Fol l ow Command i nstal lati on i nstructi ons at
5

Install Spira Command


4.3.4

Configuration To
ol

In a Command Onl y i nstal lati on, there i s no Central Corporate server. It i s recommended that confi gurati on i s
al ways created and mai ntai ned at one (the same) computer. Token (confi gurati on fi l es) may be generated for
l oadi ng and use on other standal on
e Command Cl i ents.

A Spi ra ‘Appl i cati on Node’ i s a GUID that contai ns setti ngs i n the regi stry under
HKEY_LOCAL_MACHINE
\
SOFTWARE
\
Spira Data Corp
\

An ‘Appl i cati on Node’ typi cal l y contai ns 1 Database Connecti on.

Confi gurati on Tool i s used to:

3.

Create a New A
ppl i cati on Node and Token fi l e (fi rst ti me, command onl y)

4.

Mai ntai n/Update Appl i cati on Nodes and Database Connecti ons

4.3.5

Create a New Application Node

9.

Execute C:
\
Program Fi l es
\
Spi ra Data Corp
\
Spi ra Command
\
Spi ra.Confi guration.Tool.exe

10.

Cl i ck ‘New’

a.

‘Browse For
Fol der’ popup

11.

Pi ck ‘Desktop’

a.

A new Node i s created

12.

Appl i cati on ID i s popul ated wi th a new GUID

13.

Fri endl y ID Name shows ‘
00000000
-
0000
-
0000
-
0000
-
000000000000


a.

On a Standard Instal l ati on wi th mul ti pl e nodes, thi s hel ps i denti fy each of your nodes wi th a
fri en
dl y name, i e. Spi raProducti on or Spi raTest

b.

You may change thi s to “Spi raWS”

14.

App Versi on shows 4.8
.16
.347

a.

The App Versi on shoul d al ways match the Database versi on i n t_ProductVer
si on.

15.

Corp Server Host/IP + Port are not requi red i n a Command Onl y i nstal lat
ion

a.

In a standard i nstallation, thi s woul d be the hostname/IP of the appl i cati on server that Mobi l e
fi el d cl i ents wi l l connect to

16.

Li censi ng URL
i s used for appl i cati on l icensing. Obtai n thi s from your Spi ra representati ve.

17.

[New Confi gurati on]

denotes that

no database confi gurati ons currentl y exi st

a.

Cl i ck ‘Add


i.

In the text box bel ow the Database Confi gurati on Dropdown l i st, type a name to i denti fy
the database pai r. Spi ra recommends a conventi on to easi l y i denti fy the l ocati on and
database:

[SERVER or i nsta
nce] DatabaseName, i e. ‘SPSQL01 Spi ra’ or ‘SQL2005 Spi ra’

b.

Internal Appl i cati on:

i.

Server: type i n the your: ‘SQLServer
\
Instance’

ii.

User Name: type i n a SQL authenti cated user, “Spi raUser” (or sa)



SPIRA
INSTALLATION AND CONFIGURATION GUIDE
©200
9


Revised:
November 1, 2013


Page
13

of
19

Spira
®

is a registered trademark of Spira Data Corp


iii.

Password: “password”

i v.

Database: “Spi ra”

v.

Cl i ck ‘Test’ to ensure th
at the val ues were typed correctl y and that a connecti on can be
made to the database

NOTE: ‘Test’ onl y tests the connecti on. It does not ‘test’ user permi ssi ons.

c.

Cl i ck on tab, ‘External Appl i cati on’

d.

Cl i ck on ‘Make Same as Internal ’

i.

Val ues are copi ed acros
s

e.

Cl i ck on tab, ‘Internal Messagi ng’

i.

Server: type i n the your: ‘SQLServer
\
Instance’

ii.

User Name: type i n a SQL authenti cated user, “Spi raUser” (or sa)

iii.

Password: “password”

i v.

Database: “Spi raMessagi ng”

f.

Cl i ck on tab, ‘External Messagi ng’

g.

Cl i ck on ‘Make Same as
Internal ’

18.

You shoul d now have somethi ng l i ke:


19.

Cl i ck ‘Save’

20.

Cl i ck ‘Create Token’

a.

A popup shows the ‘Confi gurati ons’ i n thi s node to i ncl ude.



SPIRA
INSTALLATION AND CONFIGURATION GUIDE
©200
9


Revised:
November 1, 2013


Page
14

of
19

Spira
®

is a registered trademark of Spira Data Corp


b.

Ensure ‘SQL2005 Spi ra’ i s checked:


c.

Cl i ck ‘OK’

i.

A popup di al og appears asking for the name to save the Token
fi l e as

d.

Pi ck your desktop or network share dri ve. Recommended nami ng conventi on for the tokens i s:
<versi on>_<server
\
i nstance>_<database>


A command wi l l ask for a token i f no current confi gurati on exi sts (i e. New i nstal l ati on)

Thi s token,
48xx_spiradata
.net_Spira.tok

can now be l oaded on other command i nstal l ati ons.


Notes:

1.

You shoul d al ways mai ntain your master confi gurati on from the same l ocati on (computer)





SPIRA
INSTALLATION AND CONFIGURATION GUIDE
©200
9


Revised:
November 1, 2013


Page
15

of
19

Spira
®

is a registered trademark of Spira Data Corp


5

Install Spira Command

1.

Obtai n ISO or i nstal ler

2.

Fol l ow on screen i nstructi ons

3.

Spi ra i s now
i nstal led

4.

You may now:

a.

Create a token usi ng Confi gurati on tool or

b.

l oad a Token i f one i s al ready generated then

c.

Logi n to Spi ra Command wi th the credenti al s:

i.

User: setupadmi n

ii.

Password: password

Load Token:

1.

Doubl e cl i ck on the Spi ra Command desktop shortcut

2.

A popup wi l l ask for a Token fi l e (outl i ned i n the fol l owi ng secti on)

Usi ng a ‘Pl ugi n’

2.

Obtai n pl ugi n from Spi ra Representati ve, i e. ‘Spi ra.Ti meCard.zi p’ or ‘Pl ugi n.zi p’

3.

Copy .ZIP to fol der:

C:
\
Documents and Setti ngs
\
Al l Users
\
Spi ra Data Corp
\
Pl ugi ns


4.

Re
start Spi ra Command

6

Install Spira Mobile

1.

Obtai n ISO or Instal ler

2.

Fol l ow on screen i nstructi ons

a.

When prompted wi th Database Server screen, l eave al l fi el ds as the defaul t val ues:

i.

Database Server: (LOCAL)
\
Spi ra

ii.

Connect Usi ng: Server Authenti cati on

1.

Logi n ID:
sa

2.

Password: Password99

iii.

Name of database catal og: Spi raLocal

Starti ng Up for the fi rst ti me

1.

Cl i ck Start. Poi nt to Al l Programs
\

Spi ra Data Corp. Cl i ck Spi ra Express. A wi ndows tray appl i cati on wi ll
run.

2.

When Prompted

When Spi ra.Express.Cl ient

Load the

48xx_spiradata.net_Spira.tok





SPIRA
INSTALLATION AND CONFIGURATION GUIDE
©200
9


Revised:
November 1, 2013


Page
16

of
19

Spira
®

is a registered trademark of Spira Data Corp


7

Install Spira Client Update Tool

1.

Obtai n ISO or Instal ler

2.

Fol l ow on screen i nstructi ons

a.

When prompted wi th Cl i ent FTP Downl oad Si te screen, enter i n the fol l owi ng val ues:

i.

FTP Si te: FTP si te hol di ng mobi l e update fi l es

ii.

FTP Us
er: FTP user name

iii.

FTP Password: FTP password

b.

When prompted wi th Appl i cati on FTP Downl oad Si te screen, enter i n the fol l owi ng val ues:

i.

FTP Si te: FTP si te hol di ng
cl i ent update tool fi l es


ii.

FTP User: FTP user

name

iii.

FTP Password: FTP password

c.

When prompted by
Versi on Informati on scr
een, enter i n the Command
\
Mobi l e

versi on

i.

To fi nd the versi on go to C:
\
Program Fi l es
\
Spi ra Data Corp
\
Spi ra
Mobi l e

ii.

Fi nd Spi ra.Base.dl l, ri ght cl ick and go to Properti es

iii.

Choose the Detai l s tab and fi nd the Fi l e versi on


d.

When prompted w
i th Sel ect Instal lation Fol der, l eave al l fi el ds as the defaul t val ues:

i.

C:
\
Program Fi l es
\
Spi ra Data Corp
\

Spi ra Update Cl i ent
\

ii.

Everyone

Starti ng for the fi rst ti me

1.

Doubl e Cl i ck on Spi ra Cl i ent Update Tool desktop i con

2.

Doubl e Cl i ck the i con i n the taskbar t
o open Spi ra Cl i ent Update Tool

3.

Spi ra Cl i ent Update Tool wi l l automati cal ly search for an update.






SPIRA
INSTALLATION AND CONFIGURATION GUIDE
©200
9


Revised:
November 1, 2013


Page
17

of
19

Spira
®

is a registered trademark of Spira Data Corp


4.

Cl i ck Update once downl oad has been compl eted.


5.

If a pl ugi n exi sts thi s needs to be updated

a.

Open Spi ra Command.

b.

Under Data go to Offl i ne Store



c.

Change
the drop down l i st from Desktop
\
Spi ra Di spatch to Pl ugi ns under Documents to be
Broadcast


d.

Add the Pl ugi n fi l e.

e.

Check the pl ugi n fi l e and cl i ck Publ ish.






SPIRA
INSTALLATION AND CONFIGURATION GUIDE
©200
9


Revised:
November 1, 2013


Page
18

of
19

Spira
®

is a registered trademark of Spira Data Corp



6.

Spi ra Mobi l e i s now up to date.

8

SQL Server Configurations

8.1.1

Server Settings

Your SQL server wi l l
need to be confi gured to al l ow
: Local and
remote connecti ons

usi ng both TCP/IP and named
pi pes:

1.

Cl i ck
Start
, poi nt to
Programs
, poi nt to
Microsoft SQL Server 2005
, poi nt to
Configuration Tools
, and then cl i ck
SQL
Server Surface Area Configuration
.

2.

On the
SQL Server 2005 Surface Area
Configuration

page, cl i ck
Surface Area
Configuration for Services and Connections
.

3.

On the
Surface Area Configuration for
Services and Connections

page, expand
Database Engine
, cl i ck
Remote Connections
,
cl i ck Local and remote co
nnecti ons, cl i ck the
appropri ate protocol to enabl e for your
envi ronment, and then cl i ck
Apply
.

a.

Spi ra Suggests, for best performance,
usi ng
Using both TCP/IP and named pipes
.

b.

NOTE:

Cl i ck
OK

when you recei ve the fol l owi ng message:

Changes to Connecti on
Setti ngs wi l l not take effect unti l you restart the Database Engi ne servi ce.

4.

Restart your SQL server

Addi ti onal Resources:



How to confi gure SQL Server 2005 to al l ow remote connecti ons

http://support.mi
crosoft.com/kb/914277





SPIRA
INSTALLATION AND CONFIGURATION GUIDE
©200
9


Revised:
November 1, 2013


Page
19

of
19

Spira
®

is a registered trademark of Spira Data Corp


8.1.2

Spira Database
User Configuration

For securi ty reasons, a
Spi ra Speci fi c
SQL
authenti cated
user shoul d be used for Appl i cati ons

(CORP + COM)

to
connect to databases:
Spira

+
SpiraMessaging
.

Thi s user can al so be used for Crystal Rep
orts read connecti on
stri ng confi gured at [Setup] > Company
. Usi ng sa/Password99 i s not secure:


1.

Cl i ck
Microsoft SQL Server Management Studio
. Connect to the
database server wi th admi ni strator account. Expand
Security
. Ri ght
-
Cl i ck
Logi ns, New Logi n.


2.

Create a SQL Server authenti cati on user,

i e. “Spi raUser” wi th password, “password”


3.

Cl i ck on
User Mapping
page.


Map
Spira

by cl i cki ng the checkbox

besi de the database Spi ra
.
Gi ve Database rol e membershi p for Spi ra:
[ ]db_datareader

and
[ ]
db_datawriter
. Ensure that

[ ] public
i s sti l l checked

Repeat for
SpiraMessaging
.

Cl i ck
OK

to create the user.

4.

Thi s user
wi l l now have read and wri te access to the Spi ra and Spi raMessagi ng databases
.