We're having an issue getting a connection from end users running Office 2007 Excel and the Data Mining add-ins to SQL Server 2008 Database engine and Analysis Svcs.
I had this working awhile back, and the server crashed, so I had to reconfig everything. I'm missing something somewhere that it won't work this time around.
The end user is getting this error when he is in Excel working off the data mining tab:
"Unable to query schema rowset on 'Tables.' Errors in the high-level relational engine. A connection could not be made to the data source with the DataSourceID of 'Data Warehouse Version0', Name of 'Data Warehouse Version0'. The following system error occured: Logon failure: unknown user name or bad password. The editor will switch to edit query mode."
So the user has already built a connection to this database already in the mining tools using the button on the ribbon. If you hit 'test connection' it comes back succeeded. But if he clicks anything like cluster, classify, query, etc. in the data mining tools...he can't actually DO anything. The error stated above pops up. Before, he'd click 'cluster' for instance, then choose the 'external data source' option, and then he'd see a listing of all the tables/views available for his use and he'd pick what he wanted. Instead now he gets the error and the area comes up blank, so he can't get anywhere.
I added him as a user on the database in the SQL server Database engine, and gave him datareader/datawriter. Also in Analysis Svcs, I created a role, added him to it, and made sure he's got db creator rights, and then I gave read or read/write rights where available for the db to him.
What might I have missed? Thanks!!