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.
| Author |
Topic |
|
drpcken
Starting Member
20 Posts |
 Posted - 2005-02-18 : 16:01:09
|
| I setup everything on my win2003 server and deploy my reports. When I go to http://servername/reportserver/ and go to a report and try to view it, it asks for login and pass, I enter them and always get the same error:An error has occurred during report processing. (rsProcessingAborted) Get Online HelpCannot create a connection to data source 'RCMR'. (rsErrorOpeningConnection) Get Online HelpLogin failed for user 'drpcken'.Always happens. Even when I try to login as administrator. This user is setup locally on the Reports Server and has access to the folders (as far as I know) Where else could I be missing credentials to let this user view the report?but also... I have another report that doesn't give this error at all. It doesn't even ask for login and pass, it just generates it, I see no difference between the two security wise....Thank you! |
|
|
drpcken
Starting Member
20 Posts |
Posted - 2005-02-18 : 16:18:40
|
| Ok i figured that out, it wanted a sql account login (the login textboxes on top of report)...but when I'm at the desk of the guy who needs to view the reportserver, and go to http://servername/reports it just shows the header it seems. All i see is the HOME header at the top with nothing at the bottom. Anyone seen this? |
 |
|
|
drpcken
Starting Member
20 Posts |
Posted - 2005-02-18 : 17:19:33
|
| ok here's what I got so far...this user is logged into domain ABC. So I setup the IIS for his ABC\drpcken user to have full rights to the reports and reportserver virtual directory.When I'm on the reports server machine, and go to http://servername/reports i am prompted for a username and pass, i enter drpcken and the pass, and it works perfectly.however when i go to drpcken's machine on the network, and do the same thing, I am NOT prompted for a password and it goes directly to the report server header, that just says HOME My Settings, Subscriptions, Site Settings etc... but there is nothing below that. no report directory listing or anything...Very frustrating, I can't figure out why i can log in as him on the server and it works, but when I'm at his machine and he's logged into the domain with the account that it doesnt. His machine is Windows 98 by the way (yes I know, beyond my power)Thanks! |
|
|
|
|
|
|
|
|
weird security issue