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

推荐订阅源

博客园 - 叶小钗
Microsoft Azure Blog
Microsoft Azure Blog
Stack Overflow Blog
Stack Overflow Blog
Jina AI
Jina AI
Vercel News
Vercel News
H
Help Net Security
Martin Fowler
Martin Fowler
美团技术团队
云风的 BLOG
云风的 BLOG
Y
Y Combinator Blog
阮一峰的网络日志
阮一峰的网络日志
MyScale Blog
MyScale Blog
钛媒体:引领未来商业与生活新知
钛媒体:引领未来商业与生活新知
博客园 - 三生石上(FineUI控件)
博客园 - 司徒正美
人人都是产品经理
人人都是产品经理
Engineering at Meta
Engineering at Meta
G
Google Developers Blog
Blog — PlanetScale
Blog — PlanetScale
MongoDB | Blog
MongoDB | Blog
宝玉的分享
宝玉的分享
小众软件
小众软件
T
Tailwind CSS Blog
WordPress大学
WordPress大学

博客园 - guojin

ASP.NET整理:Cookie,Application,Session,页面生命周期 安装 SQL SERVER 2008 必须使用 "角色管理工具" 错误 的 解决方案 (转) 经典算法和OJ网站(开发者必备-转) 新概念英语第三册课后题答案 设置服务器定时重启 http status code 数据库中索引的优缺点(转) 几类常用Case工具介绍(有点老,但还是具有参考性,对应找较新版本就是了) 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