SQL Server 2008 R2: Database sqlsrv_connect

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
marcos1
Joomla! Fledgling
Joomla! Fledgling
Posts: 1
Joined: Sun May 05, 2013 8:31 am

SQL Server 2008 R2: Database sqlsrv_connect

Post by marcos1 » Sun May 05, 2013 8:40 am

Hi I am trying to install the latest Joomla 3.x on a hosted server. I have got as far as step 2 and trying to connect to a Sql Server (SELECT @@VERSION = Microsoft SQL Server 2008 R2 (SP1) - 10.50.2550.0) database but I get

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

I can connect via SSMS using the credentials I am using on the config page. The only slightly different thing I can think of is that it's on a non-standard port e.g. mydatabaseprovider.net,2433

Any ideas?
Forum Post Assistant (v1.2.3) : 5th May 2013 wrote:
Basic Environment :: wrote:Joomla! Instance :: Joomla! 3.1.1-Stable (Ember) 26-April-2013
Joomla! Platform :: Joomla Platform 12.2.0-Stable (Neil Armstrong) 21-September-2012
Joomla! Configured :: Not Found

Host Configuration :: OS: Windows NT | OS Version: 5.2 | Technology: i586 | Web Server: Microsoft-IIS/6.0 | Encoding: gzip, deflate | Doc Root: C:/Domains/TeArai.org/wwwroot | System TMP Writable: No

PHP Configuration :: Version: 5.3.21 | PHP API: cgi-fcgi | Session Path Writable: No | Display Errors: | Error Reporting: 1 | Log Errors To: C:\PHP5\error.log | Last Known Error: | Register Globals: | Magic Quotes: | Safe Mode: | Open Base: c:\domains\ | Uploads: 1 | Max. Upload Size: 12M | Max. POST Size: 12M | Max. Input Time: 60 | Max. Execution Time: 300 | Memory Limit: 128M

MySQL Configuration :: Database Credentials incomplete or not available Nothing to display.
Missing credentials detected: Connection Type missing | MySQL Host missing | Table Prefix missing | Database Username missing | Database Password missing |
Detailed Environment :: wrote:PHP Extensions :: Core (5.3.21) | bcmath () | calendar () | ctype () | date (5.3.21) | ereg () | filter (0.11.0) | ftp () | hash (1.0) | iconv () | json (1.2.1) | mcrypt () | SPL (0.2) | odbc (1.0) | pcre () | Reflection ($Id: 4af6c4c676864b1c0bfa693845af0688645c37cf $) | session () | standard (5.3.21) | mysqlnd (mysqlnd 5.0.8-dev - 20102224 - $Id: 65fe78e70ce53d27a6cd578597722950e490b0d0 $) | tokenizer (0.1) | zip (1.11.0) | zlib (1.1) | libxml () | dom (20031129) | PDO (1.0.4dev) | bz2 () | SimpleXML (0.1) | wddx () | xml () | xmlreader (0.1) | xmlwriter (0.1) | cgi-fcgi () | openssl () | curl () | fileinfo (1.0.5-dev) | gd () | gettext () | gmp () | intl (1.1.0) | imap () | ldap () | mbstring () | exif (1.4 $Id$) | mysql (1.0) | mysqli (0.1) | Phar (2.0.1) | pdo_mysql (1.0.2) | PDO_ODBC (1.0.1) | pdo_pgsql (1.0.2) | pdo_sqlite (1.0.1) | pgsql () | shmop () | soap () | pdo_sqlsrv (3.0.3421.0) | sqlsrv (3.0.3421.0) | xsl (0.1) | mhash () | ionCube Loader () | Zend Guard Loader () | Zend Engine (2.3.0) |
Potential Missing Extensions :: suhosin |

Switch User Environment (Experimental) :: PHP CGI: Yes | Server SU: No | PHP SU: Yes | Custom SU (LiteSpeed/Cloud/Grid): No
Potential Ownership Issues: Maybe
Folder Permissions :: wrote:Core Folders :: images/ (777) | components/ (777) | modules/ (777) | plugins/ (777) | language/ (777) | templates/ (777) | cache/ (777) | logs/ (777) | tmp/ (777) | administrator/components/ (777) | administrator/modules/ (777) | administrator/language/ (777) | administrator/templates/ (777) |

Elevated Permissions (First 10) :: administrator/ (777) | administrator/cache/ (777) | administrator/components/ (777) | administrator/components/com_admin/ (777) | administrator/components/com_admin/controllers/ (777) | administrator/components/com_admin/helpers/ (777) | administrator/components/com_admin/helpers/html/ (777) | administrator/components/com_admin/models/ (777) | administrator/components/com_admin/models/forms/ (777) | administrator/components/com_admin/sql/ (777) |
Extensions Discovered :: wrote:Components :: SITE :: com_mailto (3.0.0) | com_wrapper (3.0.0) |
Components :: ADMIN :: com_admin (3.0.0) | com_banners (3.0.0) | com_cache (3.0.0) | com_categories (3.0.0) | com_checkin (3.0.0) | com_config (3.0.0) | com_content (3.0.0) | com_cpanel (3.0.0) | com_finder (3.0.0) | com_installer (3.0.0) | com_joomlaupdate (3.0.0) | com_languages (3.0.0) | com_login (3.0.0) | com_media (3.0.0) | com_menus (3.0.0) | com_messages (3.0.0) | com_modules (3.0.0) | com_newsfeeds (3.0.0) | com_plugins (3.0.0) | com_redirect (3.0.0) | com_search (3.0.0) | com_tags (3.1.0) | com_templates (3.0.0) | com_users (3.0.0) | com_weblinks (3.0.0) |

Modules :: SITE :: mod_articles_archive (3.0.0) | mod_articles_categories (3.0.0) | mod_articles_category (3.0.0) | mod_articles_latest (3.0.0) | mod_articles_news (3.0.0) | mod_articles_popular (3.0.0) | mod_banners (3.0.0) | mod_breadcrumbs (3.0.0) | mod_custom (3.0.0) | mod_feed (3.0.0) | mod_finder (3.0.0) | mod_footer (3.0.0) | mod_languages (3.0.0) | mod_login (3.0.0) | mod_menu (3.0.0) | mod_random_image (3.0.0) | mod_related_items (3.0.0) | mod_search (3.0.0) | mod_stats (3.0.0) | mod_syndicate (3.0.0) | mod_tags_popular (3.1.0) | mod_tags_similar (3.1.0) | mod_users_latest (3.0.0) | mod_weblinks (3.0.0) | mod_whosonline (3.0.0) | mod_wrapper (3.0.0) |
Modules :: ADMIN :: mod_custom (3.0.0) | mod_feed (3.0.0) | mod_latest (3.0.0) | mod_logged (3.0.0) | mod_login (3.0.0) | mod_menu (3.0.0) | mod_multilangstatus (3.0.0) | mod_popular (3.0.0) | mod_quickicon (3.0.0) | mod_stats_admin (3.0.0) | mod_status (3.0.0) | mod_submenu (3.0.0) | mod_title (3.0.0) | mod_toolbar (3.0.0) | mod_version (3.0.0) |

Plugins :: SITE :: plg_authentication_gmail (3.0.0) | plg_authentication_joomla (3.0.0) | plg_authentication_ldap (3.0.0) | plg_captcha_recaptcha (3.0.0) | plg_content_emailcloak (3.0.0) | plg_content_finder (3.0.0) | plg_content_joomla (3.0.0) | plg_content_loadmodule (3.0.0) | plg_content_pagebreak (3.0.0) | plg_content_pagenavigation (3.0.0) | plg_content_vote (3.0.0) | plg_editors_codemirror (1.0) | plg_editors_tinymce (3.5.6) | plg_editors-xtd_article (3.0.0) | plg_editors-xtd_image (3.0.0) | plg_editors-xtd_pagebreak (3.0.0) | plg_editors-xtd_readmore (3.0.0) | plg_extension_joomla (3.0.0) | plg_finder_categories (3.0.0) | plg_finder_contacts (3.0.0) | plg_finder_content (3.0.0) | plg_finder_newsfeeds (3.0.0) | plg_finder_tags (3.0.0) | plg_finder_weblinks (3.0.0) | plg_quickicon_extensionupdate (3.0.0) | plg_quickicon_joomlaupdate (3.0.0) | plg_search_categories (3.0.0) | plg_search_contacts (3.0.0) | plg_search_content (3.0.0) | plg_search_newsfeeds (3.0.0) | plg_search_weblinks (3.0.0) | plg_system_cache (3.0.0) | plg_system_debug (3.0.0) | plg_system_highlight (3.0.0) | plg_system_languagecode (3.0.0) | plg_system_languagefilter (3.0.0) | plg_system_log (3.0.0) | plg_system_logout (3.0.0) | plg_system_p3p (3.0.0) | plg_system_redirect (3.0.0) | plg_system_remember (3.0.0) | plg_system_sef (3.0.0) | plg_user_contactcreator (3.0.0) | plg_user_joomla (3.0.0) | plg_user_profile (3.0.0) |
Templates Discovered :: wrote:Templates :: SITE :: beez3 (3.1.0) | protostar (1.0) |
Templates :: ADMIN :: hathor (3.0.0) | isis (1.0) |

CanZ
Joomla! Fledgling
Joomla! Fledgling
Posts: 1
Joined: Wed Jul 31, 2013 11:47 pm

Re: SQL Server 2008 R2: Database sqlsrv_connect

Post by CanZ » Thu Aug 01, 2013 12:07 am

Hello,

I'm having this same issue. Were you able to figure it out?

Thanks.

viperion69
Joomla! Fledgling
Joomla! Fledgling
Posts: 1
Joined: Tue Aug 06, 2013 7:12 pm

Re: SQL Server 2008 R2: Database sqlsrv_connect

Post by viperion69 » Tue Aug 06, 2013 7:17 pm

:( Has anyone found answers to this? I am also having the same problem. I have php 5.4.17, I have the Microsoft driver 3.0 installed and the extensions running. Everything looks good.

Joomla 3.1.1

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

Windows Server 2008 R2
IIS 7.5 w/FastCGI
php 5.4.17
Windows (SQL) Driver 3.0 and extensions running
PHP Manager for IIS 1.2
SQL 2008 R2

PizzoL
Joomla! Fledgling
Joomla! Fledgling
Posts: 2
Joined: Fri Mar 19, 2010 4:53 pm

Re: SQL Server 2008 R2: Database sqlsrv_connect

Post by PizzoL » Wed Nov 19, 2014 6:00 pm

Hi, i get stuck in the same step.
Have someone passed of this "failed connection"?

ccyeh0901
Joomla! Fledgling
Joomla! Fledgling
Posts: 2
Joined: Mon Apr 03, 2017 10:05 pm

Re: SQL Server 2008 R2: Database sqlsrv_connect

Post by ccyeh0901 » Sun Jul 08, 2018 12:00 am

seems no one've figured it out yet.....

I've successful connect to sql server using Codeigniter with php 5.6, 7.0, so I assumed that Joomla connecting to sql server is not thing difficult....hope some one tried it out can share the experience, please:~~~~

User avatar
Per Yngve Berg
Joomla! Master
Joomla! Master
Posts: 30814
Joined: Mon Oct 27, 2008 9:27 pm
Location: Romerike, Norway

Re: SQL Server 2008 R2: Database sqlsrv_connect

Post by Per Yngve Berg » Sun Jul 08, 2018 8:22 am

Please don't use SQL Server. The support will be dropped in the next version of Joomla, and you have to rebuild your site.


Locked

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