Advanced Xin Inventory Server Setup

Advanced Setup For Xin Inventory 2.0 Server - If normal installation failed



By default, Xin Inventory 2.0 server environment should be setup correctly if install Xin Inventory as Server / Standalone. However, under some circumstances the installation and configuration might failed .This document is help the advanced user to setup Xin Inventory correctly. To know Xin Inventory simple setup and architecture, Please refer to the Xin Inventory 2.0 Network Setup for referrence.

Steps perform during Xin Inventory 2.0 Server Setup

There are 3 main steps that will be performed by Xin Inventory 2.0 setup during installation.
1. MS SQL Server 2008 Express Setup and configuration
2. Firewall add port for Client/LAN user access
3. Enable folder permission
4. Install Xin Inventory 2.0 as client in server.
5. Open Xin Inventory 2.0 in server.


1. MS SQL Server 2008 Express Setup and configuration


- Install MS SQL Server 2008 Express
Xin Inventory 2.0 will install Microsoft SQL Server 2008 R2 RTM Express into the computer. If there is any failure, please download http://www.microsoft.com/en-us/download/details.aspx?id=23650 and install MS SQL 2008 R2 RTM Express. Download SQLEXPR_x86_ENU.exe if you are using 32bit machine and download SQLEXPR_x64_ENU.exe if you are using 64bit machine. For more information, please contact our support http://support.xincube.com
For the installation steps, please refer to http://blogs.msdn.com/b/bethmassi/archive/2011/02/18/step-by-step-installing-sql-server-management-studio-2008-express-after-visual-studio-2010.aspx

Please open SSMS and connect to the Microsoft SQL Server 2008 R2 RTM Express . Server name: "your computer name" \ "instance Name". For my case, my computer name is WIN7-VMWARE and instance name is SQLEXPRESS. Click on determine SQL Server instance name to know how to check the instance name.




- Create Xin Inventory database
If there is newer MS SQL Server that already running in the server, please download XinInventorybak.zip unzip the file and restore into the server. Please contact our support http://support.xincube.com if have any issues.

Open SSMS and connect to SQL Express 2008 Database. Right Clcik on the database and click on Restore Database.




- Create Xin Inventory database's user login
By default, the setup will create Xin Inventory 2.0 database user. If there is any failure, please contact our support.

Open SSMS and connect the SQL database. Expend the folder under Security folder. Right click on the Logins and click on New Login.



- Enable TCP/IP



- Enable Microsoft SQL Browser service and SQL Server (xxxx) service




- Check Dynamic Port Number



2. Firewall add port for Client/LAN user access
- Add Port Number to Firewall



3. Enable folder permission
- Share Xin Inventory 2.0 installed folder.




4. Install Xin Inventory 2.0 as client in server
- Select install Xin Inventory 2.0 as Client.



5. Open Xin Inventory 2.0 in Server

We can test on it once the installation is completed. Click on Xin Inventory 2.0 icon in Desktop to open Xin Inventory 2.0 for the first time.


2. Select Local
3. Try to enter SQLEXPRESS as instance name. Click on determine SQL Server instance name to know how to check the instance name.
4. Click on Test Connection button to test connection.
5. Click on OK button if the network connection tested ok.
6. Click on Save button to save the setting.



Free invoice software trial!

Click on the button to Xin inventory software download page.

billing software
You can download Xin Inventory 2.0, 30 days trial version. After 30 days trial, if you wish to continue to use Xin Inventory 2.0, you can purchase the registration key to unlock the inventory software.

Buy Xin Inventory software!

Click on the button to Xin Inventory software purchase page.

billing software
You can purchase Xin Inventory 2.0 registration key to unlock this inventory software and use it permanently. After you purchase the key, our system will send the key to you through email.