Showing posts with label deploy. Show all posts

Wednesday, March 21, 2012

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
>

Tuesday, March 20, 2012

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)
|||

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

|||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,

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

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)

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

|||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)
|||

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

|||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:

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,

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

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)

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

|||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)
|||

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

|||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:

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,

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

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)

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

|||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)
|||

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

|||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:

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,

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

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)

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

|||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)
|||

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

|||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:

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,

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

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)

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

|||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)
|||

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

|||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:

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,

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

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)

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

|||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)
|||

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

|||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:

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,

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

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)

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

|||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)
|||

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

|||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:

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?

Wednesday, March 7, 2012

Reporting Services Error -- Could not find stored procedure 'spPM_ProjectManager'

Hi All,

I built this report same way like the other reports but in different database. When preview in visual stuodio, it is fine. When deploy to the server, I got this message:

Report Services Error

An error has occurred during report processing. (rsProcessingAborted) Get Online Help Query execution failed for data set 'ProjectManager'. (rsErrorExecutingCommand) Get Online Help Could not find stored procedure 'spPM_ReportManager'.

Do you know what cause the error?

Thanks in advance for your help!

Rabbie

Basically the error message is telling you it cant find the stored procedure. I would verify that the shared datasource this report is using in the designer is deployed to the reporting server. If it does exist, I would redeploy it anyway just in case.|||

Somehow the shared datasource's xml file missing initial catalog key/value pair in <ConnectString> tag. Even redeploy the shared datasource, xml file still did not change. I had to go to the server to change the value.

Thanks for your tip, Jonathan!

|||is the s.p. in the new db?

Saturday, February 25, 2012

Reporting Services Deployment Problem

I'm new to Reporting Services and whenever I try to deploy a report I've
build in .NET, I have to turn off anonymous access to the ReportServer folder
in IIS. I imagine that Reporting Services wasnt installed correctly or that
there is some way to fix this. However, I havent been able to find any help
by searching the web or other sites I usually find helpful. Does anyone know
how to fix this?I suspect I am also in the same set of issues. My configuration is SQL
Server 2005, IIS5.1 on XP-SP2 using VS.NET 2005. The tool I am using to
debug IIS is the IIS 6.0 RK. I think my problems are related to it appears
that RS wants to be on a real server with SSL and Kerberos. NT
authentication doesn't appear to be enough to get to the virtual drive?
Al
"Derek Fisher" <Derek Fisher@.discussions.microsoft.com> wrote in message
news:93B7F131-D5F8-4AAE-9B18-5702240DE3C5@.microsoft.com...
> I'm new to Reporting Services and whenever I try to deploy a report I've
> build in .NET, I have to turn off anonymous access to the ReportServer
> folder
> in IIS. I imagine that Reporting Services wasnt installed correctly or
> that
> there is some way to fix this. However, I havent been able to find any
> help
> by searching the web or other sites I usually find helpful. Does anyone
> know
> how to fix this?|||You lose functionality if you have anonymous access because everyone is
treated the same. RS uses roll based security. What I do is setup local
groups. To the local groups I add the appropriate domain groups/users. The
local group is assigned to a roll with certain rights, usually just browse
rights.
Here is a good link to read up on security.
http://odetocode.com/Articles/215.aspx
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Derek Fisher" <Derek Fisher@.discussions.microsoft.com> wrote in message
news:93B7F131-D5F8-4AAE-9B18-5702240DE3C5@.microsoft.com...
> I'm new to Reporting Services and whenever I try to deploy a report I've
> build in .NET, I have to turn off anonymous access to the ReportServer
folder
> in IIS. I imagine that Reporting Services wasnt installed correctly or
that
> there is some way to fix this. However, I havent been able to find any
help
> by searching the web or other sites I usually find helpful. Does anyone
know
> how to fix this?|||Bruce,
That may be helpful, but it looks cumbersome. I'm deploying reports across
a company Intranet. Would using role based security require me to give every
single user (there are a LARGE number) an account? What I would really like
is a way to have an 'anonymous' user group that can only browse the reports -
that way I dont spend half of my time fielding requests for access to the
reports and setting up new accounts. Any suggestions?
Derek
"Bruce L-C [MVP]" wrote:
> You lose functionality if you have anonymous access because everyone is
> treated the same. RS uses roll based security. What I do is setup local
> groups. To the local groups I add the appropriate domain groups/users. The
> local group is assigned to a roll with certain rights, usually just browse
> rights.
> Here is a good link to read up on security.
> http://odetocode.com/Articles/215.aspx
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Derek Fisher" <Derek Fisher@.discussions.microsoft.com> wrote in message
> news:93B7F131-D5F8-4AAE-9B18-5702240DE3C5@.microsoft.com...
> > I'm new to Reporting Services and whenever I try to deploy a report I've
> > build in .NET, I have to turn off anonymous access to the ReportServer
> folder
> > in IIS. I imagine that Reporting Services wasnt installed correctly or
> that
> > there is some way to fix this. However, I havent been able to find any
> help
> > by searching the web or other sites I usually find helpful. Does anyone
> know
> > how to fix this?
>
>|||Most domains have a generic group that everyone in the domain belongs to.
For instance yourdomain\users, at my company it is ourdomain\domain users.
So you should be able to just add that group once.
If you have resource kit installed there is a dos command called showgrps
that will show you all the groups you are part of, this would show you the
catchall group.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Derek Fisher" <DerekFisher@.discussions.microsoft.com> wrote in message
news:79E8F3FF-5113-4DE8-83D9-5E3371FF89A9@.microsoft.com...
> Bruce,
> That may be helpful, but it looks cumbersome. I'm deploying reports
across
> a company Intranet. Would using role based security require me to give
every
> single user (there are a LARGE number) an account? What I would really
like
> is a way to have an 'anonymous' user group that can only browse the
reports -
> that way I dont spend half of my time fielding requests for access to the
> reports and setting up new accounts. Any suggestions?
> Derek
> "Bruce L-C [MVP]" wrote:
> > You lose functionality if you have anonymous access because everyone is
> > treated the same. RS uses roll based security. What I do is setup local
> > groups. To the local groups I add the appropriate domain groups/users.
The
> > local group is assigned to a roll with certain rights, usually just
browse
> > rights.
> >
> > Here is a good link to read up on security.
> >
> > http://odetocode.com/Articles/215.aspx
> >
> >
> > --
> > Bruce Loehle-Conger
> > MVP SQL Server Reporting Services
> >
> > "Derek Fisher" <Derek Fisher@.discussions.microsoft.com> wrote in message
> > news:93B7F131-D5F8-4AAE-9B18-5702240DE3C5@.microsoft.com...
> > > I'm new to Reporting Services and whenever I try to deploy a report
I've
> > > build in .NET, I have to turn off anonymous access to the ReportServer
> > folder
> > > in IIS. I imagine that Reporting Services wasnt installed correctly
or
> > that
> > > there is some way to fix this. However, I havent been able to find
any
> > help
> > > by searching the web or other sites I usually find helpful. Does
anyone
> > know
> > > how to fix this?
> >
> >
> >|||Bruce,
Thanks for your help. I'm a bit over my head in this discussion - since I'm
a developer with very little to no experience in network administration /
server administration but I will look into setting up role based security.
Thanks for your help.
Derek
"Bruce L-C [MVP]" wrote:
> Most domains have a generic group that everyone in the domain belongs to.
> For instance yourdomain\users, at my company it is ourdomain\domain users.
> So you should be able to just add that group once.
> If you have resource kit installed there is a dos command called showgrps
> that will show you all the groups you are part of, this would show you the
> catchall group.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Derek Fisher" <DerekFisher@.discussions.microsoft.com> wrote in message
> news:79E8F3FF-5113-4DE8-83D9-5E3371FF89A9@.microsoft.com...
> > Bruce,
> >
> > That may be helpful, but it looks cumbersome. I'm deploying reports
> across
> > a company Intranet. Would using role based security require me to give
> every
> > single user (there are a LARGE number) an account? What I would really
> like
> > is a way to have an 'anonymous' user group that can only browse the
> reports -
> > that way I dont spend half of my time fielding requests for access to the
> > reports and setting up new accounts. Any suggestions?
> >
> > Derek
> >
> > "Bruce L-C [MVP]" wrote:
> >
> > > You lose functionality if you have anonymous access because everyone is
> > > treated the same. RS uses roll based security. What I do is setup local
> > > groups. To the local groups I add the appropriate domain groups/users.
> The
> > > local group is assigned to a roll with certain rights, usually just
> browse
> > > rights.
> > >
> > > Here is a good link to read up on security.
> > >
> > > http://odetocode.com/Articles/215.aspx
> > >
> > >
> > > --
> > > Bruce Loehle-Conger
> > > MVP SQL Server Reporting Services
> > >
> > > "Derek Fisher" <Derek Fisher@.discussions.microsoft.com> wrote in message
> > > news:93B7F131-D5F8-4AAE-9B18-5702240DE3C5@.microsoft.com...
> > > > I'm new to Reporting Services and whenever I try to deploy a report
> I've
> > > > build in .NET, I have to turn off anonymous access to the ReportServer
> > > folder
> > > > in IIS. I imagine that Reporting Services wasnt installed correctly
> or
> > > that
> > > > there is some way to fix this. However, I havent been able to find
> any
> > > help
> > > > by searching the web or other sites I usually find helpful. Does
> anyone
> > > know
> > > > how to fix this?
> > >
> > >
> > >
>
>|||That's OK. A network admin or server admin will be able to translate my
suggestion and the link I sent you.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Derek Fisher" <DerekFisher@.discussions.microsoft.com> wrote in message
news:036B5699-7C2E-4F8D-BBEE-4CD1084C1EAD@.microsoft.com...
> Bruce,
> Thanks for your help. I'm a bit over my head in this discussion - since
I'm
> a developer with very little to no experience in network administration /
> server administration but I will look into setting up role based security.
> Thanks for your help.
> Derek
> "Bruce L-C [MVP]" wrote:
> > Most domains have a generic group that everyone in the domain belongs
to.
> > For instance yourdomain\users, at my company it is ourdomain\domain
users.
> > So you should be able to just add that group once.
> >
> > If you have resource kit installed there is a dos command called
showgrps
> > that will show you all the groups you are part of, this would show you
the
> > catchall group.
> >
> >
> > --
> > Bruce Loehle-Conger
> > MVP SQL Server Reporting Services
> >
> > "Derek Fisher" <DerekFisher@.discussions.microsoft.com> wrote in message
> > news:79E8F3FF-5113-4DE8-83D9-5E3371FF89A9@.microsoft.com...
> > > Bruce,
> > >
> > > That may be helpful, but it looks cumbersome. I'm deploying reports
> > across
> > > a company Intranet. Would using role based security require me to
give
> > every
> > > single user (there are a LARGE number) an account? What I would
really
> > like
> > > is a way to have an 'anonymous' user group that can only browse the
> > reports -
> > > that way I dont spend half of my time fielding requests for access to
the
> > > reports and setting up new accounts. Any suggestions?
> > >
> > > Derek
> > >
> > > "Bruce L-C [MVP]" wrote:
> > >
> > > > You lose functionality if you have anonymous access because everyone
is
> > > > treated the same. RS uses roll based security. What I do is setup
local
> > > > groups. To the local groups I add the appropriate domain
groups/users.
> > The
> > > > local group is assigned to a roll with certain rights, usually just
> > browse
> > > > rights.
> > > >
> > > > Here is a good link to read up on security.
> > > >
> > > > http://odetocode.com/Articles/215.aspx
> > > >
> > > >
> > > > --
> > > > Bruce Loehle-Conger
> > > > MVP SQL Server Reporting Services
> > > >
> > > > "Derek Fisher" <Derek Fisher@.discussions.microsoft.com> wrote in
message
> > > > news:93B7F131-D5F8-4AAE-9B18-5702240DE3C5@.microsoft.com...
> > > > > I'm new to Reporting Services and whenever I try to deploy a
report
> > I've
> > > > > build in .NET, I have to turn off anonymous access to the
ReportServer
> > > > folder
> > > > > in IIS. I imagine that Reporting Services wasnt installed
correctly
> > or
> > > > that
> > > > > there is some way to fix this. However, I havent been able to
find
> > any
> > > > help
> > > > > by searching the web or other sites I usually find helpful. Does
> > anyone
> > > > know
> > > > > how to fix this?
> > > >
> > > >
> > > >
> >
> >
> >

Wednesday, March 21, 2012

Reporting Services Login Problem

Tuesday, March 20, 2012

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Reporting Services Login

Reporting Services Login

Reporting Services Login

Reporting Services Login

Wednesday, March 7, 2012

Reporting Services Error -- Could not find stored procedure 'spPM_ProjectManager'

Saturday, February 25, 2012

Reporting Services Deployment Problem

Reporting Services Count

Blog Archive

About Me