Error with step 8 of my first process? [SqlException (0x80131904)
Hi, I am currently working through the First workshop and in step 8, after clicking on "Run Process", the page loaded displays an error:
Cannot open database "Vertical" requested by the login. The login failed.
Login failed for user 'EMEA\schadwick2'.
I am having great difficulty finding out how to fix this issue. I am using sql 2008 R2 and i believe the issue may be with how I connected to the server during "Run Workflow" in the modeler, where I used a different login to the one that is having the issue here. If this is the issue, guidance on how to resolve this would be greatly aspirated. Below I have copied the full stack trace. Thanks for any help that you may be able to provide.