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

  • Article

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