You are visiting the High Monkey blog archive. Posts prior to 2016 may not meet accessibility standards. Please visit our current blog area at https://www.highmonkey.com/blog to view accessibility compliant blog posts published since January 1, 2016.

Access Services and SQLLocalDB

Written By: High Monkey
Posted: 1/9/2014

(From the mind of Peter Serzo, Previously VP of Consulting Services at High Monkey)

My customer correctly "asked" me, "Why do I have to install SQL Express, a Database on my two WFE's! That is too much exposure"

My response of, "the whitepaper says we have to," just didn't cut it. I couldn't even answer what it was for. So I reached out to an expert at Microsoft for the answer - Kevin Bell - of the Access Services team. He has been doing a lot of talks at SPUGs and I was lucky to catch him at one.

He answered me very promptly, which I am grateful for. Here is the answer.

  1. SQLLocalDB is loaded on the application server, not the WFE.
  2. SQLLocalDB does not contain any storage - it is used for query processing. It uses a different IIS process and is not accessible externally. Local DB is used to have connectivity to external data. Therefore, if you don't install it - everything will still work except...except for external data to SharePoint Lists.

So once again, Thank you to Kevin - I hope you all find this information useful!
 

Chad's Bio Coming Soon!

More About Virgil

Virgil Carroll is the owner and president of High Monkey – based in Minneapolis Minnesota. Virgil also wears the multiple ‘hats’ of Principle Human Solutions Architect and SharePoint Architect.

Virgil is one of those rare individuals who can dive deep into technical topics while speaking clearly to the business owners of a project and never forgetting that the end user experience has the highest priority. He calls it using both sides of his brain. Virgil is passionate about leveraging technologies ‘out of the box’ as much as possible with a focus on the strategic use of content to create websites that deliver the right content to the right audience on the right device at the right time. Virgil brings high energy, an ironic wit, and a sense of grounded perspective whenever he speaks to an audience. Virgil regularly speaks at conferences and user groups throughout the United States and occasionally in Europe.

Posted: 1/9/2014 12:00:00 AM by Brian Haukos | with 0 comments