Adding member SQL server questions

Tech-Archive recommends: Fix windows errors by optimizing your registry

Currently running SBS 2003 SP1 Premium and want to add a member server with
SQL server for a Great Plains 10.0 setup.

Would it be a good idea to put CRM also on this member server, does it break
EULA rules? CRM doesn't have to be on the SBS machine does it?

What about the SBS SQL installed but not fully utilitzed, does it need to be
removed if a member SQL server is added?

What a SharePoint, which is not using SQL because GP was going to added in
the future? Can the SQL member be used for the SharePoint databases too?

Will SQL member server be able to handle CRM (25 users), SharePoint (10-15
users), and Great Plains with 2-4 users.

The server also has ISA, Exchange, SAVCE installed and provides files and
printing.

There is the possiblity to upgrade to R2. What would you suggest?

How have others implemented all this and what other concerns should I be
aware of?

Thanks for the help.

Craig



.

Relevant Pages

  • Re: Migrate SBS to windows 2003 questions
    ... buy a new licenses for the SBS. ... Do they have a separate SQL license ... 60 is still a good SBS sized shop with a SBS and a member server. ... >>Unplug the second.. ...
    (microsoft.public.backoffice.smallbiz2000)
  • Re: SQL bind socket error
    ... SBS SQL user for many years, and even more curious my AD doesn't list the ... I also wonder if you might have port 1434 closed internally ... internal Trusted network but should always be blocked facing the Internet. ... >>> I've been ignoring these for a couple of years on a member server. ...
    (microsoft.public.windows.server.sbs)
  • Re: SQl question
    ... You have one less thing to argue about if SQL ... 2005 is on a member server, especially one that is not doing much. ... SQL2000 living together with SQL2005 on the SBS box ...
    (microsoft.public.windows.server.sbs)
  • Re: SMS on Member Server
    ... SMS works great on Member servers. ... If you are using advanced security you will need to have SQL 2000 ... I installed on member server with SQL that has ... > the installation available when you purchase volume license? ...
    (microsoft.public.sms.installer)
  • Re: SQl question
    ... You have one less thing to argue about if SQL ... 2005 is on a member server, especially one that is not doing much. ... SQL2000 living together with SQL2005 on the SBS box ...
    (microsoft.public.windows.server.sbs)