I work in an environment where we are building multiple datamarts in SQL Server 2000

We use an ETL tool that extracts data from various data sources, transforms the data, and then writes to the datamart tables. Depending on the complexity of the transformations, the ETL processes can require a considerable amount of memory and CPU

Hence when testing a build we logon to the server with TS and run the builds

We are only using the 2 cals of TS that comes with Win2K. We have four developers and wish to get an extra 2 cals on the server

We have been advised that to extend the licenses we would have to convert the server to a full blown terminal server which may affect existing installed applications

All we want is to do is to logon as one would in Unix in a telnet session

The proposed solution to allow up to four developers to logon seems a bit over the top.

Well admin mode is always there. You need to enable Terminal Services Via
Add/Remote Programs- Windows Components.

Now beware!. You need terminal Services licensing somewhere to allow this
with a number of cals if your workstations arent 2kpro or better. In
addition when you Change a server to TS it changes the server (even though
it is subtle)
I DONT recommend this to allow 4 guys on a production server hosting data at
once. But that is just my opinion.

--
Ron Oglesby
Microsoft MVP - Terminal Services


"Michael" <(E-Mail Removed)> wrote in message
news:56FBE9F0-5FC5-4CF7-B1E6-(E-Mail Removed)...
> Hi Ron,
>
> Thanks for the reply.
>
> What is involved in converting to a 'regular application mode terminal
server' ? Is it a case of adding the extra licenses ? Or is there something
more involved ?

--------------------
>From: "=?Utf-8?B?TWljaGFlbA==?=" <(E-Mail Removed)>
>Subject: Re: Admin Clients
>Date: Thu, 12 Feb 2004 01:46:11 -0800
>Newsgroups: microsoft.public.win2000.termserv.clients
>
>Hi Ron,



Thanks for the reply.



What is involved in converting to a 'regular application mode terminal server' ? Is it a case of adding the extra licenses ? Or
is there something more involved ?
--

Take a look at the following articles to see if they answer your question.

238162 - Change Between Remote Administration and Application Server Mode
http://support.microsoft.com/default.aspx?scid=kb;[LN];238162

248340 - Installing and Using Programs in Windows 2000 Terminal Services
http://support.microsoft.com/default.aspx?scid=kb;[LN];248340

Bill Peele
Microsoft Enterprise Support

This posting is provided "AS IS" with no warranties, and confers no rights. Use of included script samples are subject to the
terms specified at http://www.microsoft.com/info/cpyright.htm

Note: For the benefit of the community-at-large, all responses to this message are best directed to the newsgroup/thread
from which they originated.

--------------------
>From: "=?Utf-8?B?TWljaGFlbA==?=" <(E-Mail Removed)>
>Subject: Re: Admin Clients
>Date: Thu, 12 Feb 2004 01:46:11 -0800
>Newsgroups: microsoft.public.win2000.termserv.clients
>
>Hi Ron



Thanks for the reply



What is involved in converting to a 'regular application mode terminal server' ? Is it a case of adding the extra licenses ? Or
is there something more involved ?
--

Also, for Licensing you might want to look at the following article.

275052 - Terminal Services Licensing Technology for Application Service Providers
http://support.microsoft.com/default.aspx?scid=kb;[LN];275052

Bill Peele
Microsoft Enterprise Support

This posting is provided "AS IS" with no warranties, and confers no rights. Use of included script samples are subject to the
terms specified at http://www.microsoft.com/info/cpyright.htm

Note: For the benefit of the community-at-large, all responses to this message are best directed to the newsgroup/thread
from which they originated.