• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 730
  • Last Modified:

Best computer setup for small business server

What would be an ideal computer setup for a small business server?
There would be 2 in house networked connections and 3 remote connections all running XP Pro OS.

Sql server 2005 database with remote connections.

Do I have to have a separate monitor & other accessories to operate the server or can that be done thru a workstation.

I was planning using SBS 2011 Essentials for the software.

Thanks!
0
dave_sky
Asked:
dave_sky
2 Solutions
 
LordALMMaCommented:
Dave,

This is a too brief description of your needs to start dealing with numbers.

Can you post what services/works this server will handle?

Example:
- About 500 SQL Server connections for queries from a website;
- About 1 SQL Server connection for chat/support team;
- About 5 remote computers (XP Pro) working with Visual Studio
- About 2 remote computers (XP Pro) working with Expression
- About 1 remote computer (7 Pro) working with Photoshop 64-bit.
- 1TB File Server with 30% high-frequently changed files
- SVN server
- ...
- It will be a virtual machine under Hyper-V (server core? full install? bare-metal?)
- ...


This will help me and others to find a better server spec and OS for your needs.

For now, all I can tell is that:

1) Looks like SBS will be your best option;
2) Depending on your SQL load and server tasks, 6GB could be a good ammount of memory;
3) I always recommend at least 2 LAN (1Gbps connection each) with a GOOD router (increases performance a lot, specially over time);
4) I recommend that you do not rely on only one WAN connection or it will get too slow/unstable for everyone to work;
5) I also recommend that you stick to some basics configs on your hardware. Hardware gets obsolete too fast and it's better to change a cheaper server than to try to upgrade a very expensive one but of course, this will depend on your needs for now.
0
 
dave_skyAuthor Commented:
>Can you post what services/works this server will handle?

It would be a completely new computer.

Main usage:
1) Visual Studio on 1 workstation
2) In house developed windows application accessing the sql server database - 4 connections - 2 remote connections.
3) Lot of email with large pdf attachments - want to use outlook express because it is fast and easy to use. I can manage the backups ok.
4) Easy method of workstations and database backups .

No photoshop...
_________________________________________________________________________________

1) Looks like SBS will be your best option;
>ok

2) Depending on your SQL load and server tasks, 6GB could be a good amount of memory;
>ok

3) I always recommend at least 2 LAN (1Gbps connection each) with a GOOD router (increases performance a lot, specially over time);
>The Lan connections are very basic - need very little performance.

4) I recommend that you do not rely on only one WAN connection or it will get too slow/unstable for everyone to work;
> I could use some help with this - this is new to me.

5) I also recommend that you stick to some basics configs on your hardware. Hardware gets obsolete too fast and it's better to change a cheaper server than to try to upgrade a very expensive one but of course, this will depend on your needs for now.
>Good advice.

Hope this helps!
0
 
kinggekkoCommented:
look simple and straight forward enough as this should be a development server not heavy production server.

WS2008 SBS Essential should be sufficient

you can administer up to 2 concurrent remote desktop connection , you cannot many user to use remote desktop , but you can definitely administrate the server remotely via remote desktop.  so no other accessories required when you are using via LAN . via WAN outside your home please make sure you DMZ in the router is point to the server.
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

Cloud Class® Course: Certified Penetration Testing

This CPTE Certified Penetration Testing Engineer course covers everything you need to know about becoming a Certified Penetration Testing Engineer. Career Path: Professional roles include Ethical Hackers, Security Consultants, System Administrators, and Chief Security Officers.

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