Performance Point Services from scratch

Symptoms:
When trying to access sharepoint from Dashboard Designer error is thrown.
or

Solution:
Make sure these are installed:
From SQL Server 2012 Feature pack:
 -  Microsoft® SQL Server® 2012 ADOMD.NET and
 -  Microsoft® Analysis Services OLE DB Provider for Microsoft® SQL Server® 2012
From SQL Server 2008 R2:
 -  Microsoft® SQL Server® 2008 R2 ADOMD.NET and
 -  Microsoft® Analysis Services OLE DB Provider for Microsoft® SQL Server® 2008 R2

Make sure all these things are configured.
1. Start Secure Store Service

a. Central Administration> Application Management> Manage Services on Server> Secure Store Service > Start

2. Run iisreset

a. Cmd > iisreset

3. Create new Secure Store Service

a. Central Administration>Application Management> Manage Service Applications > New Secure Store Service (default settings)

4. Generate Key for Secure Store Service.

a. Central Administration>Application Management>Manage Service Applications> Secure Store Service (created above) Generate New Key

i. Use passphrase: P@ssw0rd! (optional)

5. Refresh Key for Secure Store Service.
a. Central Administration>Application Management>Manage Service Applications> Secure Store Service (created above)>Refresh Key
6. Create domain user :adventureworks\sp_unattend
a. Using Active Directory Users and Computers>New User sp_unattend with password: P@ssw0rd!
7. Create SQL Login, add db_datareader perm for sp_unattend

a. Using SQL Management Studio >Security>Logins>New Login> Loginname: Sp_unattend (or search for it)

b. User Mapping> db_datareader for all databases needed

8. Create new Performance Point Service

a. Central Administration>Application Management>Manage Service Application>New Performance Point Service Application

i. Add this service applications proxy to farm default

ii. Other Default or new application pool if needed.

9. Configure Performance Point Service, add Unattended Account.

a. Central Administration>Application Management>Manage Service Application>Performance Point Services(created above)>PerformancePoint Service Application Settings> Add adventureworks\sp_unattend as unattended service account

10. Optional Restart Server or IISReset again if any problems.
Note that if server has less than 4GB available this might not work and result in eventid3 >WebhostFailedToProcessARequest
References:
http://technet.microsoft.com/en-us/library/ee748643.aspx
http://blogs.msdn.com/b/performancepoint/archive/2009/11/24/deploying-performancepoint-2010-soup-to-nuts.aspx - good site for config .secure services

http://www.microsoft.com/en-us/download/details.aspx?id=1697 - SQL Server 2008 R2 Feature pack

http://www.microsoft.com/en-us/download/confirmation.aspx?id=29065  - SQL Server 2012 Feature pack

http://bhavikmerchant.wordpress.com/2012/12/08/setting-up-a-sharepoint-2013-bi-demo-vm/ - more detailed guide

Deploy printer through GPO

So I recently acquired an old printer for my home network. It’s a usb-only device so I need to connect it to my Server 2012 Essentials Server. Printers didn’t automatically work like they did on my W8 computer. Apparently a security feature that stops Server 2008+ from looking at Windows Update for printer drivers.

Anyways I now need to deploy this printer to all my home computers. Now I can just go around and connect manually from all machines but how fun is that. So, I’ll deploy it from a group policy. Easy and done right? So using GPO preference I add the printer and deploy it to my user OU. Hmm, nothing happens. Instead I receive an Event 4098 : Specified printer driver was not found.

After a bit of trial and error I found the solution. Creating a different GPO like on picture below and deploying it on the root gpo node makes it work.

Not really good security practice but it’ll work for my home network.

References:

http://social.technet.microsoft.com/Forums/en-US/winserverGP/thread/8c7f439c-be8c-4511-99fd-566985522673

Open with explorer causes IE10 to crash

This started happening a while ago, so don’t really know which update that caused this.

Symptom:

From a Sharepoint 2013 Document library a user tries the feature “Open With Explorer” only to be presented with error Page not responding or IE10 simply crashes. Users with IE10+W8 and IE10+W7 and S2008R2 is reporting error.

Solution:

When changing browsing mode to IE8 in the  Developer Tools in the function starts to work again. (Hit F12)

If this is true, install KB2600100 and reboot sharepoint server. Worked for me.

Se GigaJim post below for more details as exactly what the Kb does.

References:

http://support.microsoft.com/kb/2600100/en-us

http://gigajim.com/blog/2012/12/11/sharepoint-2010-and-ie10-incompatibility

Ninite removed Flash

Sad to say. Adobe forced them to take it down. They expect us to go to their crappy download procedure. Adobe… guys..did you have to?

If youre using Windows 8 its supposed to be integrated so Windows Update takes care of, but for some reason Firefox still complains that it isn’t updated. And still, were stuck with the adobe manual update procedure in all previous version of windows.

From this day forward, we say NO to adobe flash!

Heres an xkcd comic to visualize my frustration

References:

http://helpx.adobe.com/flash-player/kb/flash-player-issues-windows-8.html#main-pars_header_0

http://www.reddit.com/r/techsupport/comments/1c2h0b/flash_removed_from_ninite/

Strange group by problem

A curious problem.
Environment : Sharepoint Foundation 2010 using localization on Server 2008 R2
Symptom: After migration of Sharepointsite to different host problems started occur with the Group By function in all Views that utilized this.
First time a group by view is expanded everything works, but after opening a document under a group by node all the nodes reloaded and after this no + or – does what it should. Everything just shows as “Loading” under the Group By nodes. The Ribbonmenu also get stuck on “Loading” after this has started occuring. Reload of entire site doesn’t do anything. Browsing in InPrivate node gets in rolling once, then same error again.

Solution: Install kb2353117
References:
http://support.microsoft.com/kb/2553117/en-us

Trust Relationship between this workstation and primary domain failed

Symptom: When trying to login to the domain with a Windows 7 computer the following message is displayed “The trust relationship between this workstation and primary domain failed”.

Cause: Has the computer been out of sync with domain for some reason the domain computer password might have been expired. Check for trouble with dns or network errors.

Solution:

1. Log on to the Windows 7 computer with a local account
2. Go to system properties and choose Network ID
3. Go through the questions, yes its a domain and so on. Give a valid domain account that has the right to add computers to the domain. Normal user account works for default domains if not locked down.
4. Restart

Other solutions is to remove the computer from the domain. First on the local computer and then from the domain controller. Above solution, which is new for Windows7, is far more effecient though.

Lumia 800 finally at 7.8

Today operator Telia finally released Windows Phone 7.8 for the Lumia 800 in Sweden.

Took a while.

Features will include:

• Lockscreen with daily Bingimage
• Resizable Live tiles
• Internet Sharing (?, already release weeks ago?)
• Bluetoothsharing
• Contact Share
• PlayTo

Not really impressing, but we’ll see if it brings any nice tidbits when we’ve tried it for while…

References:

http://www.tempo.com.ph/2013/04/nokia-lumia-gets-better-with-windows-phone-7-8/#.UW1j-8p5KmQ