Author Topic: Recovering an SQL database  (Read 4488 times)

Doug Blake

  • EA User
  • **
  • Posts: 102
  • Karma: +0/-0
    • View Profile
Recovering an SQL database
« on: August 06, 2021, 07:20:54 pm »
Today I restored an SQL database and connected to it OK, however, its so long since I set the database up on another PC that I cant remember the EA login details for it. Is there a way to get me onto this database or am I screwed forever?
DGB Using 12.0.1214 / eaDocX 3.6.2.1 / MSSQL / TFS / Windows 7 / IE11

qwerty

  • EA Guru
  • *****
  • Posts: 12735
  • Karma: +361/-295
  • I'm no guru at all
    • View Profile
Re: Recovering an SQL database
« Reply #1 on: August 06, 2021, 11:47:49 pm »
There isn't a login unless you have turned on security. I'd guess your ODBC driver is the wrong one. Check EA's resource page for the right one (not all are valid).

q.

Guillaume

  • EA Practitioner
  • ***
  • Posts: 1146
  • Karma: +35/-2
    • View Profile
    • www.umlchannel.com
Re: Recovering an SQL database
« Reply #2 on: August 09, 2021, 04:50:50 pm »
If you enabled the security, you can disable it by updating values in your DB table t_secpolicies (see record with Property = UserSecurity).
You can alternatively set a null password in t_secuser for your admin account.


Guillaume

Blog: www.umlchannel.com | Free utilities addin: www.eautils.com