urgent: SQL 2005 authentication

I tried to install SQL 2005 and I remember it asked me for the
authentication and I chose mixed and input sa password. Now I uninstalled
the SQL 2005 and install again. But I don't why it never asked me for the
authentication and I can't connect to this server with sa.  Can anyone
please help and advise how to solve it. THanks.

In fact, when I uninstalled SQL 2005 server, I got an error message and not
sure if this is related to the re-installation. I go to add/remove program
to remove SQL 2005 server and during the process, it gave me an error:

The setup has encountered an expected error while Setting Internal
Properties.  The error is : Fatal error during installation.

Am I doing right procedure to uninstall SQL 2005 server? Please help.
Thanks.


"00MichaelJordan" <MJ@yahoo.com> wrote in message
news:OXb8VXyHHHA.4896@TK2MSFTNGP04.phx.gbl...
>I tried to install SQL 2005 and I remember it asked me for the
>authentication and I chose mixed and input sa password. Now I uninstalled
>the SQL 2005 and install again. But I don't why it never asked me for the
>authentication and I can't connect to this server with sa.  Can anyone
>please help and advise how to solve it. THanks.
>

By using sp_password  stored procedure , you will be able to re-assign a
passoword to 'SA'

Login SQL Server with Windows Authentication mode and run sp_passwod .For
more details see BOL




"00MichaelJordan" <MJ@yahoo.com> wrote in message
news:OXb8VXyHHHA.4896@TK2MSFTNGP04.phx.gbl...
>I tried to install SQL 2005 and I remember it asked me for the
>authentication and I chose mixed and input sa password. Now I uninstalled
>the SQL 2005 and install again. But I don't why it never asked me for the
>authentication and I can't connect to this server with sa.  Can anyone
>please help and advise how to solve it. THanks.
>