启动SQLExpress

原创文章,转载请注明出处.转载自: Li Haifeng's Blog
本文链接地址: 启动SQLExpress

进入命令运行窗口:
cd c:

hostname //这里回车键取得计算机名

sqlcmd -S YourServerSQLExpress -E //说明,YourServer是你刚取得的计算机名,以下的也是

出现1>后

sp_grantlogin [YourServerUserName] //要记住中括号也要输入

UserName为当前用户,如Administrator //个人电脑一般都是用这个默认管理员的

2>出现后

go

1>出现后

sp_addsrvrolemember [YourServerUserName],dbcreator

2>出现后

go

1>出现后

exit


——————————————————————————————-


C:Documents and SettingsAdministrator>hostname
omycle-pc


C:Documents and SettingsAdministrator>sqlcmd -s omycle-pcSqlExpress -e
1> sp_grantlogin [omycle-pcAdministrator]
2> go
sp_grantlogin [omycle-pcAdministrator]


1> sp_addsrvrolemember [omycle-pcAdministrator],dbcreator
2> go
sp_addsrvrolemember [omycle-pcAdministrator],dbcreator


1> exit


C:Documents and SettingsAdministrator>

From Li Haifeng's Blog, post 启动SQLExpress

Post Footer automatically generated by wp-posturl plugin for wordpress.

分享到: