***********************************************************
I n s t a l l a t i o n   I n s t r u c t i o n s
--------------------------------------------------------------------------

D a t a B a s e   s e r v e r :

Install SQL or MSDE

*********************

Installing MSDE

*********************

1.) execute the self extracting file MSDE2000A.exe
	This will start the extrating process. allow the extraction to 
	copy the files to the default location.

2.) copy the setup.ini file to the folder where the extracted files are.

3.) execute the setup.exe in the folder where the extracted files are.

4.) Restart the computer this will start the MSDE. You should see the icon 
    in the system tray.

------------------------------------------------------------------------------

Copying Data Base

copy the sql data base SNC_TA_data.mdb and SNC_TA_log.ldb to the 
"c:\program files\microsoft sql\mssql\data" folder.

These files are in the zipped file SNC_TA_DB.zip


------------------------------------------------------------------------------

Attaching the database:

copy scripts folder into c:\

In the scripts folder

execute the TA_attachdb.bat to attach the T&A database.

------------------------------------------------------------------------------

Granting Access:

In the scripts folder...

execute the TA_GrantAccess.bat to create the authentication. 

------------------------------------------------------------------------------
Edit the registry

Run the registry editor (Select Start | Run from the windows start menu, type 
regedit and then click OK). You can also do this from the command promt.

Set the value HKLM\Software\Microsoft\MSSqlserver\mssqlserver\LoginMode to 2. 

This tells your server to accept SQL Server & Windows authentication methods. 
Note HKLM stands for HKEY_Local_Machine.

exit the registryeditor

restart the MSDE  

from the command promt ( you can also do this through the services dialog )

NET STOP MSSQLSERVER
NET START MSSQLSERVER


------------------------------------------------------------------------------

ODBC:
 (pronounced as separate letters) Short for Open DataBase Connectivity.

On all client computers:
This includes terminals and terminal server.

create an entry under system dsn for TAdb using the sql driver, point to 
the SNC_TA database.

OS dependant
start > settings > control panel > administrator tools > data source (ODBC)  
Select System DSN (Data Source Name)
select add > SQL Server 
Name: TAdb
Server: enter name of sql or MSDE server or IP
Next
Choose sql authentication
select client config > select tcp >ok
Check connect to sql server to obtain additional configuration options.
if using sql server authentication enter the user and password
Next
Check the change default database to: SNC_TA
Next
Finish
Click on test, if you anything but success you are not connecting to the 
database. you must correct this for the client computer to access the database.

------------------------------------------------------------------------------