Wednesday, July 30, 2008

SQL Server 2005 SP2 for Window Vista

In order for SQL Server 2005 to run in Window Vista environment, you need to apply SQL Server 2005 Service Pack 2.

You may find the download page

Overview

Service Pack 2 for Microsoft SQL Server 2005 is now available. SQL Server 2005 service packs are cumulative, and this service pack upgrades all service levels of SQL Server 2005 to SP2. You can use these packages to upgrade any of the following SQL Server 2005 editions:

  • Enterprise
  • Enterprise Evaluation
  • Developer
  • Standard
  • Workgroup

Monday, July 28, 2008

SSAS service couldnt be started after applying SQL Server 2005 SP 2


You may find errors when trying to start the Analysis Services service after you have applying SQL Server 2005 Service Pack 2 under Window Vista environment. Usually you will come across it when trying to run the User Provisioning Tool right after the SP2 installation as it requires the services to be started.


To solve the problem,

1.) Go to Control Panel->Regional and Language.

2.) Click on Administrative tab

3.) Change System Locale to English (United States)

4.) Click on Copy to Reserved Accounts, and apply it to appropriate accounts.

5.) Restart your Window and try to start the SSAS service again.

It should work fine now.

Cheers

Friday, July 25, 2008

Repository Factory for VS 2008

This has been awhile and Thanks Daniel for pointing it out!! Guys, whoever wanting this for a long time, please visit the link below and leave a comment.

Thanks a lot to Ratnakar.

http://ratnakarg.wordpress.com/2008/04/07/repository-factory-for-vs-2008/#comment-52

You may also leave a comment here and I can email it to you.

Cheers