Re: security question
From: Hari Prasad (hari_prasad_k_at_hotmail.com)
Date: 01/27/04
- Previous message: Hilary Cotter: "security question"
- In reply to: Hilary Cotter: "security question"
- Next in thread: Jasper Smith: "Re: security question"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Date: Tue, 27 Jan 2004 22:27:51 +0530
Hi,
I am not soo sure about this,
Why dont you try adding the role from Query Analzer,
sp_addrolemember 'db_owner','username'
Thanks
Hari
MCDBA
"Hilary Cotter" <hilaryk@att.net> wrote in message
news:ODX3oJP5DHA.1504@TK2MSFTNGP12.phx.gbl...
> 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.
>
>
- Previous message: Hilary Cotter: "security question"
- In reply to: Hilary Cotter: "security question"
- Next in thread: Jasper Smith: "Re: security question"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
|
