Re: Authentication with Win2003 Enterprise
From: Kristofer Gafvert (kgafvertONLINE_at_ilopia.com)
Date: 05/09/03
- Next message: Shri: "SQL Server 2000 (Application) Role accessed through ADO.NET"
- Previous message: Vinodk: "Re: Transfering NT logins"
- In reply to: Bürgen Straüß: "Authentication with Win2003 Enterprise"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Date: Fri, 9 May 2003 12:27:36 +0200
Hi,
what do you mean by "ask"? When does it ask for this user? Are you using a
Web application that uses SQL Server and it's this that is causing this?
This maybe helps, if you are using a web application:
http://www.ilopia.com/windows2003/search.aspx?qid=62
Q62: I installed IBS (IBuySpy) portal and/or Store. When I try to run it I
get this error message:
"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."
What is wrong?
NT AUTHORITY\NETWORK SERVICE is an account used by IIS. When you run web
applications, it will use this account to authenticate to all resources it
is trying to use (in this case SQL Server or MSDE). So we have three
different ways to solve this, grant NT AUTHORITY\NETWORK SERVICE logon
rights to the database, create a SQL Server/MSDE user and use that, or
change the account which IIS is using. The first option is the most simple
one. To grant this user logon rights, you can use Enterprise Manager if you
have SQL Server or a utility called osql if you are using MSDE. To do this
with osql, follow these steps [... for more info, see web page]
-- Regards, Kristofer Gafvert http://www.ilopia.com - FAQ and Tutorials for Windows Server 2003 Reply only to newsgroup(s), if you by some reason must contact me, remember to remove the "online" part of my address. "Bürgen Straüß" <b_strauss@hotmail.com> wrote in message news:#8YM89FFDHA.2264@TK2MSFTNGP12.phx.gbl... > I originally has the SQL-SP3 server set to use Windows Only, I now have it > set to Mixed mode, but yet it continually asks for a non-existent > account/group: > "NT AUTHORITY\NETWORK SERVICE" > > That occurs regardless of what user_id I set, whether it be sa, > Administrator or a_user. > > This occurs regardless of whether I attempt it locally, or from a different > machine. > > Any ideas? > >
- Next message: Shri: "SQL Server 2000 (Application) Role accessed through ADO.NET"
- Previous message: Vinodk: "Re: Transfering NT logins"
- In reply to: Bürgen Straüß: "Authentication with Win2003 Enterprise"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
