Topic: msql已经开启了,但是查询分析器怎么登陆不了??

  Print this page

1.msql已经开启了,但是查询分析器怎么登陆不了?? Copy to clipboard
Posted by: oath911
Posted on: 2005-06-01 12:01

查询分析器用windows身份可以进入

而用SQL身份,我的是sa,********

就进不去

2.Re:msql已经开启了,但是查询分析器怎么登陆不了?? [Re: oath911] Copy to clipboard
Posted by: why
Posted on: 2005-06-01 18:32

不要發垃圾頂版 (刪掉它們挺費時的)
而且还是几個小時內三個
沒有耐性就不要從事IT行業了



do a search before you ask...
http://www.cjsdn.net/post/view?bid=10&id=140731
http://www.cjsdn.net/post/view?bid=10&id=144337
http://support.microsoft.com/default.aspx?scid=kb;en-us;313100

You must set the authentication mode of your SQL Server to Mixed mode, which permits both Windows Authentication and SQL Server Authentication.

3.Re:msql已经开启了,但是查询分析器怎么登陆不了?? [Re: oath911] Copy to clipboard
Posted by: 九佰
Posted on: 2005-06-02 11:17

我想,你的这个问题应该是SQl server现在登录认证的方式是操作系统。
你在sql server的属性里面可以找到,把他修改成数据库和操作系统两者认证的方式就可以了


   Powered by Jute Powerful Forum® Version Jute 1.5.6 Ent
Copyright © 2002-2021 Cjsdn Team. All Righits Reserved. 闽ICP备05005120号-1
客服电话 18559299278    客服信箱 714923@qq.com    客服QQ 714923