网摘:都没试过~只是保存~
方法1:
把sqlserver停了 把master.mdf mastlog.ldf拷贝出来 然后用别的sqlserver 附加成xxxx库然后update xxxx..sysxlogins set password=null where name='sa'
再master.mdf mastlog.ldf把这两个文件覆盖到你的data下 启动sqlserver sa密码……
方法2:
打开security(安全性) -- logins(登录名) ,右键选中sa,选择properties(属性),点击Status(状态)切换到状态面板,将Login(登录)设置为Enabled(启用)。
方法3:
USE [master]
GO
ALTER LOGIN sa ENABLE ;
GO
ALTER LOGIN [sa] WITH DEFAULT_DATABASE=[yuyunrsdb], DEFAULT_LANGUAGE=[简体中文], CHECK_EXPIRATION=ON, CHECK_POLICY=OFF
GO
USE [master]
GO
ALTER LOGIN [sa] WITH PASSWORD=N'123456'
GO
USE [yuyunrsdb]
GO
CREATE USER [sa] FOR LOGIN [sa]
GO
USE [yuyunrsdb]
GO
ALTER USER [sa] WITH DEFAULT_SCHEMA=[dbo]
GO
GO
ALTER
GO
ALTER LOGIN [sa] WITH DEFAULT_DATABASE=[yuyunrsdb], DEFAULT_LANGUAGE=[简体中文], CHECK_EXPIRATION=ON, CHECK_POLICY=OFF
GO
USE [master]
GO
ALTER LOGIN [sa] WITH PASSWORD=N'123456'
GO
USE [yuyunrsdb]
GO
CREATE USER [sa] FOR LOGIN [sa]
GO
USE [yuyunrsdb]
GO
ALTER USER [sa] WITH DEFAULT_SCHEMA=[dbo]
GO