Re: SQL Server 2005 - Start Up Error 17113

From: Howard Hoffman (HowardH_at_community.nospam)
Date: 11/09/05 

Date: Wed, 9 Nov 2005 17:15:15 -0500

Really weird, now it works.

I can now indeed use a local account to run the MSSQLServer Service.
Could that error have somehow been caused by multiple instances of the SQL Config manager Property page dialog for that service being open? I didn't realize that I had a Property Page open under all the other windows until I tried to close the Config manager after my last post.

Howard Hoffman
  "Howard Hoffman" <HowardH@community.nospam> wrote in message news:exiCEqX5FHA.252@TK2MSFTNGP15.phx.gbl...
  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