惯性聚合 高效追踪和阅读你感兴趣的博客、新闻、科技资讯
阅读原文 在惯性聚合中打开

推荐订阅源

Attack and Defense Labs
Attack and Defense Labs
The GitHub Blog
The GitHub Blog
C
Check Point Blog
博客园_首页
MongoDB | Blog
MongoDB | Blog
N
Netflix TechBlog - Medium
F
Full Disclosure
Microsoft Security Blog
Microsoft Security Blog
爱范儿
爱范儿
Recent Announcements
Recent Announcements
阮一峰的网络日志
阮一峰的网络日志
G
GRAHAM CLULEY
Cyber Security Advisories - MS-ISAC
Cyber Security Advisories - MS-ISAC
T
Threat Research - Cisco Blogs
C
Cybersecurity and Infrastructure Security Agency CISA
V
Vulnerabilities – Threatpost
K
Kaspersky official blog
博客园 - 司徒正美
S
Schneier on Security
T
The Exploit Database - CXSecurity.com
Project Zero
Project Zero
云风的 BLOG
云风的 BLOG
Cisco Talos Blog
Cisco Talos Blog
Know Your Adversary
Know Your Adversary
雷峰网
雷峰网
V
V2EX - 技术
freeCodeCamp Programming Tutorials: Python, JavaScript, Git & More
Spread Privacy
Spread Privacy
罗磊的独立博客
K
KPMG report finds enterprise disconnect between AI and its ROI | CIO
S
Security Affairs
SecWiki News
SecWiki News
Schneier on Security
Schneier on Security
O
OpenAI News
Jina AI
Jina AI
PCI Perspectives
PCI Perspectives
Cyberwarzone
Cyberwarzone
Y
Y Combinator Blog
Apple Machine Learning Research
Apple Machine Learning Research
B
Blog RSS Feed
I
InfoQ
D
Docker
P
Palo Alto Networks Blog
Recorded Future
Recorded Future
M
MIT News - Artificial intelligence
博客园 - Franky
B
Blog
Scott Helme
Scott Helme
博客园 - 叶小钗
D
DataBreaches.Net

博客园 - guojin

ASP.NET整理:Cookie,Application,Session,页面生命周期 安装 SQL SERVER 2008 必须使用 "角色管理工具" 错误 的 解决方案 (转) 经典算法和OJ网站(开发者必备-转) 新概念英语第三册课后题答案 设置服务器定时重启 http status code 数据库中索引的优缺点(转) 几类常用Case工具介绍(有点老,但还是具有参考性,对应找较新版本就是了) - guojin PowerDesigner建模工具简介(转) 如何查看一个网页打开速度 服务器维护tips (转)11款网站服务器监测通知工具 sql server 2000 数据同步(2) sql server2000 数据同步 asp.net页面中 回车触发提交事件(转) - guojin - 博客园 登陆界面设计得不错 Fetion分析之二:服务器地址从何而来——变态的配置文件(转) 飞信Fetion历史数据库研究(History.dat)——嵌入式数据库SQLite介绍(转) Google黑板报上连载的长文
reset sql server express sa password
guojin · 2010-08-16 · via 博客园 - guojin

sql server 2005 express edition does not supplied enterprise manager , and in some case you have to use sa a to  connect to sql server express. and here is the solution.

in default installation , authorization method can't be set and the default authorize method is trusted connection with your windows account.

you need some steps to use sa and chang its password , lets go:

first , open your registry , changing the authorize method with mixed way which can be find in registry , (open run >regedit ) , find loginMode key under HKLM/software/microsoft/.../MSSQL/..  ,change it's value from 1 to 2

restart the sql express service ,and this is important

second , in command prompt , direct to you sql server folder : (like c:\program files\microsoft sqlserver express\bin) , and then type

c:\program files\microsoft sqlserver express\bin> sqlcmd -E -S .\SQLEXPRESS
and then return the >prompt
and then type the follows commands
>sp_password @new='your_sa_pass',@loginame='sa'
>go
>alter login sa enable
>go
>alter login sa with password='your_sa_pass' unlock
>go
>exit


if there is no error occurred , your sql server express password has been changed

so the last step is to test the sa account

osql -U sa -S .\SQLEXPRESS
and then enter your new sa password

note: .\sqlexpress can be replace with your computer name

good luck