Joomla 2.5.4 istallation with Ms sql 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.
Locked
spliffino
Joomla! Fledgling
Joomla! Fledgling
Posts: 3
Joined: Thu May 24, 2012 5:21 pm

Joomla 2.5.4 istallation with Ms sql 2008

Post by spliffino » Thu May 24, 2012 5:28 pm

Hi all this is my first post :D
Im trying to set up joomla with sql server 2008,
Im using windows server 2003 with php 5.3 and iis6
I set up The php with the sqlsrv extension and joomla works fine untill the database connection page in with it connects to the database server and create the tables but it doesnt go thru that and return this error.
I really need to use joomla with sql server for issues related to a private server.
please help

Code: Select all

Si sono verificati alcuni errori durante il popolamento del database: [Microsoft][SQL Server Native Client 10.0][SQL Server]La conversione di un tipo di dati varchar in datetime ha generato un valore non compreso nell'intervallo dei valori consentiti.SQL=INSERT INTO qwe_categories (id, asset_id, parent_id, lft, rgt,level, path, extension, title, alias, note, description, published, checked_out, checked_out_time, access, params, metadesc, metakey, metadata, created_user_id,created_time, modified_user_id, modified_time, hits,language) SELECT 1, 0, 0, 0, 11, 0, '', 'system', 'ROOT', 'root', '', '', 1, 0, '1900-01-01 00:00:00', 1, '{}', '', '', '', 0, '2009-10-18 16:07:09', 0, '1900-01-01 00:00:00', 0, '*' UNION ALL SELECT 2, 27, 1, 1, 2, 1, 'uncategorised', 'com_content', 'Uncategorised', 'uncategorised', '', '', 1, 0, '1900-01-01 00:00:00', 1, '{"target":"","image":""}', '', '', '{"page_title":"","author":"","robots":""}', 42, '2010-06-28 13:26:37', 0, '1900-01-01 00:00:00', 0, '*' UNION ALL SELECT 3, 28, 1, 3, 4, 1, 'uncategorised', 'com_banners', 'Uncategorised', 'uncategorised', '', '', 1, 0, '1900-01-01 00:00:00', 1, '{"target":"","image":"","foobar":""}', '', '', '{"page_title":"","author":"","robots":""}', 42, '2010-06-28 13:27:35', 0, '1900-01-01 00:00:00', 0, '*' UNION ALL SELECT 4, 29, 1, 5, 6, 1, 'uncategorised', 'com_contact', 'Uncategorised', 'uncategorised', '', '', 1, 0, '1900-01-01 00:00:00', 1, '{"target":"","image":""}', '', '', '{"page_title":"","author":"","robots":""}', 42, '2010-06-28 13:27:57', 0, '1900-01-01 00:00:00', 0, '*' UNION ALL SELECT 5, 30, 1, 7, 8, 1, 'uncategorised', 'com_newsfeeds', 'Uncategorised', 'uncategorised', '', '', 1, 0, '1900-01-01 00:00:00', 1, '{"target":"","image":""}', '', '', '{"page_title":"","author":"","robots":""}', 42, '2010-06-28 13:28:15', 0, '1900-01-01 00:00:00', 0, '*' UNION ALL SELECT 6, 31, 1, 9, 10, 1, 'uncategorised', 'com_weblinks', 'Uncategorised', 'uncategorised', '', '', 1, 0, '1900-01-01 00:00:00', 1, '{"target":"","image":""}', '', '', '{"page_title":"","author":"","robots":""}', 42, '2010-06-28 13:28:33', 0, '1900-01-01 00:00:00', 0, '*' UNION ALL SELECT 7, 32, 1, 11, 12, 1, 'uncategorised', 'com_users.notes', 'Uncategorised', 'uncategorised', '', '', 1, 0, '1900-01-01 00:00:00', 1, '{"target":"","image":""}', '', '', '{"page_title":"","author":"","robots":""}', 42, '2010-06-28 13:28:33', 0, '1900-01-01 00:00:00', 0, '*'
Last edited by humvee on Fri May 25, 2012 4:42 pm, edited 1 time in total.
Reason: Marked as resolved

User avatar
humvee
Joomla! Master
Joomla! Master
Posts: 14713
Joined: Wed Aug 17, 2005 10:27 pm
Location: Kent, England

Re: Joomla 2.5.4 istallation with Ms sql 2008

Post by humvee » Thu May 24, 2012 5:40 pm

[Mod note: Moved from Installation Forum to IIS Installation Forum;]

spliffino
Joomla! Fledgling
Joomla! Fledgling
Posts: 3
Joined: Thu May 24, 2012 5:21 pm

Re: Joomla 2.5.4 istallation with Ms sql 2008

Post by spliffino » Fri May 25, 2012 1:56 pm

right i went further with the installation by formatting pc and using microsoft web platform installer wich istalled me joomla 2.5 with needed dependencies.
It returned a proper installation of joomla but when i try to open localhost it returns me this error

Code: Select all

Database connection error (1): JLIB_DATABASE_ERROR_ADAPTER_SQLSRV
plz someone can explain me this error and in case he knows can give me a solution?

tnx for support

spliffino
Joomla! Fledgling
Joomla! Fledgling
Posts: 3
Joined: Thu May 24, 2012 5:21 pm

Re: Joomla 2.5.4 istallation with Ms sql 2008

Post by spliffino » Fri May 25, 2012 4:36 pm

Ok i asked the question and solved the problem by myself :D
i installed microsoft web platform and searched for joomla 2.5 and i saw the required dependencies it need by installing it throught micro platform, then i downloaded these dependencies and it worked. tnx for support anyway. :)


Locked

Return to “Joomla! 2.5 on IIS webserver”