高分求救一个问题~~~

Question

java.sql.SQLException: 用户 'sa' 登录失败。 错误很明确了
1 密码错误哦。
2 没有开通 SQL 用户认证。而是默认的本机用户认证。参考这个 http://www.java2000.net/p316 是 SQL Server 2000的

Answer 1

我的sqlserver 是2005的   密码正确 

Answer 2

应该是登录方式的选择错了吧
把数据库登录选成混合模式的
你现在可能是windows模式下的

Answer 3

我现在sqlserver已经登陆了  是用sa登录的  密码没有错误  他是启动tomcat的时候出现的错误  不是运行Jsp出现的错误

Answer 4

那你有驱动包吗，像SQL的话，需要两个包的，也就放到web.inic/lib目录下的，那两个包，也就是起到了桥架的作用啦！
找一下，是不是由于配置错误啦

Answer 5

驱动错误，用连接池的话你应该用jtds的，报的错误是jtds的错误，可你配置文件写的是microsoft的驱动

Answer 6

首先确定你的用户名密码是正确的，然后：
如果你工程里有jtds的驱动包的话，把你的配置文件改成这个<property name="connection.driver_class"> 
net.sourceforge.jtds.jdbc.Driver
</property>

Answer 7

信息: Initializing WebApplicationContext for Struts ActionServlet 'action', module ''
2008-08-26 14:35:48,687 [org.springframework.beans.factory.xml.XmlBeanDefinitionReader]-[INFO] Loading XML bean definitions from ServletContext resource [/WEB-INF/applicationContext.xml]
2008-08-26 14:35:49,453 [org.springframework.beans.factory.xml.XmlBeanDefinitionReader]-[INFO] Loading XML bean definitions from ServletContext resource [/WEB-INF/action-servlet.xml]
2008-08-26 14:35:49,500 [org.apache.struts.util.PropertyMessageResources]-[INFO] Initializing, config='org.apache.struts.actions.LocalStrings', returnNull=true
2008-08-26 14:35:49,609 [org.springframework.web.context.support.XmlWebApplicationContext]-[INFO] Bean factory for application context [WebApplicationContext for namespace 'action-servlet']: org.springframework.beans.factory.support.DefaultListableBeanFactory defining beans [dataSource,sessionFactory,transactionManager,baseTxService,usersDAO,configfilefirstkindDAO,configfilesecondkindDAO,configfilethirdkindDAO,configmajorkindDAO,configmajorDAO,configpubliccharDAO,configquestionfirstkindDAO,configquestionsecondkindDAO,configprimarykeyDAO,humanfileDAO,humanfiledigDAO,salarystandardDAO,salarystandarddetailsDAO,engagemajorreleaseDAO,engageresumeDAO,engageinterviewDAO,engagesubjectsDAO,trainingDAO,exportfileDAO,usersTarget,configfilefirstkindTarget,configfilesecondkindTarget,configfilethirdkindTarget,configmajorkindTarget,configmajorTarget,configquestionfirstkindTarget,configquestionsecondkindTarget,configpubliccharTarget,configprimarykeyTarget,humanfileTarget,humanfiledigTarget,salarystandardTarget,salarystandarddetailsTarget,engagemajorreleaseTarget,engageresumeTarget,engageinterviewTarget,engagesubjectsTarget,trainingTarget,exportfileTarget,usersService,configfilefirstkindService,configfilesecondkindService,configfilethirdkindService,configmajorkindService,configmajorService,configpubliccharService,configquestionfirstkindService,configquestionsecondkindService,configprimarykeyService,humanfileService,humanfiledigService,salarystandardService,salarystandarddetailsService,engagemajorreleaseService,engageresumeService,engageinterviewService,engagesubjectsService,trainingService,exportfileService,/main,/users,/configfilefirstkind,/configfilesecondkind,/configfilethirdkind,/configmajorkind,/configmajor,/configpublicchar,/configprofessiondesign,/configprimarykey,/humanfile,/salarystandard,/engagemajorrelease,/engageresume,/engageinterview,/engagesubjects,/exportfile,/training]; root of BeanFactory hierarchy
2008-08-26 14:35:49,671 [org.springframework.web.context.support.XmlWebApplicationContext]-[INFO] 82 beans defined in application context [WebApplicationContext for namespace 'action-servlet']
2008-08-26 14:35:49,703 [org.springframework.web.context.support.XmlWebApplicationContext]-[INFO] Unable to locate MessageSource with name 'messageSource': using default [org.springframework.context.support.DelegatingMessageSource@179c0a7]
2008-08-26 14:35:49,703 [org.springframework.web.context.support.XmlWebApplicationContext]-[INFO] Unable to locate ApplicationEventMulticaster with name 'applicationEventMulticaster': using default [org.springframework.context.event.SimpleApplicationEventMulticaster@24389c]
2008-08-26 14:35:49,718 [org.springframework.ui.context.support.UiApplicationContextUtils]-[INFO] Unable to locate ThemeSource with name 'themeSource': using default [org.springframework.ui.context.support.ResourceBundleThemeSource@3f0bc0]
2008-08-26 14:35:49,718 [org.springframework.beans.factory.support.DefaultListableBeanFactory]-[INFO] Pre-instantiating singletons in factory [org.springframework.beans.factory.support.DefaultListableBeanFactory defining beans [dataSource,sessionFactory,transactionManager,baseTxService,usersDAO,configfilefirstkindDAO,configfilesecondkindDAO,configfilethirdkindDAO,configmajorkindDAO,configmajorDAO,configpubliccharDAO,configquestionfirstkindDAO,configquestionsecondkindDAO,configprimarykeyDAO,humanfileDAO,humanfiledigDAO,salarystandardDAO,salarystandarddetailsDAO,engagemajorreleaseDAO,engageresumeDAO,engageinterviewDAO,engagesubjectsDAO,trainingDAO,exportfileDAO,usersTarget,configfilefirstkindTarget,configfilesecondkindTarget,configfilethirdkindTarget,configmajorkindTarget,configmajorTarget,configquestionfirstkindTarget,configquestionsecondkindTarget,configpubliccharTarget,configprimarykeyTarget,humanfileTarget,humanfiledigTarget,salarystandardTarget,salarystandarddetailsTarget,engagemajorreleaseTarget,engageresumeTarget,engageinterviewTarget,engagesubjectsTarget,trainingTarget,exportfileTarget,usersService,configfilefirstkindService,configfilesecondkindService,configfilethirdkindService,configmajorkindService,configmajorService,configpubliccharService,configquestionfirstkindService,configquestionsecondkindService,configprimarykeyService,humanfileService,humanfiledigService,salarystandardService,salarystandarddetailsService,engagemajorreleaseService,engageresumeService,engageinterviewService,engagesubjectsService,trainingService,exportfileService,/main,/users,/configfilefirstkind,/configfilesecondkind,/configfilethirdkind,/configmajorkind,/configmajor,/configpublicchar,/configprofessiondesign,/configprimarykey,/humanfile,/salarystandard,/engagemajorrelease,/engageresume,/engageinterview,/engagesubjects,/exportfile,/training]; root of BeanFactory hierarchy]

Answer 8

把数据库登录选成混合模式的 也就是sqlserver+windows的那个

Answer 9

<property name="myeclipse.connection.profile">SQL </property> 
<property name="connection.password">sa </property> 
<property name="connection.driver_class"> 
com.microsoft.sqlserver.jdbc.SQLServerDriver 
</property>好像这个sa后面多了一个空格是不是这里的原因。

Answer 10

楼上的有可能，还有jar包要3个，补丁不重要，只有用netbeans创建数据库连接的时候会检查是否打了sp3,sp4补丁