Re: NT Authority\networkservice failed to connect

Thank you Ekrem for this information.
Still I have some questions about this issue:

case 1 (local)
When <identity impersonate="true/> is not set in web.config, ASP.net assumes
that NT Authority/networkservice is trying to access the SQL-database. It
raised the error, because NT Authority/networkservice is not a AD-member of
SBS2003 (and cannot be created too).

Now setting the <identity impersonate="true"/> in web.config, ASP.net
assumes that (username,password) is trying to access the SQL-database. While
this (username, password) is a user (with full permissions) of AD of SBS2003
and the access is granted.

OK, so far I can run the project local without problems.

Case 2 (remote)
Now, a user access via the Internet the aspx-file and runs it. Now the
account of this user is (in my opinion) IUSR_SBS, which is an inbuilduser of
SBS2003. I gave this inbuilduser the specific rights to access the
SQL-server, but nothing happens.. the page is not showed and the program
hangs ??

So, alltogether, I can local run the project without problems, but remote it
is not possible. Where am I thinking incorrect and what to do to solve my
problem??

regards, Ger.



"Ekrem Önsoy" wrote:

Hello Ger,

I believe the following link will provide you more information about this
setting.

http://msdn2.microsoft.com/en-us/library/72wdk8cc(VS.71).aspx

--
Ekrem Önsoy



"Ger" <Ger@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:1AACF24A-06FF-4F20-B7E2-31A230E237EB@xxxxxxxxxxxxxxxx
Hi, found it! (anyway in my case)

Setting the following in the webconfig of the VS.2003-project solved the
access-problem:
<!-- GLOBALIZATION
This section sets the globalization settings of the application.
-->
<globalization requestEncoding="utf-8" responseEncoding="utf-8" />

<identity impersonate="true"/>

Hope this helps other too,

regards, Ger.

"Ger" wrote:

Hi,

I am brandnew to webdevelopment.
Using SBS2003 sp1 with IIS6, VS.net 2003 and SQL2000.
I created a webapplication with VS.net which has a SQLClientDataadapter,
which is connected with the SQL2000-server.

I got the following error, when I run (from IDE) the project:
Login failed for user 'NT AUTHORITY\Netwerkservice'.

This user doesnot exists on SBS2003(AD). Probably VS.net 2003 uses this
user
trying to access SQL-server. In SQL-server I cannot add this user,
because it
doesnot exists in SBS2003.

What can I do, to give the VS.net app. access to SQL2000 ???

regards, Ger.


.