SharePoint 2013 Installation

This is guide for installing SharePoint 2013 Enterprise using a compilation of various posts with the plan built off of Todd Klindt’s basic installation guide.

  1. Confirm Service Accounts. Here’s another suggestion that has more detail
    • Make sp_install a local administrator on all SharePoint servers
  2. Install SQL 2012 SP1
  3. Run Prereq installer to Install Prereqs
  4. Install forgotten prereqs
  5. Install SharePoint 2013
  6. Run “Start-Transcript” in SharePoint 2013 Management Shell so you can track all the commands you are executing
  7. Create Farm
  8. Install any CUs
  9.  Create managed accounts
  10. Create content web app
  11. Create mysite web app. Here’s another resource. And finally TechNet
    • How to get those user photos in there from AD. Make sure to read the comments as well
    • If you set up the User Profile Service now, profile data will have temporary issues until you setup other services.
  12. Create App Management Service. Here’s the TechNet info on Apps. Here’s some important info regarding allowing anonymous access to Apps.
  13. Add SharePoint web apps to Hosts file
  14. Create State Service
  15. Create Usage Service app (see previous link)
  16. Create Managed Metadata Service
  17. Create Search Service
  18. Run a full crawl to verify everything works
  19. Create User Profile Service app if you haven’t already
  20. Create other service applications as needed
  21. Gpupdate /force & reboot
  22. Run all Health Analyzer rules
  23. Don’t forget the Workflow Manager and this for non-SSL:
    • register-SPWorkFlowService -spsite “http://yourSite” -WorkflowHostUri “http://workflowHost:12291” -AllowOAuthHttp
    • And don’t forget to run Workflow Manager on every server in your farm.
  24. Create the Business Data Connectivity Service Application. Make sure you’re running the “Business Data Connectivity Service” in Services on Server before you create the Service Application.
  25. Install PerformancePoint 
  26. Report Server. No content-types?

Update Web Part on a Page Using Powershell in SharePoint 2010

I recently had to update a web part’s zone id that existed on most pages throughout the SharePoint 2010 site. I wrote up this powershell script to address this. DISCLAIMER: Use at your own risk!

  $site = new-object Microsoft.SharePoint.SPSite(“http://your_site”)
  foreach($web in $site.AllWebs)
    #Make sure you specify which page needs changes
    $page = $web.GetFile(“default.aspx”)
    $wpm = $web.GetLimitedWebPartManager($page.Url, [System.Web.UI.WebControls.WebParts.PersonalizationScope]::Shared)
  #$wpm.WebParts | ft
  $wp = $wpm.WebParts | Where-Object { $_.Title -eq “Page Tabs” }
  #$wp.ZoneID | ft
  $wp.ZoneID = “Header”
  $page.CheckIn(“Update via PowerShell”,[Microsoft.SharePoint.SPCheckinType]::MajorCheckIn)
  $wp.ZoneID | ft

I left the commented lines in since they can be helpful as well.

Query Tool for Raw Web Service Search Results for SharePoint 2007 & 2010 (FAST and Enterprise)

CodePlex has two great tools to query your SharePoint 2007 or 2010 search which return raw XML so you can see exactly what is going on in your results.

Fast Search For SharePoint MOSS 2010 Query Tool – Ok, they need to work on the title a bit and the background is just a terrible idea but the thing works for both FAST and Enterprise Search on 2010. It allows you to choose Scope, edit the Default Columns, and a lot more. It’s mostly intuitive to use. Just make sure to change your “Results Provider” to “SharePoint” if you’re using Enterprise instead of FAST.

SharePoint Search Service Tool – This is for SharePoint 2007 and works just as well as the previous one. It has less options but gets you your XML results quickly and edit the query as needed. Plus, a nice background!

SharePoint 2007 Search Service Tool

Downgrading from SQL Server 2008 R2 Enterprise to SQL Server 2008 R2 Standard

I recently had to downgrade from SQL Server 2008 R2 Enterprise down to Standard with SharePoint 2010 Enterprise installed. It turned out to be surprisingly easy, thanks to this thread. One issue will likely come up. Search won’t work and you’ll get this error:

Database ‘[name]‘ cannot be started in this edition of SQL Server because part or all of object ‘MSSDocSdids’ is enabled with data compression or vardecimal storage format. Data compression and vardecimal storage format are only supported on SQL Server Enterprise Edition.

Unfortunately you’ll have to recreate search. This post references any issues with that. The same might be true for your Web Analytics Service Application with an error like this:

EVENT 5586: Database ‘WebAnalyticsDatabaseName’ cannot be started in this edition of SQL Server because it contains a partition function ‘DateIdPF’. Only Enterprise edition of SQL Server supports partitioning.

Nevertheless, here are the steps that worked for me. Be sure to follow them to the letter.

  1. Take a good backup of all of your databases (system and user).
  2. Run SELECT @@VERSION and note the specific build number of SQL Server that you are currently on.
  3. Shut down your existing instance of SQL Server.
  4. Copy the master, model, and msdb database files (both mdf and ldf), don’t move them copy them, from the current location to a new folder that you mark as readonly.
  5. Uninstall SQL Server from the system.
  6. Reboot the server.
  7. Install SQL Server Standard Edition.
  8. Apply the necessary Service Pack and/or Cumulative Updates to bring the instance up to your previous build number.
  9. Shutdown SQL Server.
  10. Copy the master, model, and msdb database files (both mdf and ldf) from the folder you saved them in to the correct location for the new install and remove the readonly flag from the files, and change the file ACL’s so that the SQL Service account has Full Control over the files.
  11. Startup SQL Server and if you did it correctly it will startup and be exactly where you were before you made any changes, with all of your user databaes online and you should be ready to let applications connect and resume operations.

The whole process took less than two hours. Good stuff.


Sawasdee – A Quickie Review

I have eaten at every Thai restaurant around town and this always ranks #1. I tend to order their Drunken Noodles Chicken which is my favorite. I get it “3 stars” spicy but have had it up to 5. Oh they’ll make it spicy! I was tearing up. The Pad Thai is the best I’ve ever had. I also recommend their Pad Prik Kra Paw Chicken which is an amazing dish with the most intoxicating smell. For an appetizer, I recommend the Satay chicken with the peanut sauce. The chicken can be a little tough sometimes but the flavor makes up for it. A lot of people I know love the Heaven Beef but it’s just not my favorite. I’ve also had their red curry which is top notch. The Kra Paw Catfish is a favorite of friends who can’t quit it to try something else. Try this place against any other Thai place in town and see where you go back to.

Centro – A Quickie Review

The food is excellent across the board but it just seems a bit overpriced. The portion sizes are a little small. Problem is that I can never escape this place for less than $16 for lunch. Maybe it’s because I have to pay for my chips and salsa? I really haven’t had a dish I didn’t love so go for what looks good because it will be. I’ll keep going back because it is that good but I’d go more if it weren’t so expensive.

The Raleigh Times Bar – A Quickie Review

LUNCH: Their burger is really good. I had mine with Habanero Cheddar. And they’ll cook it anyway you want (even rare) so if you’re a wild man like myself (see pic), you’ll love this place. Any sides are an added extra. The fries are the medium-sized/long, limp, and greasy. Personally, I liked them. They’re the grab-a-group-and-dip kind. No fancy dips here, just ketchup. They also have a decent Cuban sandwich.

The music is a fine selection of hits from the alternative/indy rock bands. I’ve heard Phantogram, the White Stripes, Interpol, and the Sonic Youth.

During nice weather, they leave the door open. This lets in flies. If you’re the type that freaks out about flies, then only go when it’s raining.

AFTER HOURS: This is the place to go and see the latest in hipster apparel which generally looks like beards, flannel, and jeans. The beer is good though with a good variety of microbrews. It can get pretty packed in here but the service is pretty quick.

Definitely a place I’ll return to. Look for me there!

Beasley’s Chicken & Honey – A Quickie Review

I’ve been here numerous times for lunch and have tried a lot of the menu. Service is usually very prompt, friendly and responsive. Staff is dressed in hipster chic as is the norm in downtown Raleigh. It can get a little loud in there since it is an open room.
The kitchen is shared with Chuck’s so if both places are packed, your food might take a little longer but honestly, I’ve never waited more than 5 mins.

Fried Chicken – very good. They drizzle a little bit of honey on it. Recommended. I wish they would add another piece.
Chicken Pot Pie – very good, but you know it must be 10000 calories. Good portion. Nevertheless, highly recommended.
Fish Fry – good but very good with hot sauce. Ask for some.
Meatloaf – very good. Tasted better than expected (I think most places screw up meatloaf)

Snap Beans – good, not my favorite though.
Summer Squash (seasonal) – mushy. Might as well have mashed potatoes.
Mac-n-Cheese – this is a favorite. Probably the best side on the menu so far.
Yukon potatoes – very good

I’ve only had one dessert, a hummingbird cake, which was ice cold and a bit dry. Not quite frozen but close! Do yourself a favor and go next door to Chuck’s for a milkshake.