If you have tried to download and install the SQL Management Tools so you can see your SQL install, after you have installed SharePoint Foundation 2013, you likely have run into a few issues.

Below is the formula to get the SQL management tools installed:

Note that I ran mine on Server 2012 R1 and received several THIS PROGRAM HAS COMPATIBILITY ISSUES popups but I have assurances from Microsoft Partner Support that it is fine to click RUN THE PROGRAM WITHOUT GETTING HELP… so I did 🙂

  1. Download and launch Management Studio for SQL 2008 R2 Express from Microsoft
  2. click NEW INSTALLATION OR ADD FEATURES
  3. click NEW INSTALLATION OR ADD SHARED FEATURES
  4. Click the I ACCEPT options
  5. CLICK MANAGEMENT TOOLS – BASIC
  6. finish the wizard

how-to-install-SQL-management-tools-for-sharepoint-foundation-2013

 

Take note that when you start your Management Studio that the SERVER NAME is <SERVER-HOST-NAME>\SHAREPOINT and you may (likely?) need to use SQL SERVER CONFIGURATION MANAGER to enable TCP/IP .  If you need to make these changes, you will also have to restart the SQL SHARPOINT service.

You also may need to start the SQL BROWSER in SERVICES.

 


0 Comments

Leave a Reply

Avatar placeholder

Your email address will not be published. Required fields are marked *