Unable to connect to MS SQL on install Joomla 3.3.6 IIS 7.5

This forum is for issues with installing Joomla! 3.x on IIS webservers.

Moderator: General Support Moderators

Forum rules
Forum Rules
Absolute Beginner's Guide to Joomla! <-- please read before posting, this means YOU.
Forum Post Assistant - If you are serious about wanting help, you will use this tool to help you post.
Windows Defender SmartScreen Issues <-- please read this if using Windows 10
Locked
Tom_Gen
Joomla! Apprentice
Joomla! Apprentice
Posts: 5
Joined: Thu Dec 18, 2014 7:11 pm

Unable to connect to MS SQL on install Joomla 3.3.6 IIS 7.5

Post by Tom_Gen » Thu Dec 18, 2014 7:32 pm

Last PHP Error(s) Reported :: Forum Post Assistant (v1.2.4) : 18th December 2014 wrote:[18-Dec-2014 18:57:15 UTC] PHP Warning: date(): It is not safe to rely on the system's timezone settings. You are *required* to use the date.timezone setting or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected the timezone 'UTC' for now, but please set date.timezone to select your timezone. in C:\inetpub\wwwroot\fpa-en.php on line 571
Forum Post Assistant (v1.2.4) : 18th December 2014 wrote:
Basic Environment :: wrote:Joomla! Instance :: Not Found
Joomla! Configured :: Not Found

Host Configuration :: OS: Windows NT | OS Version: 6.1 | Technology: i586 | Web Server: Microsoft-IIS/7.5 | Encoding: gzip, deflate | Doc Root: C:/inetpub/wwwroot | System TMP Writable: No

PHP Configuration :: Version: 5.4.35 | PHP API: cgi-fcgi | Session Path Writable: No | Display Errors: | Error Reporting: 22527 | Log Errors To: c:\PHP\php_errors.log | Last Known Error: 18th December 2014 10:57:15. | Register Globals: | Magic Quotes: | Safe Mode: | Open Base: | Uploads: 1 | Max. Upload Size: 2M | Max. POST Size: 8M | Max. Input Time: 60 | Max. Execution Time: 30 | Memory Limit: 128M

MySQL Configuration :: Database Credentials incomplete or not available Nothing to display.
Detailed Environment :: wrote:PHP Extensions :: Core (5.4.35) | bcmath () | calendar () | ctype () | date (5.4.35) | ereg () | filter (0.11.0) | ftp () | hash (1.0) | iconv () | json (1.2.1) | mcrypt () | SPL (0.2) | odbc (1.0) | pcre () | Reflection ($Id: f6367cdb4e3f392af4a6d441a6641de87c2e50c4 $) | session () | standard (5.4.35) | mysqlnd (mysqlnd 5.0.10 - 20111026 - $Id: c85105d7c6f7d70d609bb4c000257868a40840ab $) | tokenizer (0.1) | zip (1.11.0) | zlib (2.0) | libxml () | dom (20031129) | PDO (1.0.4dev) | Phar (2.0.1) | SimpleXML (0.1) | wddx () | xml () | xmlreader (0.1) | xmlwriter (0.1) | cgi-fcgi () | PDO_ODBC (1.0.1) | pdo_sqlsrv (3.0.3421.0) | sqlsrv (3.0.3421.0) | mhash () | Zend Engine (2.4.0) |
Potential Missing Extensions :: openssl | curl | mbstring | mysql | mysqli | suhosin |

Switch User Environment (Experimental) :: PHP CGI: Yes | Server SU: No | PHP SU: Yes | Custom SU (LiteSpeed/Cloud/Grid): No
Potential Ownership Issues: Maybe
(I have since fixed the TimeZone issue in my PHP.ini)

After entering the database configuration information for our Microsoft SQL Server (2008 R2) database and hit next, I receive the following error:

Could not connect to the database. Connector returned number: Database sqlsrv_connect failed

This error appears almost instantly. Our SQL DBA does not see any connection attempt from the web server.

I have searched through the forums and see lots of other post regarding similar situations, but no definitive answers on all of the necessary configuration changes to use MSSQL with Joomla! We prefer to use MSSQL since we licensed for it and have a in-house MSSQL DBA.

Any assistance would be greatly appreciated.

sovainfo
Joomla! Exemplar
Joomla! Exemplar
Posts: 8808
Joined: Sat Oct 01, 2011 7:06 pm

Re: Unable to connect to MS SQL on install Joomla 3.3.6 IIS

Post by sovainfo » Thu Dec 18, 2014 8:36 pm

Try to get any PHP script from your webserver to connect to the database server.
Issue with migrating? Include logs/joomla_update.php in your report!
Blank screen? Verify pagesource for HTML code (javascript error)
Installation failing on populating database? Install with set_time_limit(0)
Document your customizations!

Tom_Gen
Joomla! Apprentice
Joomla! Apprentice
Posts: 5
Joined: Thu Dec 18, 2014 7:11 pm

Re: Unable to connect to MS SQL on install Joomla 3.3.6 IIS

Post by Tom_Gen » Thu Dec 18, 2014 8:44 pm

None of us are familiar with PHP. Can you point me in the direction of a sample script that would attempt to connect to our SQL server?

sovainfo
Joomla! Exemplar
Joomla! Exemplar
Posts: 8808
Joined: Sat Oct 01, 2011 7:06 pm

Re: Unable to connect to MS SQL on install Joomla 3.3.6 IIS

Post by sovainfo » Thu Dec 18, 2014 8:48 pm

Issue with migrating? Include logs/joomla_update.php in your report!
Blank screen? Verify pagesource for HTML code (javascript error)
Installation failing on populating database? Install with set_time_limit(0)
Document your customizations!

Tom_Gen
Joomla! Apprentice
Joomla! Apprentice
Posts: 5
Joined: Thu Dec 18, 2014 7:11 pm

Re: Unable to connect to MS SQL on install Joomla 3.3.6 IIS

Post by Tom_Gen » Thu Dec 18, 2014 9:34 pm

Thank you. The sample script gave me a usable error. After installing the SQL 2012 Native client, I am able to make the MS SQL connection.

benjaminrobut
Joomla! Fledgling
Joomla! Fledgling
Posts: 1
Joined: Tue Dec 23, 2014 10:07 am
Contact:

Re: Unable to connect to MS SQL on install Joomla 3.3.6 IIS

Post by benjaminrobut » Tue Dec 23, 2014 10:12 am

Thanks for the solution!


Locked

Return to “Joomla! 3.x on IIS webserver”