IIS Server Security - Getting error when accessing a virtual directory

This is Interesting: Free IT Magazines  
Home > Archive > IIS Server Security > January 2006 > Getting error when accessing a virtual directory





You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author Getting error when accessing a virtual directory
LizW

2006-01-05, 6:07 pm

Not sure if this is a server 2003 issue or SQL - I can access the virtual
directory because I can get to the default home page but get this error after
I login to our application...

I am trying to connect to a virtual directory where there is an application
that was developed in .asp.net - it is linked to a sql server database. I am
using IIS, Server 2003 and SQL Server 2000 - same server - Any ideas where
this may be coming from? I posted this message in SQL and Server security
sections. Thanks.

Server Error in '/Admin' Application.
--------------------------------------------------------------------------------

Login failed for user 'NT AUTHORITY\NETWORK SERVICE'.
Description: An unhandled exception occurred during the execution of the
current web request. Please review the stack trace for more information about
the error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: Login failed for user
'NT AUTHORITY\NETWORK SERVICE'.

Source Error:

An unhandled exception was generated during the execution of the current web
request. Information regarding the origin and location of the exception can
be identified using the exception stack trace below.

Stack Trace:


[SqlException: Login failed for user 'NT AUTHORITY\NETWORK SERVICE'.]
System.Data.SqlClient.ConnectionPool.GetConnection(Boolean&
isInTransaction) +474

System.Data.SqlClient.SqlConnectionPoolManager.GetPooledConnection(SqlConnectionString options, Boolean& isInTransaction) +372
System.Data.SqlClient.SqlConnection.Open() +384
ut.hfrp.asap.DAO.BaseDAO.getConnection() +83

[DAOException: Unable to create connection to database]
ut.hfrp.asap.DAO.BaseDAO.getConnection() +154
ut.hfrp.asap.DAO.UserDAO.GetList() +70
ut.hfrp.asap.BusObj.Settings.AirlineSettings.GetUserList() +30
ut.hfrp.asap.ManagerApp.Login.SubmitLogin_Click(Object sender, EventArgs
e) +51
System.Web.UI.WebControls.Button.OnClick(EventArgs e) +108

System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +57
System.Web.UI.Page. RaisePostBackEvent(IPostBackEventHandler

sourceControl, String eventArgument) +18
System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +33
System.Web.UI.Page.ProcessRequestMain() +1292




--
LizW
Christian Paparelli

2006-01-06, 2:59 am

"LizW" <LizW@discussions.microsoft.com> ha scritto nel messaggio
news:39DD95F5-52AF-42E6-B4A3-F4F804EBEF2D@microsoft.com...
> Not sure if this is a server 2003 issue or SQL - I can access the virtual
> directory because I can get to the default home page but get this error
> after
> I login to our application...
>
> I am trying to connect to a virtual directory where there is an
> application
> that was developed in .asp.net - it is linked to a sql server database. I
> am
> using IIS, Server 2003 and SQL Server 2000 - same server - Any ideas where
> this may be coming from? I posted this message in SQL and Server security
> sections. Thanks.
>
> Server Error in '/Admin' Application.
> --------------------------------------------------------------------------------
>
> Login failed for user 'NT AUTHORITY\NETWORK SERVICE'.
> Description: An unhandled exception occurred during the execution of the
> current web request. Please review the stack trace for more information
> about
> the error and where it originated in the code.
>
> Exception Details: System.Data.SqlClient.SqlException: Login failed for
> user
> 'NT AUTHORITY\NETWORK SERVICE'.
>
> Source Error:


there is a security error, user network service doen't have permission to
access on sql server.
Then you have two solution, create on sql server the logins for the user or
on your application use valid credential

There you can find an example
http://msdn.microsoft.com/library/d...paght000008.asp


--
Christian Paparelli
http://www.ithost.ch


Sponsored Links






Free braindumps | Software forum | Database administration forum

Copyright 2003 - 2008 webservertalk.com