Deploy Report from Designer prompts for Credentials

Question

Post reply

Deploy Report from Designer prompts for Credentials

Welsh Corgi

SSC Guru

Points: 116520
More actions
November 17, 2012 at 10:11 am

#285111

I installed SQL Server 2008 R2 on a new Server.
I went through the Reporting Services Configuration Manager successfully.
Then I tried to deploy a report from the Report Designer but I keep getting prompted for User Name and Password.
This is my first shot at Reporting Services.
I'm guessing that I need to define Security?
Could someone please provide me with some guidance?
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Viewing 6 posts - 1 through 5 (of 5 total)

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

Welsh Corgi SSC Guru Points: 116520 More actions · Answer 1

I created the Report directly on the Reporting Services Server.

I specified the URL of the Reporting Services Server in the TargetServerURL Property.

When I attempt to deplo I get an error:

The specified report server url could not be found.

Please verify the syntax of the URL and that the Report Server Exists.

I'm using the URL that I defined in the Reporting Services Configuration Manager

Any ideas?

For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Welsh Corgi SSC Guru Points: 116520 More actions · Answer 2

Now all of a sudden I'm getting the gollowing error when I attempt to go to the Reporting Services URL:

User 'MyDomain\MyUser' does not have required permissions. Verify that sufficient permissions have been granted and Windows User Account Control (UAC) restrictions have been addressed.

This seemed to happen after I added myself as a Reporting Services Administrator Role.

I have been searching the internet and everthing that I found I had already done.

Any ideas would be greatly appreciated.

For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Welsh Corgi SSC Guru Points: 116520 More actions · Answer 3

I get the following error when I attempt to go to the URL from the Reporting Services Server:

User 'MyDomain\MyUser' does not have required permissions. Verify that sufficient permissions have been granted and Windows User Account Control (UAC) restrictions have been addressed.

I do not get the error when I attempt to go to the URL from my PC????

For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Welsh Corgi SSC Guru Points: 116520 More actions · Answer 4

I tried creating a Data Source from the REport Manager on the Server and I get the following error:

Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.

I specified Integrated Security following the example in the following article:

http://www.mssqltips.com/sqlservertutorial/247/report-manager/

I also tried credential stored in the report server but I got the following:

Login failed for user 'MyUser'.

If I try and deploy from BIDS on my client PC following example I keep getting prompted to Login:

http://www.mssqltips.com/sqlservertutorial/246/bids/

If I try and deploy using BIDS on the Server I get the following:

The specified report server url could not be found.

Please verify the syntax of the URL and that the Report Server Exists.

Any ideas would be greatly appreciated.

For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

BLOB EATER SSChampion Points: 14609 More actions · Answer 5

In Visual Studio > project > properties.

Is all the info there correct?