Book a Demo

Author Topic: New SQL Server  (Read 3526 times)

Luis Gustavo

  • EA Novice
  • *
  • Posts: 16
  • Karma: +0/-0
    • View Profile
New SQL Server
« on: January 24, 2012, 04:47:15 am »
HI all!

My SQL Server crashed. I atached the .dbf file in another server,  same SQL verion.
But now, can't  to connect. Appear a screen box to type the Password. I try put admin password, but not work.

Geert Bellekens

  • EA Guru
  • *****
  • Posts: 13523
  • Karma: +574/-33
  • Make EA work for YOU!
    • View Profile
    • Enterprise Architect Consultant and Value Added Reseller
Re: New SQL Server
« Reply #1 on: January 24, 2012, 05:48:37 pm »
Luis,

If you get the "password only" box that means that it can't connect to the database.
Check the connection details/user rights etc...

Geert

qwerty

  • EA Guru
  • *****
  • Posts: 13584
  • Karma: +397/-301
  • I'm no guru at all
    • View Profile
Re: New SQL Server
« Reply #2 on: January 24, 2012, 06:48:35 pm »
You may have turned on security. In that case you must tweak a table to get it turned off.

q.

Geert Bellekens

  • EA Guru
  • *****
  • Posts: 13523
  • Karma: +574/-33
  • Make EA work for YOU!
    • View Profile
    • Enterprise Architect Consultant and Value Added Reseller
Re: New SQL Server
« Reply #3 on: January 24, 2012, 07:05:13 pm »
No No, in that case you get a box with both two entry boxes: user and password.
In case of a single password box it is definitely a database connection error.

Geert

Luis Gustavo

  • EA Novice
  • *
  • Posts: 16
  • Karma: +0/-0
    • View Profile
Re: New SQL Server
« Reply #4 on: January 24, 2012, 09:53:49 pm »
Tks for help!
The last SQL Server(Crashed) was integrated in  DOMAIN, but the new SQL server isn't.  My users use DOMAIN\<USER> to logon in EA. Can be this the problem?

Geert Bellekens

  • EA Guru
  • *****
  • Posts: 13523
  • Karma: +574/-33
  • Make EA work for YOU!
    • View Profile
    • Enterprise Architect Consultant and Value Added Reseller
Re: New SQL Server
« Reply #5 on: January 24, 2012, 11:15:21 pm »
The users need to have access to the database obviously.
How (or if) they login into EA is irrelevant.

Geert

qwerty

  • EA Guru
  • *****
  • Posts: 13584
  • Karma: +397/-301
  • I'm no guru at all
    • View Profile
Re: New SQL Server
« Reply #6 on: January 25, 2012, 04:10:30 am »
Luis, could you please give more details on whether you have turned on security in EA.

q.