|
|
|
Grasshopper
 
Group: General Forum Members
Last Login: Monday, November 21, 2011 10:31 PM
Points: 20,
Visits: 363
|
|
I am taking care of a data warehouse and process couples of cubes everyday. A new user report she can't manupulate data in an excel pivot table which connects to one of the cubes.
I had already add this user as a standalone user in the Role group on the SSMS but she still can't get anything.
The error message is like this:
"Initialization of the data source failed.
Check the database server or contact your database administrator. Make sure the external database is available, and then try the operation again. If you see this message again, create a new data source to connect to the database."
I don't have any problem to open this excel pivot table and neither do other users.
This pivot table was created by another user and email this pivot table to this end user.
Sorry for my English.
Thank you in advance
Qiang
|
|
|
|
|
SSC Veteran
Group: General Forum Members
Last Login: Monday, October 25, 2010 10:10 AM
Points: 297,
Visits: 267
|
|
Perhaps this user is in a different network location that is preventing the access?
Cheers,
Ben Sullins
bensullins.com
Beer is my primary key...
|
|
|
|
|
SSC Veteran
Group: General Forum Members
Last Login: Thursday, January 06, 2011 6:44 AM
Points: 206,
Visits: 363
|
|
| Try adding the user to the Analysis Server Properties Security page...
|
|
|
|
|
Grasshopper
Group: General Forum Members
Last Login: Monday, November 21, 2011 10:31 PM
Points: 20,
Visits: 363
|
|
Mark Beringer (5/21/2008)
Try adding the user to the Analysis Server Properties Security page....
I check the Analysis Server Properties Security page but nobody is in there, even though they all have access to this pivot table.
|
|
|
|
|
Old Hand
Group: General Forum Members
Last Login: Tuesday, January 24, 2012 3:34 AM
Points: 399,
Visits: 372
|
|
| Also check the data connection credentials and make sure that connector is providing good enough credentials;)
|
|
|
|
|
Grasshopper
Group: General Forum Members
Last Login: Monday, November 21, 2011 10:31 PM
Points: 20,
Visits: 363
|
|
Finally solved this problem by installing these two components:
1. Microsoft Core XML Services (MSXML) 6.0
http://www.microsoft.com/downloads/info.aspx?na=46&p=1&SrcDisplayLang=en&SrcCategoryId=&SrcFamilyId=993c0bcf-3bcf-4009-be21-27e85e1857b1&u=http://download.microsoft.com/download/2/e/0/2e01308a-e17f-4bf9-bf48-161356cf9c81/msxml6.msi
2. Microsoft SQL Server 2005 Analysis Services 9.0 OLE DB Provider
http://www.microsoft.com/downloads/info.aspx?na=46&p=10&SrcDisplayLang=en&SrcCategoryId=&SrcFamilyId=d09c1d60-a13c-4479-9b91-9e8b9d835cdc&u=http://download.microsoft.com/download/4/4/d/44dbde61-b385-4fc2-a67d-48053b8f9fad/SQLServer2005_ASOLEDB9.msi
|
|
|
|
|
Old Hand
Group: General Forum Members
Last Login: Wednesday, August 03, 2011 1:06 AM
Points: 304,
Visits: 169
|
|
Hi
On which server did u install this ?
On the SQL server or the client/citrix side ?
Many thanx
Jeffrey
JV
|
|
|
|
|
Grasshopper
Group: General Forum Members
Last Login: Monday, November 21, 2011 10:31 PM
Points: 20,
Visits: 363
|
|
| I installed it on the end user's box.
|
|
|
|
|
Forum Newbie
Group: General Forum Members
Last Login: Tuesday, April 12, 2011 12:50 AM
Points: 3,
Visits: 43
|
|
I installed both these dlls. Still I'm getting the same error.
Do i need to register these??
|
|
|
|
|
Grasshopper
Group: General Forum Members
Last Login: Monday, November 21, 2011 10:31 PM
Points: 20,
Visits: 363
|
|
sujith (11/3/2008)
I installed both these dlls. Still I'm getting the same error.
Do i need to register these??
Does the user have OWC (Office Web Component) installed?
|
|
|
|
