Re: SQL Server 2005 - Start Up Error 17113




Hi,

I am also facing exactly the same problem as below. But closing all the
SCM windows did not help in my case:(

Just to give background.. I created an account. Did not give local
admin privileges to that. I read KB article that, using SCM to change
the account should give all required rights to the account. Am I
missing something....

Please help me. Thanks in advance.
Regards
Srini

Howard Hoffman wrote:
*Via SQL Server Configuration Manager, I'm trying to change the
account used for SQL Server (MSSQLSERVER). I've got both SQL Server
2005 Developer Edition (RTM) and SQL Server 2005 Express on my box
(different instances).

Running XP Sp2.

For the MSSQLSERVER SQL Server, I've created a local (i.e.
non-domain) account. That account is in the
"SQLServer2005MSFTEUser$MYMACHINENAME$MSSQLSERVER" group.

I select that local account in the Config Manager Properties page for
Sql Server (MSSQLSERVER). When I attempt to start the sevice in this
UI, an Error box in the Config App saying that the service has
failed to respond in a timely fashion.

My Security Event Log has a Success Audit entry for the
"MICROSOFT_AUTHENTICATION_PACKAGE_V1_0" package.
However, the System Event Log has
The SQL Server (MSSQLSERVER) service terminated with service-specific
error 17113 (0x42D9).

I can start the SQLSERVER service if I use Local System, but I don't
want to do that.

Thanks in advance for any help,

Howard Hoffman *



--
srinivaks
------------------------------------------------------------------------
Posted via http://www.webservertalk.com
------------------------------------------------------------------------
View this thread: http://www.webservertalk.com/message1276296.html

.



Relevant Pages

  • SQL Server 2005 - Start Up Error 17113
    ... That account is in the "SQLServer2005MSFTEUser$MYMACHINENAME$MSSQLSERVER" group. ... I select that local account in the Config Manager Properties page for Sql Server (MSSQLSERVER). ... the System Event Log has ...
    (microsoft.public.sqlserver.security)
  • Re: Windows authentication on SQL server
    ... Services and found SQLSERVERAGENT, MSSQLSERVER, and MSSQLServerADHelper. ... Would I set all of these services to use a domain account? ... >> run from a standard windows application. ... when I deploy it to SQL server and run it from SQL when SQL is ...
    (microsoft.public.vc.language)
  • Re: Windows authentication on SQL server
    ... Services and found SQLSERVERAGENT, MSSQLSERVER, and MSSQLServerADHelper. ... Would I set all of these services to use a domain account? ... >> run from a standard windows application. ... when I deploy it to SQL server and run it from SQL when SQL is ...
    (microsoft.public.sqlserver.programming)
  • Re: Windows authentication on SQL server
    ... Services and found SQLSERVERAGENT, MSSQLSERVER, and MSSQLServerADHelper. ... Would I set all of these services to use a domain account? ... >> run from a standard windows application. ... when I deploy it to SQL server and run it from SQL when SQL is ...
    (microsoft.public.sqlserver.security)
  • 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)