SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Logon failure: the user has not been granted the requested logon type at this computer.error for SQL...


Logon failure: the user has not been granted the requested logon type at this computer.error for SQL Services even though account has Log on as a Service...

Author
Message
craig.d.brown
craig.d.brown
Valued Member
Valued Member (61 reputation)Valued Member (61 reputation)Valued Member (61 reputation)Valued Member (61 reputation)Valued Member (61 reputation)Valued Member (61 reputation)Valued Member (61 reputation)Valued Member (61 reputation)

Group: General Forum Members
Points: 61 Visits: 6
I have a 2008 R2 instance running on a Windows 2008 Virtual Machine. After a server reboot I lost the ability to start services with the existing user account (I've actually tried 3 different user accounts..) I verified that the accounts have Log on as a Service and Log on as Batch Job privileges and the correct passwords are being used. The account that I have been using is also a sys admin and is working on another 2008 R2 instance on another VM. I can start services under a Local System Account but when I try otherwise I get an Error 1069: The service did not start due to a logon failure. My System Event log shows the failure as well. I'm at a loss at where else to look since most solutions point to password changes and account access. Any advice would be very much appreciated.
Erland Sommarskog
Erland Sommarskog
SSC-Insane
SSC-Insane (20K reputation)SSC-Insane (20K reputation)SSC-Insane (20K reputation)SSC-Insane (20K reputation)SSC-Insane (20K reputation)SSC-Insane (20K reputation)SSC-Insane (20K reputation)SSC-Insane (20K reputation)

Group: General Forum Members
Points: 20680 Visits: 886
How do you set the service account? You should use the SQL Server Configuration Manager, since this also grants the permissions needed.

Erland Sommarskog, SQL Server MVP, www.sommarskog.se
craig.d.brown
craig.d.brown
Valued Member
Valued Member (61 reputation)Valued Member (61 reputation)Valued Member (61 reputation)Valued Member (61 reputation)Valued Member (61 reputation)Valued Member (61 reputation)Valued Member (61 reputation)Valued Member (61 reputation)

Group: General Forum Members
Points: 61 Visits: 6
Thanks for the reply. I have tried changing both through the Configuration Manager and in Services.
Erland Sommarskog
Erland Sommarskog
SSC-Insane
SSC-Insane (20K reputation)SSC-Insane (20K reputation)SSC-Insane (20K reputation)SSC-Insane (20K reputation)SSC-Insane (20K reputation)SSC-Insane (20K reputation)SSC-Insane (20K reputation)SSC-Insane (20K reputation)

Group: General Forum Members
Points: 20680 Visits: 886
Could there be any DENY in the AD?

Erland Sommarskog, SQL Server MVP, www.sommarskog.se
craig.d.brown
craig.d.brown
Valued Member
Valued Member (61 reputation)Valued Member (61 reputation)Valued Member (61 reputation)Valued Member (61 reputation)Valued Member (61 reputation)Valued Member (61 reputation)Valued Member (61 reputation)Valued Member (61 reputation)

Group: General Forum Members
Points: 61 Visits: 6
I've assumed that, since the user account is working on another SQL instance that there would not be any deny. Any recommendation on how I could confirm this would be appreciated.
jasona.work
jasona.work
SSC-Forever
SSC-Forever (41K reputation)SSC-Forever (41K reputation)SSC-Forever (41K reputation)SSC-Forever (41K reputation)SSC-Forever (41K reputation)SSC-Forever (41K reputation)SSC-Forever (41K reputation)SSC-Forever (41K reputation)

Group: General Forum Members
Points: 41870 Visits: 15897
craig.d.brown - Tuesday, March 13, 2018 11:00 AM
I've assumed that, since the user account is working on another SQL instance that there would not be any deny. Any recommendation on how I could confirm this would be appreciated.

You'd have to get in touch with whoever is the Active Directory administrators to find out. There is an option to restrict the times and / or the computers an account can log in during / too. Possibly the AD Admins set this for your service account, such that it can only log in to one server (the working one,) rather than any server / computer.
craig.d.brown
craig.d.brown
Valued Member
Valued Member (61 reputation)Valued Member (61 reputation)Valued Member (61 reputation)Valued Member (61 reputation)Valued Member (61 reputation)Valued Member (61 reputation)Valued Member (61 reputation)Valued Member (61 reputation)

Group: General Forum Members
Points: 61 Visits: 6
Thanks for the continued replies. I have actually tried to accounts that are not in use anywhere else, as well as ones that are in use on other servers, and it didn't solve the problem.
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum








































































































































































SQLServerCentral


Search