locked
Standard Edition - Supported SQL Versions RRS feed

  • Question

  • Hi all, this URL https://technet.microsoft.com/en-au/library/dn951388.aspx#DBs states that "When installing Skype for Business Server 2015 Standard Edition, you’ll have SQL Server 2014 Express (64-bit edition) is automatically installed as well."

    (It goes on to list the requirements for Skype Enterprise.)

    So, SQL Express is OK with Standard Edition. But, when i try to deploy Monitoring Reports, it errors that customized permissions cannot be set with this edition of SQL. After reading forums, people say "read Technet and only use the version of SQL listed". Well, that's what I've done and it says that Expresss is OK for Skype for Biz Standard. I can't see anything that says I specifically need SQL Standard just for SSRS and it would be madness if I use SQL Express for all the databases but then need SQL Standard just to see the reports!

    Is this a bug that can't detect the fact that I'm using Skype Standard Edition?

    TIA

    m

    Thursday, September 22, 2016 3:19 PM

Answers

  • Hi M.a.r.k.T. _,

    Thanks for your response.

    For Monitoring server, it requires the MS SQL server to collect the data of QOE and CDR, in order to check these reports, we need to install SQL server reporting service, for SFB 2015, it supports the edition mentioned by James, Microsoft isn’t support to use SQL express edition for reporting service.

    I’m sorry for that and fully understand your frustration, we will improve our product by collecting customer’s feedback, hope to gain your understanding.

    Thanks for your understanding.


    Alice Wang
    TechNet Community Support


    Please remember to mark the replies as answers if they help and unmark them if they provide no help.
    If you have feedback for TechNet Subscriber Support, contact tnmff@microsoft.com.

    • Marked as answer by M.a.r.k.T. _ Wednesday, September 28, 2016 8:36 AM
    Wednesday, September 28, 2016 8:25 AM

All replies

  • If you want to use a SFB monitoring role, you have to install another SQL 2014 standard database on another server. The monitoring database canot be installed on the FE standard server!

    regards Holger Technical Specialist UC

    Thursday, September 22, 2016 7:58 PM
  • You are correct, the monitoring database cannot be on the FE server and it isn't on the FE server! I am talking about SSRS on the Skype Standard Edition server.
    Thursday, September 22, 2016 8:17 PM
  • Holger is right, you need a full edition of SQL for the monitoring and reporting.  SQL Standard won't cut it.  If you have another SQL Standard instance, it doesn't have to be 2014... sometimes if the deployment is small we'll just collocate with another SQL server.

      

    Please remember, if you see a post that helped you please click "Vote" on the left side of the response, and if it answered your question please click "Mark As Answer". SWC Unified Communications This forum post is based upon my personal experience and does not necessarily reflect the opinion or view of Microsoft, SWC, their employees, or other MVPs.

    Thursday, September 22, 2016 8:28 PM
  • Perhaps I need to explain something about SQL: SQL is not really a single product as such: it is a suite of various "products" (or engines) such as SQL Server Database Services, SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS). In most enterprise environments (well, the ones I've worked with), they are separate. So, you have Database Services on one server, SSRS on another and so on. I hope that makes sense?

    Now, Skype for Biz has certain constraints about where the databases can reside. NOTE: databases, not reporting services. (Unfortunately, I cannot find the reference that states that, but I think we are agreed that the databases for archiving and monitoring cannot reside on the front end servers.)

    Back to my point: my question was about Reporting Services, not Database Services which are (almost) a different product (well, for the sake of this question they are though for your information, SSRS actually requires its own database services, but that's a separate point).

    Now, one other thing: Express Edition includes SSRS (in the advanced version). So, we know that Skype Standard is supported with SQL Express and we know that SQL Express can (optionally) include SSRS. Now, https://technet.microsoft.com/en-au/library/dn951388.aspx#DBs says that SQL Express is OK. Moreover, the whole reason for Skype Standard is collocation for small environments. It seems highly illogical if a Microsoft allow good value in Skype Standard but then force those customers to have to buy SQL Standard. The SQL would be more expensive than Skype itself! (Well, maybe - I'm not a pricing expert.) 

    if you disagree, would you please be so kind as to post a reference that states that SSRS Express (part of SQL Express) is not allowed in Skype Standard as I believe the above URL implies that it is. Of course, we have all seen contradictory Technet articles and I have not read them all, so it is entirely possible I just have not read the one that answers this question. (I'm afraid it'll have to be a Microsoft reference rather than a blog - unless it is a Microsoft blog.) 

    So, to be clear, I am not referring to SQL Server Database Services. I am referring to SSRS, which is different.

     
    Thursday, September 22, 2016 9:59 PM
  • Yes, we understand the difference between the database and reporting services. But, the monitoring and archiving databases are different than the other backend databases. Although the role is colocated with front end services, it is separate. You need a full version of SQL, this cannot be hosted on SQL express. Please see the following article: https://technet.microsoft.com/en-us/library/jj204937.aspx

    Please remember, if you see a post that helped you please click "Vote" on the left side of the response, and if it answered your question please click "Mark As Answer". SWC Unified Communications This forum post is based upon my personal experience and does not necessarily reflect the opinion or view of Microsoft, SWC, their employees, or other MVPs.

    • Proposed as answer by Alice-Wang Friday, September 23, 2016 2:32 AM
    Thursday, September 22, 2016 11:20 PM
  • This page also clearly shows the supported Monitoring DB's

    https://technet.microsoft.com/en-us/library/gg398990.aspx

    • Microsoft SQL Server 2008 R2 Enterprise database software (64-bit edition). Additionally running the latest service pack is recommended.

    • Microsoft SQL Server 2008 R2 Standard (64-bit edition). Additionally running the latest service pack is recommended.

    • Microsoft SQL Server 2012 Enterprise (64-bit edition). Additionally running the latest service pack is recommended.

    • Microsoft SQL Server 2012 Standard (64-bit edition). Additionally running the latest service pack is recommended

    Totally understand that SRSS is "Another Product" but its still part of the same suite of products. the Montoring and QoE DB's need to be homed off the front end and for any role thats not a frontend SQL express is not supported.

    Sorry mate


    Was my post helpful? Help me help you by voting or making the post as an answer. If you're in Melbourne, Australia I regularly present at the Skype4B users group, Feel free to catch up.

    Friday, September 23, 2016 12:22 AM
  • Hi M.a.r.k.T. _,

    Welcome to post in our forum.

    Agree with Holger and Anthony.

    As a supplement, if you install the SFB standard edition, during the deployment process, it will only automatically install SQL server express on the FE server.

    For monitoring, it’s not supported SQL server express edition, and the monitor report is part of Monitoring, so if you want to install monitoring on the SFB SE server, you need to install a full edition of SQL server which has already mentioned by Anthony.

    The following is about how to install Monitoring report for SFB server for your reference

    https://technet.microsoft.com/en-us/library/jj204989.aspx

    Hope this reply helpful to you.


    Alice Wang
    TechNet Community Support


    Please remember to mark the replies as answers if they help and unmark them if they provide no help.
    If you have feedback for TechNet Subscriber Support, contact tnmff@microsoft.com.

    Friday, September 23, 2016 2:57 AM
  • The archiving and monitoring databases ARE on SQL Standard and is therefore 100% complaint with the requirements. Please understand this simple SQL point: The Database Services and SSRS DO NOT need to be on the same server. Maybe that what people do on these forums but I generally don't?!

    I think I need to spell this out:

    FE Standard server: SQL Express hosting the usual SFB databases fully complaint with this:

    https://technet.microsoft.com/en-au/library/dn951388.aspx#DBs

    SQL Standard Database Services hosting the A and M databases, fully complaint with this

    https://technet.microsoft.com/en-us/library/gg398990.aspx

    So, back to the OP: why does it not allow SSRS Express for the Reporting services. (Again, with SSRS on the FE server connecting to the fully supported SQL Standard on another server?) Where is the MS article that says that this is not allowed? I still see none. :( Indeed, I can follow the instructions that Annie provided, be 100% compliant with it but it still errors. I wonder if the Skype devs and documenters understand that SSRS and database servers can (and usually are) on separate boxes? Or maybe they do and simply forgot that people might actually try to use SSRS Express. I wouldn't be surprised: a lot of people I know don't even know that SSRS Express even exists! I know not, but what would be good is if MS add to their documentation an explicit statement about the SSRS requirements.

    (Also, IMHO, it makes a complete nonsense of having Skype Standard if it also requires customers to have to purchase SQL Standard just to read reports.)


    Friday, September 23, 2016 7:18 AM
  • Hi M.a.r.k.T. _,

    Thanks for your response.

    For Monitoring server, it requires the MS SQL server to collect the data of QOE and CDR, in order to check these reports, we need to install SQL server reporting service, for SFB 2015, it supports the edition mentioned by James, Microsoft isn’t support to use SQL express edition for reporting service.

    I’m sorry for that and fully understand your frustration, we will improve our product by collecting customer’s feedback, hope to gain your understanding.

    Thanks for your understanding.


    Alice Wang
    TechNet Community Support


    Please remember to mark the replies as answers if they help and unmark them if they provide no help.
    If you have feedback for TechNet Subscriber Support, contact tnmff@microsoft.com.

    • Marked as answer by M.a.r.k.T. _ Wednesday, September 28, 2016 8:36 AM
    Wednesday, September 28, 2016 8:25 AM
  • Hi Alice,

    Thank you for your reply. You many be surprised but as far as I know, you are the first Microsoft person to state this explicitly. Might I suggest that the documentation be updated to reflect this please?

    Technically, it also seems mad to me that one can use Standard Edition everywhere except for SSRS. That just feels like a coding oversight to me! But I learn the lesson: when proposing SFB Standard, I will need to ensure that the customer also has SQL Standard somewhere in their environment (or buy a new one).

    Thanks

    Mark

    Wednesday, September 28, 2016 8:36 AM