Windows Authentication
kai
I installed VS.NET 2003 and I noticed under SQL Server 2000 Login, VS.NET
2003 adds a new Login "NT AUTHORITY\NETWORK SERVICE" which is a windows
group, it works well if I connect SQL Server database using Windows
authentication ("integrated security=SSPI" in connection string). I cannot
"NT AUTHORITY\NETWORK SERVICE" under Windows's group.
After I reinstalled SQL Server, I canot add "NT AUTHORITY\NETWORK SERVICE"
to the login because it is not found under Windows group. Any one has an
idea how add "NT AUTHORITY\NETWORK SERVICE" to SQL Server login?
This is the error massage I get"
"Login failed for user 'NT AUTHORITY\NETWORK SERVICE'.
Please help
Thanks
Kai
Vikrant V Dalwale [MS]
Hello Kai,
I am currently looking into this and will let you know once I have update
for you.
Thanks for your patience and cooperation.
Vikrant Dalwale
Microsoft SQL Server Support Professional
This posting is provided "AS IS" with no warranties, and confers no rights.
Get secure !! For info, please visit http://www.microsoft.com/security.
Please reply to Newsgroups only.
--------------------
| From: "kai" <kail...@earthlink.net>
| Newsgroups: microsoft.public.vsnet.debugging
| Subject: Windows Authentication
| Lines: 20
| X-Priority: 3
| X-MSMail-Priority: Normal
| X-Newsreader: Microsoft Outlook Express 6.00.3790.0
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
| Message-ID: <kgkPa.94263$Io.81...@newsread2.prod.itd.earthlink.net>
| Date: Thu, 10 Jul 2003 20:46:08 GMT
| NNTP-Posting-Host: 66.32.166.27
| X-Complaints-To: ab...@earthlink.net
| X-Trace: newsread2.prod.itd.earthlink.net 1057869968 66.32.166.27 (Thu,
10 Jul 2003 13:46:08 PDT)
| NNTP-Posting-Date: Thu, 10 Jul 2003 13:46:08 PDT
| Organization: EarthLink Inc. -- http://www.EarthLink.net
| Path:
cpmsftngxa06.phx.gbl!TK2MSFTNGP08.phx.gbl!newsfeed00.sul.t-online.de!t-onlin
e.de!newsfeed.freenet.de!newsfeed.news2me.com!elnk-pas-nf2!newsfeed.earthlin
k.net!stamper.news.pas.earthlink.net!newsread2.prod.itd.earthlink.net.POSTED
!not-for-mail
| Xref: cpmsftngxa06.phx.gbl microsoft.public.vsnet.debugging:2772
| X-Tomcat-NG: microsoft.public.vsnet.debugging
Vikrant V Dalwale [MS]
Could you please let me know the OS on which VS.NET 2003 is installed ?
NT AUTHORITY\NetworkService is a built-in account introduced in Windows
XP/2003 Server.
From the fact that you are not able to manually add it to the SQL Login,
you might be using Win2K OS in which case, I think,
you will have to either repair or reinstall the VS.NET 2003 to have this
added to SQL Logins.
Please let me know if repair/reinstall of VS.NET resolves this issue , else
please get back to me with the OS info so that I can do further
investigations.
Thanks,
Vikrant Dalwale
kai
I use Win 2003 Server. I will repaire my VS.NET now and let you know.
Thanks
Kai
"Vikrant V Dalwale [MS]" <vikr...@online.microsoft.com> wrote in message
news:YouQL7NS...@cpmsftngxa06.phx.gbl...
kai
After I reinstalled VS.NET, I still cannot add "NT
AUTHORITY\NetworkService" into SQL Server 200 Login. Should I reinstall
Windows 2003 Server all together?
Thanks
Kai
"Vikrant V Dalwale [MS]" <vikr...@online.microsoft.com> wrote in message
news:YouQL7NS...@cpmsftngxa06.phx.gbl...
Vikrant V Dalwale [MS]
Hello Kai,
Please run the following stored proc from Query Analyser to add the
account in SQL Server,
exec sp_grantlogin [NT AUTHORITY\NETWORK SERVICE]
Please let me know if that resolves the problem.
Thanks,
Vikrant Dalwale
Microsoft SQL Server Support Professional
This posting is provided "AS IS" with no warranties, and confers no rights.
Get secure !! For info, please visit http://www.microsoft.com/security.
Please reply to Newsgroups only.
--------------------
| From: "kai" <kail...@earthlink.net>
| Newsgroups: microsoft.public.vsnet.debugging
| References: <kgkPa.94263$Io.81...@newsread2.prod.itd.earthlink.net>
<YouQL7NS...@cpmsftngxa06.phx.gbl>
| Subject: Re: Windows Authentication
| Lines: 95
| X-Priority: 3
| X-MSMail-Priority: Normal
| X-Newsreader: Microsoft Outlook Express 6.00.3790.0
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
| Message-ID: <ChgQa.99029$Io.85...@newsread2.prod.itd.earthlink.net>
| Date: Sun, 13 Jul 2003 17:03:30 GMT
| NNTP-Posting-Host: 66.32.225.66
| X-Complaints-To: ab...@earthlink.net
| X-Trace: newsread2.prod.itd.earthlink.net 1058115810 66.32.225.66 (Sun,
13 Jul 2003 10:03:30 PDT)
| NNTP-Posting-Date: Sun, 13 Jul 2003 10:03:30 PDT
| Organization: EarthLink Inc. -- http://www.EarthLink.net
| Path:
cpmsftngxa06.phx.gbl!TK2MSFTNGP08.phx.gbl!newsfeed00.sul.t-online.de!t-onlin
e.de!newsfeed.freenet.de!newsfeed.news2me.com!elnk-pas-nf2!newsfeed.earthlin
k.net!stamper.news.pas.earthlink.net!newsread2.prod.itd.earthlink.net.POSTED
!not-for-mail
| Xref: cpmsftngxa06.phx.gbl microsoft.public.vsnet.debugging:2802
| X-Tomcat-NG: microsoft.public.vsnet.debugging
Vikrant V Dalwale [MS]
Hello Kai,
Could you please let me know if
exec sp_grantlogin [NT AUTHORITY\NETWORK SERVICE]
as suggested in my previous post helped you resolve the issue ?
Thanks,
Vikrant Dalwale
Microsoft SQL Server Support Professional
This posting is provided "AS IS" with no warranties, and confers no rights.
Get secure !! For info, please visit http://www.microsoft.com/security.
Please reply to Newsgroups only.
--------------------
| X-Tomcat-ID: 423269198
| References: <kgkPa.94263$Io.81...@newsread2.prod.itd.earthlink.net>
<YouQL7NS...@cpmsftngxa06.phx.gbl>
<ChgQa.99029$Io.85...@newsread2.prod.itd.earthlink.net>
| MIME-Version: 1.0
| Content-Type: text/plain
| Content-Transfer-Encoding: 7bit
| From: vikr...@online.microsoft.com (Vikrant V Dalwale [MS])
| Organization: Microsoft
| Date: Mon, 14 Jul 2003 17:50:51 GMT
| Subject: Re: Windows Authentication
| X-Tomcat-NG: microsoft.public.vsnet.debugging
| Message-ID: <g4XC9BjS...@cpmsftngxa06.phx.gbl>
| Newsgroups: microsoft.public.vsnet.debugging
| Lines: 127
| Path: cpmsftngxa06.phx.gbl
| Xref: cpmsftngxa06.phx.gbl microsoft.public.vsnet.debugging:2808
| NNTP-Posting-Host: TOMCATIMPORT2 10.201.218.182