Installing and Configuration

InTransit Server Manager

SupportDepartment — Thu, 11 Feb 2010 21:19:58 GMT

Current revision posted to Installing and Configuration by SupportDepartment on 11/02/2010 21:19:58

InTransit Server Manager

Filed under: Server, Network

1. Ensure that “InTransit Express 2010” is installed on each machine you wish to use.

2. Download “InTransit Server Manager

Download here

If any "FIX" buttons are enabled, click them ” to make the change PC you wish to your system, for a list changes each button makes, see below:

1. Firewall State

Determines if your Windows Firewall is Enabled. {ON|OFF}

2host the Database.SQL Process Allowed

Check that an exception exists for "sqlsrvr.exe"

From Here: http://www.intrans.it/download/server/intransitserver.exe

3.SQL Port Allowed

Check that an exception exists for TCP Port 1433

Take note of this computers' (server) network name:

This can be found by going to

“Start->Run->cmd->Ok” and typing “echo %computername%”

(without the quotes but with the %)

4.Dataservice State

Checks that the Windows Service for SQL Server is running Ensure any enabled fix buttons are clicked

5.SQL Login Mode

If there is no LDAP Infrastructure (Windows Server Domain or similar) then Windows Authentication will not work between two Windows Peer-Clients, this will allow Select the use of a username and password to access InTransit Database from the database.drop down

6. Click “Create a new SQL Browser State User” enter and Startup Type

Checks remember the connection service is running user name and set to start automatically.

* IF CLICKING FIX ON ITEM 6 OR 7 CAUSES AN ERRORpassword, PLEASE RESTART THE PC.

7. Create one or more users this is for the user on the other machines machine(s)

7. If you had to use by clicking create new sql user

Once this click any of the fix buttons a machine restart is setup, go recommended but not usually essential (this is just in case)

<o:p> </o:p>

8. Go to the other one(s) PC (client) and inside the open InTransitApplication, go to "Tools->Options->Database

9. On the Main Window goto ”Tools->Options->Database Settings " set Tab->Change”, if you get a message box asking about a default database click “No”

10. In the Wizard’s Server to Location Tab, select “Use a Remote Server” in the one configured above dropdown there should be an entry

“%computername%(eg. "{ServerName}\SQLEXPRESS") and from step 2)\SQLEXPRESS” use this one, if there isn’t you can manually type it and click “Next”

11. Select “Use SQL Server Authentication” and enter the user name username and password (Not Windows Login) you created in from step 7 above5 and click next

12. Select “Use an existing Database” then the appropriate InTransit Database from Step 4.

13. Click “Next” then “Finish”

14. Enter Data on both the client pc and the server pc and enusre that the other can see it.

InTransit Server Manager

SupportDepartment — Thu, 16 Jul 2009 11:36:30 GMT

Revision 2 posted to Installing and Configuration by SupportDepartment on 16/07/2009 12:36:30

InTransit Server Manager

Filed under: Server, Network

InTransit Server Manager

Download here

If any "FIX" buttons are enabled, click them to make the change to your system, for a list changes each button makes, see below:

1. Firewall State

Determines if your Windows Firewall is Enabled. {ON|OFF}

2. SQL Process Allowed

Check that an exception exists for "sqlsrvr.exe"

3. SQL Port Allowed

Check that an exception exists for TCP Port 1433

4. Dataservice State

Checks that the Windows Service for SQL Server is running

5. SQL Login Mode

If there is no LDAP Infrastructure (Windows Server Domain or similar) then Windows Authentication will not work between two Windows Peer-Clients, this will allow the use of a username and password to access the database.

6. SQL Browser State and Startup Type

Checks the connection service is running and set to start automatically.

* IF CLICKING FIX ON ITEM 6 OR 7 CAUSES AN ERROR, PLEASE RESTART THE PC.

7. Create one or more users for the other machines to use by clicking create new sql user

Once this machine is setup, go to the other one(s) and inside the InTransit Application, go to "Tools->Options->Database Settings" set the Server to the one configured above (eg. "{ServerName}\SQLEXPRESS") and use the user name and password (Not Windows Login) you created in step 7 above

InTransit Server Manager

SupportDepartment — Wed, 15 Jul 2009 06:38:06 GMT

Revision 1 posted to Installing and Configuration by SupportDepartment on 15/07/2009 07:38:06

InTransit Server Manager

Download here

If any "FIX" buttons are enabled, click them to make the change to your system, for a list changes each button makes, see below:

1. Firewall State

Determines if your Windows Firewall is Enabled. {ON|OFF}

2. SQL Process Allowed

Check that an exception exists for "sqlsrvr.exe"

3. SQL Port Allowed

Check that an exception exists for TCP Port 1433

4. Dataservice State

Checks that the Windows Service for SQL Server is running

5. SQL Login Mode

6. SQL Browser State and Startup Type

Checks the connection service is running and set to start automatically.

* IF CLICKING FIX ON ITEM 6 OR 7 CAUSES AN ERROR, PLEASE RESTART THE PC.

Multi-User: Same Machine

SupportDepartment — Tue, 09 Feb 2010 07:02:59 GMT

Current revision posted to Installing and Configuration by SupportDepartment on 09/02/2010 07:02:59

Multi-User: Same Machine

Filed under: Installation, Configuration

InTransit is deployed per user by Click Once in order not require Administrator Priveleges on Windows Vista and Windows 7, however this may lead to other users on the same machine being unable to access the SQL Database.

Follow the steps below to grant the user permission:

Start->All Programs->Microsoft SQL Server 2005->Configuration Tools

SQL Server Surface Area Configuration.

{1}:

Add new Administrator

{2}:

Type the username you wish to grant access to.

Click on the ">>" button to assign the permission

Click on OK.

{1}:

{2}:

Multi-User: Same Machine

SupportDepartment — Tue, 09 Feb 2010 07:00:29 GMT

Revision 1 posted to Installing and Configuration by SupportDepartment on 09/02/2010 07:00:29

Follow the steps below to grant the user permission:

Start->All Programs->Microsoft SQL Server 2005->Configuration Tools

SQL Server Surface Area Configuration.

{1}:

Add new Administrator

{2}:

Type the username you wish to grant access to.

Click on the ">>" button to assign the permission

Click on OK.

{1}:

{2}:

Multiple Machines

SupportDepartment — Wed, 15 Jul 2009 06:35:34 GMT

Current revision posted to Installing and Configuration by SupportDepartment on 15/07/2009 07:35:34

To enable remote connections on the instance of SQL Server 2005 and to turn on the SQL Server Browser service, use the SQL Server 2005 Surface Area Configuration tool. The Surface Area Configuration tool is installed when you install SQL Server 2005.

Enable remote connections for SQL Server 2005 Express or SQL Server 2005 Developer Edition

You must enable remote connections for each instance of SQL Server 2005 that you want to connect to from a remote computer. To do this, follow these steps:

Click Start, point to Programs, point to Microsoft SQL Server 2005, point to Configuration Tools, and then click SQL Server Surface Area Configuration.
On the SQL Server 2005 Surface Area Configuration page, click Surface Area Configuration for Services and Connections.
On the Surface Area Configuration for Services and Connections page, expand Database Engine, click Remote Connections, click Local and remote connections, click the appropriate protocol to enable for your environment, and then click Apply.

Note Click OK when you receive the following message:
Changes to Connection Settings will not take effect until you restart the Database Engine service.
On the Surface Area Configuration for Services and Connections page, expand Database Engine, click Service, click Stop, wait until the MSSQLSERVER service stops, and then click Start to restart the MSSQLSERVER service.

Enable the SQL Server Browser service

If you are running SQL Server 2005 by using an instance name and you are not using a specific TCP/IP port number in your connection string, you must enable the SQL Server Browser service to allow for remote connections. For example, SQL Server 2005 Express is installed with a default instance name of Computer Name\SQLEXPRESS. You are only required to enable the SQL Server Browser service one time, regardless of how many instances of SQL Server 2005 you are running. To enable the SQL Server Browser service, follow these steps.

Important These steps may increase your security risk. These steps may also make your computer or your network more vulnerable to attack by malicious users or by malicious software such as viruses. We recommend the process that this article describes to enable programs to operate as they are designed to, or to implement specific program capabilities. Before you make these changes, we recommend that you evaluate the risks that are associated with implementing this process in your particular environment. If you choose to implement this process, take any appropriate additional steps to help protect your system. We recommend that you use this process only if you really require this process.

Click Start, point to Programs, point to Microsoft SQL Server 2005, point to Configuration Tools, and then click SQL Server Surface Area Configuration.
On the SQL Server 2005 Surface Area Configuration page, click Surface Area Configuration for Services and Connections.
On the Surface Area Configuration for Services and Connections page, click SQL Server Browser, click Automatic for Startup type, and then click Apply.

Note When you click the Automatic option, the SQL Server Browser service starts automatically every time that you start Microsoft Windows.
Click Start, and then click OK.

Note When you run the SQL Server Browser service on a computer, the computer displays the instance names and the connection information for each instance of SQL Server that is running on the computer. This risk can be reduced by not enabling the SQL Server Browser service and by connecting to the instance of SQL Server directly through an assigned TCP port. Connecting directly to an instance of SQL Server through a TCP port is beyond the scope of this article. For more information about the SQL Server Browser server and connecting to an instance of SQL Server, see the following topics in SQL Server Books Online:

SQL Server Browser Service
Connecting to the SQL Server Database Engine
Client Network Configuration

Create exceptions in Windows Firewall

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 identify the correct instance ID. To obtain an instance ID, follow these steps:

Click Start, point to Programs, point to Microsoft SQL Server 2005, point to Configuration Tools, and then click SQL Server Configuration Manager.
In SQL Server Configuration Manager, click the SQL Server Browser service in the right pane, right-click the instance name in the main window, and then click Properties.
On the SQL Server Browser Properties page, click the Advanced tab, locate the instance ID in the property list, and then click OK.

To open Windows Firewall, click Start, click Run, type firewall.cpl, and then click OK.

Create an exception for SQL Server 2005 in Windows Firewall

To create an exception for SQL Server 2005 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\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.

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.

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

Originally Published on Microsoft's Support Knowledge Base;

Initial Setup

SupportDepartment — Sun, 21 Jun 2009 22:05:06 GMT

Current revision posted to Installing and Configuration by SupportDepartment on 21/06/2009 23:05:06

Installing:
Configure the Database
Register