Welcome to MSDN Blogs Sign in | Join | Help

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.)

 

   9780735626201f

Share this post :
Published Wednesday, March 25, 2009 8:56 AM by devonm

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS

Comments

# SQL 2008 Analysis Services Step-by-Step RTM « Consulting in Austin

Wednesday, March 25, 2009 5:20 PM by SQL 2008 Analysis Services Step-by-Step RTM « Consulting in Austin

PingBack from http://consultinginaustin.wordpress.com/2009/03/25/sql-2008-analysis-services-step-by-step-rtm/

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

Sunday, May 24, 2009 11:31 PM by Chu

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

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

Tuesday, June 09, 2009 2:07 PM by wcound

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.

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

Tuesday, June 09, 2009 2:29 PM by devonm

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!

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

Wednesday, June 17, 2009 3:13 PM by jrh

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

USE [master]

GO

sp_attach_single_file_db N'SSAS2008SBS', N'C:\Microsoft Press\Analysis Services 2008 SBS\Setup\SSAS2008SBS.mdf'

GO

# Any solutions yet?

Tuesday, August 25, 2009 7:40 PM by John

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.

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

Tuesday, September 01, 2009 11:25 AM by Mathew

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.

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

Wednesday, October 21, 2009 8:10 AM by dimaggio

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.

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

Wednesday, October 21, 2009 3:27 PM by Roberto

The Database is failing to connect!

Without a fix the the book is useless..

Leave a Comment

(required) 
required 
(required) 

  
Enter Code Here: Required
 
Page view tracker