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
kleybaAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

bradleys40Commented:
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
0
kleybaAuthor 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
0
bradleys40Commented:
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.
0
10 Tips to Protect Your Business from Ransomware

Did you know that ransomware is the most widespread, destructive malware in the world today? It accounts for 39% of all security breaches, with ransomware gangsters projected to make $11.5B in profits from online extortion by 2019.

BLipmanCommented:
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.  
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
kleybaAuthor 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...
0
BLipmanCommented:
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.  
0
kleybaAuthor 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...
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Server OS

From novice to tech pro — start learning today.