SQL Server Performance Forum – Threads Archive

SQL 2005 and Terminal Services

Is it possible to have SQl 2005 and Terminal services to work together on the same server in a non clustered environment for about 2 to 3 users?
If so are there any special tweaks that should be done to make them work together? John

This will work. No special tweaks required
KH

RDP is an internal component for XP & Windows 2003 and Terminal Services is a part of Operating System where you have to install SQL too [<img src=’/community/emoticons/emotion-1.gif’ alt=’

‘ />]. What is the userbase on your SQL Server? If it is a development server then no need to worry. Satya SKJ Microsoft SQL Server MVP Writer, Contributing Editor & Moderator http://www.SQL-Server-Performance.Com</a> <center>This posting is provided AS IS with no rights for the sake of knowledge sharing. <hr noshade size="1">Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.</center>

It is a production server and SQL is used for transaction logging. We are also considering placing Citrix on top of terminal server. Again total number of users logging directly to the server is 2 to 5 and actually hitting the server <30 John

I presume the server will have a minimum 2gb RAM then I don’t see any issues, but in any case it is better to test the implications before taking it on live. Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.

]]>