+ 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
    1,832
    Thank Post
    62
    Thanked 161 Times in 133 Posts
    Rep Power
    64

    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
    793
    Thank Post
    69
    Thanked 98 Times in 80 Posts
    Rep Power
    42
    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,135
    Thank Post
    352
    Thanked 577 Times in 474 Posts
    Rep Power
    142
    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. Replies: 0
    Last Post: 10th October 2011, 05:36 PM
  2. Replies: 0
    Last Post: 24th March 2011, 02:27 PM
  3. Firefox can't log in to https sites
    By jamin100 in forum General Chat
    Replies: 3
    Last Post: 19th February 2008, 03:08 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
  •