About sp_password question

YtBenjamin

isql  -Usa -P
>sp_password null,xxxxxx
>go
Password correctly set.
(return status = 0)

=======================================================
isql -Usa -Pxxxxxx
>sp_password xxxxxx,null
>go

Msg 10317, Level 14, State 1:
Procedure 'sp_password', Line 51:
New password specified is too short.  Minimum length of acceptable passwords is
6 characters.
Msg 17720, Level 16, State 1:
Procedure 'sp_password', Line 57:
Error:  Unable to set the Password.
(return status = 1)


Why ???? Who give me an answer

chilang

這樣設(shè)置密碼為空的方法不對

zhaopingzi

先把配置改一下，讓他把密碼最小長度給為0，然后sp_password xxxxxx,null就可以了

YtBenjamin

There is not  'min password length' in Oracle8i ????
sp_configure 'min password length',0  failed in Oracle8i,,,,,,,,,,,555~~~

zhaopingzi

不是SYBASE嗎？

tchhyc

修改sa的密碼為NULL
方法一:
1. 使用sa登錄Server：
isql -Usa -Psa_password -Sserver_name
2. 記錄當(dāng)前版本號(以當(dāng)前版本號12000為例):
> sp_configure "upgrade version"
> go
3. 修改當(dāng)前值為492:
> sp_configure "upgrade version",492
> go
4. 將某用戶口令設(shè)置為NULL(以sa為例,當(dāng)前口令為"123456"):
> sp_password '123456',NULL,sa
> go
5. 重新設(shè)置當(dāng)前版本號:
> sp_configure "upgrade version",12000
> go
方法二:
sp_configure 'minimum password length',0
go
sp_password '123456',null,sa
go
sp_configure 'minimum password length',6
go

YtBenjamin

原帖由 YtBenjamin 于 2006-1-4 11:50 發(fā)表
There is not  'min password length' in Oracle8i ????
sp_configure 'min password length',0  failed in Oracle8i,,,,,,,,,,,555~~~

//////////////////////////////////////////////////////////
1> sp_configure 'minimum password length',0
2> go
Msg 18124, Level 16, State 1:
Procedure 'sp_configure', Line 494:
No matching configuration options.  Here is a listing of groups:

--------------------------------------------------
Backup/Recovery
Cache Manager
Component Integration Services
Configuration Options
Disk I/O
Error Log
Extended Stored Procedure
General Information
Languages
Lock Manager
Memory Use
Meta-Data Caches
Network Communication
O/S Resources
Parallel Query
Physical Memory
Physical Resources
Processors
Rep Agent Thread Administration
SQL Server Administration
Security Related
User Environment

YtBenjamin

If you suceed,Then tell me,ok,,

Thanks