| Author |
urgent: SQL 2005 authentication
|
|
| 00MichaelJordan 2006-12-14, 12:12 am |
| 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.
| |
| 00MichaelJordan 2006-12-14, 12:12 am |
| 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.
>
| |
| Uri Dimant 2006-12-14, 12:12 am |
| 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.
>
|
|
|
|