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?
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
Short version: add the user to the HKEY_LOCAL_MACHINE\Software\Microsoft\WindowsNT\CurrentVersion\Winlogon\SpecialAccounts\UserList registry key. Jul 16, 2009 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.– U62Jul 16, 2009 at 18:53
@U62 Updated the answer with the policy details to disable the logon. Jul 16, 2009 at 19:03