Solved

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

Posted on 2012-04-05
6
604 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
NAS Cloud Backup Strategies

This article explains backup scenarios when using network storage. We review the so-called “3-2-1 strategy” and summarize the methods you can use to send NAS data to 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

Control application downtime with dependency maps

Visualize the interdependencies between application components better with Applications Manager's automated application discovery and dependency mapping feature. Resolve performance issues faster by quickly isolating problematic components.

Question has a verified solution.

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

Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
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 count occurrences of each item in an array.

930 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

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now