Transight POS - How to install Transight database in Windows7

When you upgrade POS to windows7. You need to upgrad new database for it too.

Step1: Uninstalling Old Microsoft SQL Server Desktop Engin

Go to: Start->Control Panel->Programs and Features
Remove: Microsoft SQL Server Desktop Engine

Step2: Installing New SQL Server (version2008 or later)

Run: SQL Server Installer and choose New Installation.

When asked for components to install, select all and click next

When asked for creating SQL instance, select Default Instance and press next

When asked for service accounts configuration, make sure all services are set to Automatic

On the same page, press Use the same account for all SQL Server services, and choose NT AUTHORITY\SYSTEM, then press OK

When asked for authentication mode, select Mixed Mode authentication and enter password DTSbsd7188228, then press Next to continue installation.

When installation was compleated.
Go to: Start->All Programs->Microsoft SQL Server 2008 R2->Configuration Tools->SQL Server Configuration Manager, expand SQL Server Network Configuration and click on Protocols for MSSQLSERVER, enable connection for Named Pipes and TCP/IP

In SQL Configuration Manager, click on SQL Server Services; right click on SQL Server and SQL Server Browser then press restart, this is required in order to have TCP/IP and Named Pipes enabled

Step3: Attach Transight Database

Start->All Programs->Microsoft SQL Server 2008 R2->SQL Server Management Studio, choose SQL Server Authentication and enter the ‘sa’ password configured during the installation

On the object explorer, Right click on Database and press Attach Database. Attach the three MDF files found in C:\DTSPOS\DATA folder, the database name must be renamed to DTSPOS, POS, and POSJ. After that, press OK to attach the databases.

On the Object Explorer, expand Security and right click on Login, then press New Login. Login name is datascan, SQL Server Authentication, password is DTSbsd7188228. Uncheck Enforce password policy option

On the left pane, click on Server Roles, and check sysadmin role, then press OK

Step4: Modifying SQL Server Configuration

In SQL Server Management Studio, right click on the SQL Server on the Object Explorer and click on Facets…

Select Facet: Server Configuration
and Change the properties of the following below:
AgentXPsEnabled = TRUE
OleAutomationEnabled = TRUE
ReplicationXPsEnabled = TRUE
XPCmdShellEnabled = TRUE

Step5: Finish and Test Transight POS

Start Transight POS by launching the Transight POS and Manager icon on the Desktop, and the software is ready to use.