How to start SQL service with Network Service account?

I have a test server and we have some software that requires the MSSQLSERVER service to  logon with Network Service. When I try to do this I get the following message: A new member could not be added to a local group because the member has the wrong account type. [0x8007056c]

How can I make make it start using Network Service?

Best regards,
Clyde.
Clyde_RadcliffeAsked:
Who is Participating?
 
TomislavjSystem AdminCommented:
if sql server is on domain controler then you can't specify the Network Service because it's not supported on domain controllers
0
 
LelikInsideCommented:
try to use
USE [master]
GO
EXEC xp_instance_regwrite N'HKEY_LOCAL_MACHINE', N'Software\Microsoft\MSSQLServer\MSSQLServer', N'LoginMode', REG_DWORD, 2
GO
EXEC sys.sp_configure N'remote access', N'0'
GO
RECONFIGURE WITH OVERRIDE
GO

Open in new window

it should help....after service restart
0
 
LelikInsideCommented:
sorry, wrong parameter....
USE [master]
GO
EXEC xp_instance_regwrite N'HKEY_LOCAL_MACHINE', N'Software\Microsoft\MSSQLServer\MSSQLServer', N'LoginMode', REG_DWORD, 2
GO
EXEC sys.sp_configure N'remote access', N'1'
GO
RECONFIGURE WITH OVERRIDE
GO

Open in new window

0
Introducing Cloud Class® training courses

Tech changes fast. You can learn faster. That’s why we’re bringing professional training courses to Experts Exchange. With a subscription, you can access all the Cloud Class® courses to expand your education, prep for certifications, and get top-notch instructions.

 
Daniel_PLDB Expert/ArchitectCommented:
What do you want to achive? Do you want to change SQL Server service account to Network Service or add it as a login in SQL Server?
Above procdedure enables mixed authentication mode aswell as remote access - remote access = 1 is a default setting ;)
0
 
Clyde_RadcliffeAuthor Commented:
I want to change the login from Local System to Network Service. (see screenshot)
 Screenshot
But when I change it I get the following error:

 Error
0
 
Daniel_PLDB Expert/ArchitectCommented:
I'm afraid also in Windows Server 2008 (regardless of it's role) you'll not be able to use Network Service builtin account as SQL Server service account.
0
 
Clyde_RadcliffeAuthor Commented:
Thanks for the effort everyone! Atleast I know it can't be configured so I can stop pulling my hair out of my head. ;-)
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.