Sunday, February 12, 2012

ASP.NET Cannot use msde2000 in the win2003 server

In the office I am Setup win server 2003 and setup iis for webserver and download msde2000 for create database.
In the first I create web application for connect the database and use DataGrid Control for show it.
And then I create database in the Server Explorer in the Vc#.net. Now I compile program complete. Not error
But the IE show text for me is
......
(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 where it originated in the code.
Exception Details: System.Data.SqlClient.SqlException: Login failed for user 'NT AUTHORITY\NETWORK SERVICE'.
Source Error:
LINE 31: sqlDataAdapter1.Fill(DataSet11); -- But the source is not error in my home computer (my home computer use winxp + msde2000 + vc#)
How I fix this problem.
Thank a lot
That is the aspnet_wp.exe process model account you're seeing the
login failure message for. You configure in your machine.config file
whether to use machine or system (system is less secure) for the
processModel setting. When you connect through asp.net, you're not
connecting as yourself unless you've configured impersonation, but as
the aspnet process. The aspnet process Windows account doesn't have a
SQLS login and requisite database permissions enabled for it. A good
resource on working with asp.net security is the "best practices"
whitepaper, which i recommend you download from:
http://www.microsoft.com/downloads/r...eleaseID=44047
--Mary
On Sun, 18 Apr 2004 04:41:03 -0700, Aurora
<anonymous@.discussions.microsoft.com> wrote:

>In the office I am Setup win server 2003 and setup iis for webserver and download msde2000 for create database.
>In the first I create web application for connect the database and use DataGrid Control for show it.
>And then I create database in the Server Explorer in the Vc#.net. Now I compile program complete. Not error
>But the IE show text for me is
>......
>(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 where it originated in the code.
>Exception Details: System.Data.SqlClient.SqlException: Login failed for user 'NT AUTHORITY\NETWORK SERVICE'.
>Source Error:
>LINE 31: sqlDataAdapter1.Fill(DataSet11); -- But the source is not error in my home computer (my home computer use winxp + msde2000 + vc#)
>How I fix this problem.
>Thank a lot

No comments:

Post a Comment