Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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 !

share|improve this question

2 Answers 2

Beginning with SQL 2005, SQLXML access by way of IIS virtual directories was discontinued. For now, you can set up an HTTP endpoint in SQL, but as of 2008 native XML native web services are deprecated and will be removed from a later version of SQL Server.

Microsoft recommends discontinuing use and converting things over to WCF or ASP.NET. Have a look at this MSDN article.

When upgrading SQL Server, especially with as big of a jump as it is from SQL 2000 to SQL 2008 R2, you will want to run the upgrade advisor when planning your upgrade. That will help you catch situations like this.

share|improve this answer
    
yeah the problem i had was upgrade advisor would not install on the Old machine, sayig that it needed a newer service pack. On the new server it cannot detect the older machine using the same windows admin login, I have checked the remote registry service is enabled, but no joy. We are not performing a full upgrade, just recreate replication to a new big reporting server, but nobody mentioned that there were .xml templates hanging off the back. Can I setup HTTP endpoints without having to rewrite any code ? –  Chris Wood Apr 19 '11 at 14:37
up vote 0 down vote accepted

I'm amazed it works but I think I've solved this.

I installed iis on my back office SQL 2008 reporting server (I know its not recommended, but couldn't complete the migration without it). I then configured virutal directories in the exact same folder structure and files and the legacy 2000 server.

The client has tested with the amended URL and they are receiving their XML reports...

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.