Jun 06
Back in March of 2012, Liam Cleary wrote an excellent guide to installing SQL 2012 Reporting Services into a SharePoint 2010 farm in integrated mode. (You can find that post here.) I’ve recently been using that guide to produce a proof of concept for a client, to show that I would be able to install …
May 16
One of the things that has always annoyed me in SharePoint 2010 is the security in PowerShell when trying to work with SharePoint objects. There I am, logged into my freshly created development box, drop into PowerShell and can’t access anything, despite running as administrator. The missing ingredients, yes Database permissions, so duly into SQL, …
Aug 01
Whilst working with a client recently we decided to use the Content Migration system within SharePoint to allow us to create a template site that could then be used as the source for the 88 sites that needed to be created for each of the areas of interest. Each site had identical set-up with regards …
Feb 26
I hit a slight problem with the SQL install on the dev box today. When I first installed SQL, I included a lot of the workstation tools, but I didn’t include the tools required for designing reports in VS 2005. In addition, since I did the install, I’ve put SP2 on the server. So now, …
Jun 08
Well a week or so since I found an untidy solution to the Excel properties predicament. I’ll be honest, I’ve not spent a lot of time looking at that this week as I’ve had to concentrate on the functionality of the communications between the spreadsheet cost model and the actual back-end data systems that will …
May 14
..but not for me.. I’ve spent the last week working with Excel VBA and OLE to get a connection into our backend SQL server. Then a couple of stored procedures to generate our required indexes and voila, I almost having a working DB.. Just some tweaking to do now. For those that haven’t seen the …
Mar 02
10 hours!!!… Thats how long it took me to resolve a Kerberos issue. It all started with finishing the installation of MOSS 2007 and then running the SharePoint Configuration wizard. No major problems with this, I entered the SQL Server information, changed the default configuration database name and added the Service credentials. Click next, and …