Report Builder unable to connect to SharePoint sites which contain a "-" sign
I have enabled SSRS 2008 R2 on my SP2010 farm. works well.
The problem I am facing is that if you have a site like http://myserver.mydomain.com/sites/foo-bar
The report builder will not be able to connect to it.
The error I get is
In the text box, I can enter URL of any site. if it does not contain a "-" sign report builder connects fine. but with a "-" sign it does not connect.
I also tried to replace the - sign with %2D but even that did not make report builder connect to the site.
MSDNStudent Knows not much!
June 11th, 2012 3:01am
Hi,
Just replace hyphen with %2D .
Free Windows Admin Tool Kit Click here and download it now
June 11th, 2012 3:04am
Please ignore this question. actually this is what happended
1. I connected to a site then did a login as a different user in the browser
2. launched Report builder
3. got the error above.
4. the problem is
1. the report builder is running as the credential with which I have logged in to my desktop. but on browser I had logged on to the site with a different account.
2. the error from report builder is BAD because it should say "login denied" rather than "site not found"MSDNStudent Knows not much!
June 11th, 2012 7:10am