MS SQL Server 2008 HA Cluster

[maselhappy]

Hi,
Out IT Department use an MS SQL Server 2008 High Available Cluster and we want to place our repository on that server.
But it doesn't work.
Of cause use a Domain authorization and we have a usergroup which access the sql server.
The following permissions we have setup:
•   Db_owner
•   Public
•   Db_datareader
•   Db_datawriter
•   Db_ddladmin
I can run the script and the update Script on the server with the SQL Management studio but EA 14 says no permission to transfer data into the database.

What is missing here?

Br
Marcel

[Geert Bellekens]

If you connect to the database with SSMS using the same credentials as used through EA, can you do updates or inserts?

Seems like an SQL server permissions issue. If that doesn't help, you might want to post more detailed scenario and error description.

Geert

[winhan]

I get the same error message when trying to transfer from EA 14 to a new MS SQL 2016 server. I am moving from a file based repo to a DB based.

[Geert Bellekens]

I get the same error message when trying to transfer from EA 14 to a new MS SQL 2016 server. I am moving from a file based repo to a DB based.

We really can't help if you don't provide more information.

Geert

[winhan]

I created a separate post for my problem so I don´t hijack this one

[maselhappy]

Hi,
My problem is solved.

Our IT did not allow to make changes on the database structure. normally you don't need it but in EA case i think this was the problem.
I also transfere file to database and database to database. both works fine now.

Thanks.

@winhan,
please do it. because it is nearly the same problems.