February 7, 2006 at 2:14 pm
I am trying to change the startup account information for SQL Server and SQL Server Agent but I keep getting the error when trying to change "this account" to a local user account: "Logon failure: the user has not been granted the requested logon type at this computer."
Here is what I am trying to set in "THIS ACCOUNT" of the Security tab of the properties window.
.\myUser
password
My user account has admin privileges, but my machine running the SQL Services is on a workgroup instead of a domain. Could that be causing the problem? Does SQL Server 2000 support workgroups the same way it supports domains?
I tried changing these startup accounts on different machines that were in a domain, and it worked fine.
Somebody please help!
February 7, 2006 at 2:52 pm
Dis you check that your account has the "logon as a service" permissions?
February 7, 2006 at 3:08 pm
The user account is listed under "logon as service".
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply