I have just installed Evaluation version of SQL Server 2005. Created a new database with two tables. Created new project with data source pointing to localhost and build a data source view containning tables from database created earlier. After creating the cube, I get following error while deploying the Cube:
OLE DB error: OLE DB or ODBC error: An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections.; 08001; Client unable to establish connection; 08001; Encryption not supported on the client.; 08001.
Any help!
Regards.
Are you deploying locally or remotely?
Is the user you are trying to deploy as set up in the SQLSERVER2005MSOLAPUser group on the AS server?
|||
It is local and user is member of group you mentioned.
My problem was due to the wrong impersonation information in data source. I have corrected it and now everything is fine.
Thnks.
No comments:
Post a Comment