how to set up a remote desktop connection (1 Viewer)

Hello,

how can I define a remote desktop connection wich allow a friend to connect with my SQL server 2008 and only run 1 particular program?

It should be so that when he start the remote connection the program starts automatically and when he close the program he should be logged off automatically.

Is this possible?

Best regards,
Sven.

Re: "only run 1 particular program"
Is this referenced program a MS Access program, Excel program, or other application connected to SQL Server 2008?

For eample: A MS Access application starts up, connects to SQL Server, then closes on the end session.

For example: Another option I have used is to link a Excel workbook to SQL Server. When the user opens up Excel, it refreshes on a View located in SQL Server. Think of a View as a saved query with a security context. A view for example can be very complex and designed so a Trader can obtain today's market information as the market ticker and future pricing contracts is updating SQL in a background process. It was great for read-only reports. And, there were rare cases where Excel could also be used for read/write.

Your SQL server 2008 is running on your windows or MAC machine. Right? Ask your friend to establish a remote connection with your computer using remote support tools such as logmeinrescue, gosupportnow, GoToMyPC etc. or he may even consider deploying on premise remote support appliance such as RHUB appliances. Once connected to your computer, he can user your SQL server 2008 application.

MS Access 2010 and Excel 2010 runs on a Windows Server with DSNLess links to SQL Server. SQL Server runs on its own Windows Server. The distribution to client machines is done via Citrix.

So, the MS Access delivered front-end works equally well on both Windows and Mac.
The only thing a client needs is the Citrix Client.

One single Citrix Client can define what users can run what programs on specific servers.

There are probably many other tools to accomplish the same result.
Look up the Citrix Stock chart from 2010 to now. That is an indication of how popular it has become.