Gateway connection setup

[dfox09]

I did not see a similar post so I thought I would post this. I am taking over the management of a dataset within a specific workspace in my organization. I am having trouble setting up the connection to some of our data sources and wondering if this is something that someone who could "walk me through" this? I have looked at the documentation for this and it appears to be too generic for my purposes.  

Where I am running into trouble is taking over a dataset such as “BP Data Compliance - Missing Premium Detail” dataset in the “Benefits Services Business Process” workspace in my organization.  In the Gateway connection, it looks like this:

I have blurred out the emails for security purposes but mine is in there. If I click on “Add to gateway”, I see the following:

I don’t know what credentials to put here. If I put my own, they will expire, so I don’t think I use my own. Are my DBAs supposed to provide me with the credentials?  I hope everyone can see what is in the two graphics I pasted in here. If not let me know and I'll add the verbiage some other way.

[GilbertQ]

Awesome thanks for letting us know.

[dfox09]

Thank you Gilbert. What I found out was that I had to add myself as an admin to the existing connections. That solved the issue. 

[GilbertQ · Accepted solution]

Hi @dfox09 

When connecting to SQL Server you will need to put in either Windows Credentials or Basic Credentials (Which will be a SQL Username and Password supplied by your DBA which can query the underlying tables)