http://www.toxingwang.com/windows-server/winserver/357.html
http://hi.baidu.com/honfei/item/4e8139c7589bbd57bdef69a3
http://down.chinaz.com/server/201201/1581_1.htm
http://zjwsk.blog.163.com/blog/static/5983061320112273532469/
1,IP地址
C:\Users\Administrator>netsh
netsh>interface ipv4 set address name="本地连接" source=static addr=192.168.1.2mask=255.255.255.0
我们只用运用以下3条命令把IPv6的接口关闭即可
netsh interface teredo set state disable //netsh接口禁用Teredo的设置状态
netsh interface 6to4 set state disabled //netsh接口的6to4设置状态禁用
netsh interface isatap set state disabled //netsh接口isatap设置状态禁用
2,远程管理
C:\Windows\System32>cscript SCregEdit.wsf /ar 0
C:\Users\Administrator>netsh firewall set service remotedesktop enable custom 19
2.168.1.0/24
3,改计算机名
netsh renamecomputer OldName /newname NewName
4,停止密码复杂性
secedit /export /cfg C:\securityconfig.cfg
you should find PAssword complexity = 1
Change the value to 0 and save the file.
secedit /configure /db C:\Windows\security\new.sdb /cfg C:\securityconfig.cfg /areas SECURITYPOLICY
5,修改用户密码
net user Administrator PaSSworD123
6,共享目录
net share job=d:\work
net share XX=d:\XXX /grant:administrators,full
7,安装mssql
1)dism安装.net
Dism /online /enable-feature /featurename:NetFx2-ServerCore /featurename:ServerCore-WOW64 /featurename:NetFx3-ServerCore-WOW64 /featurename:NetFx2-ServerCore-WOW64 /featurename:NetFx3-ServerCore /featurename:MicrosoftWindowsPowerShell
2)安装setup.exe
也可以用以下命令
Setup.exe /qs /ACTION=Install /FEATURES=SQL /INSTANCENAME=MSSQLSERVER /SQLSVCACCOUNT="yourdomain\sqlserviceaccount" /SQLSVCPASSWORD="sqlserviceaccountpassword" /SQLSYSADMINACCOUNTS="yourdomain\sqladminusername" /AGTSVCACCOUNT="NT AUTHORITY\Network Service"
3)关闭防火墙
netsh firewall set opmode disable
或者
netsh advfirewall firewall add rule name="SQL" dir=in protocol=tcp localport=1433 action=allow
4)管理工具
C:\Program Files\Microsoft SQL Server\100\Tools\Binn\VSShell\Common7\IDE>ssms.exe
其它 常用命令:
1,删除目录
rd XXX /s
2,删除共享
net share XXX /del