Re: Install failure of MS SQL Server 2000 and SP3a

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: John Bell (jbellnewsposts_at_hotmail.com)
Date: 12/21/04 

Date: Tue, 21 Dec 2004 05:40:19 -0000

Hi

The "." indicates the local machine, therefore .\Edward is your account on
that machine. You will need to enter the password corresponding to the
account you set. With localsystem you don't enter the password and the
interact with desktop is not needed. I am supprised this did not work, you
may want to check the event logs and SQLServer error log to see if there is
any other information. Other than that I can only think of removing it and
re-installing from scratch.

John

"Edward Mitchell" <emitchell@nospam.ieee.org> wrote in message
news:eVjkKju5EHA.2196@TK2MSFTNGP14.phx.gbl...
> John,
>
> I open up the Administration Services>Services and see the MSSQLSERVER
> row. The Description and Status are blank. Startup Type column is
> automatic and the Logon As column contains .\Edward.
>
> I right click and select Properties. On the Log On tab the "This account"
> radio button is selected with the account name of .\Edward and Password
> and Confirm Password boxes containing 15 hidden characters.
>
> I try erasing the 15 password characters, go to the General tab and on
> Start see the Error 1069 again.
>
> Next I went back to the Log On tab and selected the "Local System Account"
> radio button. I don't understand the "Allow service to interact with the
> desktop" check box so I left that unchecked. Back to the General tab and
> Start. Still Error 1069.
>
> Now I go back to the Log On tab, check the "This account" radio button and
> try Browse... In the "Enter the object name to select" and enter
> Administrator. Hitting the "Check Names" button changes this to
> DELL340\Administrator. The name of the machine is DELL340.
>
> I return now to the Log On tab of the Properties dialog and
> .\Administrator is in the "This account" edit box (the DELL340 has
> disappeared). Still the same 15 hidden characters of Passwords.
>
> Now however, if I try and go to the General tab, there is a message
> "Please enter a valid password".
>
> I clear both password edit boxes and can go to the General tab.
>
> However when I push Start, there is the old message:
>
> Could not start the MSSQLSERVER service on Local Computer.
> Error 1069: The service did not start due to a logon failure.
>
>
> What can I change the account to?
>
> Ed
>
>
> "John Bell" <jbellnewsposts@hotmail.com> wrote in message
> news:eZLisem5EHA.1296@TK2MSFTNGP10.phx.gbl...
>> Hi Edward
>>
>> For EM to work it needs to have already been started. You should go back
>> to the services applet under the administrator menu (previously in
>> control panel!) and change the account on the logon tab for the
>> MSSQLServer service.
>>
>> John
>>
>>
>> "Edward Mitchell" <emitchell@nospam.ieee.org> wrote in message
>> news:OMGu0Ue5EHA.1564@TK2MSFTNGP09.phx.gbl...
>>> John,
>>>
>>> I searched "SQL Books on line" for "Domain Account" and found the
>>> following to change the service login:
>>>
>>> To change the MSSQLServer service login (Enterprise Manager)
>>>
>>> 1.. Expand a server group.
>>> 2.. Right-click a server, and then click Properties.
>>> 3.. In the SQL Server Properties dialog box, click the Security tab.
>>> 4.. In the Startup service account box, the option for This Account is
>>> selected, indicating that the SQL Server service account is a Windows
>>> domain account. Enter changes as necessary for the account and password.
>>>
>>> I can start the Enterprise Manager and expand the SQL Server Group.
>>> However when I right click on the server, "(local)(Windows NT)" and
>>> select properties I get the 1069 error again.
>>>
>>> Remember that I'm a developer and don't have much knowledge of the
>>> system accounts. I am running under my account "Edward" which is listed
>>> under the Administrators group. This I found under the Computer
>>> Management dialog, "System Tools">"Local Users and Groups">"Groups.
>>>
>>> Ed
>>>
>>>
>>> "John Bell" <jbellnewsposts@hotmail.com> wrote in message
>>> news:O9VpEvd5EHA.3416@TK2MSFTNGP09.phx.gbl...
>>>> Hi
>>>>
>>>> Are you using a domain account for the SQL Server service, if so try
>>>> and log in as that account
>>>>
>>>> John
>>>>
>>>> "Edward Mitchell" <emitchell@nospam.ieee.org> wrote in message
>>>> news:ONPSfXS5EHA.1192@tk2msftngp13.phx.gbl...
>>>>>I have just installed MS SQL Server 2000 Developer Edition. The
>>>>>installation package says that I have to continue with the SP3a Service
>>>>>Pack. When I do this, one of the screens is to select the
>>>>>authentication mode setup should use to connect to the SQL Server. The
>>>>>radio button to use Windows authentication is checked. When I
>>>>>installed the main SQL Server, I chose "Windows authentication" as
>>>>>well.
>>>>>
>>>>> The install then failed with the dialog message:
>>>>>
>>>>> A service control operation failed for the MSSQLSERVER service: 1069
>>>>> The service did not start due to a logon failure.
>>>>>
>>>>> When I go to Control Panel>Admin...>Services. Select MSSQLSERVER
>>>>> Properties, and attempt to start it from this dialog box I see a
>>>>> similar (but different) message:
>>>>>
>>>>> Could not start the MSSQLSERVER service on the Local Computer.
>>>>> Error 1069: The service did not start due to a logon failure.
>>>>>
>>>>> I've added the contents of the install log file (sqlstp.log) at the
>>>>> end of this message.
>>>>>
>>>>> I previously had the Desktop Edition that worked fine. I had been
>>>>> told that the Developer Edition would give me a better graphic UI!
>>>>>
>>>>> System is XP, Professional.
>>>>>
>>>>> Ed
>>>>> --
>>>>> Edward E.L. Mitchell
>>>>> Web: www.racesail.org
>>>>> Phone: (239)415-7039
>>>>> 6707 Daniel Court
>>>>> Fort Myers, FL 33908
>>>
>>>
>>
>>
>
>

Quantcast