I'm in a jam. working on a migration project from SQL 2000 to SQL2008 R2 on a windows 2008 R2 box with IIS7 now installed.
The old server had 3 simple virtual directories with XML templates installed on them. The 'IIS Virtual Directory Management for SQL Server' was installed to control SQL account access to each of the folders so the code in the database could access the templates.
I have recreated the virtual directories on the new server, but SQL server IIS snap is now discontinued, can anyone shed anylight how I would configure this to work in IIS7 with SQL2008 R2?
Any Help much appreciated !