"Warning The security database on the server does not have a computer account for this workstation trust relationship."

Last November I wrote a post about an error when trying to connect ProClarity Professional to SSAS servers. "Warning The security database on the server does not have a computer account for this workstation trust relationship."

Well, on my Windows 7 RC and RTM machines, I was getting the same error when trying to connect to some pretty clean installations of SSAS 2005 and 2008.

I checked to make sure that SSAS allowed remote settings, that both the client and the server were on the same ___domain, and that my account had security access to the cube. I also checked to make sure that this wasn’t the known AES aware issue.

Finally, I checked the SPNs on the SSAS boxes – there were no entries for MSOLAPSvc.3. However, I was doubtful it would help to add them – I hadn’t needed to do so in the past. I added the SPNs to both machines, JP-Data and JP-Data2 as follows:

MSOLAPSvc.3/jp-data.northamerica.corp.microsoft.com

MSOLAPSvc.3/jp-data

And,

MSOLAPSvc.3/jp-data2.northamerica.corp.microsoft.com

MSOLAPSvc.3/jp-data2

After restarting my SSAS services and rebooting my client box, everything works!

-Joey