March 6, 2009 at 1:47 am
We are planning to upgrade SQL Server 2000 reporting services to SQL Server 2005 Reporting services.We have SQL Server 2000 default instance with reporting services installed on it and the report server n reportervertempdb also in the default instance.So we are decided to go for in-place upgrade of reporting services along with database engine.
Inorder to acheive this,I need find the answers for the below items.
1.
Security for the virtual directories must be set to Integrated Windows Authentication; Anonymous Access is not supported for an in-place upgrade
where can I check whether it is Integrated Windows Authentication or Anonymous Access in report server virtual directory n report manger virtual directory?(exact location to check)
2.The default Application Mappings should be set as follows:
a.For the report server virtual directory, the wild card mapping must point to the v1.1 aspnet_isapi.dll executable and no other script maps should exist.
b.For the Report Manager virtual directory, the .asax and .aspx extensions must point to the v1.1 aspnet_isap.dll executable
How should I veryfy the above? I went to the report server and reportmanger virtual directories but Iam not able find these items So please explain me in more detail.
thanks in advance
kln
March 6, 2009 at 5:09 pm
1.Security for the virtual directories must be set to Integrated Windows Authentication; Anonymous Access is not supported for an in-place upgrade
where can I check whether it is Integrated Windows Authentication or Anonymous Access in report server virtual directory n report manger virtual directory?(exact location to check)
You can click on Asp.net and check authentication or click on the virtual directory security, mine with Windows authentication on anonymous users are disabled by default.
2.The default Application Mappings should be set as follows:
a.For the report server virtual directory, the wild card mapping must point to the v1.1 aspnet_isapi.dll executable and no other script maps should exist.
b.For the Report Manager virtual directory, the .asax and .aspx extensions must point to the v1.1 aspnet_isap.dll executable
You need to take care of that because SSRS 2005 will not run referencing Asp.net 1.1 isapi dll, so you need to read the guide in the link below and use it as is or your code will not run. One more thing if you are in Win2003 make sure you click on details when you install IIS 6 so you can enable all the features needed to run Asp.net.
http://msdn.microsoft.com/en-us/library/ms143724(SQL.90).aspx
Kind regards,
Gift Peddie
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply