Reporting Services Login Problem

Hi All,
I am getting Reporting Services Login box , when trying to deploy the
reporting services reports on the test server.
After entering username/password it does not do anything, I mean not
allowing to deploy.
I am unable to deploy straight from VS2005 (on development box) to the
test server which is on another domain.
(I tried even adding myself to administrator groups on another
domain).
I have developed the project on my development box,It works fine if I
copy accross the rdl files and upload them.
I am able to run/view the reportmanager and reportserver on the
another domain.
Any help much appreciated.
CheersI think, give the credentials in the datasource and save it, so that it wont
ask for username / password. Moreover just check the report project
parameters
ie target server URL (it should be http://<server>/reportserver) and
overwrite Datasource (keep it true)
just check this things and let me know still you have some probs.
Amarnath
"Veera" wrote:
> Hi All,
> I am getting Reporting Services Login box , when trying to deploy the
> reporting services reports on the test server.
> After entering username/password it does not do anything, I mean not
> allowing to deploy.
> I am unable to deploy straight from VS2005 (on development box) to the
> test server which is on another domain.
> (I tried even adding myself to administrator groups on another
> domain).
> I have developed the project on my development box,It works fine if I
> copy accross the rdl files and upload them.
> I am able to run/view the reportmanager and reportserver on the
> another domain.
> Any help much appreciated.
> Cheers
>

Reporting Services Login Issue

I have a client that has a unique situation. Here is the back ground
information:
A Reporting Services 2005 server in a DMZ. This server is not part of
any domain, only has local users.
A SQL Server with the Report Database and an Analysis Services Server
with the Cubes on which the reports are built are behind the
firewall. These servers are in a Windowss 2003 Domain using Domain
accounts for access.
The issue is getting the Report Server in the DMZ to successfully open
a report based on a Cube. Using a Standard SQL Server Login we can
successfully open a report from the Reporting Server in the DMZ that
uses a relational database behind the firewall. This works obviously
since we can use a Standard Login and not deal with the domain/no
domain issue.
When we try to setup a report that uses the CUBE, we can not get the
Domain Server to accept our "ghost" user we created. We create a
user, "reptusr" on the local server in the DMZ. We also created a
user, "reptusr" in the domain behind the firewall and gave that user
id access to the CUBE. This is not working.
I can't find a lot of information on this specific scenario so any
information anyone may have would be greatly appreciated!
Thanks in advance!
MartinDid you write full username (domain\reptusr)? Also, check Use as Windows
credentials when connecting to the data source in datasource properties.
Stjepan
<martinghale@.gmail.com> wrote in message
news:1170983260.446204.25060@.a75g2000cwd.googlegroups.com...
>I have a client that has a unique situation. Here is the back ground
> information:
> A Reporting Services 2005 server in a DMZ. This server is not part of
> any domain, only has local users.
> A SQL Server with the Report Database and an Analysis Services Server
> with the Cubes on which the reports are built are behind the
> firewall. These servers are in a Windowss 2003 Domain using Domain
> accounts for access.
> The issue is getting the Report Server in the DMZ to successfully open
> a report based on a Cube. Using a Standard SQL Server Login we can
> successfully open a report from the Reporting Server in the DMZ that
> uses a relational database behind the firewall. This works obviously
> since we can use a Standard Login and not deal with the domain/no
> domain issue.
> When we try to setup a report that uses the CUBE, we can not get the
> Domain Server to accept our "ghost" user we created. We create a
> user, "reptusr" on the local server in the DMZ. We also created a
> user, "reptusr" in the domain behind the firewall and gave that user
> id access to the CUBE. This is not working.
> I can't find a lot of information on this specific scenario so any
> information anyone may have would be greatly appreciated!
> Thanks in advance!
> Martin
>|||Thank you. Sorry for the delay in getting back. Was out sick.
We have tried that. Have tried everything it seems like. We simply
can not get the report or the Data Source to be able to use Windows
crendentials. Works perfect with SQL Server Login. Plus we are at a
disadvantage as our 'admins' won't actually give us access to the
servers to troubleshoot so we are currently building out a virtual
environment.
Thanks for the suggestion.
Martin

Reporting Services Login Error

An error has occurred during report processing. (rsProcessingAborted) Get Online Help Logon failed. (rsLogonFailed) Get Online Help The parameter is incorrect.

I can view my report inside of visual studio 2003 no problem, but when I navigate to the http://servername/Reports/Pages/Folder.aspx and click on my report to load inside of IE I get the error. I have serached all over but not able to get a correct answer.
Any help woould be greatly appreciated.
Thanks

check your datasource to make sure it deployed properly and that the report is using the proper datasource (in properties)|||Yes.. its using the Source and be able to see the corrcet datasource in SQL manager. I am thining its more Login Setup, but there is not enough documents.|||It is definitely a data souce error, although it is a strange message. What type of credentials are used to connect to the data source?

Reporting Services Login box appears when trying to deploy in SSRS 2005

Hi All,

I installed SQL Server 2005 SP2 recently. After that when I try to
deploy a solution in SSRS 2005, I get a dialog box with title:
"Reporting Services Login". It has my server listed as the first row:
"http://localhost/reportserver" and then it has two text boxes asking
for Username and Password.

I checked my IIS settings and only Integrated Security is checked for
the Reports Server folder (and for the entire website). I tried to
change that to Allow Anonymous Access = Checked, but still the same
problem.

Any ideas?

Thanks! GB

GB,

Just wondering if you ever resolved this problem... How'd do you do it?

I'm having the same symptoms and can't find a single post anywhere in which someone had a solution.

Thanks!

|||Me too. Exactly the same symptoms. Tried the same things to solve it too.|||i have face the same problem anybody is there to help us.?|||

You need to give rights in the report manager sites to the user.

Do not change it in IIS, it will do nothing.

If you have the rights to the report manager you can give access on specific folders or all folders to users.

http://yourservername/reports is the default link to the report manager. If you preferyou can use the "Microsoft SQL Server managment studio " to do the same thing.

If you are not an admin on the reporting services server contact your admin.

Good Luck

|||I have solve this problem, myself. The problem is that i have written the target server url only to http://localhost/ but when i change it to "http://localhost/reportserver" it work fines. so in this way all of you check your target server url to remove this problem|||I have been hoping for resolution of this problem. Having recently installed SS05, I have not yet got this sorted. I have followed generic instructions, incl. IIS set ups, deployment options (incl using http:\\localhost\ReportServer), but still get the credentials request. I have local admin rights to server\ using windows domain account. Could you be more explicit (sorry!) Paul about how to give necessary access to (which) folders, given I am using default settings?

Thanks for everyone's input on this.
Ken
|||

i keep getting EXACTLY the same issue. wasted 5 hours of the day trying to figure it out before i finally called in a troubleshoot request with microsoft.

will let you guys know what the problem is as well!

Xavier

(perth, australia)

|||I found this thread because I was experiencing the same issue described here. I just found a resolution, for my specific case anyway. It turns out that the report server path property was wrong in the reports project properties. I had to create the reports web site http://localhost:81/reports and I neglected to put in the port number in the properties so it was attempting to access a site that didn't exist.

My only suggestion would be to check the url of your report server very closely.

Good luck.
|||

still no word from MSFT.

Thanks scott for your advice,

I presume you inserted this URL in the "Manage Integration Settings"

http://localhost:81/reports

Then where "Grant Database settings, you entered the name of your server (no port included).

In my VM, the server name is CLEANSERVER2003

Instance is default (MSSQL)

I still get the same "Could not open DBASE with user name and password settings"

Any further info you could possibly give?

Cheers

|||

SQL 2005

I have the opposite problem. I am trying to deploy the solution and it is using some other login to try to deploy. This other login does not have the correct rights to deploy. How do I get Visual Studio to prompt for the login name and password when I am trying to deploy the solution. I have checked that the target is correct. I have deleted all cookies and internet files from my PC, removed all other (file share) connections to the server and rebooted. Still no luck - it still wants to use the old login id.

|||Works great for me! Thx!

PS: another solution that I found is here:

FIX: The Reporting Services Login dialog box appears repeatedly when you deploy a report on a remote computer by using Report Designer

http://support.microsoft.com/kb/842517

(not working for me)
|||

Paul.G. wrote:

You need to give rights in the report manager sites to the user.

Do not change it in IIS, it will do nothing.

If you have the rights to the report manager you can give access on specific folders or all folders to users.

http://yourservername/reports is the default link to the report manager. If you preferyou can use the "Microsoft SQL Server managment studio " to do the same thing.

If you are not an admin on the reporting services server contact your admin.

Good Luck

sry for the second post. This solution works for me.
|||

Paul.G. wrote:

You need to give rights in the report manager sites to the user.

Do not change it in IIS, it will do nothing.

If you have the rights to the report manager you can give access on specific folders or all folders to users.

http://yourservername/reports is the default link to the report manager. If you preferyou can use the "Microsoft SQL Server managment studio " to do the same thing.

If you are not an admin on the reporting services server contact your admin.

Good Luck

|||I've been fussing with this a couple days now myself. The fix, quite simply really:

In my particular case I install SQL 2005 as a seperate instance, so instead of

http://localhost/reportserve mine was http://localhost/reportserve$SQL2005

and that, in itself, was enough to break reporting services and query for the reporting serivces login again and again and again.

So, where do you fix it:

1. Open your project in SQL Server Business Intelligence Development Studio
2. Select the project menu followed by the properties of the project.
3. Change the TargetServerURL: To the appropriate path to your reportserver.

if your still not sure ( hard to believe but I suppose... ) open your IIS manager, expand the default web site and spot your reporting services virtual dir.

There you go ... what a pain in the ...

Regards from Indianapolis

Reporting Services Login box appears when trying to deploy in SSRS 2005

Hi All,

I installed SQL Server 2005 SP2 recently. After that when I try to
deploy a solution in SSRS 2005, I get a dialog box with title:
"Reporting Services Login". It has my server listed as the first row:
"http://localhost/reportserver" and then it has two text boxes asking
for Username and Password.

I checked my IIS settings and only Integrated Security is checked for
the Reports Server folder (and for the entire website). I tried to
change that to Allow Anonymous Access = Checked, but still the same
problem.

Any ideas?

Thanks! GB

GB,

Just wondering if you ever resolved this problem... How'd do you do it?

I'm having the same symptoms and can't find a single post anywhere in which someone had a solution.

Thanks!

|||Me too. Exactly the same symptoms. Tried the same things to solve it too.|||i have face the same problem anybody is there to help us.?|||

You need to give rights in the report manager sites to the user.

Do not change it in IIS, it will do nothing.

If you have the rights to the report manager you can give access on specific folders or all folders to users.

http://yourservername/reports is the default link to the report manager. If you preferyou can use the "Microsoft SQL Server managment studio " to do the same thing.

If you are not an admin on the reporting services server contact your admin.

Good Luck

|||I have solve this problem, myself. The problem is that i have written the target server url only to http://localhost/ but when i change it to "http://localhost/reportserver" it work fines. so in this way all of you check your target server url to remove this problem|||I have been hoping for resolution of this problem. Having recently installed SS05, I have not yet got this sorted. I have followed generic instructions, incl. IIS set ups, deployment options (incl using http:\\localhost\ReportServer), but still get the credentials request. I have local admin rights to server\ using windows domain account. Could you be more explicit (sorry!) Paul about how to give necessary access to (which) folders, given I am using default settings?

Thanks for everyone's input on this.
Ken
|||

i keep getting EXACTLY the same issue. wasted 5 hours of the day trying to figure it out before i finally called in a troubleshoot request with microsoft.

will let you guys know what the problem is as well!

Xavier

(perth, australia)

|||I found this thread because I was experiencing the same issue described here. I just found a resolution, for my specific case anyway. It turns out that the report server path property was wrong in the reports project properties. I had to create the reports web site http://localhost:81/reports and I neglected to put in the port number in the properties so it was attempting to access a site that didn't exist.

My only suggestion would be to check the url of your report server very closely.

Good luck.
|||

still no word from MSFT.

Thanks scott for your advice,

I presume you inserted this URL in the "Manage Integration Settings"

http://localhost:81/reports

Then where "Grant Database settings, you entered the name of your server (no port included).

In my VM, the server name is CLEANSERVER2003

Instance is default (MSSQL)

I still get the same "Could not open DBASE with user name and password settings"

Any further info you could possibly give?

Cheers

|||

SQL 2005

I have the opposite problem. I am trying to deploy the solution and it is using some other login to try to deploy. This other login does not have the correct rights to deploy. How do I get Visual Studio to prompt for the login name and password when I am trying to deploy the solution. I have checked that the target is correct. I have deleted all cookies and internet files from my PC, removed all other (file share) connections to the server and rebooted. Still no luck - it still wants to use the old login id.

|||Works great for me! Thx!

PS: another solution that I found is here:

FIX: The Reporting Services Login dialog box appears repeatedly when you deploy a report on a remote computer by using Report Designer

http://support.microsoft.com/kb/842517

(not working for me)
|||

Paul.G. wrote:

You need to give rights in the report manager sites to the user.

Do not change it in IIS, it will do nothing.

If you have the rights to the report manager you can give access on specific folders or all folders to users.

http://yourservername/reports is the default link to the report manager. If you preferyou can use the "Microsoft SQL Server managment studio " to do the same thing.

If you are not an admin on the reporting services server contact your admin.

Good Luck

sry for the second post. This solution works for me.
|||

Paul.G. wrote:

You need to give rights in the report manager sites to the user.

Do not change it in IIS, it will do nothing.

If you have the rights to the report manager you can give access on specific folders or all folders to users.

http://yourservername/reports is the default link to the report manager. If you preferyou can use the "Microsoft SQL Server managment studio " to do the same thing.

If you are not an admin on the reporting services server contact your admin.

Good Luck

|||I've been fussing with this a couple days now myself. The fix, quite simply really:

In my particular case I install SQL 2005 as a seperate instance, so instead of

http://localhost/reportserve mine was http://localhost/reportserve$SQL2005

and that, in itself, was enough to break reporting services and query for the reporting serivces login again and again and again.

So, where do you fix it:

1. Open your project in SQL Server Business Intelligence Development Studio
2. Select the project menu followed by the properties of the project.
3. Change the TargetServerURL: To the appropriate path to your reportserver.

if your still not sure ( hard to believe but I suppose... ) open your IIS manager, expand the default web site and spot your reporting services virtual dir.

There you go ... what a pain in the ...

Regards from Indianapolis

Reporting Services Login box appears when trying to deploy in SSRS 2005

Hi All,

I installed SQL Server 2005 SP2 recently. After that when I try to
deploy a solution in SSRS 2005, I get a dialog box with title:
"Reporting Services Login". It has my server listed as the first row:
"http://localhost/reportserver" and then it has two text boxes asking
for Username and Password.

I checked my IIS settings and only Integrated Security is checked for
the Reports Server folder (and for the entire website). I tried to
change that to Allow Anonymous Access = Checked, but still the same
problem.

Any ideas?

Thanks! GB

GB,

Just wondering if you ever resolved this problem... How'd do you do it?

I'm having the same symptoms and can't find a single post anywhere in which someone had a solution.

Thanks!

|||Me too. Exactly the same symptoms. Tried the same things to solve it too.|||i have face the same problem anybody is there to help us.?|||

You need to give rights in the report manager sites to the user.

Do not change it in IIS, it will do nothing.

If you have the rights to the report manager you can give access on specific folders or all folders to users.

http://yourservername/reports is the default link to the report manager. If you preferyou can use the "Microsoft SQL Server managment studio " to do the same thing.

If you are not an admin on the reporting services server contact your admin.

Good Luck

|||I have solve this problem, myself. The problem is that i have written the target server url only to http://localhost/ but when i change it to "http://localhost/reportserver" it work fines. so in this way all of you check your target server url to remove this problem|||I have been hoping for resolution of this problem. Having recently installed SS05, I have not yet got this sorted. I have followed generic instructions, incl. IIS set ups, deployment options (incl using http:\\localhost\ReportServer), but still get the credentials request. I have local admin rights to server\ using windows domain account. Could you be more explicit (sorry!) Paul about how to give necessary access to (which) folders, given I am using default settings?

Thanks for everyone's input on this.
Ken
|||

i keep getting EXACTLY the same issue. wasted 5 hours of the day trying to figure it out before i finally called in a troubleshoot request with microsoft.

will let you guys know what the problem is as well!

Xavier

(perth, australia)

|||I found this thread because I was experiencing the same issue described here. I just found a resolution, for my specific case anyway. It turns out that the report server path property was wrong in the reports project properties. I had to create the reports web site http://localhost:81/reports and I neglected to put in the port number in the properties so it was attempting to access a site that didn't exist.

My only suggestion would be to check the url of your report server very closely.

Good luck.
|||

still no word from MSFT.

Thanks scott for your advice,

I presume you inserted this URL in the "Manage Integration Settings"

http://localhost:81/reports

Then where "Grant Database settings, you entered the name of your server (no port included).

In my VM, the server name is CLEANSERVER2003

Instance is default (MSSQL)

I still get the same "Could not open DBASE with user name and password settings"

Any further info you could possibly give?

Cheers

|||

SQL 2005

I have the opposite problem. I am trying to deploy the solution and it is using some other login to try to deploy. This other login does not have the correct rights to deploy. How do I get Visual Studio to prompt for the login name and password when I am trying to deploy the solution. I have checked that the target is correct. I have deleted all cookies and internet files from my PC, removed all other (file share) connections to the server and rebooted. Still no luck - it still wants to use the old login id.

|||Works great for me! Thx!

PS: another solution that I found is here:

FIX: The Reporting Services Login dialog box appears repeatedly when you deploy a report on a remote computer by using Report Designer

http://support.microsoft.com/kb/842517

(not working for me)
|||

Paul.G. wrote:

You need to give rights in the report manager sites to the user.

Do not change it in IIS, it will do nothing.

If you have the rights to the report manager you can give access on specific folders or all folders to users.

http://yourservername/reports is the default link to the report manager. If you preferyou can use the "Microsoft SQL Server managment studio " to do the same thing.

If you are not an admin on the reporting services server contact your admin.

Good Luck

sry for the second post. This solution works for me.
|||

Paul.G. wrote:

You need to give rights in the report manager sites to the user.

Do not change it in IIS, it will do nothing.

If you have the rights to the report manager you can give access on specific folders or all folders to users.

http://yourservername/reports is the default link to the report manager. If you preferyou can use the "Microsoft SQL Server managment studio " to do the same thing.

If you are not an admin on the reporting services server contact your admin.

Good Luck

|||I've been fussing with this a couple days now myself. The fix, quite simply really:

In my particular case I install SQL 2005 as a seperate instance, so instead of

http://localhost/reportserve mine was http://localhost/reportserve$SQL2005

and that, in itself, was enough to break reporting services and query for the reporting serivces login again and again and again.

So, where do you fix it:

1. Open your project in SQL Server Business Intelligence Development Studio
2. Select the project menu followed by the properties of the project.
3. Change the TargetServerURL: To the appropriate path to your reportserver.

if your still not sure ( hard to believe but I suppose... ) open your IIS manager, expand the default web site and spot your reporting services virtual dir.

There you go ... what a pain in the ...

Regards from Indianapolis

Reporting Services Login box appears when trying to deploy in SSRS 2005

Hi All,

I installed SQL Server 2005 SP2 recently. After that when I try to
deploy a solution in SSRS 2005, I get a dialog box with title:
"Reporting Services Login". It has my server listed as the first row:
"http://localhost/reportserver" and then it has two text boxes asking
for Username and Password.

I checked my IIS settings and only Integrated Security is checked for
the Reports Server folder (and for the entire website). I tried to
change that to Allow Anonymous Access = Checked, but still the same
problem.

Any ideas?

Thanks! GB

GB,

Just wondering if you ever resolved this problem... How'd do you do it?

I'm having the same symptoms and can't find a single post anywhere in which someone had a solution.

Thanks!

|||Me too. Exactly the same symptoms. Tried the same things to solve it too.|||i have face the same problem anybody is there to help us.?|||

You need to give rights in the report manager sites to the user.

Do not change it in IIS, it will do nothing.

If you have the rights to the report manager you can give access on specific folders or all folders to users.

http://yourservername/reports is the default link to the report manager. If you preferyou can use the "Microsoft SQL Server managment studio " to do the same thing.

If you are not an admin on the reporting services server contact your admin.

Good Luck

|||I have solve this problem, myself. The problem is that i have written the target server url only to http://localhost/ but when i change it to "http://localhost/reportserver" it work fines. so in this way all of you check your target server url to remove this problem|||I have been hoping for resolution of this problem. Having recently installed SS05, I have not yet got this sorted. I have followed generic instructions, incl. IIS set ups, deployment options (incl using http:\\localhost\ReportServer), but still get the credentials request. I have local admin rights to server\ using windows domain account. Could you be more explicit (sorry!) Paul about how to give necessary access to (which) folders, given I am using default settings?

Thanks for everyone's input on this.
Ken
|||

i keep getting EXACTLY the same issue. wasted 5 hours of the day trying to figure it out before i finally called in a troubleshoot request with microsoft.

will let you guys know what the problem is as well!

Xavier

(perth, australia)

|||I found this thread because I was experiencing the same issue described here. I just found a resolution, for my specific case anyway. It turns out that the report server path property was wrong in the reports project properties. I had to create the reports web site http://localhost:81/reports and I neglected to put in the port number in the properties so it was attempting to access a site that didn't exist.

My only suggestion would be to check the url of your report server very closely.

Good luck.
|||

still no word from MSFT.

Thanks scott for your advice,

I presume you inserted this URL in the "Manage Integration Settings"

http://localhost:81/reports

Then where "Grant Database settings, you entered the name of your server (no port included).

In my VM, the server name is CLEANSERVER2003

Instance is default (MSSQL)

I still get the same "Could not open DBASE with user name and password settings"

Any further info you could possibly give?

Cheers

|||

SQL 2005

I have the opposite problem. I am trying to deploy the solution and it is using some other login to try to deploy. This other login does not have the correct rights to deploy. How do I get Visual Studio to prompt for the login name and password when I am trying to deploy the solution. I have checked that the target is correct. I have deleted all cookies and internet files from my PC, removed all other (file share) connections to the server and rebooted. Still no luck - it still wants to use the old login id.

|||Works great for me! Thx!

PS: another solution that I found is here:

FIX: The Reporting Services Login dialog box appears repeatedly when you deploy a report on a remote computer by using Report Designer

http://support.microsoft.com/kb/842517

(not working for me)
|||

Paul.G. wrote:

You need to give rights in the report manager sites to the user.

Do not change it in IIS, it will do nothing.

If you have the rights to the report manager you can give access on specific folders or all folders to users.

http://yourservername/reports is the default link to the report manager. If you preferyou can use the "Microsoft SQL Server managment studio " to do the same thing.

If you are not an admin on the reporting services server contact your admin.

Good Luck

sry for the second post. This solution works for me.
|||

Paul.G. wrote:

You need to give rights in the report manager sites to the user.

Do not change it in IIS, it will do nothing.

If you have the rights to the report manager you can give access on specific folders or all folders to users.

http://yourservername/reports is the default link to the report manager. If you preferyou can use the "Microsoft SQL Server managment studio " to do the same thing.

If you are not an admin on the reporting services server contact your admin.

Good Luck

|||I've been fussing with this a couple days now myself. The fix, quite simply really:

In my particular case I install SQL 2005 as a seperate instance, so instead of

http://localhost/reportserve mine was http://localhost/reportserve$SQL2005

and that, in itself, was enough to break reporting services and query for the reporting serivces login again and again and again.

So, where do you fix it:

1. Open your project in SQL Server Business Intelligence Development Studio
2. Select the project menu followed by the properties of the project.
3. Change the TargetServerURL: To the appropriate path to your reportserver.

if your still not sure ( hard to believe but I suppose... ) open your IIS manager, expand the default web site and spot your reporting services virtual dir.

There you go ... what a pain in the ...

Regards from Indianapolis

Reporting Services Login box appears when trying to deploy in SSRS 2005

Hi All,

I installed SQL Server 2005 SP2 recently. After that when I try to
deploy a solution in SSRS 2005, I get a dialog box with title:
"Reporting Services Login". It has my server listed as the first row:
"http://localhost/reportserver" and then it has two text boxes asking
for Username and Password.

I checked my IIS settings and only Integrated Security is checked for
the Reports Server folder (and for the entire website). I tried to
change that to Allow Anonymous Access = Checked, but still the same
problem.

Any ideas?

Thanks! GB

GB,

Just wondering if you ever resolved this problem... How'd do you do it?

I'm having the same symptoms and can't find a single post anywhere in which someone had a solution.

Thanks!

|||Me too. Exactly the same symptoms. Tried the same things to solve it too.|||i have face the same problem anybody is there to help us.?|||

You need to give rights in the report manager sites to the user.

Do not change it in IIS, it will do nothing.

If you have the rights to the report manager you can give access on specific folders or all folders to users.

http://yourservername/reports is the default link to the report manager. If you preferyou can use the "Microsoft SQL Server managment studio " to do the same thing.

If you are not an admin on the reporting services server contact your admin.

Good Luck

|||I have solve this problem, myself. The problem is that i have written the target server url only to http://localhost/ but when i change it to "http://localhost/reportserver" it work fines. so in this way all of you check your target server url to remove this problem|||I have been hoping for resolution of this problem. Having recently installed SS05, I have not yet got this sorted. I have followed generic instructions, incl. IIS set ups, deployment options (incl using http:\\localhost\ReportServer), but still get the credentials request. I have local admin rights to server\ using windows domain account. Could you be more explicit (sorry!) Paul about how to give necessary access to (which) folders, given I am using default settings?

Thanks for everyone's input on this.
Ken
|||

i keep getting EXACTLY the same issue. wasted 5 hours of the day trying to figure it out before i finally called in a troubleshoot request with microsoft.

will let you guys know what the problem is as well!

Xavier

(perth, australia)

|||I found this thread because I was experiencing the same issue described here. I just found a resolution, for my specific case anyway. It turns out that the report server path property was wrong in the reports project properties. I had to create the reports web site http://localhost:81/reports and I neglected to put in the port number in the properties so it was attempting to access a site that didn't exist.

My only suggestion would be to check the url of your report server very closely.

Good luck.
|||

still no word from MSFT.

Thanks scott for your advice,

I presume you inserted this URL in the "Manage Integration Settings"

http://localhost:81/reports

Then where "Grant Database settings, you entered the name of your server (no port included).

In my VM, the server name is CLEANSERVER2003

Instance is default (MSSQL)

I still get the same "Could not open DBASE with user name and password settings"

Any further info you could possibly give?

Cheers

|||

SQL 2005

I have the opposite problem. I am trying to deploy the solution and it is using some other login to try to deploy. This other login does not have the correct rights to deploy. How do I get Visual Studio to prompt for the login name and password when I am trying to deploy the solution. I have checked that the target is correct. I have deleted all cookies and internet files from my PC, removed all other (file share) connections to the server and rebooted. Still no luck - it still wants to use the old login id.

|||Works great for me! Thx!

PS: another solution that I found is here:

FIX: The Reporting Services Login dialog box appears repeatedly when you deploy a report on a remote computer by using Report Designer

http://support.microsoft.com/kb/842517

(not working for me)
|||

Paul.G. wrote:

You need to give rights in the report manager sites to the user.

Do not change it in IIS, it will do nothing.

If you have the rights to the report manager you can give access on specific folders or all folders to users.

http://yourservername/reports is the default link to the report manager. If you preferyou can use the "Microsoft SQL Server managment studio " to do the same thing.

If you are not an admin on the reporting services server contact your admin.

Good Luck

sry for the second post. This solution works for me.
|||

Paul.G. wrote:

You need to give rights in the report manager sites to the user.

Do not change it in IIS, it will do nothing.

If you have the rights to the report manager you can give access on specific folders or all folders to users.

http://yourservername/reports is the default link to the report manager. If you preferyou can use the "Microsoft SQL Server managment studio " to do the same thing.

If you are not an admin on the reporting services server contact your admin.

Good Luck

|||I've been fussing with this a couple days now myself. The fix, quite simply really:

In my particular case I install SQL 2005 as a seperate instance, so instead of

http://localhost/reportserve mine was http://localhost/reportserve$SQL2005

and that, in itself, was enough to break reporting services and query for the reporting serivces login again and again and again.

So, where do you fix it:

1. Open your project in SQL Server Business Intelligence Development Studio
2. Select the project menu followed by the properties of the project.
3. Change the TargetServerURL: To the appropriate path to your reportserver.

if your still not sure ( hard to believe but I suppose... ) open your IIS manager, expand the default web site and spot your reporting services virtual dir.

There you go ... what a pain in the ...

Regards from Indianapolis

Reporting Services Login box appears when trying to deploy in SSRS 2005

Hi All,

I installed SQL Server 2005 SP2 recently. After that when I try to
deploy a solution in SSRS 2005, I get a dialog box with title:
"Reporting Services Login". It has my server listed as the first row:
"http://localhost/reportserver" and then it has two text boxes asking
for Username and Password.

I checked my IIS settings and only Integrated Security is checked for
the Reports Server folder (and for the entire website). I tried to
change that to Allow Anonymous Access = Checked, but still the same
problem.

Any ideas?

Thanks! GB

GB,

Just wondering if you ever resolved this problem... How'd do you do it?

I'm having the same symptoms and can't find a single post anywhere in which someone had a solution.

Thanks!

|||Me too. Exactly the same symptoms. Tried the same things to solve it too.|||i have face the same problem anybody is there to help us.?|||

You need to give rights in the report manager sites to the user.

Do not change it in IIS, it will do nothing.

If you have the rights to the report manager you can give access on specific folders or all folders to users.

http://yourservername/reports is the default link to the report manager. If you preferyou can use the "Microsoft SQL Server managment studio " to do the same thing.

If you are not an admin on the reporting services server contact your admin.

Good Luck

|||I have solve this problem, myself. The problem is that i have written the target server url only to http://localhost/ but when i change it to "http://localhost/reportserver" it work fines. so in this way all of you check your target server url to remove this problem|||I have been hoping for resolution of this problem. Having recently installed SS05, I have not yet got this sorted. I have followed generic instructions, incl. IIS set ups, deployment options (incl using http:\\localhost\ReportServer), but still get the credentials request. I have local admin rights to server\ using windows domain account. Could you be more explicit (sorry!) Paul about how to give necessary access to (which) folders, given I am using default settings?

Thanks for everyone's input on this.
Ken
|||

i keep getting EXACTLY the same issue. wasted 5 hours of the day trying to figure it out before i finally called in a troubleshoot request with microsoft.

will let you guys know what the problem is as well!

Xavier

(perth, australia)

|||I found this thread because I was experiencing the same issue described here. I just found a resolution, for my specific case anyway. It turns out that the report server path property was wrong in the reports project properties. I had to create the reports web site http://localhost:81/reports and I neglected to put in the port number in the properties so it was attempting to access a site that didn't exist.

My only suggestion would be to check the url of your report server very closely.

Good luck.
|||

still no word from MSFT.

Thanks scott for your advice,

I presume you inserted this URL in the "Manage Integration Settings"

http://localhost:81/reports

Then where "Grant Database settings, you entered the name of your server (no port included).

In my VM, the server name is CLEANSERVER2003

Instance is default (MSSQL)

I still get the same "Could not open DBASE with user name and password settings"

Any further info you could possibly give?

Cheers

|||

SQL 2005

I have the opposite problem. I am trying to deploy the solution and it is using some other login to try to deploy. This other login does not have the correct rights to deploy. How do I get Visual Studio to prompt for the login name and password when I am trying to deploy the solution. I have checked that the target is correct. I have deleted all cookies and internet files from my PC, removed all other (file share) connections to the server and rebooted. Still no luck - it still wants to use the old login id.

|||Works great for me! Thx!

PS: another solution that I found is here:

FIX: The Reporting Services Login dialog box appears repeatedly when you deploy a report on a remote computer by using Report Designer

http://support.microsoft.com/kb/842517

(not working for me)
|||

Paul.G. wrote:

You need to give rights in the report manager sites to the user.

Do not change it in IIS, it will do nothing.

If you have the rights to the report manager you can give access on specific folders or all folders to users.

http://yourservername/reports is the default link to the report manager. If you preferyou can use the "Microsoft SQL Server managment studio " to do the same thing.

If you are not an admin on the reporting services server contact your admin.

Good Luck

sry for the second post. This solution works for me.
|||

Paul.G. wrote:

You need to give rights in the report manager sites to the user.

Do not change it in IIS, it will do nothing.

If you have the rights to the report manager you can give access on specific folders or all folders to users.

http://yourservername/reports is the default link to the report manager. If you preferyou can use the "Microsoft SQL Server managment studio " to do the same thing.

If you are not an admin on the reporting services server contact your admin.

Good Luck

|||I've been fussing with this a couple days now myself. The fix, quite simply really:

In my particular case I install SQL 2005 as a seperate instance, so instead of

http://localhost/reportserve mine was http://localhost/reportserve$SQL2005

and that, in itself, was enough to break reporting services and query for the reporting serivces login again and again and again.

So, where do you fix it:

1. Open your project in SQL Server Business Intelligence Development Studio
2. Select the project menu followed by the properties of the project.
3. Change the TargetServerURL: To the appropriate path to your reportserver.

if your still not sure ( hard to believe but I suppose... ) open your IIS manager, expand the default web site and spot your reporting services virtual dir.

There you go ... what a pain in the ...

Regards from Indianapolis

Reporting Services Login box appears when trying to deploy in SSRS 2005

Hi All,

I installed SQL Server 2005 SP2 recently. After that when I try to
deploy a solution in SSRS 2005, I get a dialog box with title:
"Reporting Services Login". It has my server listed as the first row:
"http://localhost/reportserver" and then it has two text boxes asking
for Username and Password.

I checked my IIS settings and only Integrated Security is checked for
the Reports Server folder (and for the entire website). I tried to
change that to Allow Anonymous Access = Checked, but still the same
problem.

Any ideas?

Thanks! GB

GB,

Just wondering if you ever resolved this problem... How'd do you do it?

I'm having the same symptoms and can't find a single post anywhere in which someone had a solution.

Thanks!

|||Me too. Exactly the same symptoms. Tried the same things to solve it too.|||i have face the same problem anybody is there to help us.?|||

You need to give rights in the report manager sites to the user.

Do not change it in IIS, it will do nothing.

If you have the rights to the report manager you can give access on specific folders or all folders to users.

http://yourservername/reports is the default link to the report manager. If you preferyou can use the "Microsoft SQL Server managment studio " to do the same thing.

If you are not an admin on the reporting services server contact your admin.

Good Luck

|||I have solve this problem, myself. The problem is that i have written the target server url only to http://localhost/ but when i change it to "http://localhost/reportserver" it work fines. so in this way all of you check your target server url to remove this problem|||I have been hoping for resolution of this problem. Having recently installed SS05, I have not yet got this sorted. I have followed generic instructions, incl. IIS set ups, deployment options (incl using http:\\localhost\ReportServer), but still get the credentials request. I have local admin rights to server\ using windows domain account. Could you be more explicit (sorry!) Paul about how to give necessary access to (which) folders, given I am using default settings?

Thanks for everyone's input on this.
Ken
|||

i keep getting EXACTLY the same issue. wasted 5 hours of the day trying to figure it out before i finally called in a troubleshoot request with microsoft.

will let you guys know what the problem is as well!

Xavier

(perth, australia)

|||I found this thread because I was experiencing the same issue described here. I just found a resolution, for my specific case anyway. It turns out that the report server path property was wrong in the reports project properties. I had to create the reports web site http://localhost:81/reports and I neglected to put in the port number in the properties so it was attempting to access a site that didn't exist.

My only suggestion would be to check the url of your report server very closely.

Good luck.
|||

still no word from MSFT.

Thanks scott for your advice,

I presume you inserted this URL in the "Manage Integration Settings"

http://localhost:81/reports

Then where "Grant Database settings, you entered the name of your server (no port included).

In my VM, the server name is CLEANSERVER2003

Instance is default (MSSQL)

I still get the same "Could not open DBASE with user name and password settings"

Any further info you could possibly give?

Cheers

|||

SQL 2005

I have the opposite problem. I am trying to deploy the solution and it is using some other login to try to deploy. This other login does not have the correct rights to deploy. How do I get Visual Studio to prompt for the login name and password when I am trying to deploy the solution. I have checked that the target is correct. I have deleted all cookies and internet files from my PC, removed all other (file share) connections to the server and rebooted. Still no luck - it still wants to use the old login id.

|||Works great for me! Thx!

PS: another solution that I found is here:

FIX: The Reporting Services Login dialog box appears repeatedly when you deploy a report on a remote computer by using Report Designer

http://support.microsoft.com/kb/842517

(not working for me)
|||

Paul.G. wrote:

You need to give rights in the report manager sites to the user.

Do not change it in IIS, it will do nothing.

If you have the rights to the report manager you can give access on specific folders or all folders to users.

http://yourservername/reports is the default link to the report manager. If you preferyou can use the "Microsoft SQL Server managment studio " to do the same thing.

If you are not an admin on the reporting services server contact your admin.

Good Luck

sry for the second post. This solution works for me.
|||

Paul.G. wrote:

You need to give rights in the report manager sites to the user.

Do not change it in IIS, it will do nothing.

If you have the rights to the report manager you can give access on specific folders or all folders to users.

http://yourservername/reports is the default link to the report manager. If you preferyou can use the "Microsoft SQL Server managment studio " to do the same thing.

If you are not an admin on the reporting services server contact your admin.

Good Luck

|||I've been fussing with this a couple days now myself. The fix, quite simply really:

In my particular case I install SQL 2005 as a seperate instance, so instead of

http://localhost/reportserve mine was http://localhost/reportserve$SQL2005

and that, in itself, was enough to break reporting services and query for the reporting serivces login again and again and again.

So, where do you fix it:

1. Open your project in SQL Server Business Intelligence Development Studio
2. Select the project menu followed by the properties of the project.
3. Change the TargetServerURL: To the appropriate path to your reportserver.

if your still not sure ( hard to believe but I suppose... ) open your IIS manager, expand the default web site and spot your reporting services virtual dir.

There you go ... what a pain in the ...

Regards from Indianapolis

Reporting Services Login box appears when trying to deploy in SSRS 2005

Hi All,

I installed SQL Server 2005 SP2 recently. After that when I try to
deploy a solution in SSRS 2005, I get a dialog box with title:
"Reporting Services Login". It has my server listed as the first row:
"http://localhost/reportserver" and then it has two text boxes asking
for Username and Password.

I checked my IIS settings and only Integrated Security is checked for
the Reports Server folder (and for the entire website). I tried to
change that to Allow Anonymous Access = Checked, but still the same
problem.

Any ideas?

Thanks! GB

GB,

Just wondering if you ever resolved this problem... How'd do you do it?

I'm having the same symptoms and can't find a single post anywhere in which someone had a solution.

Thanks!

|||Me too. Exactly the same symptoms. Tried the same things to solve it too.|||i have face the same problem anybody is there to help us.?|||

You need to give rights in the report manager sites to the user.

Do not change it in IIS, it will do nothing.

If you have the rights to the report manager you can give access on specific folders or all folders to users.

http://yourservername/reports is the default link to the report manager. If you preferyou can use the "Microsoft SQL Server managment studio " to do the same thing.

If you are not an admin on the reporting services server contact your admin.

Good Luck

|||I have solve this problem, myself. The problem is that i have written the target server url only to http://localhost/ but when i change it to "http://localhost/reportserver" it work fines. so in this way all of you check your target server url to remove this problem|||I have been hoping for resolution of this problem. Having recently installed SS05, I have not yet got this sorted. I have followed generic instructions, incl. IIS set ups, deployment options (incl using http:\\localhost\ReportServer), but still get the credentials request. I have local admin rights to server\ using windows domain account. Could you be more explicit (sorry!) Paul about how to give necessary access to (which) folders, given I am using default settings?

Thanks for everyone's input on this.
Ken
|||

i keep getting EXACTLY the same issue. wasted 5 hours of the day trying to figure it out before i finally called in a troubleshoot request with microsoft.

will let you guys know what the problem is as well!

Xavier

(perth, australia)

|||I found this thread because I was experiencing the same issue described here. I just found a resolution, for my specific case anyway. It turns out that the report server path property was wrong in the reports project properties. I had to create the reports web site http://localhost:81/reports and I neglected to put in the port number in the properties so it was attempting to access a site that didn't exist.

My only suggestion would be to check the url of your report server very closely.

Good luck.
|||

still no word from MSFT.

Thanks scott for your advice,

I presume you inserted this URL in the "Manage Integration Settings"

http://localhost:81/reports

Then where "Grant Database settings, you entered the name of your server (no port included).

In my VM, the server name is CLEANSERVER2003

Instance is default (MSSQL)

I still get the same "Could not open DBASE with user name and password settings"

Any further info you could possibly give?

Cheers

|||

SQL 2005

I have the opposite problem. I am trying to deploy the solution and it is using some other login to try to deploy. This other login does not have the correct rights to deploy. How do I get Visual Studio to prompt for the login name and password when I am trying to deploy the solution. I have checked that the target is correct. I have deleted all cookies and internet files from my PC, removed all other (file share) connections to the server and rebooted. Still no luck - it still wants to use the old login id.

|||Works great for me! Thx!

PS: another solution that I found is here:

FIX: The Reporting Services Login dialog box appears repeatedly when you deploy a report on a remote computer by using Report Designer

http://support.microsoft.com/kb/842517

(not working for me)
|||

Paul.G. wrote:

You need to give rights in the report manager sites to the user.

Do not change it in IIS, it will do nothing.

If you have the rights to the report manager you can give access on specific folders or all folders to users.

http://yourservername/reports is the default link to the report manager. If you preferyou can use the "Microsoft SQL Server managment studio " to do the same thing.

If you are not an admin on the reporting services server contact your admin.

Good Luck

sry for the second post. This solution works for me.
|||

Paul.G. wrote:

You need to give rights in the report manager sites to the user.

Do not change it in IIS, it will do nothing.

If you have the rights to the report manager you can give access on specific folders or all folders to users.

http://yourservername/reports is the default link to the report manager. If you preferyou can use the "Microsoft SQL Server managment studio " to do the same thing.

If you are not an admin on the reporting services server contact your admin.

Good Luck

|||I've been fussing with this a couple days now myself. The fix, quite simply really:

In my particular case I install SQL 2005 as a seperate instance, so instead of

http://localhost/reportserve mine was http://localhost/reportserve$SQL2005

and that, in itself, was enough to break reporting services and query for the reporting serivces login again and again and again.

So, where do you fix it:

1. Open your project in SQL Server Business Intelligence Development Studio
2. Select the project menu followed by the properties of the project.
3. Change the TargetServerURL: To the appropriate path to your reportserver.

if your still not sure ( hard to believe but I suppose... ) open your IIS manager, expand the default web site and spot your reporting services virtual dir.

There you go ... what a pain in the ...

Regards from Indianapolis

Reporting Services Login

Hi all,
I am trying to deploy a report that I have created. When I right-click
on the Report and click on Deploy, I get a Reporting Services login
dialog box. I tried all login/passwords possible and it keeps on
prompting me for it.
Everything is local to my computer. I am running SQL Server 2005
Standard Edition SP2.
Please help!
*** Sent via Developersdex http://www.codecomments.com ***Life is much easier if you set up the system so that you don't get any
Reporting Services logon dialogue. You need to fix up your IIS configuration
to sort out correct usage of integrated security.
"Audrey Ng" <odd26uk@.yahoo.co.uk> wrote in message
news:%23X0d8BcjHHA.492@.TK2MSFTNGP04.phx.gbl...
> Hi all,
> I am trying to deploy a report that I have created. When I right-click
> on the Report and click on Deploy, I get a Reporting Services login
> dialog box. I tried all login/passwords possible and it keeps on
> prompting me for it.
> Everything is local to my computer. I am running SQL Server 2005
> Standard Edition SP2.
> Please help!
>
> *** Sent via Developersdex http://www.codecomments.com ***

Reporting Services Login

Hi all,
I am trying to deploy a report that I have created. When I right-click
on the Report and click on Deploy, I get a Reporting Services login
dialog box. I tried all login/passwords possible and it keeps on
prompting me for it.
Everything is local to my computer. I am running SQL Server 2005
Standard Edition SP2.
Please help!
*** Sent via Developersdex http://www.developersdex.com ***Life is much easier if you set up the system so that you don't get any
Reporting Services logon dialogue. You need to fix up your IIS configuration
to sort out correct usage of integrated security.
"Audrey Ng" <odd26uk@.yahoo.co.uk> wrote in message
news:%23X0d8BcjHHA.492@.TK2MSFTNGP04.phx.gbl...
> Hi all,
> I am trying to deploy a report that I have created. When I right-click
> on the Report and click on Deploy, I get a Reporting Services login
> dialog box. I tried all login/passwords possible and it keeps on
> prompting me for it.
> Everything is local to my computer. I am running SQL Server 2005
> Standard Edition SP2.
> Please help!
>
> *** Sent via Developersdex http://www.developersdex.com ***

Reporting Services Login

Hi all,
I am trying to deploy a report that I have created. When I right-click
on the Report and click on Deploy, I get a Reporting Services login
dialog box. I tried all login/passwords possible and it keeps on
prompting me for it.
Everything is local to my computer. I am running SQL Server 2005
Standard Edition SP2.
Please help!
*** Sent via Developersdex http://www.codecomments.com ***
Life is much easier if you set up the system so that you don't get any
Reporting Services logon dialogue. You need to fix up your IIS configuration
to sort out correct usage of integrated security.
"Audrey Ng" <odd26uk@.yahoo.co.uk> wrote in message
news:%23X0d8BcjHHA.492@.TK2MSFTNGP04.phx.gbl...
> Hi all,
> I am trying to deploy a report that I have created. When I right-click
> on the Report and click on Deploy, I get a Reporting Services login
> dialog box. I tried all login/passwords possible and it keeps on
> prompting me for it.
> Everything is local to my computer. I am running SQL Server 2005
> Standard Edition SP2.
> Please help!
>
> *** Sent via Developersdex http://www.codecomments.com ***

Reporting Services Login

I am trying to deploy the sample reports from Reporting Services my development PC to the Reportserver. When I do this I get the Reporting Services Login prompt. I am using a user that has access to http://servername/reportserver and http://servername/reports and who is an administrator on the server. Still it will not allow me to login. What can be the problem?In Books Online, look for the topic "sample scripts" in the index. The
topic describes how to use the rs.exe utility to deploy reports. What
happens if you try this method? As this is essentially the same code we use
within Visual Studio, it might help to clarify the problem.
--
Albert Yen
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"RaVaGe" <RaVaGe@.discussions.microsoft.com> wrote in message
news:068FDDC1-833F-4480-9769-C233111BEF69@.microsoft.com...
> I am trying to deploy the sample reports from Reporting Services my
development PC to the Reportserver. When I do this I get the Reporting
Services Login prompt. I am using a user that has access to
http://servername/reportserver and http://servername/reports and who is an
administrator on the server. Still it will not allow me to login. What can
be the problem?