Solved

Remote Access to Windows Server for SQL Server 2005

Posted on 2006-06-12
5
216 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
  • 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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

So you have two Windows Servers and you have a directory/folder/files on one that you'd like to mirror to the other?  You don't really want to deal with DFS or a 3rd party solution like Doubletake. You can use Robocopy from the Windows Server 200…
A quick step-by-step overview of installing and configuring Carbonite Server Backup.
In this video I am going to show you how to back up and restore Office 365 mailboxes using CodeTwo Backup for Office 365. Learn more about the tool used in this video here: http://www.codetwo.com/backup-for-office-365/ (http://www.codetwo.com/ba…
With the power of JIRA, there's an unlimited number of ways you can customize it, use it and benefit from it. With that in mind, there's bound to be things that I wasn't able to cover in this course. With this summary we'll look at some places to go…

863 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

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now