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

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

SQL 2008 Analysis Services Step-by-Step RTM « Consulting in Austin — Thu, 26 Mar 2009 00:20:27 GMT

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

Chu — Mon, 25 May 2009 06:31:34 GMT

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

wcound — Tue, 09 Jun 2009 21:07:23 GMT

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

devonm — Tue, 09 Jun 2009 21:29:50 GMT

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

jrh — Wed, 17 Jun 2009 22:13:20 GMT

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 Press\Analysis Services 2008 SBS\Setup\SSAS2008SBS.mdf'

Any solutions yet?

John — Wed, 26 Aug 2009 02:40:21 GMT

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

Mathew — Tue, 01 Sep 2009 18:25:30 GMT

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

dimaggio — Wed, 21 Oct 2009 15:10:32 GMT

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:

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

Roberto — Wed, 21 Oct 2009 22:27:35 GMT

The Database is failing to connect!

Without a fix the the book is useless..

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

Wendy — Sat, 12 Dec 2009 20:11:45 GMT

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!!!!!

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

Mike — Mon, 14 Dec 2009 15:24:26 GMT

Guys,

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.

Best regards

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

DennisP — Sun, 20 Dec 2009 08:53:01 GMT

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

USE [master]

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

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';

USE [master]

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+']')

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.

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

Wendy — Thu, 24 Dec 2009 20:30:24 GMT

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.