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]
