Install joomla 2.5 using SQL server db!
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.
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.
-
- Joomla! Apprentice
- Posts: 8
- Joined: Tue Jan 24, 2012 6:10 pm
Install joomla 2.5 using SQL server db!
Hello,
so I could read one of the main advantages of version 2.5 is to be possible to install other versions of the database such as SQL server.
However when installing this option did not appear, only the mysql! How do I install this using sql?
TKs in advance
so I could read one of the main advantages of version 2.5 is to be possible to install other versions of the database such as SQL server.
However when installing this option did not appear, only the mysql! How do I install this using sql?
TKs in advance
-
- Joomla! Enthusiast
- Posts: 207
- Joined: Fri Sep 19, 2008 12:03 am
- Location: Sydney, Australia
- Contact:
Re: Install joomla 2.5 using SQL server db!
Step 4 (database) of the installation should have Sqlsrv in the database type drop down.
To install on SQL database, you need to ensure that you have sqlsrv support enabled in your php configuration. If you take a look at your phpinfo, you should see a section called sqlsrv.
On my computer I had to download a new sql dll file, which I loaded via my php.ini file
To install on SQL database, you need to ensure that you have sqlsrv support enabled in your php configuration. If you take a look at your phpinfo, you should see a section called sqlsrv.
On my computer I had to download a new sql dll file, which I loaded via my php.ini file
Code: Select all
extension=php_sqlsrv_53_ts_vc9.dll
Tim Plummer - Tweet @bfsurvey
-
- Joomla! Apprentice
- Posts: 8
- Joined: Tue Jan 24, 2012 6:10 pm
Re: Install joomla 2.5 using SQL server db!
im going to try again, but like i said before in step 4 only appear mysql.
Tks
Tks
-
- Joomla! Apprentice
- Posts: 8
- Joined: Tue Jan 24, 2012 6:10 pm
Re: Install joomla 2.5 using SQL server db!
mssql
MSSQL Support enabled
Active Persistent Links 0
Active Links 0
Library version 7.0
Directive Local Value Master Value
mssql.allow_persistent On On
mssql.batchsize 0 0
mssql.compatability_mode Off Off
mssql.connect_timeout 5 5
mssql.datetimeconvert On On
mssql.max_links Unlimited Unlimited
mssql.max_persistent Unlimited Unlimited
mssql.max_procs Unlimited Unlimited
mssql.min_error_severity 10 10
mssql.min_message_severity 10 10
mssql.secure_connection Off Off
mssql.textlimit 1048576 1048576
mssql.textsize 1048576 1048576
mssql.timeout 60 60
i belive i need to reinstall de dll, right?
MSSQL Support enabled
Active Persistent Links 0
Active Links 0
Library version 7.0
Directive Local Value Master Value
mssql.allow_persistent On On
mssql.batchsize 0 0
mssql.compatability_mode Off Off
mssql.connect_timeout 5 5
mssql.datetimeconvert On On
mssql.max_links Unlimited Unlimited
mssql.max_persistent Unlimited Unlimited
mssql.max_procs Unlimited Unlimited
mssql.min_error_severity 10 10
mssql.min_message_severity 10 10
mssql.secure_connection Off Off
mssql.textlimit 1048576 1048576
mssql.textsize 1048576 1048576
mssql.timeout 60 60
i belive i need to reinstall de dll, right?
-
- Joomla! Fledgling
- Posts: 2
- Joined: Wed Jan 25, 2012 9:45 am
Re: Install joomla 2.5 using SQL server db!
Hi,
I have the same problems before
To solve this problem, I make some modifications to my server :
STEP 1 - Download and install Microsoft Drivers for PHP for SQL Server
http://www.microsoft.com/download/en/de ... n&id=20098
- Download SQLSRV20.EXE to a temporary directory
- Run SQLSRV20.EXE
- When prompted, enter the path to the PHP extensions directory
- After extracting the files, read the Installation section of the SQLSRV20_Readme.htm file for next steps
STEP 2 - install "Microsoft SQL Server 2008 Native Client"
http://www.microsoft.com/downloads/fr-f ... BED18FE73C
STEP 3 - update your php.ini file
add these lines :
extension=php_sqlsrv_53_ts_vc9.dll
extension=php_pdo_sqlsrv_53_nts_vc9.dll
I hope it will help you
I have the same problems before
To solve this problem, I make some modifications to my server :
STEP 1 - Download and install Microsoft Drivers for PHP for SQL Server
http://www.microsoft.com/download/en/de ... n&id=20098
- Download SQLSRV20.EXE to a temporary directory
- Run SQLSRV20.EXE
- When prompted, enter the path to the PHP extensions directory
- After extracting the files, read the Installation section of the SQLSRV20_Readme.htm file for next steps
STEP 2 - install "Microsoft SQL Server 2008 Native Client"
http://www.microsoft.com/downloads/fr-f ... BED18FE73C
STEP 3 - update your php.ini file
add these lines :
extension=php_sqlsrv_53_ts_vc9.dll
extension=php_pdo_sqlsrv_53_nts_vc9.dll
I hope it will help you
-
- Joomla! Fledgling
- Posts: 2
- Joined: Wed Jan 25, 2012 9:45 am
Re: Install joomla 2.5 using SQL server db!
Note : i have a problem to connect to my SQL server, i don't know for the moment where the problem is ... but, i can see the list with the option "Sqlsrv" ...
-
- Joomla! Apprentice
- Posts: 8
- Joined: Tue Jan 24, 2012 6:10 pm
Re: Install joomla 2.5 using SQL server db!
My host sayd its not possible to replicate that alteration, but i read above it´s only need to alterate the php.ini, can you confirm that?
-
- Joomla! Apprentice
- Posts: 8
- Joined: Tue Jan 24, 2012 6:10 pm
Re: Install joomla 2.5 using SQL server db!
i recieved the following anwser of my host:
so MS SQL is suported or not?I only see that MySQL is supported on this page. If you think this is incorrect, please check with Joomla Support to see why MSSQL is not a supported database. As well, the features page you directed me to states:
"If your company has a different type of SQL database, such as MS SQL, then you'd have to make changes to the Joomla software to make it work, which makes updating difficult. Joomla has been rewritten so that different drivers can be written for different versions of SQL databases. Current drivers exist for the MySQL and MS SQL databases, with PostgreSQL, Oracle, SQLite and PDO drivers close to being ready."
Have you written a different driver, as specified, for MS SQL? Please contact Joomla Support if you need further assistance with creating the proper driver as outlined above.
-
- Joomla! Apprentice
- Posts: 8
- Joined: Tue Jan 24, 2012 6:10 pm
Re: Install joomla 2.5 using SQL server db!
it is possile to force the configuration.php file to use ms sql?
where i can find the script for the ms sql db?
where i can find the script for the ms sql db?
-
- Joomla! Enthusiast
- Posts: 207
- Joined: Fri Sep 19, 2008 12:03 am
- Location: Sydney, Australia
- Contact:
Re: Install joomla 2.5 using SQL server db!
Yes MS SQL is definately supported by Joomla 2.5, please refer to
http://www.joomla.org/announcements/rel ... eased.html
I've had a look at the source code, and I can see that in /installation/models/forms/database.xml, the type for that field is databaseconnection
This appears to be populating the list of database types using the code in
/libraries/joomla/forms/fields/databaseconnection.php
and this code checks to see which database types are supported by your webserver, and only shows you the ones that will work.
I did a test and disabled in my php.ini
Then I restarted apache and I can now only see mysqli and mysql. I also note that in step 2, the database support shows
Database Support:
(mysql, mysqli)
as opposed to what I saw before
Database Support:
(mysql, mysqli, sqlazure, sqlsrv)
So basically, if you don't see sqlsrv in the list, then I'd say that your php.ini is not configured correctly to load the sql drivers. Although it would be possible to hack the above and force sqlsrv in the list, if your php is not configured correctly, it's not going to work anyway, as it wont be able to find your database and it will just fail on the next step of the installation.
In my case I had to download a new sql driver as the one included in xampp did not work for me. There are several available so you need to load the correct one for your server, which will depend on your php version and whether you need the thread safe version or not. If you google "How to install SQL Server Driver for PHP", you should find some tutorials that will show you how to set it up and where to download the drivers from. Essentially you just download the correct dll file and copy it into C:\xampp\php\ext, then adjust your php.ini to load it.
http://www.joomla.org/announcements/rel ... eased.html
I've had a look at the source code, and I can see that in /installation/models/forms/database.xml, the type for that field is databaseconnection
Code: Select all
<field name="db_type" type="databaseconnection"
id="db_type" class="inputbox"
label="INSTL_DATABASE_TYPE_LABEL"
supported="mysql,mysqli,sqlsrv,sqlazure"
required="true"
default="mysqli"
filter="string"
/>
/libraries/joomla/forms/fields/databaseconnection.php
and this code checks to see which database types are supported by your webserver, and only shows you the ones that will work.
I did a test and disabled in my php.ini
Code: Select all
extension=php_sqlsrv_53_ts_vc9.dll
Database Support:
(mysql, mysqli)
as opposed to what I saw before
Database Support:
(mysql, mysqli, sqlazure, sqlsrv)
So basically, if you don't see sqlsrv in the list, then I'd say that your php.ini is not configured correctly to load the sql drivers. Although it would be possible to hack the above and force sqlsrv in the list, if your php is not configured correctly, it's not going to work anyway, as it wont be able to find your database and it will just fail on the next step of the installation.
In my case I had to download a new sql driver as the one included in xampp did not work for me. There are several available so you need to load the correct one for your server, which will depend on your php version and whether you need the thread safe version or not. If you google "How to install SQL Server Driver for PHP", you should find some tutorials that will show you how to set it up and where to download the drivers from. Essentially you just download the correct dll file and copy it into C:\xampp\php\ext, then adjust your php.ini to load it.
Tim Plummer - Tweet @bfsurvey
-
- Joomla! Apprentice
- Posts: 13
- Joined: Tue Mar 02, 2010 4:32 pm
Re: Install joomla 2.5 using SQL server db!
I followed the instructions and have the following in my PHP.ini file... no luck. this is a windows box. sqlsrv does not show up as an option when installing Joomla 2.5
extension=php_mssql.dll
extension=php_mysql.dll
extension=php_pdo_sqlsrv_52_nts_vc6.dll
extension=php_pdo_sqlsrv_52_ts_vc6.dll
extension=php_pdo_sqlsrv_53_nts_vc6.dll
extension=php_pdo_sqlsrv_53_nts_vc9.dll
extension=php_pdo_sqlsrv_53_ts_vc6.dll
extension=php_pdo_sqlsrv_53_ts_vc9.dll
extension=php_mssql.dll
extension=php_mysql.dll
extension=php_pdo_sqlsrv_52_nts_vc6.dll
extension=php_pdo_sqlsrv_52_ts_vc6.dll
extension=php_pdo_sqlsrv_53_nts_vc6.dll
extension=php_pdo_sqlsrv_53_nts_vc9.dll
extension=php_pdo_sqlsrv_53_ts_vc6.dll
extension=php_pdo_sqlsrv_53_ts_vc9.dll
-
- Joomla! Enthusiast
- Posts: 207
- Joined: Fri Sep 19, 2008 12:03 am
- Location: Sydney, Australia
- Contact:
Re: Install joomla 2.5 using SQL server db!
You shouldn't be loading every sqlsrv extension, just the correct one for your server. For starters, what php version are you using, 5.2 or 5.3? Then you need to determine if you need the thread safe version or not.vickyb wrote:I followed the instructions and have the following in my PHP.ini file... no luck. this is a windows box. sqlsrv does not show up as an option when installing Joomla 2.5
extension=php_mssql.dll
extension=php_mysql.dll
extension=php_pdo_sqlsrv_52_nts_vc6.dll
extension=php_pdo_sqlsrv_52_ts_vc6.dll
extension=php_pdo_sqlsrv_53_nts_vc6.dll
extension=php_pdo_sqlsrv_53_nts_vc9.dll
extension=php_pdo_sqlsrv_53_ts_vc6.dll
extension=php_pdo_sqlsrv_53_ts_vc9.dll
You will need to restart php for the change to take effect.
Tim Plummer - Tweet @bfsurvey
-
- Joomla! Fledgling
- Posts: 3
- Joined: Fri Jan 27, 2012 12:51 am
Re: Install joomla 2.5 using SQL server db!
Greetings everybody!
I've tried so hard to set the joomla 2.5 installation to be on SQL SERVER 2008, yet I haven't been able to achieve it even though i've followed carefully every single step described in this formun!
help me out, SQL server is my only option, eny information regarding this will be really, really appreciated
I've tried so hard to set the joomla 2.5 installation to be on SQL SERVER 2008, yet I haven't been able to achieve it even though i've followed carefully every single step described in this formun!
help me out, SQL server is my only option, eny information regarding this will be really, really appreciated
-
- Joomla! Enthusiast
- Posts: 207
- Joined: Fri Sep 19, 2008 12:03 am
- Location: Sydney, Australia
- Contact:
Re: Install joomla 2.5 using SQL server db!
Take a look at phpinfo, which you can do by creating a file with the following:gmjgrs wrote:Greetings everybody!
I've tried so hard to set the joomla 2.5 installation to be on SQL SERVER 2008, yet I haven't been able to achieve it even though i've followed carefully every single step described in this formun!
help me out, SQL server is my only option, eny information regarding this will be really, really appreciated
<?php echo phpinfo(); ?>
You should see a sqlsrv section like screenshot attached. If you don't, then there is something wrong with your php configuration.
You do not have the required permissions to view the files attached to this post.
Tim Plummer - Tweet @bfsurvey
-
- Joomla! Apprentice
- Posts: 8
- Joined: Tue Jan 24, 2012 6:10 pm
Re: Install joomla 2.5 using SQL server db!
gmjgrs,
your server is a shared hosted one?
if so you have to talk whit the admin and ask to change the config.
your server is a shared hosted one?
if so you have to talk whit the admin and ask to change the config.
-
- Joomla! Fledgling
- Posts: 3
- Joined: Fri Jan 27, 2012 12:51 am
Re: Install joomla 2.5 using SQL server db!
Tracta and tuum thanks for replying.
The deal is than I've already checked that the slqsvr is running properly in the php slq native client 10 is installed and everyhting seems to be set up, btw i run my own host so I can change as many settings as I want. Yet no way to get sqlsvr in the list of database step 4 =(
Thanks in advance
The deal is than I've already checked that the slqsvr is running properly in the php slq native client 10 is installed and everyhting seems to be set up, btw i run my own host so I can change as many settings as I want. Yet no way to get sqlsvr in the list of database step 4 =(
Thanks in advance
-
- Joomla! Apprentice
- Posts: 14
- Joined: Thu Jun 08, 2006 11:31 am
Re: Install joomla 2.5 using SQL server db!
I have a windows 2003 server running iis 6 with php and mysql installed. been running joomla 1.6 and 1.7 for the past several months, a few oddities but mostly works great.
Tried to change the settings to install 2.5.0 using sqlsrv.
1) downloaded and installed sqlsrv20.exe
2) downloaded and installed correct php extension libraries
3) changed my php.ini file as described.
restarted the server and Sqlsvr appears as a new option. Hurray!!!
However when trying to install, entering what I think is appropriate info, the installer says:
Could not connect to the database. Connector returned number: 2
db type Sqlsrv
hostname (tried localhost, 127.0.0.1, servername\sqlserver, server's ip)
username sa
password (the appropriate password, have some asp files running on the server as well, verified)
Did I miss something?
Thanks for any help.
Tried to change the settings to install 2.5.0 using sqlsrv.
1) downloaded and installed sqlsrv20.exe
2) downloaded and installed correct php extension libraries
3) changed my php.ini file as described.
restarted the server and Sqlsvr appears as a new option. Hurray!!!
However when trying to install, entering what I think is appropriate info, the installer says:
Could not connect to the database. Connector returned number: 2
db type Sqlsrv
hostname (tried localhost, 127.0.0.1, servername\sqlserver, server's ip)
username sa
password (the appropriate password, have some asp files running on the server as well, verified)
Did I miss something?
Thanks for any help.
-
- Joomla! Fledgling
- Posts: 2
- Joined: Mon Jan 09, 2012 2:45 pm
Re: Install joomla 2.5 using SQL server db!
Hello everyone,
I'm new on the Joomla! forum and this is my first problem I've encountered.
I've Joomla! for several years, starting with version 1.0, but decided it was time to go to the next release.
After installing Joomla! 2.5 on a local WampServer and using MS SqlServer 2008 for the database I'm faced a lot of problems.
First, installing Joola! seems to finish without problems. Then, after changing some setting I've noticed the following:
1) Whenever a backslash is included in a parameter, it get's escaped. Thsi should be noraml except that this 'escaping' is recursive: every save every backslash is escaped, so after four saves I end up with eight backslashes. I've inspected this in the database and they are there, but because backslashes get escaped, in the database field the're sixteen of them.
I've also inspected the sample data that is installed if you opt for it. Any bouble backslash in the sql file is insert with the double count, so four instead of the expected two.
2) When I try to write an article the Categories are not retreived and it get the following error:
[Microsoft][SQL Server Native Client 10.0][SQL Server]Column 'labc_categories.published' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause.SQL=SELECT a.id AS value, a.title AS text, a.level, a.published FROM labc_categories AS a LEFT JOIN [labc_categories] AS b ON a.lft > b.lft AND a.rgt < b.rgt WHERE (a.extension = N'com_content') AND a.published IN (0,1) GROUP BY a.id, a.title, a.level, a.lft, a.rgt, a.extension, a.parent_id ORDER BY a.lft ASC
This is also true for any component which uses the Categories.
There are some other issues but I guess they may be related so Id like to concentrate on these two.
Can any body help me?
I'm new on the Joomla! forum and this is my first problem I've encountered.
I've Joomla! for several years, starting with version 1.0, but decided it was time to go to the next release.
After installing Joomla! 2.5 on a local WampServer and using MS SqlServer 2008 for the database I'm faced a lot of problems.
First, installing Joola! seems to finish without problems. Then, after changing some setting I've noticed the following:
1) Whenever a backslash is included in a parameter, it get's escaped. Thsi should be noraml except that this 'escaping' is recursive: every save every backslash is escaped, so after four saves I end up with eight backslashes. I've inspected this in the database and they are there, but because backslashes get escaped, in the database field the're sixteen of them.
I've also inspected the sample data that is installed if you opt for it. Any bouble backslash in the sql file is insert with the double count, so four instead of the expected two.
2) When I try to write an article the Categories are not retreived and it get the following error:
[Microsoft][SQL Server Native Client 10.0][SQL Server]Column 'labc_categories.published' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause.SQL=SELECT a.id AS value, a.title AS text, a.level, a.published FROM labc_categories AS a LEFT JOIN [labc_categories] AS b ON a.lft > b.lft AND a.rgt < b.rgt WHERE (a.extension = N'com_content') AND a.published IN (0,1) GROUP BY a.id, a.title, a.level, a.lft, a.rgt, a.extension, a.parent_id ORDER BY a.lft ASC
This is also true for any component which uses the Categories.
There are some other issues but I guess they may be related so Id like to concentrate on these two.
Can any body help me?
-
- Joomla! Enthusiast
- Posts: 207
- Joined: Fri Sep 19, 2008 12:03 am
- Location: Sydney, Australia
- Contact:
Re: Install joomla 2.5 using SQL server db!
Firstly, have you created the new database in SQL Server?duetltd wrote: Could not connect to the database. Connector returned number: 2
db type Sqlsrv
hostname (tried localhost, 127.0.0.1, servername\sqlserver, server's ip)
username sa
password (the appropriate password, have some asp files running on the server as well, verified)
Did I miss something?
When you installed sqlsrv, what authentication mode did you select? I remember reading somewhere that you should choose mixed mode, not just the SQL authentication by itself.
On my computer, I can use either:
localhost\SQLEXPRESS
or
COMPUTERNAME\SQLEXPRESS
as the host.
Tim Plummer - Tweet @bfsurvey
-
- Joomla! Enthusiast
- Posts: 207
- Joined: Fri Sep 19, 2008 12:03 am
- Location: Sydney, Australia
- Contact:
Re: Install joomla 2.5 using SQL server db!
This sounds like something you should report on the CMS issue trackerHBlanke wrote:Hello everyone,
1) Whenever a backslash is included in a parameter, it get's escaped. Thsi should be noraml except that this 'escaping' is recursive: every save every backslash is escaped, so after four saves I end up with eight backslashes. I've inspected this in the database and they are there, but because backslashes get escaped, in the database field the're sixteen of them.
I've also inspected the sample data that is installed if you opt for it. Any bouble backslash in the sql file is insert with the double count, so four instead of the expected two.
2) When I try to write an article the Categories are not retreived and it get the following error:
[Microsoft][SQL Server Native Client 10.0][SQL Server]Column 'labc_categories.published' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause.SQL=SELECT a.id AS value, a.title AS text, a.level, a.published FROM labc_categories AS a LEFT JOIN [labc_categories] AS b ON a.lft > b.lft AND a.rgt < b.rgt WHERE (a.extension = N'com_content') AND a.published IN (0,1) GROUP BY a.id, a.title, a.level, a.lft, a.rgt, a.extension, a.parent_id ORDER BY a.lft ASC
http://joomlacode.org/gf/project/joomla ... er_id=8103
Tim Plummer - Tweet @bfsurvey
-
- Joomla! Apprentice
- Posts: 14
- Joined: Thu Jun 08, 2006 11:31 am
Re: Install joomla 2.5 using SQL server db!
I've been using sql with asp for years on the server, many db's on the system.Firstly, have you created the new database in SQL Server?
When you installed sqlsrv, what authentication mode did you select? I remember reading somewhere that you should choose mixed mode, not just the SQL authentication by itself.
On my computer, I can use either:
localhost\SQLEXPRESS
or
COMPUTERNAME\SQLEXPRESS
as the host.
***** Manual signatures are NOT allowed *****_____
Tim Plummer - Tweet @bfsurvey
I think there was an option for connect type? I think I did IP - not sure, I'll uninstall and reinstall.
Thanks for the help.
-
- Joomla! Apprentice
- Posts: 13
- Joined: Fri Apr 15, 2011 12:46 am
Re: Install joomla 2.5 using SQL server db!
If your installing Joomla on IIS and are having issues getting the 'SQLsrv' option to show in the Joomla installer it may be easiest for you to install Joomla using the 'Microsoft Web Platform Installer'. This will setup everything you need. You can download it here.
http://www.microsoft.com/web/downloads/platform.aspx
INSTALLATION STEPS
http://www.microsoft.com/web/downloads/platform.aspx
INSTALLATION STEPS
- 1. Download the application from the url provided above and run it on your webserver.
2. Once the 'Web Platform Installer 3.0' loads select Applications from the the top and it will reveal 'Joomla! 2.5' and other Applications you don't need to worry about.
3. Click the 'Add' button on the right side of 'Joomla! 2.5'.
4. Click the 'Install' button found at the bottom.
5. You will then be prompted for what type of database you would like to use
Select 'SQL Server'. Also select 'Use a remote server' from the dropdown list if your SQL Database is on a different server to your webserver.
6. The installer will then list all required dependencies.
7. Click the 'I Accept' button at the bottom to start the installation. Your server may need to be rebooted during the installation but don't worry it will continue installing all required dependencies after rebooting.
8. After installation is complete you will be asked to enter your site information. Fill out the form as required and click 'Continue'.
9. On the next page Select 'Create new database' if you do not already have one created otherwise select 'Use existing database' if you have already created it from MS SQL. Fill out the rest of the form as required and click 'Continue'.
10. The installer will do the rest once it's complete your new Joomla site is ready to go!
-
- Joomla! Fledgling
- Posts: 3
- Joined: Fri Jan 27, 2012 12:51 am
Re: Install joomla 2.5 using SQL server db!
I've doneee it!
after trying so much, thank you for ur help, I couldn't done anything without this reference, it was just that i was registering de PDO_SQLSRV drivers listed above, what you need to do is to is register de SQLSVR drivers and that's all. I'll list the drivers for further reference to somebody with the same problems :
extension=php_sqlsrv_52_nts_vc6.dll
extension=php_sqlsrv_52_ts_vc6.dll
extension=php_sqlsrv_53_nts_vc6.dll
extension=php_sqlsrv_53_nts_vc9.dll
extension=php_sqlsrv_53_ts_vc6.dll
extension=php_sqlsrv_53_ts_vc9.dll
after trying so much, thank you for ur help, I couldn't done anything without this reference, it was just that i was registering de PDO_SQLSRV drivers listed above, what you need to do is to is register de SQLSVR drivers and that's all. I'll list the drivers for further reference to somebody with the same problems :
extension=php_sqlsrv_52_nts_vc6.dll
extension=php_sqlsrv_52_ts_vc6.dll
extension=php_sqlsrv_53_nts_vc6.dll
extension=php_sqlsrv_53_nts_vc9.dll
extension=php_sqlsrv_53_ts_vc6.dll
extension=php_sqlsrv_53_ts_vc9.dll
-
- Joomla! Apprentice
- Posts: 5
- Joined: Thu Feb 16, 2012 3:58 pm
Re: Install joomla 2.5 using SQL server db!
I'm not sure if this helps anyone, but I tried installing on my shared windows hosting with GoDaddy using MSSQL as the database. I couldn't get past the database step so I reached out for help and got this response:
"After reviewing the issue with our hosting techs, it looks like the restrictions put on MSSQL in the shared environment will prevent you from using Joomla with MSSQL. You would need a Virtual Dedicated or Dedicated server plan to be able to get Joomla installed properly. "
I know they aren't a great host for Joomla, but I figure this might help some others in the future if they try the same setup I had.
"After reviewing the issue with our hosting techs, it looks like the restrictions put on MSSQL in the shared environment will prevent you from using Joomla with MSSQL. You would need a Virtual Dedicated or Dedicated server plan to be able to get Joomla installed properly. "
I know they aren't a great host for Joomla, but I figure this might help some others in the future if they try the same setup I had.
-
- Joomla! Apprentice
- Posts: 9
- Joined: Mon Nov 09, 2009 9:40 pm
Re: Install joomla 2.5 using SQL server db!
I follow those steps but, in step 3 i change for it:mika44bzh wrote:Hi,
I have the same problems before
To solve this problem, I make some modifications to my server :
STEP 1 - Download and install Microsoft Drivers for PHP for SQL Server
http://www.microsoft.com/download/en/de ... n&id=20098
- Download SQLSRV20.EXE to a temporary directory
- Run SQLSRV20.EXE
- When prompted, enter the path to the PHP extensions directory
- After extracting the files, read the Installation section of the SQLSRV20_Readme.htm file for next steps
STEP 2 - install "Microsoft SQL Server 2008 Native Client"
http://www.microsoft.com/downloads/fr-f ... BED18FE73C
STEP 3 - update your php.ini file
add these lines :
extension=php_sqlsrv_53_ts_vc9.dll
extension=php_pdo_sqlsrv_53_nts_vc9.dll
I hope it will help you
Code: Select all
;extension=php_msql.dll
;extension=php_mssql.dll
extension=php_sqlsrv_52_nts_vc6.dll
extension=php_sqlsrv_52_ts_vc6.dll
extension=php_sqlsrv_53_nts_vc6.dll
extension=php_sqlsrv_53_nts_vc9.dll
extension=php_sqlsrv_53_ts_vc6.dll
extension=php_sqlsrv_53_ts_vc9.dll
extension=php_pdo_sqlsrv_53_nts_vc9.dll
extension=php_mysql.dll
extension=php_mysqli.dll
After that i can see the Sqlsrv in the database type drop down, but after i enter the next information:
host: 172.20.x.x
DB : DFTPALM1
user: User1
pass: User1
i received the error: Could not connect to the database. Connector returned number: 2
Edit:
Ok was my fault, i wrote wrong the DataBase Name, now i'll probe that my components work fine =P
Last edited by jaaron019 on Fri Mar 30, 2012 1:03 am, edited 1 time in total.
-
- Joomla! Enthusiast
- Posts: 207
- Joined: Fri Sep 19, 2008 12:03 am
- Location: Sydney, Australia
- Contact:
Re: Install joomla 2.5 using SQL server db!
Make sure you are using SQL Server 2008, as SQL Server 2005 is not compatible with the Joomla SQL driver.
Tim Plummer - Tweet @bfsurvey
-
- Joomla! Intern
- Posts: 75
- Joined: Tue Feb 21, 2006 6:09 am
Re: Install joomla 2.5 using SQL server db!
Does it work with SQL Server 2008 Express, or not?
I am thinking of setting up a Joomla 2.5 install locally and am hoping not to have to buy SQL server yet!
I am thinking of setting up a Joomla 2.5 install locally and am hoping not to have to buy SQL server yet!
-
- Joomla! Enthusiast
- Posts: 207
- Joined: Fri Sep 19, 2008 12:03 am
- Location: Sydney, Australia
- Contact:
Re: Install joomla 2.5 using SQL server db!
Yes SQL Server 2008 Express works fine.petern wrote:Does it work with SQL Server 2008 Express, or not?
I am thinking of setting up a Joomla 2.5 install locally and am hoping not to have to buy SQL server yet!
Tim Plummer - Tweet @bfsurvey
-
- Joomla! Fledgling
- Posts: 1
- Joined: Thu Apr 19, 2012 9:47 pm
Re: Install joomla 2.5 using SQL server db!
greeeeeeeting everybody,
i have passed a lot of time trying to configure php to make sqlsrv section appears in phpinfo.
my configuration :
wamp server 2.1
php 5.3.4
MS SQL server 2008
windows 7 édition familial premuim 64 bits
i have used sqlsrv driver for php v2.0 and v3.0
i have passed a lot of time trying to configure php to make sqlsrv section appears in phpinfo.
my configuration :
wamp server 2.1
php 5.3.4
MS SQL server 2008
windows 7 édition familial premuim 64 bits
i have used sqlsrv driver for php v2.0 and v3.0
-
- Joomla! Fledgling
- Posts: 1
- Joined: Wed Feb 27, 2013 6:35 am
Re: Install joomla 2.5 using SQL server db!
So we're looking to install U-AIR for Exchange and SQL to backup/restore individual items. During the installation of the plug in, it asks for the Enterprise Manager I/P .. We purchased B&R although I dont seem to see any "enterprise manager" installation anywhere.. Am I just missing something here? Where do we get EM?
champion sportswear
champion sportswear