Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read
Book: Professional Microsoft SQL Server Analysis Services 2008 with MDX: 978-0-470-24798-3
This is the forum to discuss the Wrox book Professional Microsoft SQL Server Analysis Services 2008 with MDX by Sivakumar Harinath, Robert Zare, Sethu Meenakshisundaram, Matt Carroll, Denny Guang-Yeu Lee; ISBN: 9780470247983
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Book: Professional Microsoft SQL Server Analysis Services 2008 with MDX: 978-0-470-24798-3 section of the Wrox Programmer to Programmer discussions. This is a community of tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developersí questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
Reply
 
Thread Tools Display Modes
  #1 (permalink)  
Old May 30th, 2009, 08:33 PM
Registered User
 
Join Date: May 2009
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default problem deploying

at first was getting invalid loggin attempt, but changed from native client 10 to just native
but now i am getting the following error, have tried removing the tbale but recvd same error but for different table
so i think i am having connection problems to the db
i can view the tables and see the contents so not sure what i have wrong.
i know sql but not microsoft sql at all
any help would be much appreciated.
Error 16 OLE DB error: OLE DB or ODBC error: Invalid object name 'dbo.DimCurrency'.; 42S02. 0 0
Reply With Quote
  #2 (permalink)  
Old June 23rd, 2009, 02:21 PM
Authorized User
 
Join Date: Jul 2006
Location: Redmond, WA, USA.
Posts: 10
Thanks: 0
Thanked 0 Times in 0 Posts
Default problem deploying

You as a user might have permissions to the backend relational database. When you are deploying then Analysis Services uses the credentials specified in Data Source which by default is the service startup account of Analysis Services which might not have permissions to the relational database. Hence you are seeing this error. Can you please check change the datasource to use your credentials or make sure the service startup account of Analysis Services has permissions?

If this is not a permission issue can you please provide the configuration you are using for relational and analysis services?

-Sivakumar
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
Problem with default.aspx after deploying to SQL05 JoyVoltenburg BOOK: ASP.NET 2.0 Website Programming Problem Design Solution ISBN: 978-0-7645-8464-0 4 February 6th, 2008 01:29 PM
problem deploying to work/standalone/localhost leonbrits Apache Tomcat 0 August 26th, 2005 07:22 AM
Problem Deploying EJBs to Weblogic Server mmalik_altaf J2EE 6 June 27th, 2005 09:14 PM
Help me :Problem deploying Webapplication lavanyarl VS.NET 2002/2003 2 November 9th, 2004 04:00 AM
problem with deploying and accessing web Service clansullivan .NET Web Services 1 September 11th, 2003 09:43 AM



All times are GMT -4. The time now is 04:16 AM.


Powered by vBulletin® Version 3.7.0
Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.