security question

From: Hilary Cotter (hilaryk_at_att.net)
Date: 01/27/04 

Date: Tue, 27 Jan 2004 11:23:38 -0500

I have a stand alone laptop with 2 instances of SQL Server on it.

1) 8.00.818
2) 8.00.194

I create a new SQL account using EM, I park it in pubs, I assign a password.
Everything works.

Then try to park it in a role dbo, ddladmin, etc. Each time I do this I get
a confirmation for a new password.

If I enter the recently assigned password it tells me the password is
incorrect. If I try a blank password, same problem. It I try to assign it a
new password it tells me the password is incorrect.

My laptop is win2k, sp3.

Am I missing something?

This works as expected on a Win2003 server.

Relevant Pages

  • Re: security question
    ... > I have a stand alone laptop with 2 instances of SQL Server on it. ... > Then try to park it in a role dbo, ddladmin, etc. ... > new password it tells me the password is incorrect. ...
    (microsoft.public.sqlserver.security)
  • Re: security question
    ... You Are Prompted for Password Confirmation After You Change a Standard ... Jasper Smith (SQL Server MVP) ... > Then try to park it in a role dbo, ddladmin, etc. ... > new password it tells me the password is incorrect. ...
    (microsoft.public.sqlserver.security)