473,320 Members | 1,862 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

Forms Authentication and SQL 2000

I am using ASP.NET 2.0 and I'm trying to use Forms Authentication. The
application runs on IIS6 on Server 2003, but the SQL server is running
on a Windows 2000 Server.

Per this walkthrough,
http://msdn.microsoft.com/library/de...AGHT000014.asp,
it says I need to create a SQL login for NT AUTHORITY\Network Service
and grant it access to my applications database. However, since the
database server is running on 2000 Server, there is no such object NT
AUTHORITY\Network Service for which I can grant a SQL login.

I'm sure I'm missing something pretty obvious, but I can't figure out
how to get around this... Any help is appreciated!
Jason

Jul 24 '06 #1
1 773
I don't doubt that you can't see it. But you can still add it. When adding
a "New Login", type NT AUTHORITY\Network Service into the name field. It
will display "NT AUTHORITY" in the Domain box. When you click OK, it will
accept it.

Hope this helps...

Sincerely,
John Swanagon
Sr. Software Engineer, Avaya Labs
Avaya Inc.
jm********@avaya.com

<st*************@gmail.comwrote in message
news:11**********************@m79g2000cwm.googlegr oups.com...
>I am using ASP.NET 2.0 and I'm trying to use Forms Authentication. The
application runs on IIS6 on Server 2003, but the SQL server is running
on a Windows 2000 Server.

Per this walkthrough,
http://msdn.microsoft.com/library/de...AGHT000014.asp,
it says I need to create a SQL login for NT AUTHORITY\Network Service
and grant it access to my applications database. However, since the
database server is running on 2000 Server, there is no such object NT
AUTHORITY\Network Service for which I can grant a SQL login.

I'm sure I'm missing something pretty obvious, but I can't figure out
how to get around this... Any help is appreciated!
Jason

Jul 24 '06 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

6
by: Billy Jacobs | last post by:
I have a website which has both secure and non-secure pages. I want to uses forms authentication. How do I accomplish this? Originally I had my web.config file in the root with Forms...
1
by: Hugh McLaughlin | last post by:
Hello Everyone and thanks for your help in advance. I recently installed Visual Studio 2003 and .Net 1.1. I then converted one of my applications to 2003. However, I am running into a probelm...
5
by: Mark | last post by:
Hi, I want to run in my .Net Windows Form this statement System.Diagnostics.Process.Start(strURLCommand) to open the browser and navigate to the specified URL. The URL is an ASP.Net Web...
3
by: Nick | last post by:
I am working a new application...well actually a series of applications for my company. They want internal users to be able to go to a site and everything regarding security is transparent,...
4
by: Greg Burns | last post by:
I have built a web app that uses forms authentication. There isn't a "remember me" feature (i.e. the authentication cookie is not permanent). When you close the browser, and open a new one, you...
1
by: Rob | last post by:
I have an ASP.NET application that uses forms-based authentication. A user wishes to be able to run multiple sessions of this application simultaneously from the user's client machine. The...
1
by: Ed | last post by:
Hi, I'm have an asp.NET project, and I'm using Forms authentication method. I was wondering if there is a way to deny access to files that are not .aspx...ie: Someone who tries to access...
4
by: Lewis Edward Moten III | last post by:
I have a file that users can download through a web page protected by forms authentication: Download.aspx?ID=45 and within that file ... FileInfo fileToDownload = new FileInfo(fileName);
2
by: Brian Shannon | last post by:
I have an intranet site I created when I first began .NET and it is very basic. Now that I have developed my skills I am looking to revamp the old with something new. I really like the idea of...
6
by: William F. Zachmann | last post by:
We've got a project going that involves moving an old web site with a massive dll written in C++ that produces most of the output from a SQL 7.0 data base on NT4 onto IIS on Windows 2003 Server...
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
0
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.