Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

As part of installing SQL Server on my PC I've created a specific user for it. When I log in now I'm offered this user as well as my own account. I remember in older versions of the Windows NT series there was an option in the user config dialog to set the user as non-interactive so they couldn't log in. I can't seem to find that checkbox in the Vista equivalent. Is there any other way to achieve this?

share|improve this question
add comment

1 Answer 1

up vote 4 down vote accepted

This article explains the Windows XP solution which also works in Windows Vista and 7.

It requires you to do some registry editing so be extremely careful when doing this.

If you want to disable the account you can edit the local policy as follows.

  • Open the Local Security Policy
  • Local Policies
  • User Rights Assignments
  • Double Click Deny Logon Locally
  • Add User
share|improve this answer
    
Short version: add the user to the HKEY_LOCAL_MACHINE\Software\Microsoft\WindowsNT\CurrentVersion\Winlogon\Special‌​Accounts\UserList registry key. –  Joel Coehoorn Jul 16 '09 at 18:48
    
That tells you how to stop a username from appearing in the clickable logon screen introduced with XP, but it doesn't prevent a user from logging in as far as I can tell (that article says the accounts can still log in using the normal login dialog). I'm sure there was an option in NT4 and Windows 2000 that would completely stop WinLogon from accepting a particular user ID. –  U62 Jul 16 '09 at 18:53
    
@Joel Thanks. I was being lazy. –  Diago Jul 16 '09 at 19:02
    
@U62 Updated the answer with the policy details to disable the logon. –  Diago Jul 16 '09 at 19:03
    
Awesome, thanks! –  U62 Jul 17 '09 at 23:45
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.