SQL and Terminal on 2 different PC's

shawn

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

Subscribe Reply

1749

John Bell

Hi

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

John

"shawn" <se*****@tampab ay.rr.com> wrote in message
news:11******** *************@e 56g2000cwe.goog legroups.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

Greg D. Moore \(Strider\)

"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*****@tampab ay.rr.com> wrote in message
news:11******** *************@e 56g2000cwe.goog legroups.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

John Bell

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.co m> wrote in message
news:kk******** *********@newsr ead3.news.atl.e arthlink.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*****@tampab ay.rr.com> wrote in message
news:11******** *************@e 56g2000cwe.goog legroups.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

Similar topics

3783

Develop an VB6 programs to run on Terminal Services for Pocket PC

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 control the resolution or the screen size of the vb6 programs so it fit into the pocket pc screen ? Please let me know my option, why, how and possible some sample code.

Visual Basic 4 / 5 / 6

2066

Access 97 on PC with more than 1 GB of RAM (Terminal Server)

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 message ("Server OLE not registered") and the application quits. Searching on the web I've find this: http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q161255

Microsoft Access / VBA

2448

Terminal Server: Enough included w/MSDN?

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 implementation? -- PeteCresswell

Microsoft Access / VBA

2711

DataBase over WAN: ASP vs. Terminal Server Costs?

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. They use Win2003 Server at the moment. All the client PC's are Win2000 or Win XP. At this moment there are two different approaches/ideas considered. -- to develop an ASP-web application. (not by me) -- to develop an Access97-TerminalServer...

Microsoft Access / VBA

2742

Writing Session Specific Code For Windows 2003 Terminal Server Session

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 desktop ( On windows 2003 Server ), I need to determine in the code the machine name and username. If I use GetUsername and GetMachineName, it simply gives me the name of the currently logged on user ( at the Server ) and the Servers Machine Name.

Visual Basic .NET

4047

Identifying ID of a Terminal Services Client

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 application. it can be by IP or by machine network name... Doesn't matter. I am using Visual Basic .Net 2003 Any help would be greatly appreciated.

Visual Basic .NET

1299

SQL and Terminal server on 2 different PC's

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 2 different PC's? I have 30 users that need to log on to my SQL database.

Microsoft SQL Server

3152

Crystal Reports for .NET 2005 secuity issue with terminal services connection?

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 able to trace, these users are not able to view any of the reports. The same is also true if I attempt to view the reports while running the program over a Remote Desktop/Terminal Services connection. The exception noted is...

Visual Basic .NET

4610

opening a new terminal and output it there

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

C / C++

9643

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...

General

9480

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...

Windows Server

10147

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

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 tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...

Online Marketing

10087

The easy way to turn off automatic updates for Windows 10/11

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 Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...

Windows Server

9947

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

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 protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...

General

5380

Trying to create a lan-to-lan vpn between two differents networks

by: TSSRALBI | last post by:

Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...

Networking - Hardware / Configuration

5511

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

Visual Basic .NET

4046

transfer the data from one system to another through ip address

by: 6302768590 | last post by:

Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system

C# / C Sharp

2877

Comprehensive Guide to Website Development in Toronto: Expert Insights from BSMN Consultancy

by: bsmnconsultancy | last post by:

In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

General