Connection issues with MSSQL 2008

This forum is for issues with installing Joomla! 2.5 (All 1.6 and 1.7 releases have reached end of life and should be updated to 2.5.) 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.
Post Reply
brewhaus
Joomla! Apprentice
Joomla! Apprentice
Posts: 5
Joined: Thu Sep 04, 2014 2:16 pm

Connection issues with MSSQL 2008

Post by brewhaus » Thu Sep 04, 2014 2:25 pm

I apologize in advance if this has been answered previously, but I have searched the forums for more than a day and not managed to find anything that solved our problem. We are trying to install Joomla 2.5.4 to run on MSSQL Server. Specs are as follows:

Joomla 2.5.4
MS Server 2008 R2
IIS 7.5
MSSQL 2008 Standard
PHP 5.4.31

I have uploaded the SQL extensions (v3.0) to the PHP/ext folder and referenced them at the bottom of the PHP configuration file. I know that this part was successful as we originally had only MySQL and MySQLi options, and we now have SQLSRV and SQLAZURE options in the DB type list. I have also tested the DB connection via an ODBC connection test, and that was successful (ie. the DB is available and accessible). However, when we try to set up Joomla we get the following error:

Could not connect to the database. Connector returned number: Unable to connect to the Database: JLIB_DATABASE_ERROR_CONNECT_SQLSRV

Can anyone help with this? I am sure that I am just overlooking something, but cannot seem to figure out what that is.
Thanks in advance! :)
Rick

User avatar
pe7er
Joomla! Master
Joomla! Master
Posts: 21959
Joined: Thu Aug 18, 2005 8:55 pm
Location: Nijmegen, The Netherlands
Contact:

Re: Connection issues with MSSQL 2008

Post by pe7er » Thu Sep 04, 2014 2:53 pm

brewhaus wrote:We are trying to install Joomla 2.5.4 to run on MSSQL Server.
Please always upgrade to the latest Joomla version within the same series first before trying to solve errors with an older version. Possible bugs might have been solved in the meantime, and it's a waste of time trying to solve issues that are caused because of non-updated software...

The latest version in the 2.5 series is Joomla 2.5.24 and in the 3.x series Joomla 3.3.3: http://www.joomla.org/download.html
Kind Regards,
Peter Martin, Global Moderator
https://db8.nl - Joomla specialist, Nijmegen, Nederland
Co-founder of data2.eu GDPR Tool https://data2.eu/en/gdpr-tool

brewhaus
Joomla! Apprentice
Joomla! Apprentice
Posts: 5
Joined: Thu Sep 04, 2014 2:16 pm

Re: Connection issues with MSSQL 2008

Post by brewhaus » Thu Sep 04, 2014 3:57 pm

My mistake- you are correct, and we are trying to install 2.5.24. The reason for using 2.5 instead of 3.3 is because we were told that Virtuemart is not necessarily compatible with 3.3, and so it was best to use 2.5.24. If that was incorrect then I am happy to try installing 3.3.3.

Until a couple of days ago I had not heard of Joomla (but, admittedly, I have not looked as we have functional software for our ecomm sites), but I really like the features that are available for it, so we would like to install and consider transitioning over. That install part is our problem.

Rick

User avatar
pe7er
Joomla! Master
Joomla! Master
Posts: 21959
Joined: Thu Aug 18, 2005 8:55 pm
Location: Nijmegen, The Netherlands
Contact:

Re: Connection issues with MSSQL 2008

Post by pe7er » Fri Sep 05, 2014 12:12 pm

I'm sorry, but I don't have much experience with hosting a website on Windows / IIS / MSSQL.

Does your SQL Server meet the requirements that are specified in http://www.joomla.org/technical-requirements.html ?
Kind Regards,
Peter Martin, Global Moderator
https://db8.nl - Joomla specialist, Nijmegen, Nederland
Co-founder of data2.eu GDPR Tool https://data2.eu/en/gdpr-tool

brewhaus
Joomla! Apprentice
Joomla! Apprentice
Posts: 5
Joined: Thu Sep 04, 2014 2:16 pm

Re: Connection issues with MSSQL 2008

Post by brewhaus » Fri Sep 05, 2014 2:38 pm

Yes, we meet all of the requirements listed for Joomla 2.5.24 and 3.3.3.

brewhaus
Joomla! Apprentice
Joomla! Apprentice
Posts: 5
Joined: Thu Sep 04, 2014 2:16 pm

Re: Connection issues with MSSQL 2008

Post by brewhaus » Sat Sep 06, 2014 7:29 pm

Finally got through the install (had to install SQL Server Express 2008 R2 and updated Native Client), but after the install, when you try to go to the website, there is just long error with respect to SQL (starts with Microsoft][SQL Server Native Client 11.0][SQL Server]Incorrect syntax near the keyword 'LEFT'.SQL=SELECT * FROM ( SELECT a.id, a.title, a.alias, a.title_alias, a.introtext, a.language, a.checked_out, a.checked_out_time...). You can see the entire error at dev2.brewhaus.com.

There was an error noted when trying to remove the Installation folder, and Joomla will not allow us to log in using the credentials provided during setup- it says that those credentials do not have administrator privileges.

So, we are closer, but still having issues. Does anyone have any thoughts?

anirbanghatak
Joomla! Fledgling
Joomla! Fledgling
Posts: 1
Joined: Thu Mar 08, 2018 4:28 pm

Re: Connection issues with MSSQL 2008

Post by anirbanghatak » Thu Mar 08, 2018 4:32 pm

Hi All,

I am using Joomla 2.5.8 with ms sqlserver 2008,Installations done properly but while connection module i am getting error jlib_database_error_connect_sqlsrv , I am using & jdatabase::getinstance() to connect.

KIndly help please


Post Reply

Return to “Joomla! 2.5 on IIS webserver”