Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Deploy Report from Designer prompts for Credentials Expand / Collapse
Author
Message
Posted Saturday, November 17, 2012 10:11 AM


SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: 2 days ago @ 7:06 AM
Points: 4,196, Visits: 4,268
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
Posted Saturday, November 17, 2012 4:51 PM


SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: 2 days ago @ 7:06 AM
Points: 4,196, Visits: 4,268
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
Posted Saturday, November 17, 2012 5:26 PM


SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: 2 days ago @ 7:06 AM
Points: 4,196, Visits: 4,268
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
Posted Saturday, November 17, 2012 5:36 PM


SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: 2 days ago @ 7:06 AM
Points: 4,196, Visits: 4,268
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
Posted Sunday, November 18, 2012 9:07 AM


SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: 2 days ago @ 7:06 AM
Points: 4,196, Visits: 4,268
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
Posted Monday, November 19, 2012 4:41 AM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Saturday, August 23, 2014 9:39 AM
Points: 174, Visits: 573
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 »

Add to briefcase

Permissions Expand / Collapse