Having trouble deploying a report

I've installed SQL Server 2005 express SP2 with SQL Server Reporting
Services, along with the Business Intelligence Development Studio from
the SQL Server Express Toolkit SP2. I've created a reports project
and a simple report that I'm trying to deploy. When I try to deploy,
I get prompted for a username and password. I've tried all the
username and password for this computer combinations I can think of,
but it doesn't recognize any of them. I have the virtual directory for
the SQL Reports set to 'integrated windows'. Any ideas about what I'm
missing?
-MichaelOn Jan 19, 7:07 pm, michael.sle...@.gmail.com wrote:
> I've installed SQL Server 2005 express SP2 with SQL Server Reporting
> Services, along with the Business Intelligence Development Studio from
> the SQL Server Express Toolkit SP2. I've created a reports project
> and a simple report that I'm trying to deploy. When I try to deploy,
> I get prompted for a username and password. I've tried all the
> username and password for this computer combinations I can think of,
> but it doesn't recognize any of them. I have the virtual directory for
> the SQL Reports set to 'integrated windows'. Any ideas about what I'm
> missing?
> -Michael
Have you created at least one user account in the Report Manager? If
you haven't, you will want to create a user account with at least
Browser privileges in the Report Manager, preferably set to your
current windows domain account (i.e., DOMAIN_NAME\UserName). Also, if
you are using Firefox or some other non-IE browser, the authentication
window always pops up. If this doesn't help, you may need to evaluate
the security on the Reports and ReportServer virtual directories in
IIS. Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant|||Why not uploading the report using report manager?
http://localhost/reportS
Then "Upload Report"
See if you get an error message there, possibly more specific and post this
here.
Regards
Ralf Stofer
"EMartinez" wrote:
> On Jan 19, 7:07 pm, michael.sle...@.gmail.com wrote:
> > I've installed SQL Server 2005 express SP2 with SQL Server Reporting
> > Services, along with the Business Intelligence Development Studio from
> > the SQL Server Express Toolkit SP2. I've created a reports project
> > and a simple report that I'm trying to deploy. When I try to deploy,
> > I get prompted for a username and password. I've tried all the
> > username and password for this computer combinations I can think of,
> > but it doesn't recognize any of them. I have the virtual directory for
> > the SQL Reports set to 'integrated windows'. Any ideas about what I'm
> > missing?
> >
> > -Michael
>
> Have you created at least one user account in the Report Manager? If
> you haven't, you will want to create a user account with at least
> Browser privileges in the Report Manager, preferably set to your
> current windows domain account (i.e., DOMAIN_NAME\UserName). Also, if
> you are using Firefox or some other non-IE browser, the authentication
> window always pops up. If this doesn't help, you may need to evaluate
> the security on the Reports and ReportServer virtual directories in
> IIS. Hope this helps.
> Regards,
> Enrique Martinez
> Sr. Software Consultant
>|||On Jan 21, 2:35 pm, Ralf Stofer <RalfSto...@.discussions.microsoft.com>
wrote:
> Why not uploading the report using report manager?http://localhost/reportS
> Then "Upload Report"
> See if you get an error message there, possibly more specific and post this
> here.
> Regards
> Ralf Stofer
> "EMartinez" wrote:
> > On Jan 19, 7:07 pm, michael.sle...@.gmail.com wrote:
> > > I've installed SQL Server 2005 express SP2 with SQL Server Reporting
> > > Services, along with the Business Intelligence Development Studio from
> > > the SQL Server Express Toolkit SP2. I've created a reports project
> > > and a simple report that I'm trying to deploy. When I try to deploy,
> > > I get prompted for a username and password. I've tried all the
> > > username and password for this computer combinations I can think of,
> > > but it doesn't recognize any of them. I have the virtual directory for
> > > the SQL Reports set to 'integrated windows'. Any ideas about what I'm
> > > missing?
> > > -Michael
> > Have you created at least one user account in the Report Manager? If
> > you haven't, you will want to create a user account with at least
> > Browser privileges in the Report Manager, preferably set to your
> > current windows domain account (i.e., DOMAIN_NAME\UserName). Also, if
> > you are using Firefox or some other non-IE browser, the authentication
> > window always pops up. If this doesn't help, you may need to evaluate
> > the security on the Reports and ReportServer virtual directories in
> > IIS. Hope this helps.
> > Regards,
> > Enrique Martinez
> > Sr. Software Consultant
In order to upload a report via the Report Manager, the items I
mentioned above need to be in place beforehand.
Regards,
Enrique Martinez
Sr. Software Consultant