Deploying AdventureWorks Analysis Database ..

If you are working with SQL Server then you might already have used this great cycle selling company’s database (AdventureWorks) at least once. Microsoft has created this cycle selling company database for SQL Server 2005 and later versions, before this sample we had “NorthWind” database.

Anyways, if you try to install these sample databases you will find that it is not just one single database but rather a collection of different types of databases like OLTP, Data Warehouse and OLAP cube. And honestly, I have learned a lot by working on OLTP and DW samples. But default installation doesn’t install Analysis Database by default. You have to manually deploy it using a solution provided, you just need to follow this instructions provided by MSFT. Ideally it should work just OK if your SQL Server instance is running with Local System account (which is not recommended at all because it gives admin access to your system, but who cares … its bloody local system, right ?? Disappointed smile) … but in my case SQL Server is using Network Service account which gives it limited permission. So when you try to deploy the cube as instructed in MSFT help your deployment might fail with following errors.

The most eye-catching error was Login failed for database user NT Authority \ Network Service for database AdeventureWorksDW2008r2. And perhaps the main reason (at least in my case) of failed deployment. My interpretation of this error was, this guy can’t access AdeventureWorksDW2008r2 database, which is probably because there is no database user associated with this login NT Authority \ Network Service. So simple solution will be associate a user with login NT Authority \ Network Service for database AdeventureWorksDW2008r2 or create new user for that database.

deployFail2

(ok, screenshot it is for AdventureWorks database but process is same for AdventurWorksDW2008r2 database too. I am feeling lazy to take another shot and write instructions again Smile)

And now try to deploy the cube (OLAP database) again and this time it should succeed without any troubles Smile

That’s it for now…

It’s Just A ThoughtFingers crossed

Gaurang Sign

Leave a Reply

Your email address will not be published. Required fields are marked *