Where is SQL Management Studio in SQL 2016?

So, in preparation of installing SharePoint 2016, I was installing SQL 2016 Enterprise. I got to the “Feature Installation” page and found that SQL Management Studio is not listed in the SQL install. Think I am lying? Look below!

 

So, I did a bit of research and found this: https://msdn.microsoft.com/en-us/library/mt238290.aspx where you can download SSMS for 2016. It is backwards compatible. I have not seen the technical reason behind this change, but if I had to guess it is so you can get SSMS by itself AND you don’t install anything extra on your Database Server. I am sure someone will comment and give a good number.

Posted in Infrastructure | Leave a comment

The local farm is not accessible. Cmdlets with FeatureDependencyId are not registered

Problem

This is an age-old problem. When you run powershell on your server you get the following error:

The local farm is not accessible. Cmdlets with FeatureDependencyId are not registered.


Solution

Make sure the logged in user has rights to the SharePoint_Configuration database

  • SharePoint_Shell_Access
  • DB_owner (try reducing the privileges after you get it working in order to support “least privileges”


 

Posted in Infrastructure | Leave a comment

Use Microsoft Word to Publish Blog Posts to SharePoint

I often get asked as I have gone from place to place, “How do can I easily post documents with screen-shots in them up to SharePoint?” I of course answer, “Use a SharePoint blog!” In order to do that, you have to know how. So, this is a simple article that talks about how to do this. You of course would have to customize the SharePoint blog to meet your needs. This is intended for SharePoint 2010, 2013, or SharePoint 2016. It may or may not work for SharePoint 2007.

1. Open Microsoft Word.


2. Click on the File Tab. Select Share from the side menu. Select Post to Blog. Click on the Post to Blog Command.


3. Select Register Now from the Register a Blog Account screen.


4. Select SharePoint blog from the dropdown list in the New Blog Account screen.

(If you’re using WordPress, it’s basically the exact same steps below with one extra – add your username and password).


5. Copy the URL of the blog. Paste it into Notepad and remove any extra junk text (such as “default.aspx”) that may appear at the end.


6. Paste it into the Blog URL field. Before you select OK, click on Picture Options.


7. You can select from several Picture “providers” – what this is doing is telling Word where to store the images in your post – to the Pictures Library that is part of the SharePoint blog sub-site or to your own server…

Not sure? Ask your SharePoint Champion who know your organizations’ policies around file storage best practices.


8. Select OK. Congrats! Account registration successful!


9. You can manage your blog accounts in the Blog Post tab using the Manage Accounts command button in the Blog group. (Note: This tab is not always visible. Repeat steps 1 and 2 to have it appear.)


10. You can add new Blog Accounts, Change existing Blog Accounts, remove Blog Accounts or after adding multiple accounts, select a default account.


11. You have several options for blogging providers. As you can see, I added my personal knowledge blog “Oh365eh!” that lives on the WordPress platform:


Tips:

#1 – When writing a blog post be sure to remember to select which Account you want to publish the post to before pressing Publish. It does not automatically Publish to the blog that is selected as the Default.

Extra Resources:

The “Help with blogging in Word” article on the Microsoft Support site is an excellent troubleshooting resource.

(Yes, it’s for Word 2007 but 90% of it is applicable to Word 2010 and Word 2013 users. It’s so relevant that when you click on the “Help me fill out this section” link in Word 2013 it takes you to said page.)

Posted in User Tips | Tagged , , | Leave a comment

Add Home and Back Button To Search Results Page

So one of the annoying things about SharePoint 2010 and SharePoint 2013 is that once users get to the search result page, there is no way to go back to the previous page without clicking the browser back button.  Also, if you haven’t done a little customization, you lose the typical navigation at the top and often can not return to the Portal Home page.  How can we remedy this?


There is an old method that was mentioned in SharePoint 2007, and still works for SharePoint 2013 since it is using out-of-box web parts to enable your ability to see the Home and Back button.  We can add some code to a content editor web part to display a button on the page to let people go back to previous page and with search term displaying in the search box.


Old 2007 Buttons (Feel free to create newer ones)

2013 Version uses more text-based buttons and you could do something like this on the Search page.


Here is the code to add to a content editor web part:
<!–Home button–>

<a href=”/”>

 <img src=”_layouts/images/hhome.png” border=”0″ alt=””/>

< /a>

<a href=”/”>Home</a>

<!–Back button–>

< a onclick=”history.go(-1)” href=”#”>

  <img src=”_layouts/images/back.gif” border=”0″ alt=””/>

< /a>

< a onclick=”history.go(-1)” href=”#”>Back</a>

Obviously, you need to edit the URL for the home button to suit your needs.  You can also edit the text that shows up on the page to better suite your needs as well, but this is a quick solution for your Search navigation.

Posted in Page Design, Search Configuration | Tagged , , | Leave a comment

Everything Lost

Update, I recently changed web hosts and unfortunately as a part of the process, I lost all of my posts. Some of them I have been able to get back from Google Cache, but I much of it I was not. Note to self, start saving copies in Word as well. For the articles I did have saved in MS Word, I am re-posting those. Others, I guess I will have to start fresh again. Sorry about that guys.

Thanks for the continued support!!

Ben

Posted in Uncategorized | Leave a comment

SharePoint 2010 / 2013 Firewall Rules

SHAREPOINT 2010/2013 FIREWALL RULES

Firewall Rules Table

Inbound/Outbound  From  Port  Type To  Version
Inbound Service Application 32843, 32844 (HTTPS), 32845 (net.tcp binding) HTTP SharePoint Web Service SP2010, SP2013
Inbound WFE (mail enabled list) SMTP (TCP 25) SP2010, SP2013
Inbound Index TCP 80 or 443 WFE SP2010, SP2013
Inbound All SharePoint Servers, but where Forefront Identity Management agent is installed TCP/5725 Active Directory SP2010, SP2013
Inbound All SharePoint Servers, but where Forefront Identity Management agent is installed TCP/UDP 389 (LDAP service) Active Directory SP2010, SP2013
Inbound All SharePoint Servers, but where Forefront Identity Management agent is installed TCP/UDP 53 (DNS) Active Directory SP2010, SP2013
Inbound All SharePoint Servers, but where Forefront Identity Management agent is installed TCP/UDP 88 (Kerberos) Active Directory SP2010, SP2013
Inbound All SharePoint Servers, but where Forefront Identity Management agent is installed UDP 464 (Kerberos Change Password) Active Directory SP2010, SP2013
Inbound All SharePoint Server (Depends on Central Admin config) Office Server Web Services, TCP 56737, SSL 56738 App (Central Admin) SP2010, SP2013
Inbound TS Jump point RDP (TCP 3389) For Remote Admin APP (Central Admin) SP2010, SP2013
Inbound Client IPs (as applicable) TCP 80 or 443 ISA Web Pub or WFE SP2010, SP2013
Inbound Index TCP 80 or 443 WFE SP2010, SP2013
Inbound Office Web Apps 809 (private traffic between the servers that run Office Web Apps Server) All Servers SP2013
Outbound ALL SharePoint Servers (Based on Authentication) DNS (TCP/UDP 53) DC (AD) /DNS (LDAP) SP2010, SP2013
Outbound External Content DNS (TCP/UDP 53) DNS SP2010, SP2013
Outbound ALL SharePoint Servers (Based on Authentication) DS (TCP 445) DC (AD) /DNS (LDAP) SP2010, SP2013
Outbound Index (File Shares) Either NBT (TCP/UDP 137, 138,139) or Direct-hosted SMB (TCP/UDP 445) Server Message Block (SMB) External Content SP2010, SP2013
Outbound ALL SharePoint Servers (Based on Authentication) Kerberos (UDP 88) DC (AD) /DNS (LDAP) SP2010, SP2013
Outbound ALL SharePoint Servers (Based on Authentication) LDAP/S (UDP 389/636) DC (AD) /DNS (LDAP) SP2010, SP2013
Outbound ALL SharePoint Servers (Based on Authentication) RPC (TCP 135) DC (AD) /DNS (LDAP) SP2010, SP2013
Outbound WFE (SSO) RPC for SSO – (TCP 135), plus random high ports (Dynamic RPC) or restricted high ports (Static RPC) APP Servers SP2010, SP2013
Outbound Index (Propagation) Search Query, either NBT (TCP/UDP 137, 138,139) or Direct-hosted SMB (TCP/UDP 445) Query SP2010, SP2013
Outbound WFE (Search Request) Search Query, either NBT (TCP/UDP 137, 138,139) or Direct-hosted SMB (TCP/UDP 445) Server Message Block (SMB) Query SP2010, SP2013
Outbound WFE (alerts) SMTP (TCP 25) SMTP/Exchange SP2010, SP2013
Outbound Index (BDC) SQL (TCP 1433, UDP 1434) or custom port External Content SP2010, SP2013
Outbound ALL SharePoint Servers SQL (TCP 1433, UDP 1434) or custom port for Named SQL Instance SQL Server Tabular Data Stream (TDS) SQL Server SP2010, SP2013
Outbound Index (Search Crawling) TPC 80, TCP 443, TCP (custom) HTTP WFE SP2010, SP2013
Outbound Index (Sites) TPC 80, TCP 443, TCP (custom) External Content SP2010, SP2013
Outbound WFE TPC 80, TCP 443, TCP (custom) HTTP Index Server (search crawling) SP2010, SP2013

 

Posted in Infrastructure | Tagged , | Leave a comment

Use Microsoft Word to Publish Blog Posts to SharePoint

I often get asked as I have gone from place to place, “How do can I easily post documents with screen-shots in them up to SharePoint?” I of course answer, “Use a SharePoint blog!” In order to do that, you have to know how. So, this is a simple article that talks about how to do this. You of course would have to customize the SharePoint blog to meet your needs. This is intended for SharePoint 2010, 2013, or SharePoint 2016. It may or may not work for SharePoint 2007.

1. Open Microsoft Word.


2. Click on the File Tab. Select Share from the side menu. Select Post to Blog. Click on the Post to Blog Command.


3. Select Register Now from the Register a Blog Account screen.


4. Select SharePoint blog from the dropdown list in the New Blog Account screen.

(If you’re using WordPress, it’s basically the exact same steps below with one extra – add your username and password).


5. Copy the URL of the blog. Paste it into Notepad and remove any extra junk text (such as “default.aspx”) that may appear at the end.


6. Paste it into the Blog URL field. Before you select OK, click on Picture Options.


7. You can select from several Picture “providers” – what this is doing is telling Word where to store the images in your post – to the Pictures Library that is part of the SharePoint blog sub-site or to your own server…

Not sure? Ask your SharePoint Champion who know your organizations’ policies around file storage best practices.


8. Select OK. Congrats! Account registration successful!


9. You can manage your blog accounts in the Blog Post tab using the Manage Accounts command button in the Blog group. (Note: This tab is not always visible. Repeat steps 1 and 2 to have it appear.)


10. You can add new Blog Accounts, Change existing Blog Accounts, remove Blog Accounts or after adding multiple accounts, select a default account.


11. You have several options for blogging providers. As you can see, I added my personal knowledge blog “Oh365eh!” that lives on the WordPress platform:


Tips:

#1 – When writing a blog post be sure to remember to select which Account you want to publish the post to before pressing Publish. It does not automatically Publish to the blog that is selected as the Default.

 

 

Extra Resources:

The “Help with blogging in Word” article on the Microsoft Support site is an excellent troubleshooting resource.

(Yes, it’s for Word 2007 but 90% of it is applicable to Word 2010 and Word 2013 users. It’s so relevant that when you click on the “Help me fill out this section” link in Word 2013 it takes you to said page.)

Posted in Uncategorized | Leave a comment

Add home and back button to the search result page in SharePoint

So, this was originally written for SharePoint 2007 and the icons are designed for SharePoint 2013, but the methodology still works and you certainly could choose to use this on SharePoint 2010 or SharePoint 2013. I don’t know if it still applies to SharePoint 2016 search centers. The problem is once people get into the search result page, there is no way to go back to the previous page without clicking the browser back button.

One thing we can do is we can add some code to a content editor web part to display a button on the page to let people go back to previous page and with search term displaying in the search box.


Here is the code to add to a content editor web part:

<!–Home button–>

<a href=”/”>
     <img src=”_layouts/images/hhome.png” border=”0″ alt=””/>
< /a>
< a href=”/”>Home</a>

<!–Back button–>
< a onclick=”history.go(-1)” href=”#”>
 <img src=”_layouts/images/back.gif” border=”0″ alt=””/>
< /a>
< a onclick=”history.go(-1)” href=”#”>Back</a>

Posted in Uncategorized | Leave a comment