我爱我老婆

SQL Express 相关

1. 远程访问,两点,1)打开tcp/ip, 2)启动sqlbrower

 

2. 权限, 4步,

1)加入本机admin group,

2) 在 configuration中SQL Services| sql express| 属性 | advance |startup 尾部加上;-m,并重启serivce

3)打开客户端:运行脚本:

 

CREATE LOGIN [your domain account] FROM WINDOWS;

GO

 

SP_ADDSRVROLEMEMBER 'your domain account', 'sysadmin'

GO

4)去掉-m, 重启

http://blogs.msdn.com/b/dparys/archive/2009/09/17/create-database-permission-denied-in-database-master-my-fix.aspx

 

posted @ 2012-10-30 07:43  DataFlow  阅读(223)  评论(0编辑  收藏  举报