I am running Joomla 2.5.1 on IIS server with SQL server. I'm running PHP 5.3.9 and everything seems to be working fine including core Joomla functionality.

I install the K2 Component without issues and no errors reported once completed.

However, a set of tables were not created in the database. Because of this, I can't add categories, items, tags, etc... I get errors similar to the following:

TableK2Category: :store failed
[Microsoft][SQL Server Native Client 10.0][SQL Server]Incorrect syntax near ')'.SQL=INSERT INTO [myprefix_k2_categories] () VALUES ()

I get an error when I hit the paramaters as well:

[Microsoft][SQL Server Native Client 10.0][SQL Server]Invalid object name 'myprefix_k2_user_groups'.SQL=SELECT id AS value, name AS K2UserGroup FROM myprefix_k2_user_groups

Any thoughts as to where the issue lies during the installation process?

We would hate to have to resort to Joomla core functionality on this site - K2 is MUCH more flexible and powerful.

We haven't been able to solve this issue.

We've decided to drop SQL server and use a My SQL database. Everything is working fine now. There is likely an issue between K2 and Joomla 2.5.