getting sa password

14 Sep 2006 8:05 PM

rodchar

hey all,
how do i get/set password for sql express?

thanks,
rodchar

14 Sep 2006 8:16 PM

Aaron Bertrand [SQL Server MVP]

You can set it if you log in as a sysadmin (e.g. local windows administrator
account) using sp_password. Please read Books Online for usage/information.

You can't retrieve it as far as I know.

Show quote

"rodchar" <rodc***@discussions.microsoft.com> wrote in message
news:932C82C2-409B-4EF5-8D11-95AC85E5106D@microsoft.com...
> hey all,
> how do i get/set password for sql express?
>
> thanks,
> rodchar

14 Sep 2006 10:36 PM

Hari Prasad

Hi,

You can not see the SA password. All you can do is reset the password of SA
by logininto SQL Server using windows adminuser.

1.Login to OS as a domain user who has sysadmin rights (Part of OS Admin
group) to SQL Server.From command prompt:-

SQLCMD -E -S SQL Servername

Issue the command

sp_password null,'newpassword','sa'

Thanks
Hari
SQL Server MVP

Show quote

"rodchar" wrote:

> hey all,
> how do i get/set password for sql express?
>
> thanks,
> rodchar