Problem Starting SQL Server Analysis Services.

For those who are facing problem in Starting SQL Server Analysis Services, please follow the following steps to fix the issue.

1. Open Control Panel
2. Go to Regional and Language Options Locale Settings
3. Change the Format, Location and Administrative from English(India) to English(United States)
4. Restart the System
5. Once your system is Restarted open the Registry Editor (from Start = > Run => regedit)
6. Navigate to HKEY_USERS
7. Look for LSA entry @ S-1-5-18
8. Search for LocaleName
9. Update the following keys
   1. Locale = 00000409
   2. LocaleName = en-US
   3. sCountry = United States

      10. Open the SQL Server Configuration Manager, and start the SQL Server Analysis Services.

FYI: This is caused because Windows Vista is supporting en-IN whereas SQL Server 2005 does not provide support for en-IN, so while doing the SQL Server Surface Area configuration, if you try to run SQL Server Analysis Services it will give the following exception (can be found in Event Viewer)

The service cannot be started: Message-handling subsystem: The message manager for the default locale cannot be found. The locale will be changed to US English. Errors in the metadata manager. LOG file extension can be only .LOG. Message-handling subsystem: The message manager for the default locale cannot be found. The locale will be changed to US English. Message-handling subsystem: The message manager for the 16393 locale cannot be found. Internal error: Failed to generate a hash string.

Read More

Troubleshooting Visual Studio 2005 and Visual Studio 2008 On Windows Vista

With the introduction of IIS 7.0 in windows vista number of people have been reporting problems when trying to debug their ASP.NET applications on Windows Vista with Visual Studio 2005 F5 debugging support.  There are a handful of posts about trying to get this to work in various ways.

I also faced similar issues. As there are already some good articles floating on net, so instead of reinventing the wheel, I am giving below the links to those articles here. This post I am publishing for my reference only, but if you found this article then I hope this will provide you too with one stop solution to most of the issues. And if you have any good articles then please post as comment.

Fix problems with Visual Studio F5 debugging of ASP.NET applications on IIS7 Vista

Explore The Web Server For Windows Vista And Beyond

Using Visual Studio 2008 with IIS 7.0

Tip/Trick: Using IIS7 on Vista with VS 2005

For me just the first link was more then enough, but for your knowledge I think every link has got some unique combination of knowledge which may help you, and save you time googling with flooded search result.

Cheers

~Brij

Read More

Installing Sharepoint Services 3.0 on Windows Vista OS

Just few days back I started exploring Sharepoint Technologies, and started thinking where to start. The biggest setback for me was I cannot run Sharepoint Services on my windows Vista System because Sharepoint Services can only be installed on Windows Server Family of Operating System. But now I cannot go back and repartition my System and install Sharepoint, I also tried using Windows Virtual Machine, but Windows Server 2003 was not working properly on my Windows Virtual Machine.

So now I am left with only two option either repartition the whole harddisk and install dual boot OS or Find some way to run windows sharepoint services on my windows vista. So I started googling and finally I found a jackpot where I can install sharepoint on Windows Vista. First I thought its one more bluff, but thought to give a try, and it worked, and now I am using Windows Sharepoint Services on my Windows Vista Ultimate OS.

Just follow the link below which will guide you step by step process how to do that.

http://community.bamboosolutions.com/blogs/bambooteamblog/archive/2008/05/21/how-to-install-windows-sharepoint-services-3-0-sp1-on-vista-x64-x86.aspx

To download the setup helper file you can either download from the above link or you can download from here directly.

Cheers

~Brij

Read More