SQL Server 2008 R2

You are currently browsing articles tagged SQL Server 2008 R2.

Owkay, I’ve got a good one for you this time.

And all it takes is checking a checkbox, just one checkbox!

That’s the solution to a problem with which I’ve been struggling yesterday.  What problem?  Let me tell you.

I’ve been installing Master Data Services (MDS) on my SQL Server 2008 R2.  This feature will not only create a database but also a website which you can use to manage MDS.  And it’s the website part that I had a problem with.  Everything installed just fine but when I tried to load the site in Internet Explorer 8 on my Windows 7 64-bit machine, I got the following error:

HTTP Error 401.2 – Unauthorized

You are not authorized to view this page due to invalid authentication headers.

Great, an authentication problem – aren’t those our favorite ones?  And like any decent developer, I didn’t waste my time reading all the text on the error page and started investigating the issue.  I had a look at the settings of the Application Pool and those of the Default Web Site.  I also tried changing the security settings in IE.  At the end I think I have tried every possible setting in IIS 7.5 (which is the version that ships with Windows 7), but I kept getting that same error.

I let some time pass (not on purpose but because we were going to visit my parents-in-law) and in the evening I decided to have another look.  This time I took the effort of reading everything mentioned in the error:

HTTP Error 401.2 - Unauthorized

Do you see that blue link down at the bottom, which I’ve marked with a red rectangle?  That’s where I got the answer from!  Clicking it opened up the following Microsoft Support page: Error message when you try to visit a Web page that is hosted on IIS 7.0: "HTTP Error 401.2 – Unauthorized".

Sounds familiar doesn’t it?  Okay, it’s meant for IIS 7.0 but works for 7.5 as well.

I solved my problem by applying Resolution 1.  In short: IIS was running without the Windows Authentication module installed!  Apparently that is not installed by default when you activate Internet Information Services through the “Turn Windows features on or off” window.  Here’s a screenshot showing what needs to be added:

Activating Windows Authentication for IIS 7.5 in Windows 7

Once that was set up I was able to load the MDS application:

Master Data Services Home Page

If you’re looking for instructions on how to install and configure Master Data Services, have a look at this article at the Master Data Services Team blog.

(Do I need to mention that this was the first-ever web application that I tried running on Windows 7? :-) )

Have fun!

Valentino.

Share

Tags: , , , , ,

For those who haven’t heard about SQL Server 2008 R2 yet, have a look at its home page: http://www.microsoft.com/sqlserver/2008/en/us/r2.aspx

Download the August CTP to give it a go!

After having had a look at the available documentation in the Books Online, which at this moment is pre-release obviously (R2 is planned for the first half of 2010), following is a list of new stuff that caught my interest.  Well, besides the major new components such as Project Gemini or the Self Service Business Intelligence capabilities.  These are not yet included in this release anyway, you’ll have to wait for the Fall 2009 CTP for that.

Reporting Services

Maps

That’s right, maps!  Isn’t that cool?  Now we’ll finally have a way to visualize our two new spatial data types which we have available since SQL Server 2008 (geometry and geography).

These maps will be available in Report Builder 3.0 as well as in SSRS projects in BIDS.  If you want, you can try out Report Builder 3.0 without downloading SQL Server, it’s a separate download in the page mentioned earlier.

This is what the new report template looks like when first opening the new Report Builder:

New report in Report Builder 3.0 shows the Map icon

Indeed, it now shows a third object icon called Map.  Dan English wrote a detailed blog post about the Report Builder 3.0 installation procedure, in case you want to see the wizard before actually running it yourself.

Furthermore, in this tutorial Robert Bruckner shows you how to use the map visualization functionality using Report Builder 3.0.

Lookup functions

Finally, here’s the answer to the "Want to link datasets? Please vote!” article.  Well, not exactly but at least it’s a first step.

The following 3 new functions will be available for us to use in expressions in our reports:

These lookup functions will allow us to fetch data from dataset2 and display it within a data region that’s bound to dataset1.  Of course it’s not as convenient as when it would be possible to join two datasets together but it does overcome the limitation of not being able to display data from more than one dataset in the same data region.  Definitely looking forward to trying it out!  Here’s a blog post by Teo Lachev where he shows how it works.

Report Manager Enhancements

Look and feel plus user experience have gotten an upgrade here, such as "Eliminating the need to render a report before accessing and configuring report properties when in default view.".  Well, that saves us the click to switch to Detail View, as we’re used to doing.  Teo Lachev has posted some screenshots of the new Report Manager, which as you’ll notice has become more “SharePointy”.

Analysis Services

Windows XP Not Supported

According to the release notes it’s not fully operational on XP.  I do hope that this gets fixed by RTM?  More info in the Release Notes.

Database Engine

The relational database engine didn’t get any major functionality changes but I still noticed the following.

CPUs

The number of CPU cores that a server can use for database operations has been increased from 64 to 512.  Well, I sure would like to try that feature out!  If you’re reading this and have got a spare computer with, let’s say 128 CPUs please do contact me and I’ll give you the shipping details :-)

Unicode Compression

Unicode data that is stored in nvarchar(n) and nchar(n) columns is compressed by using an implementation of the Standard Compression Scheme for Unicode (SCSU) algorithm.  Could be interesting.  I’m always in favor of saving space if it doesn’t cost in performance.  But there is a limitation: Data values that are stored off row or in nvarchar(max) columns are not compressed.
More details: http://msdn.microsoft.com/en-us/library/ee240835(SQL.105).aspx

Now if you’ll excuse me, I have some downloading to do! :-)

Share

Tags: , , ,

Newer entries »

© 2008-2014 BI: Beer Intelligence? All Rights Reserved