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.)
PingBack from http://consultinginaustin.wordpress.com/2009/03/25/sql-2008-analysis-services-step-by-step-rtm/
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
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 .
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.
Hello. I've sent both of these comments to our Support team at email@example.com. I'll post as soon as I hear that we have a solution. Thanks for letting us know!
I was able to run this command, and the ldf file was created.
sp_attach_single_file_db N'SSAS2008SBS', N'C:\Microsoft Press\Analysis Services 2008 SBS\Setup\SSAS2008SBS.mdf'
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.
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.
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.
The Database is failing to connect!
Without a fix the the book is useless..
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!!!!!
You probably need to create write permission to "C:\Microsoft Press\Analysis Services 2008 SBS" folder and subfolders. It worked for me and log file was created with no problem.
had same named pipes problem:
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 AUTHORITY\SYSTEM
2.) check in folder to see .ldf file exists in :
C:\Microsoft Press\Analysis Services 2008 SBS\Setup
3.) if it does not, open a new query window and run commands below posted previously by JRH
ldf should now be created
4.) Now open up a new sql query window and run the commands in C:\Microsoft Press\Analysis Services 2008 SBS\Setup\SSAS_Login.sql
DECLARE @user nvarchar(100);
SET @user ='NT AUTHORITY\SYSTEM';
IF NOT EXISTS (SELECT * FROM sys.server_principals WHERE name = @user)
EXEC ('CREATE LOGIN ['+ @user+'] FROM WINDOWS WITH DEFAULT_DATABASE=[master]')
EXEC ('GRANT ALTER TRACE TO [' +@user+']')
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.
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.
OK, this is what I did and worked:
1) Move the SSAS2008SBS database from
C:\Microsoft Press\Analysis Services 2008 SBS\Setup
C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA
(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:
sp_attach_single_file_db N'SSAS2008SBS', N'C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA\SSAS2008SBS.mdf'
And that´s it!
Now you can continue using the book.
But it´s true, a Microsoft book shouldn´t have this error.
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 'mydomain\SQL2008SBS'.;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.