Thursday, May 24, 2012

The target principal name is incorrect while trying to connect to Analysis Services server

A sql server had been setup for testing purposes but never been used with SSAS. The service was installed. Today when trying to connect to the AS server I received this error message:

The target principal name is incorrect.
The solution is to use th IP address of the server or the fully qualified domain name. e.g. instead of using ‘SERVER01’, use ‘SERVER01.somedomainname.com’
Thanks to Patrick Purviance who wrote about this problem in his blog:

No comments: