Solved

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

Posted on 2012-04-05
6
612 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 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
The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

 

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

NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!

Question has a verified solution.

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

Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
These days socially coordinated efforts have turned into a critical requirement for enterprises.
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…
The viewer will learn how to dynamically set the form action using jQuery.

726 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