access is denied when starting service

We have a user who could start and stop the sql server service through EM at
one time and then he started getting an "error 5 (access is denied) occurred
while performing this service operation on the MSSQLServer service."
I removed his login and created a new one for him and gave him sysadmin
permissions but he still gets the same error when trying to start the
service.
Any ideas?
Thanks,
--
Dan D.Starting/ stopping services are OS specific. Make sure he's allowed to do
this at the OS level, also make sure that his password is correct in EM. Did
he change his password since the lat time he was able to do this?
--
TIA,
ChrisR
"Dan D." wrote:
> We have a user who could start and stop the sql server service through EM at
> one time and then he started getting an "error 5 (access is denied) occurred
> while performing this service operation on the MSSQLServer service."
> I removed his login and created a new one for him and gave him sysadmin
> permissions but he still gets the same error when trying to start the
> service.
> Any ideas?
> Thanks,
> --
> Dan D.|||I saw this recently when some of our users switched to a new Win 2003
domain.
We had forgotten to set them up in sql server.
Paul
"ChrisR" <ChrisR@.discussions.microsoft.com> wrote in message
news:7BB943F7-C48F-406A-A44D-22C200686A8C@.microsoft.com...
> Starting/ stopping services are OS specific. Make sure he's allowed to do
> this at the OS level, also make sure that his password is correct in EM.
> Did
> he change his password since the lat time he was able to do this?
> --
> TIA,
> ChrisR
>
> "Dan D." wrote:
>> We have a user who could start and stop the sql server service through EM
>> at
>> one time and then he started getting an "error 5 (access is denied)
>> occurred
>> while performing this service operation on the MSSQLServer service."
>> I removed his login and created a new one for him and gave him sysadmin
>> permissions but he still gets the same error when trying to start the
>> service.
>> Any ideas?
>> Thanks,
>> --
>> Dan D.|||They have logins in sqlserver and they are sysadmins in sqlserver.
--
Dan D.
"Paul Cahill" wrote:
> I saw this recently when some of our users switched to a new Win 2003
> domain.
> We had forgotten to set them up in sql server.
> Paul
> "ChrisR" <ChrisR@.discussions.microsoft.com> wrote in message
> news:7BB943F7-C48F-406A-A44D-22C200686A8C@.microsoft.com...
> > Starting/ stopping services are OS specific. Make sure he's allowed to do
> > this at the OS level, also make sure that his password is correct in EM.
> > Did
> > he change his password since the lat time he was able to do this?
> > --
> > TIA,
> > ChrisR
> >
> >
> > "Dan D." wrote:
> >
> >> We have a user who could start and stop the sql server service through EM
> >> at
> >> one time and then he started getting an "error 5 (access is denied)
> >> occurred
> >> while performing this service operation on the MSSQLServer service."
> >>
> >> I removed his login and created a new one for him and gave him sysadmin
> >> permissions but he still gets the same error when trying to start the
> >> service.
> >>
> >> Any ideas?
> >>
> >> Thanks,
> >> --
> >> Dan D.
>
>|||I'm thinking it is OS related too. They also can't stop and start IIS. They
say they haven't changed their passwords recently.
--
Dan D.
"ChrisR" wrote:
> Starting/ stopping services are OS specific. Make sure he's allowed to do
> this at the OS level, also make sure that his password is correct in EM. Did
> he change his password since the lat time he was able to do this?
> --
> TIA,
> ChrisR
>
> "Dan D." wrote:
> > We have a user who could start and stop the sql server service through EM at
> > one time and then he started getting an "error 5 (access is denied) occurred
> > while performing this service operation on the MSSQLServer service."
> >
> > I removed his login and created a new one for him and gave him sysadmin
> > permissions but he still gets the same error when trying to start the
> > service.
> >
> > Any ideas?
> >
> > Thanks,
> > --
> > Dan D.|||Another thing that happened with our new domain.
One of my colleagues (a user on our old domain) mapped a drive on the new
domain as the NEWDOMAIN\administrator (remember by password).
We then noticed that when he connected to an SQL Server on the new domain he
was logging in as NEWDOMAIN\administrator and not his OLDDOMAIN\username.
Ie the authentication of network resources affects sql server too. I guess
this makes sense but caught me out.
Maybe not the same issue for you but it looks like an authentication issue
of some sort.
Paul
"Dan D." <DanD@.discussions.microsoft.com> wrote in message
news:90E92723-FA30-48F4-9415-50A4A0EF8797@.microsoft.com...
> I'm thinking it is OS related too. They also can't stop and start IIS.
> They
> say they haven't changed their passwords recently.
> --
> Dan D.
>
> "ChrisR" wrote:
>> Starting/ stopping services are OS specific. Make sure he's allowed to do
>> this at the OS level, also make sure that his password is correct in EM.
>> Did
>> he change his password since the lat time he was able to do this?
>> --
>> TIA,
>> ChrisR
>>
>> "Dan D." wrote:
>> > We have a user who could start and stop the sql server service through
>> > EM at
>> > one time and then he started getting an "error 5 (access is denied)
>> > occurred
>> > while performing this service operation on the MSSQLServer service."
>> >
>> > I removed his login and created a new one for him and gave him sysadmin
>> > permissions but he still gets the same error when trying to start the
>> > service.
>> >
>> > Any ideas?
>> >
>> > Thanks,
>> > --
>> > Dan D.