Changing SQL 2005 tempdb Collation

Posted on August 12th, 2010 in Technology, Work by Jim Prince

I recently had cause to change the SQL Collation of the tempdb database on a SQL 2005 Cluster. The installed collation was SQL_Latin1_General_CP1_CI_AS and I needed to change it to Latin1_General_CI_AS. After some brief research it became apparent that the process isn’t as straightforward as you’d imagine.

My first attempt, based on a couple of blog posts I’d read, suggested restoring the model database from an alternative SQL installation with the desired collation. This worked in that once I’d restarted SQL, tempdb had the correct collation, but unfortunately this caused errors in Management Studio. I think this was because the master database had a different collation to that of tempdb.

Apparently the only way to change the collation of the master database is to rebuild all the system databases. So, in preparation, I detached all the user databases and took a copy of syslogins. Apparently you can only rebuild the system databases from the command line and it took some experimentation before I hit on the right combination of arguments. These were as follows;

setup.exe /qn VS=<virtual server name> INSTANCENAME=<instance name> REINSTALL=SQL_Engine REBUILDDATABASE=1 SQLCOLLATION=Latin1_General_CI_AS GROUP=<cluster group> SKUUPGRADE=1 SQLACCOUNT=<sql service account> SQLPASSWORD=<sql service account password> ADMINPASSWORD=<logged in user password> SAPWD=<sa password>

SKUUPGRADE was required because the server was running service pack 1 but setup.exe was from the RTM version. I don’t know a way around this as you can’t slipstream a SQL 2005 SP1 installation.

ADMINPASSWORD specified the password of the logged in user. I had initially omitted this option but was getting an error “The installation was cancelled by the user” in the logs. After some investigation I discovered that the installer was trying to create a scheduled task on each of the cluster nodes, but was failing because it couldn’t authenticate. As an added bonus this would also lock out my domain account. Nice one Microsoft!

SAPWD was required (despite the SA account being disabled), otherwise I would get the following error in C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Summary.txt.

Error: Action "LaunchPatchedBootstrapAction" threw an exception during execution. Error information reported during run:
"C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\setup.exe" finished and returned: 1602 Aborting queue processing as nested installer has completed Message pump returning: 1602

Once the installation had completed I attached the user databases and restored the syslogins. See here for details on how to do this.

The moral of the story is to check and double check you have the correct collation at the point of installation. It’s a right pain to change afterwards. Lesson learnt.


NETGEAR, you suck

Posted on August 3rd, 2010 in Personal, Technology by Jim Prince

At the weekend I installed a NETGEAR WG311v3 Wireless PCI Network card into my main PC. This was to replace the external Belkin USB one I’d been using for some time. After fitting the card and installing the drivers from Windows Update I noticed an error which read “Device Cannot Start (Code 10)”.

61943[1]There’s a whole heap of discussion around this problem on NETGEARs forums and it would appear there are several causes for this issue. In my case it was simply that I’m using 64bit Windows 7 with 4gb of ram, hardly an unusual combination!

The only way I can get the card to work is if I remove 2gb of memory, something I’m not prepared to do. I’ve tried drivers from Marvell (the chipset manufacturer), I’ve disabled driver signing and tried numerous hacks from forums, websites and blogs all with no success.

 

The issue is mentioned on their list of known issues for the driver (dated 7th July 2010) but there’s no indication of when this is likely to be fixed or if there’s a supported workaround.

I’ve removed the card and will put it on e-bay, I’ll never buy a NETGEAR product again.


Opening documents from MOSS 2007 with Office 2010 (Beta)

Posted on August 2nd, 2010 in Technology, Work by Jim Prince

For a while now I’ve been getting an error when trying to open office documents (Word, Excel etc) from our SharePoint 2007 based Intranet, this has been happening since I upgraded of Office 2010 Beta. The error was always of the type ‘”Could not open ‘http://…”.

moss_error[3]

To get around the issue I’d just download the document to my desktop then re-upload to the Portal, which while not very efficient, worked just fine.

This morning I got fed up and decided to try and fix it.

The solution turned out to be very straightforward, at least on my laptop. Open IE navigate to Tools –> Internet Options –> Connections –> LAN Settings and uncheck the box Automatically detect settings. Problem solved, now if anybody could explain why the hell that should make any difference I would love to know!

ie



SharePoint People Picker AD groups discrepancy

Posted on July 30th, 2010 in Technology, Work by Jim Prince

We recently came across a problem where the People Picker in a SharePoint farm was displaying different numbers of users in AD groups when accessed from different Web Apps. The Web Apps in question were in different SSPs in the same farm.

I spent an hour of so with a colleague trying to work out why this might be and to be honest I gave up and moved onto something else. Luckily John was more tenacious and managed to resolve the problem that evening.

He happened to spot that the Membership and BDC Import status for one of the SSPs with incorrect AD Group Members read “Idle – Completed in 0h 0m 0s” – which clearly wasn’t right.

import[6]

On a hunch based on a similar problem he’d read about he cleared the SharePoint Configuration Cache. This resolved the problem. The list of issues resolved by clearing the configuration cache continues to grow!


Adding SQL Reporting Services to an existing cluster

Posted on June 11th, 2010 in General, Technology, Work by Jim Prince

This morning I had to add SQL Reporting Services to an existing SQL 2008 fail-over cluster. I started the installation selected the existing cluster instance and added the Reporting Services feature. However, when I reached the Installation rules page I got the below failure on the Existing clustered or cluster-prepared instance check. 

"The instance selected for installation is already installed and clustered on computer xxx. To continue, select a different instance to cluster."

SQL Reporting Services


After some investigation I found the following statement buried in the SQL Server 2008 Failover Clustering white-paper. 

"Note: SQL Server 2008 does not support adding features to an existing failover cluster instance, so Analysis Services cannot be added to an existing instance of SQL Server. To share a resource group with an instance of SQL Server, you must choose to install Analysis Services during the initial installation of SQL Server."

While this is referring to Analysis Services it must also apply to SQL Reporting Services. To get around the issue I carried out a stand alone installation of SQL Reporting Services in "FilesOnlyMode" and used the Reporting Services Configuration tool to create the databases on the fail-over cluster instance. 

I then carried out the same process on the other node in the cluster to create a scale-out deployment as documented here.

All in all quite a frustrating experience, but I got there in the end.

Posted via email from Jim’s Posterous Blog


User renames not being recognised

Posted on June 8th, 2010 in General, Technology, Work by Jim Prince

I recently resolved a problem where one of our applications wouldn't recognise the user type of accounts renamed in Active Directory. The solution was fairly generic so I thought I'd document it here in the hope that it helps someone else.

Basically if you renamed an account in AD and then signed into the application it would still believe you had the old user name. This was proved by navigating to a test aspx page containing the following

< % =System.Web.HttpContext.Current.User.Identity.Name %>

Curiously if you rebooted the server the correct user name was identified so clearly information was being cached somewhere. After some further investigation (by which I mean judicious use of Google) I stumbled across the following Microsoft Knowledgebase Article - http://support.microsoft.com/kb/946358. 

In a nut shell disabling the local SID cache fixed the problem, renamed users simply needed to re-authenticate to pick up the change to their username.

Note that this does not appear to be an issue under Windows Server 2008.

Posted via email from Jim’s Posterous Blog


Downgrading Windows 7

Posted on March 20th, 2010 in General, Personal, Technology by Jim Prince

Up until recently I’d been using the Windows 7 Enterprise Trial from TechNet on my home PC. Unfortunately it was due to expire, so I purchased a copy of Windows 7 Home Premium as I don’t need Ultimate or Professional at home.

Not wanting to loose my settings I tried to downgrade but was presented with the following error;

Windows 7 Upgrade


After some Googling I stumbled upon a post with a simple registry hack to allow the downgrade.

Once I’d configured the relevant registry keys in HKEY_LOCAL_MACHINE\Software\Microsoft\Windows NT\CurrentVersion (see image below) I was able to perform the downgrade. I am now happily running a licenced and activated Windows 7 without having to install a fresh copy.

Registry Keys

You may argue that a fresh install would be more sensible but frankly its running as well as it did 3 months ago so I really didn’t see the need. Oh and for the record moving to Windows 7 is well worth the effort.


Operating System Analogies

Posted on March 19th, 2010 in General, Technology, Work by Jim Prince

According to Security expert Charlie Miller "Mac OS X is like living in a farmhouse in the country with no locks, and Windows is living in a house with bars on the windows in the bad part of town."

I'd be inclined to agree but it's left me thinking what is Linux or more specifically FreeBSD? The only analogy I can come up with is like living on your own in an underground nuclear bunker with no doors or windows….after Armageddon.

I'm sure you can do better… 

Posted via email from Jim’s Posterous Blog


GD Library versions and Ubuntu

Posted on January 14th, 2010 in General, Technology, Work by Jim Prince

I'd been having a problem with GD being out of date on a LAMP installation on Ubuntu. This was odd because the installation is the latest (9.10) release. After some digging, it would seem that in Ubuntu PHP5 is not compiled with the version of GD that comes bundled with PHP! 

There's a really helpful article explaining how to recompile PHP5 with support for the latest version of GD here. You'll probably need to update the directories and file names depending on the release you're using but it worked for me.

Posted via email from Jim’s Posterous Blog


Overclocking an Intel E2160

Posted on January 4th, 2010 in General, Personal, Technology by Jim Prince

A while back I overclocked my aging Gigabyte motherboard and Intel Pentium 2160 processor. I overclocked the CPU from 1.8Ghz to 3.0Ghz and the machine has been rock solid with the CPU core temperature around 45° even under load.
 
The motherboard is a Gigabyte ga-p35-s3. Here are the settings I used;
 
CPU Clock Ratio [9x]
CPU Frequency [3.00 Ghz (333x9)]
CPU Host Freqency [333]
System Memory Multiplier [2.40]
System Voltage Control [Manual]
DDR2 Overvoltage Control [+0.1v]
PCI-E Overvoltage Control [+0.1v]
FSB Overvoltage Control [+0.1v]
CPU Voltage Control [1.50000v]
 
I hope this helps someone but of course your mileage may vary. Any changes you make as a result of this post are entirely at your own risk…
 

Posted via email from Jim’s Posterous Blog


Next Page »