[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

Can't deploy Reports - Login fails

Posted on 2009-04-15
7
Medium Priority
?
749 Views
Last Modified: 2012-05-06
I have some reports on one server and like to deploy them onto another web server. Reports have been built with no errors. I am using SQL Server 2005. The server to deploy to is a Wiindows 2003 Server Standard edition with IIS installed. When I deploy the reports in BIDS, I get a login dialog and I enter the admin account info and click. Nothing happens and BIDS keeps asking me for a login. No error messages and nothing seems to happen. What can I do? Any suggestions?
0
Comment
Question by:gtrapp
  • 4
  • 3
7 Comments
 
LVL 8

Expert Comment

by:SNilsson
ID: 24154521
Your can always browse to the reporting server interface on that server with IE running under your admin account (Servername/reportspath).
Then you just hit the upload button and browse for your .rdp file on the local computer.
You might need to create a new datasource in the web interface and bind the report to that one.
Then it should work.
 
0
 

Author Comment

by:gtrapp
ID: 24160339
I can browse to reporting server interf Managace on the server with IE running. Report Server and Report Manager are up and running.

Not sure where this upload button is and can't find a .rdp file on my local button. Is the upload button in BIDS?
0
 
LVL 8

Accepted Solution

by:
SNilsson earned 1500 total points
ID: 24160444
Check the picture below thats the upload buton I'm talking about, the rdp file should be in your development folder on the local computer.
ssrs.bmp
0
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 

Author Comment

by:gtrapp
ID: 24161351
I fixed the problem. I needed to change the target folder on the deploy properties and BIDS found the reporting server. Also, I could not find a .rdp file.
0
 
LVL 8

Expert Comment

by:SNilsson
ID: 24162233
Sorry, it's .rdl not .rdp
0
 
LVL 8

Expert Comment

by:SNilsson
ID: 24164934
Since an alternative solution to deploy the report was introduced and the deploy path was shown when browsing to the reports folder it did help to solve the original problem.
0
 

Author Closing Comment

by:gtrapp
ID: 31570735
Fine, even though you had the file name wrong and I did not use the upload. The actual problem was with the deployment paths.
0

Featured Post

Visualize your virtual and backup environments

Create well-organized and polished visualizations of your virtual and backup environments when planning VMware vSphere, Microsoft Hyper-V or Veeam deployments. It helps you to gain better visibility and valuable business insights.

Question has a verified solution.

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

Introduction In the following article I’ll be discussing and demonstrating several different ways of how images can be put on a report. I’m using SQL Server Reporting Services 2008 R2 CTP, more precisely version 10.50.1352.12, but the methods ex…
I recently went through setting up a JasperReports Server using the AWS EC2 instance, and this article will cover some basic administration tasks I had to perform.
Is your OST file inaccessible, Need to transfer OST file from one computer to another? Want to convert OST file to PST? If the answer to any of the above question is yes, then look no further. With the help of Stellar OST to PST Converter, you can e…
As many of you are aware about Scanpst.exe utility which is owned by Microsoft itself to repair inaccessible or damaged PST files, but the question is do you really think Scanpst.exe is capable to repair all sorts of PST related corruption issues?

867 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