Re: NT Authority\networkservice failed to connect

Hi Ger,

Check what is the Identiry of the application pool which is configured for
you site. It should be Network Service by default. Remove impersonate tag
from the web config. Give permissions to "NT AUTHORITY\Network Service", if
your SQL Server on same server as IIS, If SQL Server is on seperate server
give access to the machine account "<domain>\<web server name>$" .

Hope this helps...

-Manoj

"Ger" wrote:

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.


.

Relevant Pages

  • Re: Put database on Internet
    ... > Once you will be able to connect to MSDE or to SQL-Server, ... > and ADP in the same time as frontends to your database. ... >> will be able to serve as SQL server. ...
    (microsoft.public.access.dataaccess.pages)
  • Re: Problem using SP as record source with Access2002 & SQL Server 7
    ... you shouldn't use the prefix sp_ for your stored procedures. ... SQL-Server Profiler; as you will see what ADP is trying to do when inserting ... > whole WHERE clause which is using them. ... > working with SQL Server 7, ...
    (microsoft.public.access.adp.sqlserver)
  • Re: A97 to SQL?
    ... The access/JET back-end is on the same LAN that your SQL-Server would be. ... You could migrate your data to a SQL-Server back-end, and link to your data there. ... Currently I am regularly adding little enhancements, new reports, etc etc, to the A97 mdb FE, and it's very useful that I can do this. ... I know nothing about SQL server, and am unlikely to be able to find the time to get into it. ...
    (microsoft.public.access.conversion)
  • Re: SSIS Datenkonvertierung
    ... Express-Edition) und hab die Informationen aus dem SQL-Server Management ... Microsoft Analysis Services-Clienttools 2005.090.1399.00 ... Services, das Management Studio, SQL-Server Analysis Services. ... Welche Version om SQL Server 2005 hast Du? ...
    (microsoft.public.de.sqlserver)
  • Re: SQL Server CE Mobile?
    ... I did run the ConnWiz30.exe and after some trouble with the share config, ... I need to install SQL Server Replication Components - is that a correct ... "SQL Server Mobile Server Agent ... Replication is actually easier with SQL Mobile. ...
    (microsoft.public.sqlserver.ce)