January 17, 2010 at 7:18 pm
Hi all,
Over the past couple of days I have been fighting an issue with SQL Server 2008 and the Management Tools which I would like to share. This was an incredibly frustrating issue as I tried almost anything I could and carried out a huge amount of research in an effort to resolve it.
We had an issue just recently where all the following was occuring on Windows Server 2008 SP1 (x64) with SQL Server 2008 Enterprise Edition (x64):
SSMS would not launch with a MSVCR80.dll faulting module errors, BIDS would not launch with a KERNEL32.dll faulting module errors, SQL Profiler would fail, SQL Configuration Manager would fail, various MMC snap-ins would fail to launch, you could not uninstall the .NET 3.5 framework, SQL Server 2008 media and SP1 would not launch with media info file validation failures and any patches for .NET 3.5 from Windows Update would fail. This occured in both development and production environments.
After a number of hours of working through various "red herrings", and being at the verge of a rebuild, the issue turned out to be a Regional Settings Group Policy applied by one of the Domain Administrators to Authenticated Users in AD. The policy tied down Regional Settings to a particular locale (New Zealand) and this corrupted the local profile of all users who logged in, using domain authentication, to the SQL Servers. This policy essentially killed all the SQL Server related applications on the servers (although the database services were still ok) including several that were only Windows Server 2008 related, and prevented any SQL Server related media from being launched either by the command prompt or through setup.exe.
What I found the most interesting is how devistating this could be to a number of components on the servers i.e. management tools, SQL media, SQL Service Packs, .NET Framework, MMC snap-ins etc. It was across the board and made it very difficult to resolve. I am now in the process of deciphering how and why these Regional Settings caused this issue.
Just keep this in mind if you ever experience this in the future.
Cheers
Scott
B.Sc MCITP(2) MCTS(2) MCSE MCDBA MCSA CCNA CompTIA A+
January 17, 2010 at 7:26 pm
Please report this issue on the connect site and post the link back here so other we can vote and follow up on developpement of solutions.
TIA.
January 17, 2010 at 7:42 pm
Sorry, I forgot to post the resolution.
I disabled the Group Policy, deleted the local profile and logged in again. Once this was done the applications etc all worked perfectly fine.
This post is now with Microsoft too.
Cheers
Scott
January 18, 2010 at 3:23 am
Thanks, and what's the link on MS?
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply