Link to home
Start Free TrialLog in
Avatar of kleyba
kleyba

asked on

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
Avatar of bradleys40
bradleys40

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
Avatar of kleyba

ASKER

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.
ASKER CERTIFIED SOLUTION
Avatar of BLipman
BLipman
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of kleyba

ASKER

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...
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.  
Avatar of kleyba

ASKER

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...