Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 Other SQL Server 2008 Topics
 SQL 2008 access to XML templates

Author  Topic 

chris_wood99
Yak Posting Veteran

70 Posts

Posted - 2011-04-19 : 07:44:30
Hi,

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 !

robvolk
Most Valuable Yak

15732 Posts

Posted - 2011-04-19 : 08:04:22
To my knowledge it's been deprecated/discontinued, in favor of either ASP.Net applications or Service Broker endpoints delivered via HTTP (which have also been deprecated in SQL 2008, or at least not recommended).

Correction: I was thinking of SOAP over HTTP. It's not deprecated, but IIRC it was discouraged for future use.
Go to Top of Page
   

- Advertisement -