July 23, 2008 at 12:40 am
I'm fairly new to SSRS but have set it up successfully in the past so I'm not sure what I've missed.
The first thing that seems a bit odd is I can't browse to or publish to the default URL of http://serverName/reportServer
The only way I can view the default reporting page is to go to...
http://systemName/reports$SDDEV/ (where SDDEV is the SQL instance name I am working with)
I have created an SQL login called RPTUser with a password of rptuser and have configured my SSRS data source to use this account when deploying / running reports. The account is a DB OWNER of the DB I'm running against and I am able to successfully log in to the SQL server and manage the DB with this account.
I have changed the credential settings on the properties of the data source to Windows authentication and none and in all cases I get prompted to enter my credentials when publishing to the 2nd URL shown above, failing each time. It always pops right back to the enter user ID and PW screen like the information being entered is wrong.
This happens if I try to publish directly from the report server or from a remote workstation.
I'm starting to worder if IIS is hosed up or if I just need to reinstall SSRS and IIS both???
Any help / thoughts would be greatly appreciated.
Bob
😀
June 25, 2009 at 11:00 am
Its normal for it to put the instance name afterwards. The default instance is as you describe and every named instance is in the server$instance format.
Its asking for credentials to the page though and IIS is unaware of SQL logins. We don't have this issue as we are windows integrated but I would suggest you look at permissions on the IIS site first and login with windows credentials that have access to your page.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply