Go Back   Velocity Reviews > Newsgroups > ASP Net
User Name
Password
Register FAQ Members List Calendar Search Today's Posts Mark Forums Read

Reply

ASP Net - Forms Authentication and SQL 2000

 
Thread Tools Search this Thread
Old 07-24-2006, 05:32 PM   #1
Default 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



studio60podcast@gmail.com
  Reply With Quote
Old 07-24-2006, 05:57 PM   #2
Swanagon, John M \(John\)
 
Posts: n/a
Default Re: Forms Authentication and SQL 2000
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.


<> wrote in message
news: 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
>





Swanagon, John M \(John\)
  Reply With Quote
Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
Computer Security aldrich.chappel.com.use@gmail.com A+ Certification 0 11-27-2007 02:11 AM




SEO by vBSEO 3.3.2 ©2009, Crawlability, Inc.

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46