Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Unable to open a SQL connection
Message
 
To
14/10/2002 08:38:54
Christian Cote
Les Logiciels Onoma Inc.
Longueuil, Quebec, Canada
General information
Forum:
ASP.NET
Category:
Other
Miscellaneous
Thread ID:
00710873
Message ID:
00710887
Views:
13
>while using a connect string w/o any problems with Windows Forms, I cannot use the same string with a Web Form. I get this error message:
>System.Data.SqlClient.SqlException: Login failed for user 'NT AUTHORITY\NETWORK SERVICE'.
>
>What kind of security I need to change in SQL server?

The difference is that Web pages by default run under the anonymous account (i.e. IUSR_XXXXXXXXX) and not the logged in user.
If you want each user to access SQL Server with it's own account, you must turn Impersonation on thru the Web.config file.
Otherwise, you may assign a domain user to the Web site anonymous login (thu the Internet Services Console), and grant permissions to that user on the SQL Server.

Hope this helps and bye
Jose
------------------
Jose Marcenaro
Tercer Planeta - Argentina
http://www.tercerplaneta.com
Previous
Reply
Map
View

Click here to load this message in the networking platform