Two ASP.NET configuration questions

[spammy]

Hi,

Two issues bugging me:

1) When creating new web applicaiton projects using VS.NET and file share
mode, I always have to manually dip into IIS Manager and "create" the
application in there (by right clicking on the folder -> Properties ->
Create application). With another set up, this manuial step isnt required.
Once done (manually) as far as I can tell operation of development and
debugging are normal. Any idea why?

2) How do I change the user that the ASP.NET application runs under? I want
to access a SQL database on another machine, but instead of logging in as a
standard SQL user Id like to use an existing Windows domain user that weve
created specially for this purpose via integreated security. Can this be
done?

Thanks!

Spammy

[Cowboy]

1) Most likely a permissions issue. Make sure you are a member of VS
Developers; I believe that is the one. I have, however, had a setup where I
am not certain this worked, so there may be something even deeper.

2) This is not an ASP.NET issue, per se. Set up your web application where
there is no anonymous access. This forces a logon, which allows you to use
that user's domain account to access SQL Server.

--
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA

************************************************
Think Outside the Box!
************************************************
"spammy" <[e-mail]> wrote in message
news:2h************@uni-berlin.de...

Hi,

Two issues bugging me:

1) When creating new web applicaiton projects using VS.NET and file share
mode, I always have to manually dip into IIS Manager and "create" the
application in there (by right clicking on the folder -> Properties ->
Create application). With another set up, this manuial step isnt required.
Once done (manually) as far as I can tell operation of development and
debugging are normal. Any idea why?

2) How do I change the user that the ASP.NET application runs under? I want to access a SQL database on another machine, but instead of logging in as a standard SQL user Id like to use an existing Windows domain user that weve
created specially for this purpose via integreated security. Can this be
done?

Thanks!

Spammy

[John Saunders]

"Cowboy" <No************@comcast.netNoSpamM> wrote in message
news:Ow*************@TK2MSFTNGP09.phx.gbl...

1) Most likely a permissions issue. Make sure you are a member of VS
Developers; I believe that is the one. I have, however, had a setup where I am not certain this worked, so there may be something even deeper.

Spammy, you say that you have to create the application in IIS, but you
don't tell us which commands you use and what results or error messages you
receive. Please do. :-)

Are you logged into the same domain as the machine running IIS? Is this the
same machine you're developing on? I've seen issues when attempting to
manipulate IIS across domains.

Also, be aware that VS.NET greatly prefers to create web applications in
http://localhost/<somewhere>. Attempts to create a new web application
elsewhere can be interesting.

Please supply the details.
--
John Saunders
johnwsaundersiii at hotmail

[spammy]

>

Spammy, you say that you have to create the application in IIS, but you
don't tell us which commands you use and what results or error messages you receive. Please do. :-)

Are you logged into the same domain as the machine running IIS? Is this the same machine you're developing on? I've seen issues when attempting to
manipulate IIS across domains.

Also, be aware that VS.NET greatly prefers to create web applications in
http://localhost/<somewhere>. Attempts to create a new web application
elsewhere can be interesting.

Please supply the details.

oops sorry. firstly, i was developing locally, but now have moved to a dev
server (although i still got the same problem). the connection string and
settings im using are:

string connectionString = "data source=" + server + ";initial catalog=" + db
+ ";integrated security=SSPI;persist sec" +

"urity info=False;packet size=4096";

sqlc = new SqlConnection(connectionString);

the exception is thrown when i call sqlc.open() - 'failed login for user
"null"'. the problem is that there is no account that the asp user process
can use. changing the above to use a standard (user/password) SQL account
will make it to work however.

what i was asking was if i were to use a domain user ("ASPDomainUser", say)
to run the asp pages which has access to the SQL server it should login ok.
its just that im not sure how to get ASP processes to run in an account
other than the local ASP MACHINE USER one.