Enterprise Architect Database Repository connection issue

[Deepu M]

Hi,

I setup an SQL Server data base for working with Enterprise architect. Iam getting the following error while connecting to access the models mounted in the data base server.
I can share the error code and the screen shot of the error along with this topic.

Iam not getting this error while trying to access the model by selecting it from the recent list. Iam getting this only when trying to connect explicitly every time by giving the server URL, username and password.

error - "Microsoft OLE DB Provider for SQL Server[0x80040e4d] Login failed for user 'entarch_admin'


Any help to solve this problem would really be appreciated!

Best Regards
Deepu Manoharan

[Geert Bellekens]

That means the database is rejecting your login.

Make sure you can connect with the username and password you are using (or even better, switch to windows authentication)

Geert

[Deepu M]

Hi,

Thanks for the reply. At the moment, we have enabled the windows authentication as the next level. Is there any way to bypass the first level(Using OLE DB Provider for SQL Server) and directly reach the second level windows authentication to access the models.

Please correct me If Iam wrong, Iam new to this topic

[Geert Bellekens]

Hi,

Thanks for the reply. At the moment, we have enabled the windows authentication as the next level. Is there any way to bypass the first level(Using OLE DB Provider for SQL Server) and directly reach the second level windows authentication to access the models.

Please correct me If Iam wrong, Iam new to this topic

Select windows authentication instead of a user/password when setting up the OLED DB connection.

Geert

[Deepu M]

Hi,

Thanks for the suggestion. It worked for me using the Windows authentication instead of the data base user name and password.

Best Regards
Deepu M

[Uffe]

Hello Deepu,


For context, database access and EA project access are completely separate. You must decide how you wish to authenticate the DBMS connection and set the database up for that, and you must also decide how you wish to authenticate EA project users and set the project up for that.

Windows (or AD) authentication is the best overall, but setting the database to authenticate users this way does not affect the EA project authentication, and vice versa. So you must configure both the database and the EA project, the one does not affect the other.

HTH,


/Uffe