SQL Server - 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

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

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 ???

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

24-Nov-09 04:25 PM

Hi,
Yep, have solved the problems... thanks for your help!