RTM’d today: Microsoft SQL Server 2008 Analysis Services Step by Step

Ken mentioned this book yesterday when he was posting about Microsoft SQL Server 2008 Reporting Services Step by Step, and indeed today the final files for Microsoft SQL Server 2008 Analysis Services Step by Step, by Scott Cameron (Microsoft Press, 2009; ISBN: 9780735626201), were shipped to the printer.  Here’s some info about the book.

We’ll post excerpts later; we just wanted to let you know that it’s out the door! (You can pre-order the book here.)



Share this post :

Comments (30)

  1. Chu says:

    I got this book and I noticed that the setup did not install correctly because the DVD contains the MDF and no LDF for the database SSAS2008SBS so DB does not install

  2. wcound says:

    I have also run into this issue. I get the following error.

    HResult 0x2, Level 16, State 1

    Named Pipes Provider: Could not open a connection to SQL Server [2].

    Sqlcmd: Error: Microsoft SQL Server Native Client 10.0 : A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online..

    Sqlcmd: Error: Microsoft SQL Server Native Client 10.0 : Login timeout expired.

    Has there been a correction posted? If so where?

    I am unable to work through the examples so it is a little frustrating.

  3. Hello.  I’ve sent both of these comments to our Support team at mspinput@microsoft.com.  I’ll post as soon as I hear that we have a solution.  Thanks for letting us know!

  4. jrh says:

    I was able to run this command, and the ldf file was created.

    USE [master]


    sp_attach_single_file_db N’SSAS2008SBS’, N’C:Microsoft PressAnalysis Services 2008 SBSSetupSSAS2008SBS.mdf’


  5. John says:

    I’m having the same named pipe problem described above, and can’t find an authoritative description of the problem anywhere.  The only troubleshooting I can find suggests I should be using tools that aren’t actually listed in the configuration tools folder (mostly Surface Area Configuration).

    Having something visible as a fix would be very helpful.

  6. Mathew says:

    Tried to install the sample database, following the instructions in the book. However, when I test the connection it says it cannot open the database. There were no errors when I ran the script.

    Without being able to install the samples the book is of no use at this time.

  7. dimaggio says:

    I have the same issue.

    I’m trying to create a data source in a new Analysis services project and when I’m trying to insert SSAS2008SBS as database name, the Test Connect shows the message:

    <TITLE: Connection Manager Test connection failed because of an error in initializing provider. Login failed for user. Cannot open database "SSAS2008SBS" requested by the login. The login failed.>

    Moreover during the SQL Server configuration, in the Setup folder on the log file is displayed the message:

    <Database ‘SSAS2008SBS’ does not exist. Make sure that the name is entered correctly.>

    Please may someone help me? On this way I’m not able to use the sample!

    Thank you in advance.

  8. Roberto says:

    The Database is failing to connect!

    Without a fix the the book is useless..

  9. Wendy says:

    Isn’t it about time a fix was posted for this problem, as I see the last query was in October – we’ve been waiting ages for this, so come on guys, get your finger out!!!!!

  10. Mike says:


    You probably need to create write permission to "C:Microsoft PressAnalysis Services 2008 SBS" folder and subfolders. It worked for me and log file was created with no problem.

    Best regards

  11. DennisP says:

    had same named pipes problem:

    do this.

    1.) Open MSSQLSERVER Management Studio

    1.5) UNDER security –> logins make sure the account running your sql server has create db enabled. in my case it was NT AUTHORITYSYSTEM

    2.) check in folder to see .ldf file exists in :

    C:Microsoft PressAnalysis Services 2008 SBSSetup

    3.) if it does not, open a new query window and run commands below posted previously by JRH

    USE [master]


    sp_attach_single_file_db N’SSAS2008SBS’, N’C:Microsoft PressAnalysis Services 2008 SBSSetupSSAS2008SBS.mdf’


    ldf should now be created

    4.) Now open up a new sql query window and run the commands in C:Microsoft PressAnalysis Services 2008 SBSSetupSSAS_Login.sql

    DECLARE @user nvarchar(100);


    USE [master]

    IF NOT EXISTS (SELECT * FROM sys.server_principals WHERE name = @user)


    EXEC (‘GRANT ALTER TRACE TO [‘ +@user+’]’)

    USE [SSAS2008SBS]

    EXEC sp_addrolemember ‘db_owner’, @user


    5.) reconnect to your sql server instance and you should see the database: SSAS2008SBS

    I come from a sybase/db2 background but we use msas for aggregations and i am trying to get up to speed. I feel for the people who have trouble installing MSSQL2008 express and developer trial editions and the samples from this book.  I think i hit every type of bug during my installs.  To make a long story short, i am now doing 2 tutorials on MSAS and i now know WAY MORE about sql server installation/configuration than i ever wanted to. Now that everything is working, i don’t dare touch a damn thing. Another tip, when sql server configuration manager starts to crap out, Just use windows services to change logon accounts etc. Disable VIA protocol unless you using VIA.  Ensure your firewall port exceptions are entered for TCP/IP : mssqlserver = 1433 , browser = 1434, i even added program exceptions sqlsrvr.exe and browser.  ensure your sqlserver has remote connections enabled.

  12. Wendy says:

    I have tried every solution seen here so far and I still cannot attach the sample database. I have always believed that the Step by Step authors (experts?) were among the best in this industry, but they have certainly not come up to scratch in this case, as they have not even bothered to respond to any of the posts. Shame on you …. my book will be going to the charity shop, unread past Chapter 3.

  13. Stuart Rochabrunt says:

    OK, this is what I did and worked:

    1) Move the SSAS2008SBS database from

    C:Microsoft PressAnalysis Services 2008 SBSSetup


    C:Program FilesMicrosoft SQL ServerMSSQL10.MSSQLSERVERMSSQLDATA

    (In case you have the same folders structure, of course, but you will be able to change them properly if youy don´t)

    2) Execute this query:

    USE [master]


    sp_attach_single_file_db N’SSAS2008SBS’, N’C:Program FilesMicrosoft SQL ServerMSSQL10.MSSQLSERVERMSSQLDATASSAS2008SBS.mdf’


    And that´s it!

    Now you can continue using the book.

    But it´s true, a Microsoft book shouldn´t have this error.

  14. Eric Lawson says:

    I have applied the fix described above to attach the database. However, I now get errors from the exercise on Page 66 (Deploy and browse a dimension).

    The Deploy process fails. The main error message in the Error List view is "OLE DB error: OLE DB or ODBC error: Login failed for user ‘mydomainSQL2008SBS’.;28000′

    I have tried this twice on two separate machines with independently installed copies of SQL Server 2008 Developer Edition, running on Windows XP Service Pack 3.

    All steps in the book work up to this point, including table browses etc.

    I even took the step on the second instance of first backing up the SSAS2008SBS database in case there were any knock on effects from the fix of the missing LDF.

    I continued on by skipping thru to page 69 to do the work on creating the hierachies (as a warning precedes the login error related to creating hierachies in non-parent child dimensions.

    Unfortuntely the same login error occurs.

    This book does not appear to have any MSDN corrections against it.

    Please provide some guidance.

    So far out of 8 hours effort I have had about 1 hour of productive learning. The rest has been trying to resolve these 2 (so far) problems.


  15. Eric Lawson says:

    PS. I should add the domain and username are correct. The username derives from the process to configure SQL Server 2008 from the step by step book of the same name and the domain name is set to my machine name as derived from my system.

  16. MDS says:

    All I did was copy the mdf to the same place as the other mdf's, right clicked on Databases, chose "Attach…", chose the SA… mdf, deleted the ldf automatically created and it worked. SQL Server will create the ldf if you tell it the ldf doesn't exist by forcing it to select one. The trouble with auto populating…

  17. Alinne says:

    I have a major problem: i cannot attach the database. Is it because we are using SQL 2008 R2 and not SQL 2008? I get this error message:

    "exec master..sp_attach_db 'SSAS2008SBS', [C:Microsoft PressAnalysis Services 2008 SBSSetupSSAS2008SBS.mdf]

    Msg 948, Level 20, State 1, Server DVRODESK0004, Line 1

    The database 'SSAS2008SBS' cannot be opened because it is version 655. This server supports version 612 and earlier. A downgrade path is not supported.

    Msg 1813, Level 16, State 2, Server DVRODESK0004, Line 1

    Could not open new database 'SSAS2008SBS'. CREATE DATABASE is aborted.


    Please, help.

  18. laxmikanth.v says:

    hi anyone know. where do i download SSAS2008SBS database file? free. please let me know

  19. Dan says:

    I have the same question as Alinne. Does the SSAS2008SBS.mdf file work with R2?

  20. brandy says:

    I found the SSAS2008SBS.mdf file in C:Microsoft PressAnalysis Services 2008 SBSSetup, where the CD sample files were installed on my computer.

  21. ssu says:

    I bought that book but CD turned out to be damaged.Is it possible to download the CD from any site ?

    I was unable to find it so far, neither on MSDN pages nor on any other sites.

  22. Sp says:

    Same problem.  Go to deploy and "error"

  23. Marek says:

    I've attached this MDF file but only on SQL SERVER 2008 R2.

  24. HiralP says:

    I am getting Error message while attach database

    The database 'SSAS2008SBS' cannot be opened because it is version 655. This server supports version 654 and earlier. A downgrade path is not supported.

    I am stuck and without resolving this, Can not go ahead.


  25. GL says:

    Using SQLServer 2008 R2

    Moved the mdf file to C:Program FilesMicrosoft SQL ServerMSSQL10_50.MSSQLSERVERMSSQLDATA

    and ran

    USE [master]


    sp_attach_single_file_db N'SSAS2008SBS', N'C:Program FilesMicrosoft SQL ServerMSSQL10_50.MSSQLSERVERMSSQLDATASSAS2008SBS.mdf'


    Installed correctly.

  26. Sam says:

    Microsoft products are ok (compared to Oracle/Essbase) but word of advice, stay way away from their books. I've brought two and they are just rubbish. The samples either dont work or of little use. Looking at this page, their customer service is just as bad. Ask anyone who has made the mistake of buying their books and they'll tell you…

  27. Sam says:

    But thanks for your post GL, it worked for me, finally (I brought this book 18 months ago), wrote to Microsoft Press(where they advised me to for any questions related to this book) and nothing. Wouldn't have bothered to return had it not been for the fact I wanted to do KPI.

  28. Using Windows XP SP3 in VMWare, I have installed SSAS 2008 (Step by Step) using SQL Server 2008 R2, trying to get thru steps using Business Intelligence Development Studio. At one point, I could swear this worked because I managed to 'Explore Data' in chapter 3, but something changed – I have since rebooted, and I dont know what, but I cannot connect to SSAS2008SBS anymore.

    I restarted all the services and they are up and running. I noted named servers in the exception list of the windows firewall as well. Never changed/added any Windows usernames.

    In chapter 4, needing to Explore Data again, getting error:

    Microsoft SQL Server Native Client 10.0

    Login timeout expired….Named Pipes Provider: Could not open a connection to SQL Server [2].

    I tried rerunning the setup.cmd in the directory (where SSAS2008SBS and associated Logfile resides)

    in C:Program FilesMicrosoft SQL ServerMSSQL10_50.SQLSERVER2008R2MSSQLDATA

    This creates attach.txt error file with similar errors noted:

    HResult 0x2, Level 16, State 1

    Named Pipes Provider: Could not open a connection to SQL Server [2]. …

    command looks like this, but I tried several variations with same results.

    sqlcmd -E -o "%CD%attach.log" -Q "exec master..sp_attach_db 'SSAS2008SBS', [%CD%SSAS2008SBS.mdf]" -e

    I also tried

    sqlcmd -E -o "%CD%attach.log" -Q "exec master..sp_attach_single_file_db 'SSAS2008SBS', [%CD%SSAS2008SBS.mdf]" -e

    same results.

    Any ideas ?

  29. AdamE.Rice says:

    I have noticed a lot of people having a problem attaching the database and complaining aboout a missing .ldf file. After you discover the windows login user name(for me it was "Network Service"), you must grant that user name full access or permission to the Microsoft Press folder. After you do this and run the script the .ldf file will be created. The problem is that without permission to the folder SSAS can not connect to SQL, attach the database then create the .ldf file.