Results 1 to 5 of 5
  1. #1
    Join Date
    Feb 2012
    Posts
    108
    Provided Answers: 1

    Answered: SSAS Tabular Attach AW_DW Using MDF

    Hi all,

    I am trying to attach AdventureWorksDW2012_Data.mdf to a Tabular Instance.
    I was able to attach AdventureWorks2012_Data.mdf to the database engine in a separate instance.

    I downloaded all files from CodePlex and put them in C:\AW_2012\
    I right-clicked on SSMS and ran as administrator.

    I'm following this tutorial from Sherry Li.

    Code:
    Code:
    CREATE DATABASE AdventureWorksDW2012
    ON (FILENAME = N’C:\AW_2012\AdventureWorksDW2012_Data.mdf’)
    FOR ATTACH_REBUILD_LOG;
    Messages:
    Executing the query ...
    Query (1, 17) The syntax for 'AdventureWorksDW2012' is incorrect.
    Execution complete
    I searched Google on the message, but did not find anything. Any other ideas I can try?

  2. Best Answer
    Posted by goss

    "Thanks Pat,

    Now I got it. I was trying to attach the .mdf file to the instance of SSAS Tabular instead of the database instance to be used as the source for the Data Model.
    Once I realized that and changed Analysis Services Instance login account from the NT Service\MSSQLServerOLAPService to my user account, I was able to deploy the project which created the Tabular Database.

    Thanks
    w"


  3. #2
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    You need to connect to the SQL Server instead of to SSAS in order to execute that command.

    -PatP
    In theory, theory and practice are identical. In practice, theory and practice are unrelated.

  4. #3
    Join Date
    Feb 2012
    Posts
    108
    Provided Answers: 1
    Thanks Pat,

    I added SSAS Tabular Mode to the default instance
    I right clicked and ran SSMS as Admin.

    I tried running the Script again and received this error:
    Msg 102, Level 15, State 1, Line 2
    Incorrect syntax near '’'.
    I then right-clicked on Databases under Analysis Server >> Clicked attach >>and selected the MSAS11.MSSQLSERVER\OLAP\Data folder
    I previously copied the AdventureWorksDW2012_Data.mdf into the Data folder.

    I received this error:

    The specified database folder 'C:\Program Files\Microsoft SQL Server\MSAS11.MSSQLSERVER\OLAP\Data' is not valid. It does not match the Analysis Services naming convention of 'ID.version.db'.
    (Microsoft.AnalysisServices)
    Any other ideas?

    thx
    w

  5. #4
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    Those error messages indicate that you tried to run a SQL Server command to restore an Adventure Works database using Analysis Services. This is like speaking Japanese to a German speaker.

    You need to run the same command against the SQL Server. It ought to understand and respond appropriately.

    -PatP

  6. #5
    Join Date
    Feb 2012
    Posts
    108
    Provided Answers: 1
    Thanks Pat,

    Now I got it. I was trying to attach the .mdf file to the instance of SSAS Tabular instead of the database instance to be used as the source for the Data Model.
    Once I realized that and changed Analysis Services Instance login account from the NT Service\MSSQLServerOLAPService to my user account, I was able to deploy the project which created the Tabular Database.

    Thanks
    w

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •