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

Posted on 2006-05-26
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

    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

    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.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    This is my first ever Article on EE or elsewhere; therefore, please bear with me if I have some discrepancies in my writing. I read many articles and questions related to "how to pass values to SSIS packages at run-time?"  Hence, this common ques…
    Let's review the features of new SQL Server 2012 (Denali CTP3). It listed as below: PERCENT_RANK(): PERCENT_RANK() function will returns the percentage value of rank of the values among its group. PERCENT_RANK() function value always in be…
    This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
    Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed

    794 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

    Need Help in Real-Time?

    Connect with top rated Experts

    16 Experts available now in Live!

    Get 1:1 Help Now