Celtic Coding Solutions Blog

Celtic Coding Solutions Blog - for everything computer related

Upgrade Web App from v3 to v.45 HTTP Error 500.22

Managed to successfully upgrade a Web Application from .Net Version 3 to Version 4.5 and I get the following error:-

HTTP Error 500.22 - Internal Server Error

As ASP.NET aspiration abortion setting has been detected abortion pill costs that does not apply in Integrated managed pipeline mode

Module: configurationValidationModule

Notification: BeginRequest

Handler: ExtensionlessUrlHandler-Integrated-4.0

Error Code: 0x80070032

Solution was quite simple and found it here:-

StackOverFlow - An ASP.NET setting has been detected that does not apply in Integrated managed pipeline mode


In web.config add the following or make sure it exists:-

        <validation validateIntegratedModeConfiguration="false"/>

Error running Phone Emulator on Windows 8.1 and VS2013 in VMWare Workstation 8

I am running Windows 7 Ultimate as my main development machine but thought it would be good to play around with Windows 8 Phone dev kit.  Now you need Windows 8.1 and Visual Studio 2013 which I wanted to install on my VMWare Workstation 8 as a virtual pc.  I created risk of abortion a virtual PC and Windows 8.1 and Visual Studio 2013 installed fine, but when running the Windows Phone Emulator I got the following error:-

Windows Phone Emulator is unable to verify that the virutal machine is running:

Something happened while starting a virtual machine: 'Emulator 8.1 WVGA 4 facts of abortion inch 512MB.admin' failed to start. (Virtual machine ID ...

The Virtual Machine Management Service failed to start the virtual machine 'Emulator 8.1 WVGA 4 inch 512MB.admin' because on of the Hyper-V components is not running (Virual machine ID...

There is a great article on the nokia developer site for VMWare:-


The only bit I was missing was that when I opened the .vmx file I didn't have the following at all:-

hypervisor.cpuid.v0 = "FALSE"

So after adding this in and checking all the other settings where on I was then able to boot up the Windows Phone emulator - yippy.

TFS 2013 - change assigned to drop down list for work item bug, task etc

Using Team Foundation Server 2013 with Visual Studio 2013 and creating a work item like bug, task or issue the assigned to drop down was display far more people than where on my team.  As there is no obvious guid having an abortion to change who is listed then I did some digging and found it involves a small bit of effort which I will document here:-

I am using Visual Studio 2013 and Team Foundation Server 2013

You will need to download and install Microsoft Visual Studio Team Foundation Server 2013 Power Tools (please not if you already have a TFS Power Tools you will need to uninstall):-


Once installed, open Visual Studio 2013 and connect to your TFS 2013 Server.

In Visual Studio 2013, Menu -> Tools -> Process Editor -> Work Item Types -> Open WIT from Server

Select a Project and a Work Item Type e.g. here I will use Issue

A form will open in in Visual Studio like so:-

Find the Assigned To row (selected above).  Double click and you will see the Field Definition.  Select Rules Tab:-

Edit VALIDUSER row and you will see a VALIDUSER popup form:-

Now select a group you have all the users you want to display, here I am using the [Global]\Developers TFS Group

OK all open pop up forms and save the *.wit file.

Now you need to upload this file back to TFS.  To do this use almost the same menu opitions:-

In Visual Studio 2013, Menu -> Tools -> Process Editor -> Work Item Types -> Import WIT

Select the correct project and browse for the *.wit file you just saved.

Once uploaded try to create a new Issue for that project and you will see that only the users selected in your TFS Group are now displayed (if you are using the Web abortion procedures TFS version make sure you F5 to refresh otherwise you will not see the changes).

Using Telerik WPF RadWindow as MainWindow

Thought I would blog about how to use the Telerik abortion pill video WPF RadWindow as a MainWindow when using Visual Studio 2012 and .Net 4.5 (but I presume it will work with other versions).

So change the MainWindow.xaml from:-




Now this works fine but I notice that we have no taskbar icon, bit strange as this is default with the standard WPF form.  

To add this you will need a new reference:-



Now we get the Taskbar icon back but it is the default WPF one so to add a custom one I added my own icon to a new Resource file and then referenced it:-


I also want how to get the pill the icon to show in the WPF window itself.  So I add the following:-


     <Image Source="Resources/MyIcon.ico" Height="18"/>


I also want to add a Telerik style to the whole form so I just add in:-



The complete code looks like:-










    Header="My Telerik Form">    


        <Image Source="Resources/ReportsIcon.ico" Height="18"/>



SQL Server Management Studio - Index was outside the bounds of the array.

Tried to connect to a SQL Server using Microsoft SQL Server Management Studio 2005 and got the following error message (plus the databases wouldn't show):-

Index was outside the bounds of the array. (Microsoft.SqlServer.Smo)

Check the SQL Server version and it was a SQL methods of abortion Server 2012 SP1 CPU5 Enterprise Edition.


I just used Microsoft SQL Server Management Studio online abortion pills 2012 and all is well

SSRS 2005 Web Page Resource cannot be found

Had a strange error with SSRS 2005 on Windows 2003 Server running IIS6.  Trying to load the Web Reports Manager for SSRS 2005 at http://localhost/reports and I would get the following error:-

Server Error in '/Reports' Application

The resource cannot be found

Description: HTTP 404.

Ok but I can load up:-


So I thought the Default content page wasn't set - nope it was?

OK so what is going on, only different is Asp.net 4.0 was installed.  Saw some articles saying maybe the Asp.net version wasn't set correctly for that Web Applications, but again checked and it was still set to buy abortion pills Asp.Net 2.0. 


Seemed like the root web ru 486 pill properties (Default Web Site Properties in this instance) was set to Asp.Net 4.0.

OK so changed this back to Asp.Net 2.0 and restarted IIS.  Bingo no SSRS 2005 http://localhost/reports works again.

Fix for SQL Server Database with no owner

I came across an issue today in SQL Server Management Studio.  On a particular database I right clicked and selected properties and was presented with the following error:-

Cannot show requested dialog. (SqlMgmt)


Property Owner is not available for Database for abortion '[]'. This property may not exist for this object, or may not be retrievable due to insufficient access rights.  (Microsoft.SqlServer.Smo)

So I ran sp_helpdb
And sure enough under the database the owner was NULL
Just run the following command on the database without abortion legal an owner, here I am using sa but you can use whichever owner you want:-
EXEC sp_changedbowner 'sa'

Installing .Net Assemblies in GAC for Windows Server 2008 r2

I blogged about installing .Net Assemblies in GAC for Windows Server 2008 (Celtic Coding Linky), but for 2008 R2 it no longer works unless you change the Security Policy and re-boot the server (blogs.msdn.com).

This isn't really an option on a live server so I decided to use gacutil.exe.  Yes I abortion pill safety know this is not supported in a live environment but it works and late term abortions when under tight deadlines it is a proper option.

However this server had an old verion under:-


No problem give it a go in Command Prompt running as an administrator and get the following error:-

Failure initializing gacutil.


Looks like a .Net version difference so open gacutil.exe.config and change the following:-

<?xml version ="1.0"?>



        <requiredRuntime version="v1.1.4322"  />





<?xml version ="1.0"?>



        <requiredRuntime  safemode="true"  imageVersion="v1.1.4322" version="v1.1.4322"  />



        <assemblyBinding xmlns="urn:schemas-microsoft-com:asm.v1">

            <publisherPolicy apply="no"/>





Now try installing the dll

gacutil /i CCAssembly.dll


Assembly successfully added to the cache


SQL Server T-SQL SELECT Varchar not matching - CHAR(160)

First time I've come across this.  Imported some data from Excel 2010 into SQL Server Table.  Tried to match against some other data already in SQL Server and notice certain values where not matching even though to the naked eye these look exactly the same and the abortion risk field is the same varchar.  

So did a quick HexEdit check (thanks Visual FoxPro for this handy tool) and found the following:-

Looks after pill like in Excel or in the import process a space (last 3 characters) has been translated into:-

CHAR: 160


Normally I see space in SQL as:-

CHAR: 32

HEX: 20

So a quick REPLACE(Field, CHAR(160), CHAR(32)) and now the values match.

Error when importing Excel 2007 spreadsheet into SQL Server 2012

Tried to import an Excel 2010 spreadsheet (file extension xlsx) into SQL Server 2012 using the import wizard and selecting Microsoft Excel 2007:-


Then I had the following error on my Windows 7 x64 PC:-

SQL Server Import and Export Wizard Error

Additional Information: The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine. (System.Data)

This is strange as I have Office 2010 x64 abortion hotline installed?

Fix: you need to install generic abortion pill the x86 (32bit) Office drivers.  This is a simple download from Microsoft called "2007 Office System Driver: Data Connectivity Components".

Url - http://www.microsoft.com/en-us/download/confirmation.aspx?id=23734