Re: password
- From: Hugo Kornelis <hugo@xxxxxxxxxxxxxxxxxxxxxx>
- Date: Wed, 26 Oct 2005 23:38:27 +0200
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)
.
- Prev by Date: Re: Compare Character to numberic
- Next by Date: Re: Selecting by date
- Previous by thread: Re: Compare Character to numberic
- Next by thread: Re: Selecting by date
- Index(es):
Relevant Pages
|
|
