Friday, January 8, 2010

How to install SQLXML 3 on IIS 7 (Windows Server 2008 64 Bit)

The release notes of SQLXML 4.1 state, that if you need SQLXML with ISAPI (Internet Information Server) support, the latest version for you is SQLXML 3 SP3.

If you try to install it on a Windows Server 2008 R2 64Bit you might see 2 issues with that:

After installing you click "Start - SQLXML 3.0 - Configure IIS Support"

If you get the error

"An error occurred connecting to 'server'. This server does not exist or is unavailable."

apply the following solution

Click "Start - Administrative Tools - Server Manager"

in the Server Manager go to

"Roles - Webserver (IIS)"

Go to section "Role Services"

verify that all of "IIS 6 Management Compatibilty" packages are installed.

After I installed the IIS 6 compatibility packages the SQLXML 3 snapin starts and connects just fine.

The second error can occur if you attempt to call one of the xml templates and IIS just gives a 500 error 0x800700c1. Permissions and all appear correct. The IIS Virtual Direcotry Manager for SQLXML 3.0 throws an error when I attempt to Restart Application DLL "Error occurred unloading the application".

Then apply the following solution:

1. Open IIS Manager, Select Application Pools.

2. Under Actions pane, Select 'Set Application Pool Defaults'.

3. Set 'Enable 32-bit Applications' to 'True'. (Solution found here)

9 comments:

Anonymous said...

Thank you Thank you Thank you Thank you Thank you Thank you
I had read that SQLXML 3.0 was deprecated on IIS7 WinServer 2008, and this article made me SMILE !! You wouldn't believe how much this helped, THANK YOU! I had resorted in WCF LINQ SQL RSS ATOM feed, and still haven't got it to work, it so complex.... Thanks again, Chuck.

Willian said...

Thank you !!!!!!!!!!!!!

I was losing hope, but you saved me!

Thanks !!!!!!!!!!!!!!!

Willian said...

Thank you !!!!!!!!!!!!!

I was losing hope, but you saved me!

Thanks !!!!!!!!!!!!!!!

Anonymous said...

legend!!!!!!!!!

Anonymous said...

love you , it works well

Anonymous said...

Thanks a ton. I would never have thought of this as a resolution. This guy knows his stuff.

Anonymous said...

Thanx a lot, man. It helped me a lot.

Kelvin said...

I Spent nearly 2 days going over every single setting possible to get this working, but nothing seemed to work. I was about to reinstall the entire box, but thought of givnig this blog a try. after checking this blog, it took just 2 minutes and this just saved me so much time and energy. Thank you so much.

Dharma said...

Hi Thanks for the post, we have resolved the first issue by following this blog but we are getting the second error and it is not resolved by the steps.
we are using windows server 2012.

is this process applicable to only windows 2008?

-
Dharma