For the sake of clarifcation, this is only necessary when restoring to an instance of SQL server that is different from the one on which the backup was created. On your production server, you can use SQL Enterprise Manager to generate the necessary SQL script to create the users and roles specific to that database, and to apply the object-level permissions. That way, you just restore the database to the test server, run the SQL script, and you should be ready to go.
>>> [EMAIL PROTECTED] 12/16/2004 8:41:40 AM >>> 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]
