+ Post New Thread
Results 1 to 3 of 3
MIS Systems Thread, Nightmare trying to log in to dbattach in Technical; Hi, I have just taken over a new school and have a new server which I need to use for ...
  1. #1

    Join Date
    Apr 2010
    Thank Post
    Thanked 190 Times in 157 Posts
    Rep Power

    Nightmare trying to log in to dbattach

    I have just taken over a new school and have a new server which I need to use for Sims and FMS.

    Normally when I move Sims and FMS to a new server I use dbattach to export the databases and then to also import on the new server. Problem is the old tech has left me a sa username and password that does not work. I get the error ' login failed for user sa'

    I can access the sql studio and have managed to do a backup (BAK) of the databases.

    am I able to move the databases to the new server using some other methode? I have seen posts saying its better to use dbattach as it keeps the users intact.

    This is not a good situation, I don't like it when my standard method fails and I have to go down an unknown path, also I set tonight aside to do this.

    Thanks for any advice

  2. #2
    BKGarry's Avatar
    Join Date
    Mar 2006
    Thank Post
    Thanked 139 Times in 110 Posts
    Rep Power
    maybe some of this will work, assuming it is SQL2008 (which is a SIMS pre-requisite)

    SQL SERVER – Reset sa Password « worth.Posting

  3. #3

    matt40k's Avatar
    Join Date
    Jun 2008
    Thank Post
    Thanked 657 Times in 537 Posts
    Rep Power
    Log on to SQL management, run a query on each database (ie sims and fms if you've got it) exec sims.db_p_transfer_login (or is it sims.db_p_transfer_logins?). Then under the left menu select security then select sa r-click change the password - make sure you store it somewhere secure so it doesn't happen again

+ Post New Thread

Similar Threads

  1. Firefox can't log in to https sites
    By jamin100 in forum General Chat
    Replies: 8
    Last Post: 20th May 2014, 12:58 PM
  2. Replies: 0
    Last Post: 10th October 2011, 06:36 PM
  3. Replies: 0
    Last Post: 24th March 2011, 03:27 PM
  4. Logging in to a new SIMS installation
    By AnnDroyd in forum MIS Systems
    Replies: 3
    Last Post: 15th January 2008, 02:36 PM
  5. New users can't log in to Outlook Web Access
    By WithoutMotive in forum Windows
    Replies: 5
    Last Post: 7th September 2007, 12:17 PM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts