为dnn安装msde

1. 从msdn下载msde2000 release A(当前最新)
2. 将其解压缩到一个目录
3. 打开cmd,cd到此目录,运行 setup sapwd="xxx" datadir="d:sqldata"
3.1 查阅readme.htm文件有详细的setup参数介绍
4. 重启,msde自动运行。
5. list databases and then create database "hdss"
5.1 c:>osql -E -S wanwan
1> use master
2> go
1> select name from sysdatabases
2> go
1> create database hdss
2> go
5.2 list all tables in a database
1> select name from sysobjects where type = "S"
2> go
1> use hdss
2> go
1> select name from sysobjects where type = "U"
2> go
5.3 add user and grant access to the user
1> use master
2> exec sp_addlogin ‘hdss’, ‘hdss1234’, ‘hdss’
3> go
已创建新登录。
1> use hdss
2> exec sp_grantdbaccess ‘hdss’
3> go
已向 ‘hdss’ 授予数据库访问权。
1> use hdss
2> exec sp_addrolemember ‘db_owner’, ‘hdss’
5.4 list users and roles for a specific database
1> use hdss
2> select name from sysusers
3> go
6. 更改登录模式
HKEY_LOCAL_MACHINESOFTWAREMicrosoftMSSQLServerMSSQLServer 将loginMode从1改成2(混合)

Leave a Reply

Your email address will not be published.