timematters program and database, how to copy from one server to another

Posted on 2006-05-26
Medium Priority
Last Modified: 2007-12-19
I run timematters enterprise version 7.  I want to copy the tm 7 app and database  to a test server to develop modifications to my system.  I am pretty inexperienced with sql (I am running sql 2000).  I can detach, copy and reattach the db, but dont see the data.  As I start the application, however, it looks like it is loading the full database.  The timematters app itself appears to just use one login to the sql server, the login is called tm7user, and then the individual users licensed in the tm 7 applicatoin log into the application.  It looks to me lilke the app simply uses sqlserver to hold the data, and the app passes the data to the users.  This is a law office  (mostly)  program, and there is not much help outside of the "official" consultants, who are not really eager to share their knowledge on a list-serve.  I can't believe that it should be that hard to do, but its not intuitive either.  Is there any expert's exchange guru out there who can help? Since there seems to be a lack of knowledge, I think this is worth the max 500 points.
Question by:195ecentralave
LVL 28

Accepted Solution

imran_fast earned 2000 total points
ID: 16775444
You detach and reattach the database did you do the same with msdb database.
I think this is purely access problem try to check on the old server what are the user and what are there acces on database and do you have the same here.

Msdb database and master database are the one containing these but the contain server specific info so i prefer you should create those users and revoke their access on databases.

Author Comment

ID: 16825620
That got me what I needed.  I was just moving the databases for the data, not the msdb and master.  Once I did that, and some other things for my application, i was able to connect.
Thank you.

Featured Post

Transaction-level recovery for Oracle database

Veeam Explore for Oracle delivers low RTOs and RPOs with agentless transaction log backup and transaction-level recovery of Oracle databases. You can restore the database to a precise point in time, even to a specific transaction.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Ever wondered why sometimes your SQL Server is slow or unresponsive with connections spiking up but by the time you go in, all is well? The following article will show you how to install and configure a SQL job that will send you email alerts includ…
It is possible to export the data of a SQL Table in SSMS and generate INSERT statements. It's neatly tucked away in the generate scripts option of a database.
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.

862 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question