Sign in
 
HomeLibraryLearnDownloadsTroubleshootingCommunityForums
SQL Server Developer Center >
> 
> 
Cannot deploy AdventureWorks Analysis Services Project

Answered Cannot deploy AdventureWorks Analysis Services Project

  • Wednesday, February 16, 2011 1:55 PM
     
     
    Sign In to Vote
    0

    I've installed the AdventureWorks database and have been able to look at the reports in Visual Studio, I can open the AdventureWorks Analysis Services Project but when I attempt to deploy the Enterprise version I get:

    Error 62 - Errors related to feature availability and configuration: The 'Perspectives' feature is not included in the '64 Bit Standard Edition' SKU.

    I've tried following different help resources online and cannot find anything that works.

     

All Replies

  • Thursday, March 17, 2011 2:53 PM
     
     Answered
    Sign In to Vote
    2

    Hi,

    perspectives are only in Enterprise edition. Standard edition doesn't support all features. You need tu deploy project in standard folder.

     

    Jiri

    Jiri Neoral BIExperts s.r.o. www.biexperts.cz
     
  • Wednesday, April 06, 2011 2:21 PM
     
     
    Sign In to Vote
    0

    HI,
    I am a total newbie to SQL, i downloaded sql express with advanced services and followed instructions on

    http://msftdbprodsamples.codeplex.com/wikipage?title=Database%20Prerequisites%20for%20SQL%20Server%202008R2      and

    http://msftdbprodsamples.codeplex.com/wikipage?title=Installing%20Analysis%20Services%20Database

    page everything goes smoothly till i click on "deploy" on the "properties" Adventure Works DW 2008 then a "save" dialogue box appears and when i click "save" it prompts if i want to replace the file and when i give "yes" it says access denied......... i dont understand why, i am the administrator.............the connection test was successful and the deployment in the properties of the solution is the correct server name............Pls help i've been at it for the past 3 hrs.........

    Thnx in advance

     
  • Friday, November 25, 2011 9:17 AM
     
     Answered
    Sign In to Vote
    4

    For the newbies,

    In order to do what Jiri suggest you need to open the visual studio (bids) solution file (.sln) from C:\Program Files\Microsoft SQL Server\100\Tools\Samples\AdventureWorks 2008R2 Analysis Services Project\standard

    and reconfigure your data source (if you need so, even though the default should work) and deployment setting (right-click your solution project --> properties) [even though the deployment settings should be fine aswell]

    Then right click your solution project and click on "Deploy" this should now go smoothly.

    Seve