Online Reporting Setup

About Online Reporting: Online reporting allows you to access your PointOS databse remotely. To use online reporting you must sign up from your PointOS application providing your email address and a password. Once you have an account you will need to setup your firewall to allow connections in and out for SQL server, and setup your router (if you are using one) to allow incoming connections to be sent to the correct computer and database. Note: No sales or customer data is stored by our servers. All data is stored on your database, and only you will be able to access it. Setting Up Your Port: It may not be necessary to setup the tcp port on SQL Server. It should be set to the 1433 default. However, if not here are some instructions: 1. Go to SQL Server Configuration Manager 2. Expand the SQL Server 2005 Network Configuration 3. Select the Protocol for the SQL Server instance SHAKENSOFT 4. Enabled the TCP/IP 5. Right the TCP/IP protocol and go to properties 6. Click on the IP Addresses tab 7. Go to the last one called IPALL 8. Set the TCP Dynamic Ports To 1433 You can find more information on setting up your SQL port here: MSDN Port Config Port Setup Firewall Setup: To use online reporting you have to make sure that your firewall is allowing connections in or out of your computer. You will only want to allow access to SQL Server on port 1433. These steps apply to the version of Windows Firewall that is included in Windows XP Service Pack 2 (SP2) and in Windows Server 2003. If you are using a different firewall system, see your firewall documentation for more information. If you are running a firewall on the computer that is running SQL Server 2005, external connections to SQL Server 2005 will be blocked unless SQL Server 2005 and the SQL Server Browser service can communicate through the firewall. You must create an exception for each instance of SQL Server 2005 that you want to accept remote connections and an exception for the SQL Server Browser service. SQL Server 2005 uses an instance ID as part of the path when you install its program files. To create an exception for each instance of SQL Server, you must know the correct instance ID. The instance ID is SHAKENSOFT. Create an exception for SQL Server 2005 in Windows Firewall To create an exception for SQL Server 2005 in Windows Firewall, follow these steps: 1. In Windows Firewall, click the Exceptions tab, and then click Add Program. 2. In the Add a Program window, click Browse. 3. Click the C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\sqlservr.exe executable program, click Open, and then click OK. Create an exception for the SQL Server Browser service in Windows Firewall To create an exception for the SQL Server Browser service in Windows Firewall, follow these steps: 1. In Windows Firewall, click the Exceptions tab, and then click Add Program. 2. In the Add a Program window, click Browse. 3. Click the C:\Program Files\Microsoft SQL Server\90\Shared\sqlbrowser.exe executable program, click Open, and then click OK. Find more information on setting up your Windows Firewall here: SQL Server Express Setup Find more information on setting up other firewall types here Firewall Setup or Windows Firewall Windows Firewall Firewall Settings Setting Up Your Router: To setup your router for online reporting you will need to use port forwarding. You will need to allow your router to send all commands from PointOS's server to the computer that hosts your database. The solution is to open up a door, or port, in your router for the information to come through. Most applications have specific ports that need to be opened for them to work, for your PointOS database that port is 1433. You can find more information on setting up your router for Port Forwarding here: Wikki or Port Forwarding By Router Router Setup