Solved

Sql server virtualization with centralized client access  setup recommendation

Posted on 2013-01-06
2
398 Views
Last Modified: 2013-02-03
Main office and 5, 6 branch offices. Currently each office has a sql server with pharmacy software installed. Sql server 2000 & server 2003 r2 64 bit runs  on servers. At about 15 users from each office access software using xp clients.

Client needs to virtualize or centralize servers in to main office  & setup clients to access servers from branch offices.
High availability method should include in solution.
How many servers do we buy? , which hardware configuration ?
Vmware or hyper-v ? Which method for high availability?
How is storage consideration?
What are the best ways clients can access software in main office? Clints should print to local pos printers.
What are the other things do we consider in this case?
Your any of suggestions greately appreciated
Thank you.
0
Comment
Question by:upalakshitha
[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 Comments
 
LVL 121

Accepted Solution

by:
Andrew Hancock (VMware vExpert / EE MVE^2) earned 500 total points
ID: 38748530
have a read of this recent EE post which debates VMware or Microsoft.

http://www.experts-exchange.com/Software/VMWare/Q_27985921.html

As for Best Practices of SQL on VMware

see here

http://www.vmware.com/files/pdf/sql_server_best_practices_guide.pdf

http://communities.vmware.com/docs/DOC-8964

What's your budget?

(it's a large question, you would probably be better off splitting into several, for more Experts to respond!)
0
 
LVL 13

Author Comment

by:upalakshitha
ID: 38749444
thanks for your valuable input.
still there is no budget. i thought providing full detail will help you to give a solution easily.
ok i will split the question.
0

Featured Post

Connect further...control easier

With the ATEN CE624, you can now enjoy a high-quality visual experience powered by HDBaseT technology and the convenience of a single Cat6 cable to transmit uncompressed video with zero latency and multi-streaming for dual-view applications where remote access is required.

Question has a verified solution.

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

In this article, I will show you HOW TO: Suppress Configuration Issues and Warnings Alert displayed in Summary status for ESXi 6.5 after enabling SSH or ESXi Shell.
This article outlines why you need to choose a backup solution that protects your entire environment – including your VMware ESXi and Microsoft Hyper-V virtualization hosts – not just your virtual machines.
This tutorial will walk an individual through the process of transferring the five major, necessary Active Directory Roles, commonly referred to as the FSMO roles to another domain controller. Log onto the new domain controller with a user account t…
This Micro Tutorial hows how you can integrate  Mac OSX to a Windows Active Directory Domain. Apple has made it easy to allow users to bind their macs to a windows domain with relative ease. The following video show how to bind OSX Mavericks to …

729 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