Holidays Booked!

Finally got my summer holidays booked! Off to Sri Lanka!

Cannot Connect to SQL from Excel

After a farm re-provision we had issues connecting to SQL Server from Excel.

I used this guide below (2nd Post) to fix my problem which was great!

Much thanks to JotaBe

http://stackoverflow.com/questions/10056560/connect-to-remote-sql-database-using-excel

Secure Store Shared Service is not responding

Decided i will actually try to  start posting from now on!

Following an re-install of a SharePoint Farm i had a number of issues around Secure Store, namely recieving this message "Cannot complete this action as the Secure Store Shared Service is not responding. Please contact your administrator".

I tried a number of solutions including making sure that the correct services were running, an IIS reset etc but to no avail.  

I then tried checking other services and noticed a few others such as BCS were also down.  This prompted me to look at the Event Log where i found 

"An exception occurred when trying to issue security token: The HTTP service located athttp://localhost:32843/SecurityTokenServiceApplication/securitytoken.svc/actas is too busy. ."

I searched high and low  this before coming across a blog post outlining the need to reprovision the secure token service using

1	$sts = get-spserviceapplication -identity {id of sts}

2	$sts.status

3

online

4	$sts.provision()

Luckily this allowed me access to the Secure Store and solved my problem :)

Introduction

Hi,

This is my new Blog about mostly Project Server and SharePoint but also about life, which i end up posting more about we will have to see ;)  I aim to add content on issues and solutions encountered in Project Server

Barry