Joomla + MSSQL

Aamdaron · 16th June 2008, 4:12 PM

Hey guys just curious if anyone knew if it was possible to get Joomla running under MSSQL. If this isn't possible what would you recommend as a CMS for MSSQL?

Thanks

Primüs · 16th June 2008, 9:09 PM

Sure its possible to do so, but you would have to go through and make sure all SQL syntax's will work, and all functions are changed to their MSSQL equivalents. Quite a big job.

As for MSSQL based CMS', i dont really know any haha. Maybe google can be helpful here.

mitsimonsta · 16th June 2008, 9:27 PM

Joomla is MySQL out of the box, no need to run anything differently. It's menat for a LAMP (Linux/Apache/MySQL/PHP) environment but can be massaged onto just about anything that supports Apache/MySQL/PHP. Which is like everything

You could run MS-SQL but there would be some funniness to it, I have heard installing PHP into IIS is annoying. Haven't tried of late, maybe they have improved it.

At work we use Atlassian Confluence for our intranet Wiki. Works okay, Sharepoint is probably infinitely better for us now.

Otherwise, the CMS Comparison Matrix is probably your best shot. Most MS-SQL CMS's are ASP based, and basically need IIS.

houseofzeus · 16th June 2008, 10:46 PM

Honestly for the amount of effort you would have to go to make Joomla! work with MSSQL (and more importantly, test it thoroughly) you are better off either:

Installing MySQL
Finding a CMS that supports MSSQL out of the box

Unfortunately I don't myself know of anything fitting for the later but no doubt there are options out there. At the very worst both of these options cost you no more time/money than what you are suggesting and probably quite a bit less.

Aamdaron · 17th June 2008, 1:05 AM

Thanks for the help guys. Really have my heart set on Joomla and my provider doesn't have mysql support. So yeah either im gonna go for an mssql cms or go with a different provider.

Primüs · 17th June 2008, 8:08 AM

Quote:

Originally Posted by Aamdaron

Thanks for the help guys. Really have my heart set on Joomla and my provider doesn't have mysql support. So yeah either im gonna go for an mssql cms or go with a different provider.

What the? What kind of host DOESNT support MySQL? But supports MSSQL? Thats just whack. Find a new provider, you will find for free open source applications MySQL is a lot more widely used.

Elyzion · 17th June 2008, 8:11 AM

Quote:

Originally Posted by Primüs

What the? What kind of host DOESNT support MySQL? But supports MSSQL? Thats just whack. Find a new provider, you will find for free open source applications MySQL is a lot more widely used.

Um, i think you have it wrong...

What kind of host has PHP but not MySQL?

16th June 2008, 4:12 PM	#1
Aamdaron Member Join Date: Jul 2002 Location: Melbourne Posts: 2,118	Joomla + MSSQL Hey guys just curious if anyone knew if it was possible to get Joomla running under MSSQL. If this isn't possible what would you recommend as a CMS for MSSQL? Thanks __________________ P4 2.53 Ghz\| Abit IT7 Max2 V2 \| Aopen H600B \|512mb DDR RAM PC-2700 CORSAIR CAS2 \| Hercules Radeon 9700 PRO \| Audigy 2 ZS \| Mitsubishi 19" \| WD 80GB 7200rpm 8mb cache \| Sony 16x dvd OCAU Night Owl#253 Member of the OCAU 3DMark Team AOPEN CASE MODDERS/OWNERS CLUB MEMBER #13 Firebird is teh rox

16th June 2008, 9:09 PM	#2
Primüs Member Join Date: Oct 2005 Location: Coffs Harbour, NSW Posts: 2,712	Sure its possible to do so, but you would have to go through and make sure all SQL syntax's will work, and all functions are changed to their MSSQL equivalents. Quite a big job. As for MSSQL based CMS', i dont really know any haha. Maybe google can be helpful here. __________________ I has blog!

16th June 2008, 9:27 PM	#3
mitsimonsta Member Join Date: Aug 2006 Location: Starfleet HQ, 2194 Posts: 10,019	Joomla is MySQL out of the box, no need to run anything differently. It's menat for a LAMP (Linux/Apache/MySQL/PHP) environment but can be massaged onto just about anything that supports Apache/MySQL/PHP. Which is like everything You could run MS-SQL but there would be some funniness to it, I have heard installing PHP into IIS is annoying. Haven't tried of late, maybe they have improved it. At work we use Atlassian Confluence for our intranet Wiki. Works okay, Sharepoint is probably infinitely better for us now. Otherwise, the CMS Comparison Matrix is probably your best shot. Most MS-SQL CMS's are ASP based, and basically need IIS. __________________ Opinions expressed are my own, and generally unpopular with others. All rights reserved, some wrongs still available OCAU Folding Hall of Fame Inductee \| 55 Million F@H Points for OCAU \| 600K PPW Club \| Folding Stats [TOG] Black Ops Server Admin - Over 25 and enjoy gaming? Join TOG Are you an OCAU Wet Shaver? Visit Paste & Cut Last edited by mitsimonsta; 16th June 2008 at 9:30 PM.

16th June 2008, 10:46 PM	#4
houseofzeus Member Join Date: Mar 2005 Location: St. Lucia, Brisbane Posts: 3,200	Honestly for the amount of effort you would have to go to make Joomla! work with MSSQL (and more importantly, test it thoroughly) you are better off either: Installing MySQL Finding a CMS that supports MSSQL out of the box Unfortunately I don't myself know of anything fitting for the later but no doubt there are options out there. At the very worst both of these options cost you no more time/money than what you are suggesting and probably quite a bit less.

17th June 2008, 1:05 AM	#5
Aamdaron Member Join Date: Jul 2002 Location: Melbourne Posts: 2,118	Thanks for the help guys. Really have my heart set on Joomla and my provider doesn't have mysql support. So yeah either im gonna go for an mssql cms or go with a different provider. __________________ P4 2.53 Ghz\| Abit IT7 Max2 V2 \| Aopen H600B \|512mb DDR RAM PC-2700 CORSAIR CAS2 \| Hercules Radeon 9700 PRO \| Audigy 2 ZS \| Mitsubishi 19" \| WD 80GB 7200rpm 8mb cache \| Sony 16x dvd OCAU Night Owl#253 Member of the OCAU 3DMark Team AOPEN CASE MODDERS/OWNERS CLUB MEMBER #13 Firebird is teh rox