Reporting Services Login Box always prompting when deploying my report

Question

Post reply

Reporting Services Login Box always prompting when deploying my report

rachellebs

Ten Centuries

Points: 1144
More actions
June 25, 2008 at 4:34 am

#381361

Hi to all,
I have a problem in deploying my report in BIDS because there's a Reporting Services Login box that keeps prompting whenever I deploy my report, asking for Username and Password. I didn't set or configure a password when I installed the SQL server 2005.. I did everything search the net, configure IIS through properties of reportserver, change it's Directory Security and edit the Anonymous access and aunthentication control but no luck.
Please help...:blink:

Viewing 15 posts - 1 through 15 (of 72 total)

You must be logged in to reply to this topic. Login to reply

wu.wuqiang Ten Centuries Points: 1008 More actions · Answer 1

Try this:

When setup your datasource, on the Share Data Source dialog box menu, in Credentials tab, choose "No credentials".

Hope this helps.

Qiang

rachellebs Ten Centuries Points: 1144 More actions · Answer 2

Hi,

Sorry but It's my first time to deploy a report in BIDS and I dunno where to find the what you've said "setup datasource". Can you please tell me where to find that?:D

And also I'm wondering, does IIS have something to with authentication of the windows...or somethig to do with BIDS when deploying a report?

Thanks...:)

rachellebs Ten Centuries Points: 1144 More actions · Answer 3

Hi Qiang,

I have figure out where that datasource is, I choose the "No Credential" radio button and try again to deploy my report but no luck it is still prompting waiting for Username and Password to be type in textbox. And back in credentials tab I choose the radio button Use a specific User name and password, Deploy my report and type there what I have been set in Credentials but unfortunately it didn't work.:(

rachellebs Ten Centuries Points: 1144 More actions · Answer 4

Hi,

I have conclude that IIS is got something to do with deploying a project because when I choose Integrated Windows authentication and Anonymous Access and browse the default Web site I can browse the http://localhost/iishelp/iis/misc/default.asp and at the same time deploying the report through BIDS. It gives an error "A connection could not be made to the report server http://localhost/reportserver".

But when I unchecked Integrated Windows authentication and just leave the Anonymous Access and tried again to deploy the report, it now works, though the annoying Reporting Services Login box prompt again expecting the user to give the Username and Password.

I am all new to this... So could someone please help me?:(

Ivanna Noh SSCarpal Tunnel Points: 4138 More actions · Answer 5

try this

Open the report inside Visual Studio

On the Data tab click on the three dots next to the "Dataset" dropdown list. This will open the Dataset dialog box.

Click the button with the three dots next to the "Data Source" dropdown list. This will display the Data Source dialog box.

Click on the "Credentials" tab and select either the "Use Windows Authentication" or the "Use a specific name..." radio button. If the latter is slelected, enter a username and a password

I usually use a SQL user (not a windows user) specifically for running reports - but I would expect that using Windows Authentication would be equally successful, and wouldn't prompt for a password...

🙂

rachellebs Ten Centuries Points: 1144 More actions · Answer 6

Hi Ivannah,

I've already done that, from this post..

" I have figure out where that datasource is, I choose the "No Credential" radio button and try again to deploy my report but no luck it is still prompting waiting for Username and Password to be type in textbox. And back in credentials tab I choose the radio button Use a specific User name and password, Deploy my report and type there what I have been set in Credentials but unfortunately it didn't work. "

:crying:

don't know what to do.....:sick:

Thanks for your response...:)

Ivanna Noh SSCarpal Tunnel Points: 4138 More actions · Answer 7

when you deploy your report do you also deploy the datasource?

In Visual Studio, if you right click on the project and select 'properties', then click on 'configuration properties | general' is the 'overwritedatasource' value (under 'deployment') set to 'true'?

If not, then any changes you make to the credentials will not be deployed. I'm no expert, but have had issues with datasources in the past.

Another thing to check is: on the properties of the datasource, general tab, click the 'edit' button adjacent to the connection string and then click the test connection button. If you are using a 'specific user name and password' these should be displayed, and if correct you should be able to connect from VS at least - then check the deploy settings as per above

rachellebs Ten Centuries Points: 1144 More actions · Answer 8

Hi Ivanna,

I set the OverwriteDataSources to = 'true'. And I also used SQL server account and set a Username (computername\user) and Password. And deploy the report, when the Reporting Services Login box prompts I typed the Username and password that I set a while ago.But It doesnt accept it.:crying: Also when I tried to 'run' the report, you have to type the username and password before viewing the report and again it doesn't accept the username and password.

Thanks....:)

Ivanna Noh SSCarpal Tunnel Points: 4138 More actions · Answer 9

have you checked the properties of the data source once its been deployed to the report server? For comparison, on the report server, I have the following set up for a typical datasource:

- "Name" : name of datasource

- "enable this data source": is checked

- "connection type": MS SQL Server

- "connection string": Data Source= name of SQL server

Catalog = name of database

- "Credentials stored securely in the report server" (radio button):

User name = SQL Username or 'sa'

Password = password for the above

everything else is blank / not filled in / not checked

I don't use windows authentication when setting up the data source, I usually create a SQL Login/user with db_datareader permission on the database. This user is created specifically for running reports on the database. Alternatively, try using 'sa'

Hope this helps - not sure what else to suggest - maybe someone with more experience will have some advice on what else to check

🙂

Dave Balsillie SSCertifiable Points: 5589 More actions · Answer 10

The problem you're having is your general IIS and security set up. It has nothing to do with your data source.

Here's what you should do:

a) Make sure IIS is set to Integrated Authentication. Remember, with ISS, you can set / reset properties at each level of your web site (much like directory security properties). You need to have IIS "cascade" it down through the affected directories.

b) Make sure you've run the "Reporting Services Configuration" and everything is clean.

c) Check the directory security on the report services directories. (In case they got messed up trying to resolve the problem.)

This assumes a relatively clean machine. If this doesn't work, the easiest course will be to uninstall / reinstall both IIS and MSRS to get everything back to the original (default) settings.

rachellebs Ten Centuries Points: 1144 More actions · Answer 11

Thanks for the response... yeah I think I should reinstall the IIS and MS SQL server 2005. Hope that will do the trick...:)

Ed B Hall of Fame Points: 3669 More actions · Answer 12

Are they both running on the same box? If not then you may have to set up kerberos. It sounds simple, but never works on our network.

rachellebs Ten Centuries Points: 1144 More actions · Answer 13

Hi,

What do you mean by "are they both running on the same box?"

And how do I set up Kerberos....I heard of kerberos but never really know how it works....:)

thanks...

rachellebs Ten Centuries Points: 1144 More actions · Answer 14

Hi Dave,

I have already uninstalled and reinstalled the SQL server 2005 as well as the IIS and I tried to deploy my report without configuring anything, as you have said it should be in default settings. But the reporting services login box still prompting.....:pinch:

I really dunno what to do!