Solved

does SQL service account require interactive logon priveledge

Posted on 2008-10-15
4
326 Views
Last Modified: 2013-12-04
Can I disable interactive logon for the SQL server service accounts?
0
Comment
Question by:qpm
  • 2
4 Comments
 
LVL 37

Expert Comment

by:momi_sabag
ID: 22719583
what do you mean by interactive logon?
0
 
LVL 10

Accepted Solution

by:
Marcjev earned 500 total points
ID: 22720215
The account privilege 'Logon as a service' is needed.
In the servicemanager you can set 'Interact with the desktop'. This is not needed.
0
 
LVL 10

Assisted Solution

by:Marcjev
Marcjev earned 500 total points
ID: 22720221
And 'Log on locally' is not needed.
0
 

Author Comment

by:qpm
ID: 22722020
Thanks for the quick responses.  

' interact with desktop' is set on the service, are the others group policies set on the account?  I didn't see those settings on the AD Users and Groups properties for the user account.  

If it is group policy, I am pretty new to that.  Can I attach a policy to a specific user?  I've seen some things that recommend moving the user into a new OU and setting the policy there - is that what I need to do?  

0

Featured Post

Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Article by: btan
The intent is not to repeat what many has know about Ransomware but more to join its dots of what is it, who are the victims, why it exists, when and how we respond on infection. Lastly, sum up in a glance to share such information with more to help…
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
This Micro Tutorial will give you a basic overview how to record your screen with Microsoft Expression Encoder. This program is still free and open for the public to download. This will be demonstrated using Microsoft Expression Encoder 4.
This video shows how to quickly and easily add an email signature for all users on Exchange 2016. The resulting signature is applied on a server level by Exchange Online. The email signature template has been downloaded from: www.mail-signatures…

809 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question