Solved

Visual Studio 2008 - Reporting services login prompt

Posted on 2012-04-01
3
776 Views
Last Modified: 2012-04-03
When attempting to deploy a report in Visual Studio 2008, a 'Report Services Login' is generated.
Server: http://'ServerName'/ReportServer

We have attempted to use domain admin credentials and also the sa credentials, all of which are not accepted. No error is generated, the login prompt remains.

SQL Server 2008 is hosted on Windows Server 2008 Standard.
Visual Studio is installed on Server 2003.

When browsing http://'ServerName'/ReportServer/ - the page is opened automatically.
When browsing the same server but using IP address - a username and password is requested. Logging in with domain admin credentials is fine.


Thanks in advance.
0
Comment
Question by:KCITS
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
3 Comments
 
LVL 11

Expert Comment

by:srikanthreddyn143
ID: 37798148
Report server path and report manager path are different.  When you access reports through report server path, you can just execute reports. But thru report manager path, you can update data sources, remove reports etc. You cannot deploy reports to report manager path. Please check with your admin to get the right report server path.
0
 
LVL 29

Accepted Solution

by:
sammySeltzer earned 500 total points
ID: 37802398
If you can access the report via servername with no login prompts but you are challenged with you attempt to do so with IP address, it seems to be that one of your system admins needs to synch ip address with servername.

Meanwhile, it is advisable to use servername instead of iP address anyway.
0
 
LVL 1

Author Closing Comment

by:KCITS
ID: 37803942
there were problems with AD, AD user names could not be resolved we jhad error messages such as RPC Server unavailable. we fixed this by changing TMG RPC rule to not require strict compliance.

Then the report server cold be used by the server name as suggested by sammy. previously we were using ip-address. this fixed the problem
0

Featured Post

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

After restoring a Microsoft SQL Server database (.bak) from backup or attaching .mdf file, you may run into "Error '15023' User or role already exists in the current database" when you use the "User Mapping" SQL Management Studio functionality to al…
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
Michael from AdRem Software explains how to view the most utilized and worst performing nodes in your network, by accessing the Top Charts view in NetCrunch network monitor (https://www.adremsoft.com/). Top Charts is a view in which you can set seve…
Monitoring a network: how to monitor network services and why? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the philosophy behind service monitoring and why a handshake validation is critical in network monitoring. Software utilized …

626 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question