CRM 2011 User does not have send-as privilege

When you have workflows in CRM 2011 that create e-mails for other users, like say, send an e-mail from the person who last modified an account to the owner of the account, you’re probably going to end up with e-mails staying in Draft.

When you want to send the e-mail afterwards you’re greeted with a nice: “User does not have send-as privilege.” (ErrorCode: -2147203059) exception.

When you look up the privilege, it’s nowhere to be found in the UI.
You can however set it (as suggested on the Microsoft Forum) in the Personal Settings.

The downside, you only get this option when you have the System Administrator role and no other.

When looking in the database, there is actually a prvSendAsUser privilege, so after assigning it to a general role that all users get like this:
AddPrivilegesRoleRequest addPrivilegesRequest = new AddPrivilegesRoleRequest
RoleId = new Guid(generalroleid),
Privileges = new[]
// Grant prvSendAsUser privilege.
new RolePrivilege
PrivilegeId = new Guid("6FD3EB4F-66E3-4587-B4AB-C064F03AD783"),
Depth = PrivilegeDepth.Global

If you afterwards have a look at the user’s privileges in the database with this query:
FROM SystemUser u
JOIN filteredSystemUserRoles sur ON sur.systemuserid = u.systemuserid
JOIN RolePrivileges rp ON rp.roleid = sur.roleid
JOIN FilteredPrivilege p ON p.privilegeid = rp.PrivilegeId

You’ll see that the user has in fact got the prvSendAsUser role.
But when you try to send an e-mail the problem stays the same.

The solution however is very simple, check for this privilege is not done in through privileges, despite what the exception makes you suggest, but is checked in the user settings.
Running an easy update query will fix this for you:
UPDATE UserSettings
SET IsSendAsAllowed = 1
WHERE IsSendAsAllowed = 0

Logical, no; but does it work, yes.

Can’t connect to server with BI FetchXML Addon

OK I’m at a loss here; I’m going bonkers.

I’ve created a report in CRM 2011 (which runs executes fine), afterwards exported the .rdl file, opened that .rdl file in Visual Studio 2008 with BI extensions.

When I try to get any data from VS I get an error: “Unable to connect to data source ‘CRM’.” with the details saying: “No organization was found for the user.”.

The server is running SQL 2008 R2 with accompanying SSRS.

Anyone any idea?

Erase CD the cool way

If Super Mario Bros. was a FPS

That are some nice offices!

Tech companies usually have the nicest offices. Have a look.

Complete post from

Move Offline files location in Windows 7

When you have offline files enabled but want to move the cache location to a 2nd hard disk with more space (or just a faster one), here’s how you do it:

Note: I would advise to create a restore point prior to doing the following.

  1. Create a folder for your offline file cache. Something like D:\Offline.
  2. From an elevated command prompt type the following: Takeown /r /f C:\Windows\CSC
  3. Open the Sync Center and go to Manage Offline Files.
  4. Click Disable Offline Files and restart the machine.
  5. From an elevated command prompt issue the following commands:
    rd /s C:\Windows\CSC
    mklink /J C:\Windows\CSC “D:\Offline” (or whatever you folder name is, but be sure to use the quotations if you have a space in the name)
  6. Reopen the Manage Offline Files window and Enable Offline Files.
  7. Restart the machine

All files/folders that are made available offline should now be redirected to whichever folder you specified.

Project Rescue PS3: Success!

After weeks and weeks of searching for a solution for my broken PS3, I finally fixed it.

In my previous post, I let know that I ordered a $11 part to replace the positioning motor in the blue-ray drive. That part finally arrived and after installing it, I had good hopes. Putting everything back together, reconnecting the PS3 to my TV and turning it on. The dashboard showed up, so I didn’t make it worse. I inserted a disc and then, my PS3 ate my disc and wouldn’t give it back!

Opening up the PlayStation again, I removed the disc from the drive only to notice that some of the mechanical parts in the drive itself were broken too. I don’t know if this was due to my attempts or due to the broken motor before, but the result was the same.
I ordered another drive (cost $56 excl transport), this time a complete blue ray drive, which arrived a few weeks later.

Reassembling the PS3 with the new, drive, still nothing. WTF!
I let it rest for a few weeks, but the problem still lingered in my brain.
Read the rest of "Project Rescue PS3: Success!" »

Giving new life to my Sennheiser PC 35 USB headset

Having a Voip-conference later in the day, I searched through my older hardware I still had lying around and dug up my Sennheiser headset.
It didn’t came with any drivers, so just plugging it into the USB port should be enough.
No such luck :S
I got a Windows driver error: This device cannot start. (Code 10). After a bit of googling it appeared that the device was not compatible with Windows Vista and Windows 7.

Not giving up, I finally found a firmware upgrade for the PC35 USB headset itself. Although there is no information about it, the update is only compatible with 32bit versions of Windows.
Firing up my trusty Acer One, I upgraded the Sennheiser, plugged it back into my Windows 7 64bit and now it works like a charm.

Project Rescue PS3

My trusty PS3 became not so trusty anymore.
When I was playing a game, the game just hung. First I thought it was the game or the operating system that faulted. However after rebooting my PS3 no longer wanted to read any disks, not games, not blueray movies, not plain old DVDs.

Since I like my PS3 and I only upgraded the harddisk from a 40GB to a 500GB, I wasn’t ready to give up on it.

First trying the non evasive ways of fixing it. Cold booting, going into the diagostics,… nothing helped.

Time to open it up.

I followed a few “guidelines” online for cleaning the drive and the lens. Reassembling it again… nothing.

Digging a little further, I moved the laser assembly manually and I turned the PS3 on while it was all open. In a normal drive the laser will position itself to the start position, reflect some light to see if a disk is present and then spin up the motor. But after turning the PS3 on, nothing happened.

So my current conclusion, the laser assembly positioning motor is broken. I’ve ordered a new one for € 11 (delivery included). It should be here in a few days. Let’s see how that goes.

To be continued…

Great geek articles

Some great articles for your inner geek.

The secret origin of Windows.

Future of Windows.

Fifteen classic game console designs that failed.

132 years of videophone history.