Accessing SQL server using ASP .NET

[Stephen]

Hi,

I have written a sample ASP .NET application to connect to a SQL Server box
that uses Windows authentication ( i guess it was installed by the server
guys that way). In my web.config page I have used these configuration
parameters
<authentication mode="Windows" />
<identity impersonate="true"/>

<authorization>
<allow users="*" />

<appSettings>
<add key="SQL_DB_CONNECTION" value="SQL123" initial
catalog=Sample;integrated security=SSPI;persist security info=False;
Trusted_Connection=Yes" />

</appSettings>

Now when I run the application it gives me an Connection/Configuration Error
authorization failed for "NT\anonymous" user... why?

I went to IIS and for the application and removed the "anoymous access
login" and the application works....

How can I make the application accessible by anonymous users?

thanks,
Stephen.

[Curt_C [MVP]]

you'll have to assign the user in IIS as a valid SQL/Domain user, and not
the IUSR account

--
Curt Christianson
Owner/Lead Developer, DF-Software
Site: http://www.Darkfalz.com
Blog: http://blog.Darkfalz.com
"Stephen" <st*********@hotmail.com> wrote in message
news:ur***************@TK2MSFTNGP12.phx.gbl...

Hi,

I have written a sample ASP .NET application to connect to a SQL Server
box
that uses Windows authentication ( i guess it was installed by the server
guys that way). In my web.config page I have used these configuration
parameters
<authentication mode="Windows" />
<identity impersonate="true"/>

<authorization>
<allow users="*" />

<appSettings>
<add key="SQL_DB_CONNECTION" value="SQL123" initial
catalog=Sample;integrated security=SSPI;persist security info=False;
Trusted_Connection=Yes" />

</appSettings>

Now when I run the application it gives me an Connection/Configuration
Error
authorization failed for "NT\anonymous" user... why?

I went to IIS and for the application and removed the "anoymous access
login" and the application works....

How can I make the application accessible by anonymous users?

thanks,
Stephen.

[bruce barker]

in the web config, see the <impersonate> settings. set a userName and
password. note: asp.net supports using encrypted registery values for
security.

-- bruce (sqlwork.com)

"Stephen" <st*********@hotmail.com> wrote in message
news:ur***************@TK2MSFTNGP12.phx.gbl...
| Hi,
|
| I have written a sample ASP .NET application to connect to a SQL Server
box
| that uses Windows authentication ( i guess it was installed by the server
| guys that way). In my web.config page I have used these configuration
| parameters
| <authentication mode="Windows" />
| <identity impersonate="true"/>
|
| <authorization>
| <allow users="*" />
|
| <appSettings>
| <add key="SQL_DB_CONNECTION" value="SQL123" initial
| catalog=Sample;integrated security=SSPI;persist security info=False;
| Trusted_Connection=Yes" />
|
| </appSettings>
|
| Now when I run the application it gives me an Connection/Configuration
Error
| authorization failed for "NT\anonymous" user... why?
|
| I went to IIS and for the application and removed the "anoymous access
| login" and the application works....
|
| How can I make the application accessible by anonymous users?
|
| thanks,
| Stephen.
|
|

[Curt_C [MVP]]

Ooo... yeah, or do that :}

--
Curt Christianson
Owner/Lead Developer, DF-Software
Site: http://www.Darkfalz.com
Blog: http://blog.Darkfalz.com
"bruce barker" <no***********@safeco.com> wrote in message
news:e7**************@TK2MSFTNGP12.phx.gbl...

in the web config, see the <impersonate> settings. set a userName and
password. note: asp.net supports using encrypted registery values for
security.

-- bruce (sqlwork.com)

"Stephen" <st*********@hotmail.com> wrote in message
news:ur***************@TK2MSFTNGP12.phx.gbl...
| Hi,
|
| I have written a sample ASP .NET application to connect to a SQL Server
box
| that uses Windows authentication ( i guess it was installed by the
server
| guys that way). In my web.config page I have used these configuration
| parameters
| <authentication mode="Windows" />
| <identity impersonate="true"/>
|
| <authorization>
| <allow users="*" />
|
| <appSettings>
| <add key="SQL_DB_CONNECTION" value="SQL123" initial
| catalog=Sample;integrated security=SSPI;persist security info=False;
| Trusted_Connection=Yes" />
|
| </appSettings>
|
| Now when I run the application it gives me an Connection/Configuration
Error
| authorization failed for "NT\anonymous" user... why?
|
| I went to IIS and for the application and removed the "anoymous access
| login" and the application works....
|
| How can I make the application accessible by anonymous users?
|
| thanks,
| Stephen.
|
|

[Peter Campbell]

If you are running IIS 6, you can create an application pool and set the
identity to a user that has access rights to the sql server. Then put your
asp.net application into that application pool.

"Curt_C [MVP]" wrote:

Ooo... yeah, or do that :}

--
Curt Christianson
Owner/Lead Developer, DF-Software
Site: http://www.Darkfalz.com
Blog: http://blog.Darkfalz.com
"bruce barker" <no***********@safeco.com> wrote in message
news:e7**************@TK2MSFTNGP12.phx.gbl...

in the web config, see the <impersonate> settings. set a userName and
password. note: asp.net supports using encrypted registery values for
security.

-- bruce (sqlwork.com)

"Stephen" <st*********@hotmail.com> wrote in message
news:ur***************@TK2MSFTNGP12.phx.gbl...
| Hi,
|
| I have written a sample ASP .NET application to connect to a SQL Server
box
| that uses Windows authentication ( i guess it was installed by the
server
| guys that way). In my web.config page I have used these configuration
| parameters
| <authentication mode="Windows" />
| <identity impersonate="true"/>
|
| <authorization>
| <allow users="*" />
|
| <appSettings>
| <add key="SQL_DB_CONNECTION" value="SQL123" initial
| catalog=Sample;integrated security=SSPI;persist security info=False;
| Trusted_Connection=Yes" />
|
| </appSettings>
|
| Now when I run the application it gives me an Connection/Configuration
Error
| authorization failed for "NT\anonymous" user... why?
|
| I went to IIS and for the application and removed the "anoymous access
| login" and the application works....
|
| How can I make the application accessible by anonymous users?
|
| thanks,
| Stephen.
|
|