I have found a temporary solution. By creating an extra login credential on the server with sql server authorization I were able to get access without using Integrated Security.
This might not be a possible solution for our project. If anyone have a better solution I would love to hear about it!