| Author |
SQLAgent Proxy Account
|
|
| Jeffrey K. Ericson 2005-07-12, 1:23 pm |
| When trying to set this, no matter what account I use, I get a login failure.
The login can quite clearly login to the server as among others, I've
specified the service account. Works on one server identiacally patched to
one that fails.
Any ideas?
| |
|
| Did you ever reset the service account without using enterprise manager?
--
Thanks & Rate the Postings.
-Ravi-
"Jeffrey K. Ericson" wrote:
> When trying to set this, no matter what account I use, I get a login failure.
> The login can quite clearly login to the server as among others, I've
> specified the service account. Works on one server identiacally patched to
> one that fails.
>
> Any ideas?
| |
| Jeffrey K. Ericson 2005-07-13, 11:23 am |
| No, I am going to try and reset things off hours. I noticed quite a
disparaity between the good and the bad server interms of effective polocies.
"Ravi" wrote:
[color=darkred]
> Did you ever reset the service account without using enterprise manager?
>
> --
> Thanks & Rate the Postings.
> -Ravi-
>
>
> "Jeffrey K. Ericson" wrote:
>
| |
|
| That could be the problem. In order to run SQL Server Service, the service
account needs certain internal permissions. If account doesn't have enough
permissions the server will still run but you cannot do certain things like
settings proxy account.
--
Thanks & Rate the Postings.
-Ravi-
"Jeffrey K. Ericson" wrote:
[color=darkred]
> No, I am going to try and reset things off hours. I noticed quite a
> disparaity between the good and the bad server interms of effective polocies.
>
> "Ravi" wrote:
>
| |
|
| The service account must have following permissions
1. Act as part of the Operating System
2. Increase Quotas
3. Log on as a Service
4. Replace a process level token
5. bypass traverse checking
6. Log on as a batch job
--
Thanks & Rate the Postings.
-Ravi-
"Jeffrey K. Ericson" wrote:
[color=darkred]
> No, I am going to try and reset things off hours. I noticed quite a
> disparaity between the good and the bad server interms of effective polocies.
>
> "Ravi" wrote:
>
| |
|
| Ravi,
I think I'm experiencing a similar situation (see posting "Proxy Account
Error"). Simply put - I cannot reset the proxy account. I have SQL 2000
with SP2 on a Windows 2000 OS. Both the MSSQL Service and SQL Agent service
are run by an admin account. I checked that all of the permissions you
listed below are enabled for this account. I am trying to use the same admin
account for the Proxy Account but when I do, I get "Unable to
set.......'Error executing extended stored procedure: Specified user can not
login'". By your question "Did you ever reset the service account without
using enterprise manager?" do mean through using:
xp_sqlagent_proxy_ac
count N'SET',
N'DOMAIN',
N'USER',
N'Password',
I have not yet tried to use this method. Do you think that this would
resolve my problem?
Thanks
LeAnn
"Ravi" wrote:
[color=darkred]
> The service account must have following permissions
>
> 1. Act as part of the Operating System
> 2. Increase Quotas
> 3. Log on as a Service
> 4. Replace a process level token
> 5. bypass traverse checking
> 6. Log on as a batch job
> --
> Thanks & Rate the Postings.
> -Ravi-
>
>
> "Jeffrey K. Ericson" wrote:
>
| |
|
| LeAnn
I am talking about the MSSQLSERVER AND SQLAGENT Service Accounts. There are
2 ways to reset these accounts, either using Enterprise Manager or from
Services Applet in Control panel.
You must reset the Service account via Enterprise manager Only.
Hope this helps.
Ravi
--
Thanks & Rate the Postings.
-Ravi-
"LeAnn" wrote:
[color=darkred]
> Ravi,
>
> I think I'm experiencing a similar situation (see posting "Proxy Account
> Error"). Simply put - I cannot reset the proxy account. I have SQL 2000
> with SP2 on a Windows 2000 OS. Both the MSSQL Service and SQL Agent service
> are run by an admin account. I checked that all of the permissions you
> listed below are enabled for this account. I am trying to use the same admin
> account for the Proxy Account but when I do, I get "Unable to
> set.......'Error executing extended stored procedure: Specified user can not
> login'". By your question "Did you ever reset the service account without
> using enterprise manager?" do mean through using:
>
> xp_sqlagent_proxy_ac
count N'SET',
> N'DOMAIN',
> N'USER',
> N'Password',
>
> I have not yet tried to use this method. Do you think that this would
> resolve my problem?
>
> Thanks
> LeAnn
>
> "Ravi" wrote:
>
| |
|
| The Service accounts seem to be working fine. If I reset them (to the same
account) will that remedy my proxy issue? I use the same account for all (3)
of them.
Thanks
LeAnn
"Ravi" wrote:
[color=darkred]
> LeAnn
> I am talking about the MSSQLSERVER AND SQLAGENT Service Accounts. There are
> 2 ways to reset these accounts, either using Enterprise Manager or from
> Services Applet in Control panel.
> You must reset the Service account via Enterprise manager Only.
> Hope this helps.
> Ravi
> --
> Thanks & Rate the Postings.
> -Ravi-
>
>
> "LeAnn" wrote:
>
| |
|
| Yes
--
Thanks & Rate the Postings.
-Ravi-
"LeAnn" wrote:
[color=darkred]
> The Service accounts seem to be working fine. If I reset them (to the same
> account) will that remedy my proxy issue? I use the same account for all (3)
> of them.
>
> Thanks
> LeAnn
>
>
> "Ravi" wrote:
>
| |
|
| Ok one more (ok 3) dumb questions. Since I must reset the SQL Service
through the EM, would I just retype the same user and password in the
Security tab of the Properties dialog box? Would that be considered
"resetting" the account? Do the same for SQL Agent?
"Ravi" wrote:
[color=darkred]
> Yes
> --
> Thanks & Rate the Postings.
> -Ravi-
>
>
> "LeAnn" wrote:
>
| |
|
| Yes for your first question.
Yes That is consider reset.
Yes Do the same for SQLAgent.
--
Thanks & Rate the Postings.
-Ravi-
"LeAnn" wrote:
[color=darkred]
> Ok one more (ok 3) dumb questions. Since I must reset the SQL Service
> through the EM, would I just retype the same user and password in the
> Security tab of the Properties dialog box? Would that be considered
> "resetting" the account? Do the same for SQL Agent?
>
>
> "Ravi" wrote:
>
|
|
|
|