In the past I have had SQL and Terminal server on the same PC.

With SQL and Windows 2003 Terminal server, you can not have them on the
same PC.
How can I make this work with SQL and Terminal and 2 different PC's? I
have 30 users that need to log on to my SQL database.

Hi

I often connect to remote SQL Servers though remote desktop, what is the
issue running both?

John

"shawn" <sepling (AT) tampabay (DOT) rr.com> wrote

"John Bell" <jbellnewsposts (AT) hotmail (DOT) com> wrote

He's using the Terminal Services, not remote desktop. i.e. having 30 users
all have their own "desktop" at a time.

Not sure why he needs to do that on the SQL Server. They should all be able
to log on remotely (i.e. using Query Analyzer, etc.)

Hi

I have always been confused by the Remote Desktop/Terminal Services
terminology, but I believe I am using Remote Desktop as a Terminal Services
Client. Having more than two users connected requires a full licenced copy
of Terminal Services to be installed, which I have also had working.

If the OP (shawn) wishes to use Terminal Services as a Application Server he
would be advised to use a separate machine to host as the Terminal Services
Server, although I am not sure with the number of users he is serving that
this would be the most cost effective solution even if he is saving on
licences elsewhere.

John

"Greg D. Moore (Strider)" <mooregr_deleteth1s (AT) greenms (DOT) com> wrote