×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

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

SMS Installation Issues

SMS Installation Issues

SMS Installation Issues

(OP)
I am in the planning stage right now. My plan is to install SQL database for SMS on my file server and have SMS Administrative Server on a separate server. Is it a good idea?

Along with the SMS Admin server, I also want to have WSUS server on the same machine(on 1 server, I will have SMS Admin server and WSUS server, and terminal server).Since WSUS server requires SQL, is it a good idea to have a WSUS database on the same machine SMS database is hosted on?

SMS minimum requirements call for
Microsoft SQL Server 7.0 Standard Edition or Enterprise Edition with SP3 or later or
SQL Server 2000 Standard Edition or Enterprise Edition with SP3a or later.

WSUS calls for WMSDE (desktop edition of SQL). Can WSUS and SMS run on the same version of SQL?

RE: SMS Installation Issues

First of all, its always good practice to have the SMS SQL DB on another server other than the one where SMS will be installed.  And yes you can have WSUS on the same server as SMS and WSUS use completely separate databases.  For the record, i'm running SMS 2003 w/SP2 and my SQL server is SQL 2000 hosting the SMS DB, a corporate DB, and the WSUS DB with no issues.  I just religiously backup the DB server

"I'm certifiable, not certified. It just means my answers are from experience...not a book"

RE: SMS Installation Issues

(OP)
Thank you for the answer, drew1701d.

What SQL Licensing are you using on your SQL 2000: per device/user or per processor?

We are planning to have up to 600 PCs with SMS client installed.

Thank you again.

RE: SMS Installation Issues

We are using per device licensing.

"I'm certifiable, not certified. It just means my answers are from experience...not a book"

RE: SMS Installation Issues

What if you put MOM into the mix as well, I have had issues with all apps trying to use IIS?

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