NT Authority\Networkservices SPN account

Can I use NT Authority\Networkservices for SPN account?
metagenicsAsked:
Who is Participating?
 
Phil_AgcaoiliConnect With a Mentor Commented:
Let me expand.

The NT AUTHORITY\NetworkService account will allow you to connect remotely to a system.  When configuring the service, you can specify this as your user account (no password needed).  This causes Windows to send the machines domain credentials to sqlserver, therefore SqlServer would see something like "mydomain\ComputerB$" (dollar sign is important).

Just add this account to SqlServer and you should be able to connect.

Also note that this only works when the machine accounts are registered in the AD  (W2K/W2K3), and where your SQL server SPN (Service Principal Name) is registered in the AD as well.

I hope this helps.
0
 
Forrest BurrisConnect With a Mentor Commented:
Yes you can
0
 
metagenicsAuthor Commented:
Thanks.
0
All Courses

From novice to tech pro — start learning today.