+ 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
    Posts
    2,032
    Thank Post
    82
    Thanked 187 Times in 154 Posts
    Rep Power
    83

    Nightmare trying to log in to dbattach

    Hi,
    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
    Location
    Kent
    Posts
    908
    Thank Post
    92
    Thanked 118 Times in 95 Posts
    Rep Power
    47
    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
    Location
    Ipswich
    Posts
    4,377
    Thank Post
    368
    Thanked 637 Times in 519 Posts
    Rep Power
    158
    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

SHARE:
+ 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, 11:58 AM
  2. Replies: 0
    Last Post: 10th October 2011, 05:36 PM
  3. Replies: 0
    Last Post: 24th March 2011, 02:27 PM
  4. Logging in to a new SIMS installation
    By AnnDroyd in forum MIS Systems
    Replies: 3
    Last Post: 15th January 2008, 01: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, 11:17 AM

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
  •