Re: SQL Server Agent Start up Service

From: Belinda Rodriguez (rodrigub@symbol.com)
Date: 04/18/03


From: "Belinda Rodriguez" <rodrigub@symbol.com>
Date: Fri, 18 Apr 2003 09:54:50 -0400


I am using enterprise edition with SP2. It looks like the same account I
start SQL Server with except for the fact that the account that is starting
SQL Server does not have .\ infront of the name. I am using the account that
I use to log into with so I know that the account information is correct.
Is there any other suggestions you can give me?

Thanks,

Belinda

"Jasper Smith" <jasper_smith9@hotmail.com> wrote in message
news:OKUrOUTBDHA.3008@TK2MSFTNGP11.phx.gbl...
> This error would seem to indicate that the server could not
> contact a domain controller. What version and service pack
> are you on ? This error can also occur if accounts are renamed
> Can you confirm that SQL starts fine using this same account
> as the SQL Service account.
>
> --
> HTH
>
> Jasper Smith (SQL Server MVP)
>
> I support PASS - the definitive, global
> community for SQL Server professionals -
> http://www.sqlpass.org
>
> "Belinda Rodriguez" <rodrigub@symbol.com> wrote in message
> news:eB0TcqQBDHA.1952@TK2MSFTNGP12.phx.gbl...
> > The error I am gettin says that "no mapping between account names and
> > security IDs were done"
> >
> > I know the passwords are correct because it is the same password that I
> used
> > with the instance.
> >
> >
> > "Jasper Smith" <jasper_smith9@hotmail.com> wrote in message
> > news:O2ZTo5PBDHA.2316@TK2MSFTNGP10.phx.gbl...
> > > What error are you getting - check the SQL Agent error log
> > > Are you using Enterprise Manager to change the service
> > > account ?
> > >
> > > --
> > > HTH
> > >
> > > Jasper Smith (SQL Server MVP)
> > >
> > > I support PASS - the definitive, global
> > > community for SQL Server professionals -
> > > http://www.sqlpass.org
> > >
> > > "Belinda Rodriguez" <rodrigub@symbol.com> wrote in message
> > > news:#f11zrPBDHA.2316@TK2MSFTNGP10.phx.gbl...
> > > > I am trying to start the agent with a domain account instead of a
> local
> > > > system account, but when I try to change it the Agent will not
start.
> > The
> > > > account I am trying to start it up with is the same account that is
> > > > currently starting up the instance. What could be the problem?
> > > >
> > > > Thanks in advance
> > > >
> > > > Belinda
> > > >
> > > >
> > >
> > >
> >
> >
>
>



Relevant Pages

  • Re: Error 15401 using sp_grantlogin (not addressed by current KB articles)
    ... Restarting Windows 2000 resolved the problem for this particular account, ... confused when it sees a duplicate SID. ... > One way to get SQL Server to agree with the renamed NT ... > Preview (to ensure the script was created), ...
    (microsoft.public.sqlserver.security)
  • Re: SharePoint V3 Install Error
    ... But it our case it had to do with Group Policies that forbid the account of ... WSS FAQ:www.wssv3faq.com/wss.collutions.com ... Event Source: WindowsSharePointServices3Search ... whatever you are installing WSS as sufficient rights to the SQL Server ...
    (microsoft.public.sharepoint.windowsservices)
  • Re: sbs 2003 network slow why?
    ... Issue: Local Account Password Test ... SQL Server and/or MSDE authentication mode is set to Windows Only. ... The Everyone group does not have more than Read access to the SQL Server and/or MSDE registry keys. ... BUILTIN\Administrators group should not be part of sysadmin role. ...
    (microsoft.public.windows.server.sbs)
  • RE: Problems with WebParts
    ... to a database called aspnetdb. ... > The connection string specifies a local SQL Server Express instance using a ... > server account must have read and write access to the applications directory. ... > This is necessary because the web server account will automatically create ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Error 0x80070534 when changing service account
    ... The only solution that I have been able to find for this error is to RDP into the SQL Server using the new Service account you want the SQL server to run under. ... prefix, an error 0x80070056 "The specified network password is not correct." ...
    (microsoft.public.sqlserver.security)