We help IT Professionals succeed at work.

Install terminal server on SQL server.

The server is already a SQL server now I need to add Terminal services to it to have remote users connect. Is this possible? or will I have to reinstall the SQL ?

Thanks
Comment
Watch Question

SQL server is a DB tool and not an operating system, if you have windows 2000 or 2003 you can use terminal services for 2 users there is a licensing consequence if you require full terminal services
you need to look at you server os and then look at the relevent documents at microsoft
http://www.microsoft.com/windowsserver2003/technologies/default.mspx
http://www.microsoft.com/technet/prodtechnol/win2kts/default.mspx

Author

Commented:
Thanks for reply I know about the licensing issues I already bought the licenses I need. But I need to add Terminal Services to the Server that is currently also my SQL Server. If I do this will it affect my SQL setup?

Thanks
no it is an inbuilt service in windows serveR tnhat when activated will not damage your sql server program,  there may be performance issues with them both running on the same server depending on the amount of connections and the amount of processing that the sql server is doing.
Commented:
Turning on Application Server Mode is always ideally done prior to installing any programs, period.  You MAY have issues but very likely will not.  I have done this and, although you run a slight risk, will usually have no problems.  Worst case scenario, if SQL starts acting buggy, reinstall it.  

Author

Commented:
OK thanks I know but it was not planned at first....  The reason why I ask is when I tried to tun on the treminal server the installation told me I'd have to install everything again...  I'm trying to avoid this...

Commented:
As long as you test things well you should be ok.  It is just preparing you for the potential for application reinstallation.  I would try it.  

Author

Commented:
I never did it I could not redo the Database if needed... They decided to just add a separate TS server which was the best solution anyway...