Thanks David. /robert
> -----Original Message----- > From: David Boyer [mailto:[EMAIL PROTECTED] > Sent: Thursday, December 16, 2004 11:27 AM > To: [EMAIL PROTECTED] > Subject: RE: [OT] cannot connect a sqlserver > > > In Enterprise Manager: > > Right-click on the database, select "All Tasks", and "Generate SQL > Script" > > This will let you script various portions of the database for later > recreation. It may take a couple tries until you find the combination of > objects and options for the specific situation. > > >>> [EMAIL PROTECTED] 12/16/2004 10:03:14 AM >>> > > David, > > Thanks for the clarification. Can you elaborate on how you > can use SQL Enterprise Manager to generate necessary SQL > script to create the users and roles specific to that database, > and to apply the object-level permissions or point me to the > docs? I have a script which I use for permisions, but I had to > create it and maintain it manually. I have been using Enterprise > Manager UI to manage users when restoring from a backup. It would > be great to place all of this into a single script for execution. > > /robert > > > -----Original Message----- > > From: David Boyer [mailto:[EMAIL PROTECTED] > > Sent: Thursday, December 16, 2004 10:45 AM > > To: [EMAIL PROTECTED] > > Subject: RE: [OT] cannot connect a sqlserver > > > > > > 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] > > > > > > > > --------------------------------------------------------------------- > 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]
