Deploy Report from Designer prompts for Credentials

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Reporting Services » Reporting Services 2008 Administration » Deploy Report from Designer prompts for...

Deploy Report from Designer prompts for Credentials

Rate Topic

Display Mode

Topic Options

Author

Message

Welsh Corgi

Posted Saturday, November 17, 2012 10:11 AM

Hall of Fame

Group: General Forum Members
Last Login: Today @ 2:29 PM
Points: 3,823, Visits: 4,046

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/

Post #1385950

Welsh Corgi

Posted Saturday, November 17, 2012 4:51 PM

Hall of Fame

Group: General Forum Members
Last Login: Today @ 2:29 PM
Points: 3,823, Visits: 4,046

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/

Post #1386019

Welsh Corgi

Posted Saturday, November 17, 2012 5:26 PM

Hall of Fame

Group: General Forum Members
Last Login: Today @ 2:29 PM
Points: 3,823, Visits: 4,046

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/

Post #1386023

Welsh Corgi

Posted Saturday, November 17, 2012 5:36 PM

Hall of Fame

Group: General Forum Members
Last Login: Today @ 2:29 PM
Points: 3,823, Visits: 4,046

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/

Post #1386026

Welsh Corgi

Posted Sunday, November 18, 2012 9:07 AM

Hall of Fame

Group: General Forum Members
Last Login: Today @ 2:29 PM
Points: 3,823, Visits: 4,046

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/

Post #1386051

sql.com

Posted Monday, November 19, 2012 4:41 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, April 22, 2013 8:31 AM
Points: 172, Visits: 549

In Visual Studio > project > properties.

Is all the info there correct?

-------------------------------------------
I'm not afraid of storms, for I'm learning to sail my ship

Post #1386300

« Prev Topic | Next Topic »

Permissions