Author Topic: The user does not have database level permission to transfer data  (Read 824 times)

winhan

  • EA Novice
  • *
  • Posts: 6
  • Karma: +0/-0
    • View Profile
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
« Last Edit: October 01, 2018, 10:48:38 pm by winhan »

Geert Bellekens

  • EA Guru
  • *****
  • Posts: 10167
  • Karma: +329/-30
  • Make EA work for YOU!
    • View Profile
    • Enterprise Architect Consultant and Value Added Reseller
Re: The user does not have database level permission to transfer data
« Reply #1 on: October 01, 2018, 11:10:33 pm »
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

  • EA Novice
  • *
  • Posts: 6
  • Karma: +0/-0
    • View Profile
Re: The user does not have database level permission to transfer data
« Reply #2 on: October 01, 2018, 11:19:25 pm »
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

  • EA Guru
  • *****
  • Posts: 10167
  • Karma: +329/-30
  • Make EA work for YOU!
    • View Profile
    • Enterprise Architect Consultant and Value Added Reseller
Re: The user does not have database level permission to transfer data
« Reply #3 on: October 01, 2018, 11:49:42 pm »
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

  • EA Novice
  • *
  • Posts: 6
  • Karma: +0/-0
    • View Profile
Re: The user does not have database level permission to transfer data
« Reply #4 on: October 02, 2018, 12:06:59 am »
Thanks, I have created a Bug report.
I get the same result when I try with Windows authentification.