prompted for username and password

hi,
I've a .net app written to view reports. The app is set up in iis
with the anonymous access checked and integrated windows
authentication checked for the default web site (my app - it's a
dedicated web server) and the same with the Reports and ReportServer
virtual directories within the Default Web Site.
I can get to my app's start page fine and browse the site I've
written, but when I try to view a report from the app I am prompted
for a username and password. Why is this and how can I get rid of
it'
I've added new roles for everyone and iusr_<machinename> but still I
can't get rid of these prompts.
Any ideas'
Gearóidlook at internet explorer configuration. Security / Intranet / and deselect
"Ask for..."
"Gearoid" wrote:
> hi,
> I've a .net app written to view reports. The app is set up in iis
> with the anonymous access checked and integrated windows
> authentication checked for the default web site (my app - it's a
> dedicated web server) and the same with the Reports and ReportServer
> virtual directories within the Default Web Site.
> I can get to my app's start page fine and browse the site I've
> written, but when I try to view a report from the app I am prompted
> for a username and password. Why is this and how can I get rid of
> it'
> I've added new roles for everyone and iusr_<machinename> but still I
> can't get rid of these prompts.
> Any ideas'
> Gearóid
>|||Thanks for the suggestion but that doesn't seem to be the problem. If
I run the report server from my own machine and try to access reports
from other machines accross the network there's no problem. But if I
deploy the reports to a web server (still on the same network) I get
prompted for the username / password.
Does this sound like a firewall issue with the web server? Or an IIS
issue? Or a Report Server Config issue?
I am truly stumpted here...
"LeCroix" <LeCroix@.discussions.microsoft.com> wrote in message news:<4B95B3D1-745F-4D8F-A127-5EEA073F7626@.microsoft.com>...
> look at internet explorer configuration. Security / Intranet / and deselect
> "Ask for..."
> "Gearoid" wrote:
> > hi,
> >
> > I've a .net app written to view reports. The app is set up in iis
> > with the anonymous access checked and integrated windows
> > authentication checked for the default web site (my app - it's a
> > dedicated web server) and the same with the Reports and ReportServer
> > virtual directories within the Default Web Site.
> >
> > I can get to my app's start page fine and browse the site I've
> > written, but when I try to view a report from the app I am prompted
> > for a username and password. Why is this and how can I get rid of
> > it'
> >
> > I've added new roles for everyone and iusr_<machinename> but still I
> > can't get rid of these prompts.
> >
> > Any ideas'
> >
> > Gearóid
> >

project deployment issues

Im having some issues when deploying my project written in vb.net which
uses and Sql server database. During development I used my local
machine as the server database, and this worked fine for myself and
other users on remote pcs.
But now I have changed the sql connection string to point to a
dedicated sql server for deployment of the completed project I am the
only user who can access it. I have another administrator with access
to the same database and he can view/edit all the tables in sql server
Enterprise Manager, but when he runs my program it generates an error
on the first attempt the program makes to retreive data from the
database.
It is a basic select statement which works fine for me, but generates a
"cannot find <table_name>" type of error. We are both using exactly the
same version of the project, so I know the table exists.
I thought it must be some kind of permission i need to set in the
database, but he seems to think because he can see it in enterprise
manager it must be in my code.Hi
Does "administrator" have a full access to the server ? Is he a memeber of
symin server role?
Who is an owner of the table?
How do you perform a SELECT statement?
SELECT <> FROM dbo.TableName
SELECT <> FROM fred.Tablename ( fred is an user and owner of the table)
<nathan.atkins@.alcoa.com.au> wrote in message
news:1139196815.500065.315700@.o13g2000cwo.googlegroups.com...
> Im having some issues when deploying my project written in vb.net which
> uses and Sql server database. During development I used my local
> machine as the server database, and this worked fine for myself and
> other users on remote pcs.
> But now I have changed the sql connection string to point to a
> dedicated sql server for deployment of the completed project I am the
> only user who can access it. I have another administrator with access
> to the same database and he can view/edit all the tables in sql server
> Enterprise Manager, but when he runs my program it generates an error
> on the first attempt the program makes to retreive data from the
> database.
> It is a basic select statement which works fine for me, but generates a
> "cannot find <table_name>" type of error. We are both using exactly the
> same version of the project, so I know the table exists.
> I thought it must be some kind of permission i need to set in the
> database, but he seems to think because he can see it in enterprise
> manager it must be in my code.
>|||
> Does "administrator" have a full access to the server ? Is he a memeber of
> symin server role? - Yes

> Who is an owner of the table? - Me
> How do you perform a SELECT statement?
>
> SELECT <> FROM dbo.TableName
> SELECT <> FROM fred.Tablename ( fred is an user and owner of the table)
Currently im saying "SELECT <> FROM tablename
After reading your post im starting to think this is the problem, but
how to fix i dont know.|||Nathan --
Look in Enterprise Manager under "tables" on the database. Who is the
owner of the table you want to access? Is it "dbo" or is it you? Try
"select * from dbo.<table_name>" or "select * from
[DOMAIN\yourlogin].<table_name>. Does the latter one work? If so, you
are probably going to want to recreate your tables with "dbo" as the
owner, instead of yourself:
CREATE TABLE dbo.NewTable (...)
vs
CREATE TABLE NewTable
My best guess--
-Dave Markle
nathan.atkins@.alcoa.com.au wrote:
> Im having some issues when deploying my project written in vb.net which
> uses and Sql server database. During development I used my local
> machine as the server database, and this worked fine for myself and
> other users on remote pcs.
> But now I have changed the sql connection string to point to a
> dedicated sql server for deployment of the completed project I am the
> only user who can access it. I have another administrator with access
> to the same database and he can view/edit all the tables in sql server
> Enterprise Manager, but when he runs my program it generates an error
> on the first attempt the program makes to retreive data from the
> database.
> It is a basic select statement which works fine for me, but generates a
> "cannot find <table_name>" type of error. We are both using exactly the
> same version of the project, so I know the table exists.
> I thought it must be some kind of permission i need to set in the
> database, but he seems to think because he can see it in enterprise
> manager it must be in my code.
>