Multi Station
Multiple Station Setup:
You can connect multiple clients to one central database computer. This computer must have PointOS/Server Client installed on it, and the other computers just need PointOS Client. The client computers can be any Vista or XP machine, however the server cannot be XP Home Edition or Vista Home Basic.

PointOS Installer
Enable File Sharing:
The first thing you'll want to do when setting up multiple stations is make sure the PointOS Database folder is shared. Other stations will need to be able to access the shared files on the central server. You should be able to go to Network and see PointOS Database on >computername<. This folder should be accessable without a password and should allow new files to be created or changed in it.

If you cannot access this folder, you may need to enable file sharing on your database server. To do this in Windows XP, go to My Documents and then find the PointOS Professional folder. Right click on this folder and go to Sharing. From here you'll need to click on 'If you understand the security risks but want to share the files without running the wizard, click here'. Then click on Just Enable File Sharing and press OK. Make sure the Share Name is PointOS Database and that 'Allo network users to change my files' is checked. Then press the OK button to finish.

In Windows Vista, you'll need to go to Start - Network, and then click on Network and Sharing Center at the top of the window. Make sure that File sharing and Public folder sharing are turned on. Then turn off Password protected sharing. After you have enabled sharing then go to Documents - PointOS Professional and right click on the PointOS Professional folder. Go to share, and share out the folder with the name PointOS Database.

See
Getting Started for information..

XP Sharing

Vista Sharing

Connecting To A Central Server:
When you install Client Only on a computer to connect to a central database computer, you must select the computer name and database name from the drop down lists.

If your central database computer does not show up in the list, make sure that all of your stations are on the same workgroup and that your firewall is setup correctly (see below).

See
Getting Started for information..

Choose Computer
And Database
Setting Up XP Server:
The installer is supposed to grant access rights to SQL server on the database computer, however sometimes protection in the operating system will not allow this to occur. So, when this happens rights must be setup manually. This is only for servers running XP Professional.

To do this you must go to Control Panels - Administrative Tools - Computer Management.

Administrative Tools
Assigning Rights:
To allow other computers to connect to your XP Pro computer you'll need to give them access rights. Once in Computer Management, click on Local Users And Groups then Groups.

You'll want to add everyone to all 3 SQL server groups. This will allow 'everyone' from your network to be able to access the database.

Computer Management
Adding User To Group:
Assign Access Rights To Groups:
  • SQLServer2005MSSQLServerADHelperUser$SHAKENSOFT
  • SQLServer2005MSSQLServerADHelperUser$SHAKENSOFT
  • SQLServer2005SQLBrowserUser$SHAKENSOFT

    Click on the group name, then click the Add button to add a user.

    In the box that pops up, Select Users, type in the object name everyone then click OK.

    Do this for all SQLServer Groups listed.



  • Add User
    Windows Firewall Setup:
    If the databases are still not showing up on your client computers, you may have an issue with your firewall programs. If you are using Windows Firewall, you can disable it (not recommended) or make exceptions for SQL Server.

    To start, in Windows Firewall, click the Exceptions tab, and then click Add Program.

    Windows Firewall
    Creating SQL Firewall Exception:
    In the Add a Program window, click Browse.
  • Click the C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\sqlservr.exe executable program, click Open, and then click OK.

    Note The path may be different depending on where SQL Server 2005 is installed.

    MSSQL.1 is a placeholder for the instance ID that you obtained in step 3 of the previous procedure.

    Repeat steps 1 through 3 for each instance of SQL Server 2005 that needs an exception.

    PointOS uses an instance name of SHAKENSOFT for SQL Server.

  • Windows Firewall

    Creating SQL Browser Exception:
    You will also need to 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:
  • In Windows Firewall, click the Exceptions tab, and then click Add Program.
  • In the Add a Program window, click Browse.
  • Click the C:\Program Files\Microsoft SQL Server\90\Shared\sqlbrowser.exe executable program, click Open, and then click OK.

  • Enable Exceptions