Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Server Specs

Server Specs

Server Specs

About to install SMS 2.0 with about 1000 nodes.  How big of a server should I buy?  Do I need 2 servers to use Crystal Reporting?  Should I write my own reports?

RE: Server Specs


We bought a quad 700 MHz Pentium III with 2 GB RAM.  It is a beefy machine but we will have 2000 nodes to manage and are trying to keep our CAP on the site server (so far, so good).  We also have our SQL Server installation on the same server.

I will be using Access for reporting.  I wouldn't think you would need a separate server for Crystal Reports.  To write reports in either, you will need a basic understanding of relational databases and Structured Query Language.  If you have that knowledge, you should be OK.  Microsoft has a white paper on Advanced SMS 2.0 Reporting that discusses the SMS database structure and several other useful things.  Contact me at wardenlc@corning.com if you can't find it on their site.

Good luck,

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close