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 ...
23rd May 2012, 07:46 PM #1
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
IDG Tech News
23rd May 2012, 07:48 PM #2
maybe some of this will work, assuming it is SQL2008 (which is a SIMS pre-requisite)
SQL SERVER – Reset sa Password « worth.Posting
24th May 2012, 12:23 AM #3
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
By Davit2005 in forum General Chat
Last Post: 10th October 2011, 06:36 PM
By burgemaster in forum Wireless Networks
Last Post: 24th March 2011, 03:27 PM
By jamin100 in forum General Chat
Last Post: 19th February 2008, 04:08 PM
By AnnDroyd in forum MIS Systems
Last Post: 15th January 2008, 02:36 PM
By WithoutMotive in forum Windows
Last Post: 7th September 2007, 12:17 PM
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)