<div>
Thanks for responding.<br />
<br />
Regards<br />
George
</div>


<div>
<div class="content wysiwyg-content">
Hi<br />
Thanks in advance for helping.<br />
<br />
The reason I am posting this here is because I need an unbiased opinion, from resources with experience as I have to provide this info to my boss urgently.<br />
<br />
Problem – we run a SQL database (accounting software called Pastel) onsite, with our offsite users RDP’ing onto the terminal server from where the application is launched and used, i.e. the “client” is running on the TS.<br />
<br />
Question – is it possible that the SQL database integrity can be comprised using this deployment method “if the link from the end user (offsite) goes down in the middle of a transaction”? Or more specific, is it possible that entries/transaction can be duplicated or missing.<br />
<br />
Is there in reason for NOT to allow accessing the client using terminal server when using the application?<br />
<br />
Again, thanks for helping.<br />
<br />
Regards<br />
George
</div>
</div>


Hi
Thanks in advance for helping.

The reason I am posting this here is because I need an unbiased opinion, from resources with experience as I have to provide this info to my boss urgently.

Problem – we run a SQL database (accounting software called Pastel) onsite, with our offsite users RDP’ing onto the terminal server from where the application is launched and used, i.e. the “client” is running on the TS.

Question – is it possible that the SQL database integrity can be comprised using this deployment method “if the link from the end user (offsite) goes down in the middle of a transaction”? Or more specific, is it possible that entries/transaction can be duplicated or missing.

Is there in reason for NOT to allow accessing the client using terminal server when using the application?

Again, thanks for helping.

Regards
George

SQL - database integrity when using a terminal server

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Microsoft SQL Server

Network design and methodology, also known as network architecture, is the design of a communication network. It is a framework for the specification of a network's physical components and their functional organization and configuration, its operational principles and procedures, as well as data formats used in its operation. In telecommunication, the specification of a network architecture may also include a detailed description of products and services delivered via a communications network, as well as detailed rate and billing structures under which services are compensated.

Network Architecture

Installation is the act of making a computer program program ready for execution. Because the process varies programs often come with a specialized program responsible for doing whatever is needed for their installation. Installation may be part of a larger software deployment process. Cross platform installer builders that produce installers for Windows, Mac OS X and Linux include InstallAnywhere, InstallBuilder and Install4J. Installers for Microsoft Windows include Windows Installer, InstallShield, and Wise Installation Studio; free installer-authoring tools include NSIS, IzPack, Clickteam, InnoSetup, InstallSimple and WiX. Mac OS X includes Installer, and also includes a separate software updating application.