Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 252
  • Last Modified:

Remote Access to Windows Server for SQL Server 2005

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
CoreSupport
Asked:
CoreSupport
  • 2
1 Solution
 
Jay_Jay70Commented:
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
 
Jay_Jay70Commented:
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
 
CoreSupportAuthor Commented:
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
 
2hypeCommented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now