Changing from Terminal Server Remote Admin to Application

[Guest tom f]

Hi, we have a 2003 server with sql2000 on it. Right now it is in Remote

Admin mode and we would like to change it to Application Mode. I understand

that I need to uninstall Access, the only user app on the server, and

reinstall, but what effect will it have on the sql server? Am I asking for

trouble here?

 

Thanks,

Tom

[Guest Jeff Pitsch]

Re: Changing from Terminal Server Remote Admin to Application

 

It's a matter of what your going to be doing with it and how many users

will be accessing it. SQL Server and terminal services do conflict with

each other because both can be memory hogs and overall resource hogs.

 

Jeff Pitsch

Microsoft MVP - Terminal Server

Citrix Technology Professional

Provision Networks VIP

 

Forums not enough?

Get support from the experts at your business

http://jeffpitschconsulting.com

 

tom f wrote:

> Hi, we have a 2003 server with sql2000 on it. Right now it is in Remote

> Admin mode and we would like to change it to Application Mode. I understand

> that I need to uninstall Access, the only user app on the server, and

> reinstall, but what effect will it have on the sql server? Am I asking for

> trouble here?

>

> Thanks,

> Tom

[Guest tom f]

Re: Changing from Terminal Server Remote Admin to Application

 

Thank you for your reply. There are 4 sql db's, and no more than 25

connections. The server isn't heavily used, and this is all it will be doing.

But there is some growth planned for it in the next few years. Maybe 1-2 more

db's. We are a non-profit so we try to get the most out of what we have. My

concern is that if we change the mode to application mode, will that in

itself mess up the sql installation.

 

Thanks,

Tom

 

"Jeff Pitsch" wrote:

> It's a matter of what your going to be doing with it and how many users

> will be accessing it. SQL Server and terminal services do conflict with

> each other because both can be memory hogs and overall resource hogs.

>

> Jeff Pitsch

> Microsoft MVP - Terminal Server

> Citrix Technology Professional

> Provision Networks VIP

>

> Forums not enough?

> Get support from the experts at your business

> http://jeffpitschconsulting.com

>

> tom f wrote:

> > Hi, we have a 2003 server with sql2000 on it. Right now it is in Remote

> > Admin mode and we would like to change it to Application Mode. I understand

> > that I need to uninstall Access, the only user app on the server, and

> > reinstall, but what effect will it have on the sql server? Am I asking for

> > trouble here?

> >

> > Thanks,

> > Tom

>

[Guest Jeff Pitsch]

Re: Changing from Terminal Server Remote Admin to Application

 

It won't do anything to the SQL installation but you are hurting

yourself if your expecting more growth. It would be best to invest in a

new server now for the planned growth versus having to move one or the

other role. Moving in the future will be much harder than starting

clean today.

 

Jeff Pitsch

Microsoft MVP - Terminal Server

Citrix Technology Professional

Provision Networks VIP

 

Forums not enough?

Get support from the experts at your business

http://jeffpitschconsulting.com

 

tom f wrote:

> Thank you for your reply. There are 4 sql db's, and no more than 25

> connections. The server isn't heavily used, and this is all it will be doing.

> But there is some growth planned for it in the next few years. Maybe 1-2 more

> db's. We are a non-profit so we try to get the most out of what we have. My

> concern is that if we change the mode to application mode, will that in

> itself mess up the sql installation.

>

> Thanks,

> Tom

>

> "Jeff Pitsch" wrote:

>

>> It's a matter of what your going to be doing with it and how many users

>> will be accessing it. SQL Server and terminal services do conflict with

>> each other because both can be memory hogs and overall resource hogs.

>>

>> Jeff Pitsch

>> Microsoft MVP - Terminal Server

>> Citrix Technology Professional

>> Provision Networks VIP

>>

>> Forums not enough?

>> Get support from the experts at your business

>> http://jeffpitschconsulting.com

>>

>> tom f wrote:

>>> Hi, we have a 2003 server with sql2000 on it. Right now it is in Remote

>>> Admin mode and we would like to change it to Application Mode. I understand

>>> that I need to uninstall Access, the only user app on the server, and

>>> reinstall, but what effect will it have on the sql server? Am I asking for

>>> trouble here?

>>>

>>> Thanks,

>>> Tom