Solved

Remote Access to Windows Server for SQL Server 2005

Posted on 2006-06-12
5
242 Views
Last Modified: 2010-04-18
I need some advice on server 2003.  

We have one main site and and a number of home users.  We are setting up a new server and need to run one of our clinet server programs with SQL server.  I am concerned that VPN access tothe program would be too slow and was considering using terminal services.  

Is this the best solution to use and which version of Server 2003 would be most suitable.  Is there an alternative to terminal services?

I'm finding the microsoft sites difficult to get information from and they say I need Windows CALs, Terminal Server CALs and SQL CALs which I would imagine will work out rather expensive.  Is there a better solution?

Thanks,
Donna  
0
Comment
Question by:CoreSupport
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
5 Comments
 
LVL 48

Expert Comment

by:Jay_Jay70
ID: 16884371
personally i wouldnt bother spending the money on cals when you can use VPN, it is plenty quick enough depending on your internet connection from the remote site

2003 Standard provides all you need builtin
http://www.onecomputerguy.com/networking.htm
0
 
LVL 48

Expert Comment

by:Jay_Jay70
ID: 16884375
or a couple of other remote access options

1) UltraVNC
free, easy and buggy although this seems to better than the traditional tightvnc or realvnc
http://ultravnc.sourceforge.net/

2) Dameware
I havent used but heard good things such as the remote installer feature
http://www.dameware.com/

3) Symantec PCanywhere
has great functionality but is buggy and slow and expensive
http://www.symantec.com/home_homeoffice/products/remote_pc_fax/pca12/index.html

4) RADMIN (remote admin)
if you have a little funding i would highly reccomend this, awesome product,
only used for a short while but it kicks any of the other out of the way, remote controlling,
or controlling services, registries, file transfers etc. this thing does the lot
http://www.famatech.com/
0
 

Author Comment

by:CoreSupport
ID: 16884410
I am familiar with the remote access software that you have mentioned, but to the best of my knowledge, it doesn't give sessions?

Is there anything that would give me this functionality?  And if I were to proceed down the line of Terminal Services, would I need all of the above?

0
 
LVL 13

Accepted Solution

by:
2hype earned 500 total points
ID: 16886694
You would probally need to go with Terminal Services.  Like you mentioned using software like vnc would only let 1 user log on remotley directly to the computer and control it.   You would need to setup terminal services that way many users can logon remotley and access your program.  You have a little more control over what they can access with terminal services as well.

You would have to purchase your Sql Server 2005 Cals as well as Terminal Services Cals.

You could also go the citrix route to.
0

Featured Post

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

by Batuhan Cetin In this article I will be guiding through the process of removing a failed DC metadata from Active Directory (hereafter, AD) using the ntdsutil tool in a Windows Server 2003 environment. These steps are not necessary in a Win…
Setting up a Microsoft WSUS update system is free relatively speaking if you have hard disk space and processor capacity.   However, WSUS can be a blessing and a curse. For example, there is nothing worse than approving updates and they just have…
In this video we outline the Physical Segments view of NetCrunch network monitor. By following this brief how-to video, you will be able to learn how NetCrunch visualizes your network, how granular is the information collected, as well as where to f…
NetCrunch network monitor is a highly extensive platform for network monitoring and alert generation. In this video you'll see a live demo of NetCrunch with most notable features explained in a walk-through manner. You'll also get to know the philos…

696 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question