473,403 Members | 2,071 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,403 software developers and data experts.

SQL and Terminal on 2 different PC's

In the past I have had SQL and Terminal server on the same PC.

With SQL and Windows 2003 Terminal server, you can not have them on the
same PC.
How can I make this work with SQL and Terminal and 2 different PC's? I
have 30 users that need to log on to my SQL database.

Apr 20 '06 #1
3 1728
Hi

I often connect to remote SQL Servers though remote desktop, what is the
issue running both?

John

"shawn" <se*****@tampabay.rr.com> wrote in message
news:11*********************@e56g2000cwe.googlegro ups.com...
In the past I have had SQL and Terminal server on the same PC.

With SQL and Windows 2003 Terminal server, you can not have them on the
same PC.
How can I make this work with SQL and Terminal and 2 different PC's? I
have 30 users that need to log on to my SQL database.

Apr 21 '06 #2

"John Bell" <jb************@hotmail.com> wrote in message
news:44**********************@news.zen.co.uk...
Hi

I often connect to remote SQL Servers though remote desktop, what is the
issue running both?

He's using the Terminal Services, not remote desktop. i.e. having 30 users
all have their own "desktop" at a time.

Not sure why he needs to do that on the SQL Server. They should all be able
to log on remotely (i.e. using Query Analyzer, etc.)

John

"shawn" <se*****@tampabay.rr.com> wrote in message
news:11*********************@e56g2000cwe.googlegro ups.com...
In the past I have had SQL and Terminal server on the same PC.

With SQL and Windows 2003 Terminal server, you can not have them on the
same PC.
How can I make this work with SQL and Terminal and 2 different PC's? I
have 30 users that need to log on to my SQL database.


Apr 21 '06 #3
Hi

I have always been confused by the Remote Desktop/Terminal Services
terminology, but I believe I am using Remote Desktop as a Terminal Services
Client. Having more than two users connected requires a full licenced copy
of Terminal Services to be installed, which I have also had working.

If the OP (shawn) wishes to use Terminal Services as a Application Server he
would be advised to use a separate machine to host as the Terminal Services
Server, although I am not sure with the number of users he is serving that
this would be the most cost effective solution even if he is saving on
licences elsewhere.

John

"Greg D. Moore (Strider)" <mo****************@greenms.com> wrote in message
news:kk*****************@newsread3.news.atl.earthl ink.net...

"John Bell" <jb************@hotmail.com> wrote in message
news:44**********************@news.zen.co.uk...
Hi

I often connect to remote SQL Servers though remote desktop, what is the
issue running both?


He's using the Terminal Services, not remote desktop. i.e. having 30
users
all have their own "desktop" at a time.

Not sure why he needs to do that on the SQL Server. They should all be
able
to log on remotely (i.e. using Query Analyzer, etc.)

John

"shawn" <se*****@tampabay.rr.com> wrote in message
news:11*********************@e56g2000cwe.googlegro ups.com...
> In the past I have had SQL and Terminal server on the same PC.
>
> With SQL and Windows 2003 Terminal server, you can not have them on the
> same PC.
> How can I make this work with SQL and Terminal and 2 different PC's? I
> have 30 users that need to log on to my SQL database.
>



Apr 21 '06 #4

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

3
by: Jimmy | last post by:
Dear All, I have a interesting question, may sound dump. Could I develop a vb6 programs that run under win2000 server terminal services and the program is access by a pocket pc? How could I...
0
by: Red | last post by:
I've an Access '97 application that works fine on Clients (or Terminal Server) with 128 - 1 GB of RAM. If the PC has more than 1 GB of RAM there's some problems: Unexpectly appears an error...
28
by: (Pete Cresswell) | last post by:
I'd like to dabble in Terminal Server enough to see if I can get some of my MS Access apps to run through it. I've got the MSDN subscription. Is there enough there for a real-world...
29
by: Arno R | last post by:
Hi all, I am involved in a project where a client needs a new database over a wan (30 or more locations). The client is a health-care organisation that 'services' mentally disordered people. ...
8
by: OHM | last post by:
Hi peoples, I dont know where to place this question, so as I know you guys are all resourceful experts, I thought I would try here. I am writing some code which will be run usingh remote...
6
by: Atley | last post by:
I have a Terminal Services server running Windows 2000 Server. I need to be able to identify, in my application on that server, which client computer is addressing that server and running that...
1
by: shawn | last post by:
In the past I have had SQL and Terminal server on the same PC. With SQL and Windows 2003 Terminal server, you can not have them on the same PC. How can I make this work with SQL and Terminal and...
3
by: tommcd24 | last post by:
I have an in-house VB.NET 2.0 application that uses Crystal Reports for ..NET 2005 - CR10?). A few users access the program via a Wyse dumb-terminal via Citrix. For some reason that I've not been...
13
by: sayansayan | last post by:
two threads are running in a prog i need the output of one thread in a new terminal which the prog will create and the output of other thread in the old terminal
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.