[2 days left] What’s wrong with your cloud strategy? Learn why multicloud solutions matter with Nimble Storage.Register Now

x
?
Solved

Cannot Deploy Reports?  Login pops up??

Posted on 2008-06-12
20
Medium Priority
?
1,225 Views
Last Modified: 2011-10-19
Hello All,

I am trying to get reporting services up and running on a Windows Vista machine.  I'm using SQL Server 2005.  I built several reports and when I try and deploy them a RS Login prompt comes up.  I didn't have this on my other machine that was running the reports.  Also, I am using Windows Authentication.  How do I get this to go away??

Thank you for all your help.
0
Comment
Question by:ltmnm
[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
20 Comments
 
LVL 19

Expert Comment

by:Melih SARICA
ID: 21774144
u sure u ave administrative rights  ?
0
 
LVL 17

Expert Comment

by:Daniel Reynolds
ID: 21774147
Check how you log into the vista machine... for example:

If you were logging in to the domain that the reporting server is on, you probably wouldn't get prompted to login.

Conversely, you say that you are now on a new machine. Is it on the same domain? Are you logging in to the vista machine or are you logging on to the domain when you log on to the vista machine.

0
 
LVL 1

Author Comment

by:ltmnm
ID: 21778432
I do have admin rights.  I log onto the domain.  It is the same domain and the same domain user as the other system.  I believe I ran into this issue before when it was setup on the first machine.  I thought that all I needed to do was go into IIS and set the security settings for the virtual report folders.  But I don't see the same setup in Vista as I did in XP and Server 2003.
0
Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

 
LVL 1

Author Comment

by:ltmnm
ID: 21780624
Here is the screen shot of what I was talking about.  This may not be where I should be looking to fix the issue.  But I thought that I remembered changing this before to address a similar issue.  Any ideas?
0
 
LVL 1

Author Comment

by:ltmnm
ID: 21780692
sorry, did not attach correctly.
screenshots.jpg
0
 
LVL 1

Author Comment

by:ltmnm
ID: 21794676
Is there anyone out there that knows about setting up Reporting Services on Vista??
0
 
LVL 18

Expert Comment

by:chrismc
ID: 21800427
This might help?
I got this from Brian Welckers Weblog at
http://blogs.msdn.com/bwelcker/archive/2007/03/19/candy-apple-grey-installing-ssrs-and-windows-vista.aspx;


CANDY APPLE GREY (INSTALLING SSRS AND WINDOWS VISTA)
It's a bit tricky to get Reporting Services (including the report server that comes with SQL Express with Advanced Services) to work on Windows Vista. The key is to turn on the right set of IIS components in the "Turn Windows features on or off" tool in the Vista control panel. Here is the list of required IIS features you need to add for Reporting Services to work:

Web Management Tools
IIS 6 Management Compatibility
IIS 6 WMI Compatibility
IIS Metabase and IIS 6 configuration compatibility
World Wide Web Services
Application Development
.NET Extensibility
ASP.NET
ISAPI Extensions
ISAPI Filters
 Common HTTP Features
Default Document
Directory Browsing
HTTP Redirection
Static Content
 Security
Windows Authentication
Note that IIS7 in Vista Home Premium does not include Windows Authentication functionality so it will not work with SSRS.

You will get a compatibility message when you start to install SQL Server 2005. This is to let you know that you will need to install SQL Server 2005 Service Pack 2 after the installation finishes. You should also read Section 5.5 of the SQL Server 2005 Readme (Reporting Services Considerations for Windows Vista) for known issues and limitations.
0
 
LVL 1

Author Comment

by:ltmnm
ID: 21803119
Thank you for your input.  All those options are checked.
0
 
LVL 1

Author Comment

by:ltmnm
ID: 21803255
what about turning on Integrated Windows authentication?  I read online that is how you fix this issue in server 2003.  How would I do this in Vista?
0
 
LVL 18

Expert Comment

by:chrismc
ID: 21807213
In IE on XP you go to Tools | Internet Options | Security | Intranet | Custom
Then scroll down to the bottom of the long list of settings and make sure
"Automatic Logon in Intranet only" is selected.

Haven't had the pleasure ;-P of Vista yet so can't help there but the setting should be a million miles away from that.
0
 
LVL 1

Author Comment

by:ltmnm
ID: 21807916
That IE security setting is already set to that.  I still get the login prompt when I try to deploy a report.
loginScreenShot.jpg
0
 
LVL 18

Expert Comment

by:chrismc
ID: 21808845
In IIS do you have Basic Authentication checked?

Also I just upgraded a server to SQL Server SP2 and the final step was the "SQL Server 2005 User Provisioning Tool for Vista" which automatically changes some security settings.

May be worth looking at.
0
 
LVL 1

Author Comment

by:ltmnm
ID: 21812613
Basic Authentication is checked.
0
 
LVL 18

Expert Comment

by:chrismc
ID: 21814163
Try unchecking it, I think that's what's prompting you for the login.
0
 
LVL 1

Author Comment

by:ltmnm
ID: 21815400
I unchecked it and tried to deploy a report.  Still get the login prompt.
0
 
LVL 18

Expert Comment

by:chrismc
ID: 21815427
Maybe a stupid question, but did you restart IIS afterwards?

0
 
LVL 1

Accepted Solution

by:
ltmnm earned 0 total points
ID: 21830632
I did restart IIS afterwards
0
 
LVL 18

Assisted Solution

by:chrismc
chrismc earned 400 total points
ID: 21832783
I'm at a loss to suggest anything else.
I'm fairly certain your issue is in IIS, but it could be Active Directory or Policies affecting it.

None of this areas am I expert in!
Maybe post this in a more security orientated zone?
0
 

Expert Comment

by:LouisGia
ID: 22830323
I'm facing the same problem... I don't see a solution anywhere on the web. I've deployed Reporting services on my home PC, running Windows Vista Ultimate and I can't make it work!!! I Also tried MS SQL 2008 but not luck with it either! What are we missing here?
0

Featured Post

NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

Question has a verified solution.

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

In this article we will learn how to fix  “Cannot install SQL Server 2014 Service Pack 2: Unable to install windows installer msi file” error ?
An alternative to the "For XML" way of pivoting and concatenating result sets into strings, and an easy introduction to "common table expressions" (CTEs). Being someone who is always looking for alternatives to "work your data", I came across this …
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function

656 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