When you restore a backup using SQLServer, you must delete and re-add the database users for that database. It's deceiving, because when you restore the database, and look at the users in Enterprise Manager, they are still there and you have no problem querying the database using Query Analyzer. Try deleting the users, then adding them back and don't forget to re-run your permissions once you've added the users back.
/robert > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > Sent: Thursday, December 16, 2004 8:56 AM > To: [EMAIL PROTECTED] > Subject: cannot connect a sqlserver > > > > > I have a problem building a testserver with a webapp using sqlserver2000. > > We got a productionserver running, so I installed java SDK > > (j2sdk-1_4_2_04-windows-i586-p.exe),tomcat (jakarta-tomcat-4.1.30.exe) and > > SQLserver2000 (restored a backup) and took the .war file from the > > productionserver and placed it under the webapps directory. I changed the > > .properties file started Tomcat again. Are ther more changes to do??? > > > > This is the SQLException I get: > > > > java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for > > JDBC][SQLServer]Invalid object name 'LogonUser'. > > at com.microsoft.jdbc.base.BaseExceptions.createException(Unknown > > Source) > > at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown > > Source) > > at > > com.microsoft.jdbc.sqlserver.tds.TDSRequest.processErrorToken(Unknown > > Source) > > at > > com.microsoft.jdbc.sqlserver.tds.TDSRequest.processReplyToken(Unknown > > Source) > > at > > com.microsoft.jdbc.sqlserver.tds.TDSRPCRequest.processReplyToken(Unknown > > Source) > > at com.microsoft.jdbc.sqlserver.tds.TDSRequest.processReply(Unknown > > Source) > > at > > com.microsoft.jdbc.sqlserver.SQLServerImplStatement.getNextResultType(Unkn > > own Source) > > at > > com.microsoft.jdbc.base.BaseStatement.commonTransitionToState(Unknown > > Source) > > at com.microsoft.jdbc.base.BaseStatement.postImplExecute(Unknown > > Source) > > at > > com.microsoft.jdbc.base.BasePreparedStatement.postImplExecute(Unknown > > Source) > > at com.microsoft.jdbc.base.BaseStatement.commonExecute(Unknown > > Source) > > at > > com.microsoft.jdbc.base.BaseStatement.executeQueryInternal(Unknown Source) > > at > > com.microsoft.jdbc.base.BasePreparedStatement.executeQuery(Unknown Source) > > at > > org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(Delegatin > > gPreparedStatement.java:205) > > at com.quinity.standard.business.StdEntity.retrieve(StdEntity.java) > > at > > nl.terrafilius.lms.business.LogonUser.retrieveWithLogonData(LogonUser.java > > ) > > at > > nl.terrafilius.lms.servlet.HandlerLogon.handleActionLogon(HandlerLogon.jav > > a) > > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) > > at > > sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java: > > 39) > > at > > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorIm > > pl.java:25) > > at java.lang.reflect.Method.invoke(Method.java:324) > > at com.quinity.standard.servlet.StdHandler.handle(StdHandler.java) > > at com.quinity.standard.servlet.StdHandler.handle(StdHandler.java) > > at > > com.quinity.standard.servlet.StdController.doPost(StdController.java) > > at javax.servlet.http.HttpServlet.service(HttpServlet.java:760) > > at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) > > at > > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applicati > > onFilterChain.java:247) > > at > > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilter > > Chain.java:193) > > at > > org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve. > > java:256) > > at > > org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.inv > > okeNext(StandardPipeline.java:643) > > at > > org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480 > > ) > > at > > org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) > > at > > org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve. > > java:191) > > at > > org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.inv > > okeNext(StandardPipeline.java:643) > > at > > org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480 > > ) > > at > > org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) > > at > > org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2422) > > at > > org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:1 > > 80) > > at > > org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.inv > > okeNext(StandardPipeline.java:643) > > at > > org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValv > > e.java:171) > > at > > org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.inv > > okeNext(StandardPipeline.java:641) > > at > > org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:1 > > 63) > > at > > org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.inv > > okeNext(StandardPipeline.java:641) > > at > > org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480 > > ) > > at > > org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) > > at > > org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.ja > > va:174) > > at > > org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.inv > > okeNext(StandardPipeline.java:643) > > at > > org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480 > > ) > > at > > org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) > > at > > org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:199) > > at > > org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:828) > > at > > org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processCon > > nection(Http11Protocol.java:700) > > at > > org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:584) > > at > > org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.j > > ava:683) > > at java.lang.Thread.run(Thread.java:534) > > ------------------------------------------- > > > > Hope you can help me, > > Gertjan Draafsel > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
