The user does not have database level permission to transfer data

[winhan]

I have set up a new MS SQL 2016 Server and successfully created the tables for EA 14.
I have created a SQL user that is a member of

• db_datareader
• db_datawriter
• db_ddladmin
• public

and the server roles public and sysadmin

When I try to Transfer my Source Project from EA 14 to the DB I get the following error messages:
First it says that the credentials are wrong (they are not) and gives me a input window to write the passord again. When I write the password again I get the error message:
The user does not have database level permission to transfer data

As the selected user I am able to insert data into tables from SSMS

[Geert Bellekens]

First it says that the credentials are wrong (they are not) and gives me a input window to write the passord again. When I write the password again I get the error message:
The user does not have database level permission to transfer data

The problem is in the database connection you are creating from EA. For some reason it doesn't have access, indicated by saying the credentials are wrong.
There is a "Test Connection" button on the data link dialog. Have you used that to test the connectivity?
The second password dialog is just EA indicating that it can't connect to the database. (the same happens if you don't have a network connection).

Geert

[winhan]

When I click on Test Connection I get a message back "Test connection succeded"
But whan I after that click on Transfer I get the message:
Microsoft OLE DB Provider for SQL Server [-2147217843]
Login failed for user 'username'
Do you want to retry entering the password?
If I click yes I get a new dialog window where I insert the password again
and after that I get the message The user does not have database level permission to transfer data

I can connect to the DB using SSMS using the same credentials

[Geert Bellekens]

Weird. Where you able to select the model database from the dropdown?

I'm pretty sure that it is an SQL server security issue. If all else fails you can always contact Sparx support.

Geert

PS. Any reason why you are using an SQL server user instead of windows authentication to create the connection to the database?

[winhan]

Thanks, I have created a Bug report.
I get the same result when I try with Windows authentification.