jimprince.co.uk

Changing SQL 2005 tempdb Collation

Jim Prince — Thu, 12 Aug 2010 20:48:35 +0000

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= INSTANCENAME= REINSTALL=SQL_Engine REBUILDDATABASE=1 SQLCOLLATION=Latin1_General_CI_AS GROUP= SKUUPGRADE=1 SQLACCOUNT= SQLPASSWORD= ADMINPASSWORD= SAPWD=

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.

Social Bookmarks

Hide Sites

NETGEAR, you suck

Jim Prince — Tue, 03 Aug 2010 07:57:19 +0000

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)”.

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.

Social Bookmarks

Hide Sites

Opening documents from MOSS 2007 with Office 2010 (Beta)

Jim Prince — Mon, 02 Aug 2010 16:14:44 +0000

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://…”.

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!

Social Bookmarks

Hide Sites

SharePoint People Picker AD groups discrepancy

Jim Prince — Fri, 30 Jul 2010 10:22:10 +0000

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.

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!

Social Bookmarks

Hide Sites

PNG Colour mismatch in Internet Explorer

Jim Prince — Fri, 02 Jul 2010 08:47:24 +0000

I recently did some web work that involved working with PNG files. I’m not a designer so was using Paint.Net, I haven’t used Adobe Photoshop for years. I came across an odd problem where my saved PNG didn’t match the CSS used on the page even though the hex values for the colours were exactly the same. It was only when I tried opening the webpage in Chrome that I noticed the problem was specific to Internet Explorer.

After some Googling I discovered that this is due to Internet Explorer not recognising the gAMA metadata inherent in PNG files. Apparently you can remove the metadata using Adobe Photoshop but Paint.Net has no such option.

I eventually stumbled across a program called TweakPNG which allowed me to open the image and remove the offending gAMA metadata.

Problem solved.

UPDATE: The issue is described far more eloquently then I ever could here.

Social Bookmarks

Hide Sites

The most redundant radio button ever

Jim Prince — Thu, 01 Jul 2010 19:47:23 +0000

Words fail me.

Posted via email from Jim’s Posterous Blog

Social Bookmarks

Hide Sites

Adding SQL Reporting Services to an existing cluster

Jim Prince — Fri, 11 Jun 2010 11:17:49 +0000

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."

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

Social Bookmarks

Hide Sites

User renames not being recognised

Jim Prince — Tue, 08 Jun 2010 12:53:22 +0000

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

Social Bookmarks

Hide Sites

Downgrading Windows 7

Jim Prince — Sat, 20 Mar 2010 13:53:39 +0000

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;

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.

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.

Social Bookmarks

Hide Sites

Operating System Analogies

Jim Prince — Fri, 19 Mar 2010 16:02:30 +0000

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

Social Bookmarks

Hide Sites