I've been given a requirement to create a component for a project. The server provided is a Windows server with IIS7 and MS SQL Server as the DB. No budging on the environment.

My question is, can this tool be used to create the component and integrate with the MS SQL server? I have successfully installed the environment using web matrix and the website runs great on IIS including SEF URL features.

So, I've given this 8 days and still not a peep. Can I at least get some feedback? Even a you can't use it would do. Is anyone out there?

On my own I never tried Joomla on Sql Server. In the past I worked with it, but since I am a Joomla addict, I never did any project with Windows servers.

I think it is a general Joomla question.
Cook is not specialy designer for that, but I would not think it a problem.

When you instance your DB in the table and in the model, just change database driver from those supported by Joomla.

If you want to use only for one particular table, then override the __constructor of your both models.
Change the $options in parameters. (By memory, because I do not have much time to check)

Do the same, when you want to catch a table outside of your component (or another MySql DB) and drive it with your own MVC structure.

That's it.
If you cannot do it I cam come back with more detailled explainations...

One of the issues is the script doesn't install the database. I changed the driver in the xml file to use the Sqlsrv driver but I think it's in the syntax of the install script.

I manually added the tables to the MS SQL database and didn't receive an error but nothing was getting entered into the tables.

I'm not sure what you mean by overriding the constructors. What folders/file are you speaking of?

Think Joomla3 is multi db, so version 2 of cook will be cool