Solved

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

Posted on 2012-04-05
6
605 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
  • 4
  • 2
6 Comments
 
LVL 3

Accepted Solution

by:
tobyweston earned 500 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
Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

 

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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
Nothing in an HTTP request can be trusted, including HTTP headers and form data.  A form token is a tool that can be used to guard against request forgeries (CSRF).  This article shows an improved approach to form tokens, making it more difficult to…
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…
Explain concepts important to validation of email addresses with regular expressions. Applies to most languages/tools that uses regular expressions. Consider email address RFCs: Look at HTML5 form input element (with type=email) regex pattern: T…

777 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