password

I have lost my password for my mssqlserver can someone help me retrieve it or
should I delete this server and download another.
On Wed, 26 Oct 2005 12:20:02 -0700, RonP wrote:

>I have lost my password for my mssqlserver can someone help me retrieve it or
>should I delete this server and download another.
Hi Ron,
If you are not the DBA, then ask the DBA to reset your password.
If you are the DBA, then log on to the computer with the Administrator
account, then connect to SQL Server using windows authentication (i.e.
you don't specify a SQL Server userid and password; SQL Server relies on
Wondows' authentication that you are indeed "Administrator"). You can
now use sp_password to change the password for your regular account.
Best, Hugo
(Remove _NO_ and _SPAM_ to get my e-mail address)