• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 235
  • Last Modified:

Trying to upgrade from mssql 2005 standard to mssql 2008 standard

Hi!
Attached is a picture of four errors I got when trying to upgrade from MSSQL 2005 standard to MSSQL 2008 standard. Any ideas how to fix these?
Capture.PNG
0
TrueBlue
Asked:
TrueBlue
  • 4
  • 2
2 Solutions
 
QPRCommented:
Go to the IIS websites on the server and make sure anonymous access is NOT enabled for both the reportserver and reports virtual directory.
0
 
TrueBlueAuthor Commented:
QPR:
I can not find an anonymous access option under the IIS manager for reporting.
I am using Windows 7 Pro for the operating system and under administrative tools, I found the IIS which it says is version 6. Any ideas?
0
 
QPRCommented:
expand default web site under IIS
Below here you should see 2 folders reportserver and reports.
Click on each indivdually and under the security settings ensure that anonymous access is not enabled
0
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 
TrueBlueAuthor Commented:
QPR,
I do not see an anonymous item to check if it is enabled or not.
Here is a screen shot of what I see.
Any ideas?
Capture.PNG
0
 
Faiga DiegelCommented:
To go to IIS, follow this steps:

1) Programs >> Administrative Tools >> IIS Manager
2) Browse to your machine  >> Sites >> Deafult Website (if you set it under default)
3) Go to Reports folder >> Authentication >> Anonymous Authentication. Check the value, this should be disabled
4) Go to Report Server >> Authentication >> Anonymous Authentication. Check the value, this should be disabled




0
 
TrueBlueAuthor Commented:
faiga16,

I looked at both of those folders and the anonymous authentication was already disabled.
Here is a screen shot of one of them.
Any other ideas? :)
Capture.PNG
0
 
TrueBlueAuthor Commented:
Problem not solved, but awarded points for attempt.
0

Featured Post

How to Use the Help Bell

Need to boost the visibility of your question for solutions? Use the Experts Exchange Help Bell to confirm priority levels and contact subject-matter experts for question attention.  Check out this how-to article for more information.

  • 4
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now