TMS 1.0

Rating: No reviews yet
Downloads: 110
Released: Jun 2, 2011
Updated: Jun 2, 2011 by gurvinderd
Dev status: Alpha Help Icon

Recommended Download

application, 7717K, uploaded Jun 2, 2011 - 110 downloads

Release Notes

Refer install.txt in TMS1.0 folder for installtion steps.

The following steps are necessary to install a 2-tier desktop client application:

1. Install SQL Server Express on the target (client) computer, if not already installed. TMS require SQL Server 2005 or a later version, or SQL Server Express 2005 or a later version. Learn more about SQL Server Express installation options.

2. On the target computer, deploy the database schema by using sqlcmd.exe command tool. The Sqlcmd.exe tool is installed with SQL Server, typically in the \Microsoft SQL Server\100\Tools\Binn directory under the Program Files or Program File (x86) directory.

a. From an elevated Command Prompt, change to the directory TMS1.0 and enter a command similar to the following:

sqlcmd.exe -i TMS.sql -S .\SQLExpress

Replace .\SQLExpress with the database location on the server.

Note : If you want to install database from SQL Server Management Studio, then Open TMS.sql from SQL Server Management Studio.
On Query menu of SQL Management studio select SQL CMD mode and
Execute TMS.sql

3. Locate the web.config file in the Application Files subdirectory of the TMS1.0.

a. Open web.config in Notepad and edit the connection in the <connectionStrings> section to use your server and database name. For example, for the entry similar to:

<add name="_IntrinsicData" connectionString="Data Source=SERVERNAME\SQLEXPRESS;Initial Catalog=TMS;Integrated Security=True;Pooling=True;Connect Timeout=30;User Instance=False" />

Replace SERVERNAME with the name of the database server.

4. Run Setup.exe on the target computer to install the application.

5. You need to provide the default administrator login after installing the app, using the Security Admin tool. The tool SecurityAdmin.exe, can be found under \TMS1.0\Microsoft.LightSwitch.SecurityAdmin.exe

a. To run the tool, open a command prompt and navigate to path for the tool, then type:

Microsoft.LightSwitch.SecurityAdmin.exe /createadmin /user:domainname\username /password:adminpassword /fullname:user'sfullname /config:pathtowebconfig

Replace "domainname\username" with the Username, "adminpassword" with password, "fullname" with full name, and full path to the TMS TMS1.0\Application Files\web.config file. You must also include web.config in the path.

Reviews for this release

No reviews yet for this release.