Re: trouble changing SA password on SQL Server 2005 Express

I'd quickly switch to SQL Authentication, try logging in as SA with what you
think the password is, then switch back.

Personally, I start it off during the install as SQL authentication to set
an SA password, then quick move it back to Windows Authentication.
"Dasani" <Dasani@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:0101B246-5F1E-4094-931E-E4A51C7265B9@xxxxxxxxxxxxxxxx
Hello,

I have a basic question about changing/setting the sa password on an
instance of SQL 2005 Express running in Windows Authentication mode. Its
my
understanding that even though this account is disabled in Windows Auth
mode,
I should still set a strong password in the event it is ever changed to
mixed
mode.

I login using, "sqlcmd -E -S $servername\$instancename"

Then run:

sp_password @old = null, @new = 'strongpass', @loginame = 'sa'
go

The problem is that I never receive the "Password Changed" notice from the
system, as all the documentation that I have read says. I do not receive
any
errors either - it simply drops back to the prompt. I do believe it is
setting the password, because if I try the same command, but provide a
wrong
old password instead of null, it throughs an error saying that I do not
have
permission.

Is this behavior normal? - I've also tried using osql as well. I just
want
to be sure that I do not have a blank sa password.

Thanks,

Dasani



.

Relevant Pages

  • RE: 0x80004005 - you need permission to view its data
    ... switch to SQL authentication? ... It must be a Domain account which has the needed permission to start or ... Sophie Guo ...
    (microsoft.public.sqlserver.security)
  • Re: Problems connecting to SQL server on W2K3 from Win 2000 workst
    ... Can you connect to a network share on the SQL server? ... Also I know this isn't as important on 2k machines but is the primary DNS ... >> This is because you are using Windows authentication without a domain ... >> because it tends not to work, use SQL Authentication and you'll always ...
    (microsoft.public.sqlserver.connect)
  • Re: Login error when opening a deployed project
    ... You should use SQL Authentication instead of Windows Authentication. ... Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand ... command, CommandBehavior behavior) ...
    (microsoft.public.dotnet.security)
  • Re: SQL Login vs NT Login
    ... the index every night with my maintenance plan and my user tell me that the ... I reinstall the old version of my application with the SQL Authentication ... that I have on my company to use Windows Authentication. ...
    (microsoft.public.sqlserver.security)
  • SQL Login vs NT Login
    ... Last week I modify my application that connect to a SQL Server 7 to use ... For exemple, for the same batch of record, with the SQL Authentication, it ... takes 15 second but with the Windows Authentication, ...
    (microsoft.public.sqlserver.security)