I have an SSAS project set up that processes a small cube. The project was originally written in VS 2005 running against a SQL Server 2005 database. I have since upgraded to VS 2008 Professional and SQL Server 2008 Developer Edition. Now, I cannot get the cube to process. It keeps choking on the data source connection credentials. The error I get is:
OLE DB error: OLE DB or ODBC error: Cannot generate SSPI context; HY000; SQL Server Network Interfaces: The target principal name is incorrect.
The thing is, I'm using MY account specific credentials on the connection's impersonation pane. If I go into the connection itself and test it, it works fine. It's only when I try to deploy and process to the server that I get these issues.
I'm uncertain how to proceed. Do I need a service pack? Am I missing something simple?