I'm on WinXp Home. Is there even an Administrator acount?. I set up
the users on this PC, with me as admin.

I used Windows authentication when I installed SQL Server. This should
allow SQL to login using the Windows logon info, correct?

In the SQL Server Service Manager, there are 2 servers; one named
after the PC name (MAROIS1) and another with the instance name I gave
it MAROIS\SQLSERVER1.

MAROIS1 is running, but when I try to start the other, I get the mesage
'The service did not start due to a logon error'

Should I have used Sql Server authentication? If so, what do I need to
do set it that way?

Or am I totally lost here?


>Kevin,
>
>Are you doing this under Administrator acount? Did you try to use Sql Server authentication? BTW, does SQL Server starts at all?
>
>>Sergey,
>>
>>I have SQL Server installed, and I'm trying to install
>>Service Pack 3, which came with it. I'm getting an error.
>>
>>Under the Connect To Server, I chose Windows Authentication.
>>
>>The error is:
>>
>>"A service control operation failed for the MSSQL$SQLSERVER1 service: 1069
>>The serice did not start due to a long failure"
>>
>>When I click OK, I then get:
>>
>>"Setup was unable to verify the state of the server for an upgrade. Verify
>>the server is able to start and you provided a valid sa password and restart
>>setup."
>>
>>I think I'm in over my head now.
>>