none
SBS 2011 Standard and SQL RRS feed

  • Question

  • I have installed SBS2011 Standard, and I would like to install SQL Express onto the same server.  Will that be OK, and if so do I need to download and install.   I am intrigued by the fact that I already have Microsoft SQL Server 2008 and Microsoft SQL Server 2008 R2 program folders on the server with various configuration and others tools.  Why are these there if SQL is not installed as standard?

     

    A

    Thursday, May 19, 2011 9:09 AM

Answers

  • You are right I think, In exchange 2010 you have journaling what it does it copy's all incoming and / or outgoing email in a separate mailbox. You have 2 options you can do this for all incoming and/or outgoing mail, or you can configure this per mailbox (and create seperate rules for all users wanted) Only for the last option you need additional Exchange enterprise CAL's.

    Read here http://technet.microsoft.com/en-us/library/aa998649.aspx and here http://www.howexchangeworks.com/2011/02/standard-vs-premium-journaling-in.html for more information.

    Beside journaling you also have Personal archiving in exchange 2010. What this does it archive mails from the users mailbox (via configured retention rules and policies) to the users personal archive, this is a special mailbox in your exchange store.

    Look here http://www.howexchangeworks.com/2009/08/archive-mailbox-in-exchange-2010.html how this works and how you see this in outlook and owa. For this feature you also need additional exchange enterprise CAL's and this requires a minimal version for you outlook client (at least professional and 2010 for all features, with 2007 some features won't work.

    Big difference between both are that journaling is capturing all email when it comes in and/or goes out your mailserver and archiving does move mails from the users mailbox to the archive mailbox to keep the users mailbox clean and smooth. If a users deletes a email it also doesn't come in the archive.

    If you have some additional questions please ask.


    Regards Ronny
    -------------
    Visit my Blog or follow me on Twitter

    • Marked as answer by Alex PH Thursday, May 19, 2011 5:38 PM
    Thursday, May 19, 2011 11:45 AM

All replies

  • Hi,

    SBS uses by default a couple of SQL instances, MSSQL$SBSMONITORING for monitoring, MSSQL$SHAREPOINT for Sharepoint and MSSQL$MICROSOFT##SSEE the Windows internal database, used by Wsus and sharepoint. So SQL is installed on a SBS server.

    Microsoft doesn't recommend to install any other SQL instance on the SBS server (domain controller), there are a few security issues and ofcourse if it is a heavily used SQL server it will have impact on the other parts of your SBS server. These are some of the reasons the have the premium add-on with the SQL license. I thougt the security issue was that you could not run the SQL services under local system so you have to create a service account with rights on your domain controller.

    But if you can live with those things you can install SQL on the SBS server.


    Regards Ronny
    -------------
    Visit my Blog or follow me on Twitter
    Thursday, May 19, 2011 10:21 AM
  • Hi Thanks for your explanation

    I'm coming from SBS2003 to SBS2011 and lots has changed !  Our users obviously have their own email addresses  and we have about 2000 emails a month to all users.  I have been asked to archive all emails for certain users.  I used third party software on our SBS2003 server which required SQL. 

    Can this now be done directly through Exchange?  I found a KB article about archiving for Security Groups but that seemed to require a common email address for the group.

    A

     


    Edit

    In fact I am not sure I am using the correct terminaology.  i think i need to journal the emails - i.e. the user gets the message, but a copy is also stored elsewhere.

    A

    Thursday, May 19, 2011 10:47 AM
  • You are right I think, In exchange 2010 you have journaling what it does it copy's all incoming and / or outgoing email in a separate mailbox. You have 2 options you can do this for all incoming and/or outgoing mail, or you can configure this per mailbox (and create seperate rules for all users wanted) Only for the last option you need additional Exchange enterprise CAL's.

    Read here http://technet.microsoft.com/en-us/library/aa998649.aspx and here http://www.howexchangeworks.com/2011/02/standard-vs-premium-journaling-in.html for more information.

    Beside journaling you also have Personal archiving in exchange 2010. What this does it archive mails from the users mailbox (via configured retention rules and policies) to the users personal archive, this is a special mailbox in your exchange store.

    Look here http://www.howexchangeworks.com/2009/08/archive-mailbox-in-exchange-2010.html how this works and how you see this in outlook and owa. For this feature you also need additional exchange enterprise CAL's and this requires a minimal version for you outlook client (at least professional and 2010 for all features, with 2007 some features won't work.

    Big difference between both are that journaling is capturing all email when it comes in and/or goes out your mailserver and archiving does move mails from the users mailbox to the archive mailbox to keep the users mailbox clean and smooth. If a users deletes a email it also doesn't come in the archive.

    If you have some additional questions please ask.


    Regards Ronny
    -------------
    Visit my Blog or follow me on Twitter

    • Marked as answer by Alex PH Thursday, May 19, 2011 5:38 PM
    Thursday, May 19, 2011 11:45 AM
  • If you purchase the Add-on Exchange Enterprise licenses, you will have the ability to enable Email Archiving and Retention

    For more information on this, check here - http://www.microsoft.com/exchange/en-us/email-archiving-and-retention.aspx

    Licensing and comparisons can be found here - http://www.microsoft.com/exchange/en-us/licensing-exchange-server-email.aspx

     

     


    Regards, Boon Tee - PowerBiz Solutions, Australia - http://blog.powerbiz.net.au
    Thursday, May 19, 2011 1:03 PM
  • Can you explain what you mean by a 'service account...'

    very many thanks

    A

    Thursday, May 19, 2011 1:59 PM
  • You mean for SQL I think, a sevice account is just a user account that is created to start the SQL Server services.

    Most services start with the local system account, but if you would like to run SQL on a domain controller you need a dedicated account, with the apropiate rights.


    Regards Ronny
    -------------
    Visit my Blog or follow me on Twitter
    Thursday, May 19, 2011 2:32 PM
  • Thanks for the clarification - I was sure if there was a separate service account set up somewhere.  All up and running and seems to be OK

    Thanks for you help

    Thursday, May 19, 2011 5:38 PM