How to install the eStockCard Server into SQL Server 2008R2 PC?

February 21st, 2013, Filed in Install, Activate & Update

Here are the steps to setup Chronos eStockCard on your own  SQL Server 2008:-

To setup a new Instance Engine, run the SQL 2008 Setup, it will install another instance engine name to be  used for Chronos eStockCard System.

STEP:

a) Start the new instance installation by clicking the “New installation or add features to an existing installation”. Then proceed to tick on New Installation.

Installation

 

Installation Type

 

b) Tick the checkbox to accept the agreement and click “Next” button.

SQL 2008 Agreement

 

c) Under Instance Features, tick on Database Engine Services as shown below. Proceed to click Next.

Feature Selection

 

d) Instance Configuration:- Type the Named Instance as ESTOCKCARD3 as shown. Ensure the instance root directory is also as shown below and proceed to click Next.

Instance Configuration

 

e) Again click Next

Server Configuration

 

f) Tick on Mixed Mode and then enter your required password for the SQL database and then click Next. **** Please remember to keep a copy of the password created.

Database Configuration

 

g)  Click Next button.

Error Reporting

 

h) Now wait for the installation to complete.

Installation Process

 

To Reattach the Database

1. Locate the 4 database files under Chronos eStockCard Folder_v3.1.x\Files\.  The 4 files are:- eSock.mdf. eStock_Archive.mdf, eStock_Archive_log.ldf and eStock_log.LDF. Please refer image below.

 

Install Files

2. Copy and paste this file into new EStockCard Data Folder, should be C:\Program Files\EStockCard3 SQL Server\MSSQL.1\MSSQL\Data folder  - for 32 bit PC or C:\Program Files(x86)\EStockCard3 SQL Server\MSSQL.1\MSSQL\Data – for 64 bit PC.

3. Then use Microsoft SQL Server Management Studio Express or equivalent tools to reattach the database, you need to reattach two database, eStock and eStock_Archive. Run your Microsoft SQL Server Management Studio Express and at “Connect to Server” screen, choose your MachineName\ESTOCKCARD3 and login. You should have no database at this point, only Master and few database.

4. Right click the database header and choose “attach” menu, click “Add” button to select the eStock.mdf file (refer my sample below), then click “OK” button.

Database File

5. Repeat the same steps for eStock_Archive, remember to create the DBO user and assign the DBO user can access eStock and eStock_Archive Database and the Master Database as well.

 

For changing connection during login


  1. Run the Chronos eStockCard Program, default system will look for ESTOCKCARD3 instance. Since you are not using the “SA” password that we supplied, you will see the Error Connecting Dialog when you come to Login Screen and this is a normal case.
  2. Click the “Server Connection” button and change the Server Connection Configuration.
  3. Click the “Connect” button. If the connection is established, the Connection Dialog will close by itself.
  4. Finally, you can login to Chronos eStockCard System now.



Related posts:

  1. How to Set the eStockCard Server from my own SQL Server 2005 into the PC server?
  2. I’m using Chronos eStockCard Network Version. After changing my computer name, why I can’t connect to eStockCard server again?
  3. SQL Server Setup Cannot Install to Compressed Folder
  4. I am unable to install the Chronos eStockCard due to MS. SQL Server Native Client not being found during installation. What should I do?
  5. Unable to Re-Create Database from the Installation file