SQL Express
(1)
SQL Server
(1)
Windows 7
(1)
Vista
(1)
IIS
(1)
Report
(1)
Conger
(1)
Loehle
(1)

always asks for user my userid and pwd when deploying a report

Asked By Aussie Rules
20-Nov-09 04:33 AM
Hi,

I have a vista PC with IIS installed and SQL Express with advanced services.

I have installed the reporting services and have been able to access the web
site and ensure that its all working.

On loading visual studio 2008, I create a repot. I am able to create the
report and test it, and its all fine.

When I go to publish the report, it always has a popup that requests my user
id and password. No matter what I enter it always fails and end up asking
again for my userid/pwd over and over.

I am logged into the Vista PC as an Administrator so not sure why this is
happening... I just want to be able to easily deploy my reports from visual
studio.

Any ideas on whats happening ????

Thanks

Vista and Windows 7 both have additional security.

Bruce L-C [MVP] replied to Aussie Rules
20-Nov-09 11:49 AM
Vista and Windows 7 both have additional security. It does not matter that
you are logged in as administrator, if you do not run a program with enhanced
rights (run as administrator or something like that) then you run with
limited rights. On Windows 7 I had the issue with using IE to connect to RS
on the same box. I got around it by opening up IE with enhanced rights. I
bet if you do this with VS then you will be OK.

--
Bruce Loehle-Conger
MVP SQL Server Reporting Services

Hi,I took your advice, and loaded up visual studio, by selecting the

Aussie Rules replied to Bruce L-C [MVP]
21-Nov-09 07:38 PM
Hi,

I took your advice, and loaded up visual studio, by selecting the option
'Run as Administrator', but it still asks me for a user id/pwd combo when I
try to deploy.

Any other tips or tricks to try ???

Make sure that you do not have anonymous turned on with IIS.

Bruce L-C [MVP] replied to Aussie Rules
23-Nov-09 03:13 PM
Make sure that you do not have anonymous turned on with IIS.

--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
Hi,Yep, have solved the problems... thanks for your help!
Aussie Rules replied to Bruce L-C [MVP]
24-Nov-09 04:25 PM
Hi,
Yep, have solved the problems... thanks for your help!
Post Question To EggHeadCafe