I've been tasked with moving us from one decade old system (Access '97) to a brand new system using MS SQL Express 2008 as a backend. So great, I know I can connect to the database (successful with a read-only user), the only problem is... I don't have a user in the database with write access, and we don't have source access to the application to know what password the application uses (though, I do have the username).
So, as I can see it, I have two options:
- Recover the password for the user the application uses in a non-destructive (or undoable) manner.
- Insert an extra administrative user to the database that I can then use as a data import user.
Are either of these options viable and/or possible, and how would I go about one or both of them, given the fact that I am sitting infront of the computer with full access to do whatever.