FTP CONFIGURATION ( FOR SO TO HO DATA TRANSFER )

FTP SERVER CONFIGURATION
Ø Computer connect with existing server (through LAN cable)
Ø O.S. Windows 2000 Server with IE 6 & SP4 or Windows 2003
Ø Internal (or) external Dialup modem (both end HO and SO)
Ø Parallel phone connection from existing phone (both end HO and SO)

AT HO :

1. Install windows 2000 server and 2003 server and create active directory. Give server name and domain like XXXftpserver, XXXftpdomain. Give ip number (give running number in your HO domain and not to give your existing HO server IP number)
2. Install modem driver and check diagnostics.3. Go to control panel add and remove programs windows components wizard IIS enable all services (ftp transfer protocol ftp service)
4. a. Start -+ Program – Admin Tools – Internet Service Manager
b. Click Domain Name – It Shows Server Name
c. Right click the server name – select ‘new’ – select ‘ftp site’ – give name – give IP address (your computer).
d. Give TCP Port – 21 (always)
e. Give path – D:\SBFTP\Received (Create directory)
f. Give permission – read and write – click finish.
(By default created ftp site will be stopped)
g. Right click newly created FTP site – property – check IP address and TCP port and give connections ‘unlimited’.

5. a. Select admin tools – routers and remote access
b. Right click server name – configure routing and remote services – click manual selection.
c. Select server name – ports – right click – select property – click selected modem – configure – make tick in ‘inbound only and inbound and out bound’.
d. Give phone number of this server.

6. a. Select admin tools – select active directory users and computers.
b. Create a new user (like XXXftp, YYYftp…) and give the password same in user name.
c. Right click created new user – select ‘dialin’ tab – make tick in ‘allow access’ – select ‘member of’ tab – make the user in domain user and give administrator rights to that user.
d. Create a network user as available in existing server and give Administratory rights (this domain) to that user.
7. Check the IIS and RRAS running correctly.
8. a. Install MSSQL 2000 client connectivity only (not to install full setup)
b. Click client connectivity – give the server name (existing old server name) alias
9. Install Bridge and Plugin. ( or Copy SB Plugis 2.5.3 Version )

AT SOS :
1. Install modem and create a dialup connection with username, password, and phone number created at HO level same as HO.
2. Install bridge and Plugin ( or Copy SB Plugis 2.5.3 Version ) and configure the FTP.

(Please delete old ‘PATCH’ database and create new thro ‘SB Plugin’ software)

SQL Backup & database Maintenance Plan

For Taking SQL backup
Backup Database ( Single Database )

Start -> programes -> Microsoft SQL Server -> Enterprise Manager ->
Server -> Database -> ( Select Database) All Task -> Backup Database -> Add -> Give Backup Path & filename -> Ok ->
----------------------------------------------------------
Restore Database ( Single Database Eg. Database Name as xxx )
Start -> programes -> Microsoft SQL Server -> Enterprise Manager -> Server -> Database ->
(Due to Security Problem it is not explained here)
Ok
----------------------------------------------------------
Database Maintenance Plan (Database Backup)
Management -> Database Maintenance Plan ->
New Maintenance Plan -> Select Databases
( All or user or Selected )
Next -> Next -> Next ->
Specify the database Backup Plan (Apply Tick )
Specify the Transaction log Backup Plan (Remove Tick)
Change the Job Time
Specify the DB Backup Disk Directory
Option : Use This Directory
( eg. E:\BACKUP for Local Backup
(eg file://CLIENT/BACKUP for Network Backup )
Next -> Next -> Next -> Next -> Plan Name
( eg. SERVER DAILY 16.00 HRS )
Finish

The Schedule has Starts in the correct time if the system is in ON condition

Database Maintenance Plan ( Transaction log File Backup )

Management -> Database Maintenance Plan ->
New Maintenance Plan -> Select Databases
( All or user or Selected )
Next -> Next -> Next ->

Specify the database Backup Plan (Remove Tick )
Specify the Transaction log Backup Plan (Apply Tick)

Change the Job Time
Specify the DB Backup Disk Directory
Option : Use This Directory
( eg. E:\BACKUP OR file://CLIENT/BACKUP)

Next -> Next -> Next -> Next -> Plan Name
( eg. SERVER DAILY 16.00 HRS )
Finish

Steps Followed in the New Server Installation

1. WINDOWS 2003 -SERVER INSTALLATION
2.SQL –2000 / 2005 ( DATABASE SERVER INSTALLATION )
3.PREREQUISITIES INSTALLATION
SQL2000 - SP4
SQl2005 - SP1
WINDOWS 2003 SERVER SP2
DOTNET 2.0, 2.1, 3.0, 3.5 ( any one version )
MABRY BARCODE (eMO)
4. Meghdoot software installation
> Server Component and client Application
> Share the server folder
eg. PointofSale , Treasury, Subaccounts, Speednet
5. run the software for Database creation

6. Sanchaypost software installation
( POST folder creation)
7. run the software for Database creation
8. Database restoration ( all databases one by one )
9. Copy the MDB files in to concerned server folder
10. DCL user updation ( for SP only)

Check the correctness of Database restoration