Windows Authentication

0 views
Skip to first unread message

kai

unread,
Jul 10, 2003, 4:46:08 PM7/10/03
to
Hi, All
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]

unread,
Jul 11, 2003, 7:49:55 PM7/11/03
to

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]

unread,
Jul 12, 2003, 9:33:35 PM7/12/03
to
Hello Kai,

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

unread,
Jul 13, 2003, 9:54:12 AM7/13/03
to
Vikrant,
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

unread,
Jul 13, 2003, 1:03:30 PM7/13/03
to
Vikrant,
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]

unread,
Jul 14, 2003, 1:50:51 PM7/14/03
to

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]

unread,
Jul 16, 2003, 8:12:45 PM7/16/03
to

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

Reply all
Reply to author
Forward
0 new messages