?
Solved

Install jommla 2.5 on a Windows Server 2008 and use SQL server 2008

Posted on 2012-04-05
6
Medium Priority
?
621 Views
Last Modified: 2012-04-12
Hi there,
Although i think is possible i think i got stuck help would be much appreciated!
I'm able to see the joomla installation instruction and everything which is half of way but when i go to select the database only mySql is the only option that shows on the database drop down. I have tried so many way s on how to make my SQL database option to show but it does no want to work. Can you experts give some pointer or tell me how to do it? I try to locate my php.ini but i wasn't able to find it windows Server does not shows me where the file is and i did a search and it came back with the plesk information.
I'm working on a dedicated server out in the internet and i have full control over help would be much appreciated
-COHFL
0
Comment
Question by:COHFL
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 2
6 Comments
 
LVL 3

Accepted Solution

by:
tobyweston earned 2000 total points
ID: 37811993
Php usually gets installed into C:\php. The php.ini file will be in there. Within that file there should be the following lines:

extension=php_sqlsrv_53_ts_vc9.dll
extension=php_pdo_sqlsrv_53_nts_vc9.dll

Open in new window


If they are not there, add them in with the rest of the extensions.

You will also need to make sure the MS SQL Drivers for PHP are installed.

This can be downloaded from Microsoft Drivers for PHP for SQL Server
0
 

Author Comment

by:COHFL
ID: 37812030
I did that but once i enable the dll the site does not respond and throws an error im wonder if i need to move the dll to an EXT folder or something?
do you know
0
 

Author Comment

by:COHFL
ID: 37812048
Run SQLSRV20.EXE
- When prompted, enter the path to the PHP extensions directory

whats that directory can i find it suing phpinfo()?
0
Get 15 Days FREE Full-Featured Trial

Benefit from a mission critical IT monitoring with Monitis Premium or get it FREE for your entry level monitoring needs.
-Over 200,000 users
-More than 300,000 websites monitored
-Used in 197 countries
-Recommended by 98% of users

 

Author Comment

by:COHFL
ID: 37812217
ok this might help pin point the problem

i go to IIS Manager and look a my site  under IIS there is an option that reads PHP Manager once i click on it all sort of options do show up. I go all the way to the bottom of the page and click on ENABLE OR DISABLE AN EXTENSION once the PHP Extension do load up i look for: extension=php_sqlsrv_53_ts_vc9.dll right click and enable them extension=php_pdo_sqlsrv_53_nts_vc9.dll right click and enable.

Once all this is enable i restart IIS and my server shows a 500 - Internal server error.
There is a problem with the resource you are looking for, and it cannot be displayed error.

I go back to ISS click on my site virtual directory click on Content View and right click on index.php and select browse and this is what i get:

HTTP Error 500.0 - Internal Server Error
C:\Program Files (x86)\Parallels\Plesk\Additional\PleskPHP5\php-cgi.exe - The FastCGI process exited unexpectedly

I hope this helps!
0
 
LVL 3

Expert Comment

by:tobyweston
ID: 37812363
Can you try moving the dll to C:\Program Files (x86)\Parallels\Plesk\Additional\PleskPHP5\ext and trying again.

The php.ini file should be in there as well, is that where you saw the "extension=" lines?

The following registry key should tell you where the php.ini file is as well.

HKEY_LOCAL_MACHINE\SOFTWARE\PHP\IniFilePath
0
 

Author Comment

by:COHFL
ID: 37837748
I think i found the problem since i was trying i left the 5.2 and 2.3 dll on the same directory this cause the problem once i delete the unnecessary dlls everything worked =)
0

Featured Post

Are You Using the Best Web Development Editor?

The worlds of web hosting and web development are constantly evolving. Every year we see design trends change, coding standards adapt and new frameworks/CMS created. With such a quick pace of change it’s easy to get lost trying to keep up.

See if your editor made the list.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction This article is intended for those who are new to PHP error handling (https://www.experts-exchange.com/articles/11769/And-by-the-way-I-am-New-to-PHP.html).  It addresses one of the most common problems that plague beginning PHP develop…
There are times when I have encountered the need to decompress a response from a PHP request. This is how it's done, but you must have control of the request and you can set the Accept-Encoding header.
Learn how to match and substitute tagged data using PHP regular expressions. Demonstrated on Windows 7, but also applies to other operating systems. Demonstrated technique applies to PHP (all versions) and Firefox, but very similar techniques will w…
The viewer will learn how to look for a specific file type in a local or remote server directory using PHP.

770 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question