title: SSRS - Unable to connect to datasource
body: <p><strong>Context:</strong> I have an installation of SQL Server 2019 installed on my local workstation and within an SSRS Report Project I'm trying to create a dataset that connects to this SQL Server datasource. I keep raising this error</p>
  <p><strong>&quot;Unable to connect to datasource 'XXXX'&quot;</strong></p>
  <p>EDIT: I realized clicking through the details there's a more descriptive message here: <strong>You have specified integrated security or credentials in the connection string for the data source, but the data source is configured to use a different credential type. To use the values in the connection string, you must configure the unattended report processing account for the report server.</strong></p>
  <p><a href="https://i.stack.imgur.com/rEKzp.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/rEKzp.png" alt="enter image description here" /></a></p>
  <p>I'm thought I was using Windows Authentication. This is a very strange error because prior to this step when I create the datasource and test the connection the test succeeds. How is it that the datasource connection properties dialog recognizes the server, database name and successfully authenticates my windows creds in the connection test but suddenly the dataset dialog cant connect...?</p>
  <p><strong>How have I tried to fix this:</strong> I thought this could be an issue with the ODBC driver I'm using so I've installed both Microsoft ODBC Driver 13.1 &amp; 17 for SQL Server which is not resolving the issue.</p>
  <p><strong>Question:</strong> Does anyone know why this is happening and how to fix it?</p>
  <p><a href="https://i.stack.imgur.com/N52nD.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/N52nD.png" alt="enter image description here" /></a></p>