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