« previous next »
Pages: [1]

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?
Logged
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.
Logged

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.


Logged
Guillaume

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

Pages: [1]
« previous next »