search

mmajcica / DeploySsrs

Build-Release task for VSTS/TFS that manages Microsoft's SQL Server Reporting Services
MIT License
21 stars 21 forks source link

DataSource with sql server athentication #26

Open sebitsi opened 5 years ago

sebitsi commented 5 years ago

Hi,

How i should configure dataSource deployment when credentials are stored in SSRS ? I'm using:

"DataSources": [
      {
          "ConnectionString": "Data Source=1.1.2.1;Initial Catalog=DB",
          "Name": "dsSomething",
          "Extension": "SQL",
          "CredentialRetrieval": "Store",
          "UserName": "User",
          "Password": "Pass",
          "WindowsCredentials": "True"
     }
 ]                   ]

Datasource is created, but cannont connect. I need to manually change "Type of credentials" from "Windows user name and password" to "Database user name and password".

I'm using SQL 2016 How to configure credentials type from windows to server in config file ? Thanks for advance.

Edvin

dabrantkosky commented 4 years ago

Hi, did you manage to do it? I'm having the same issue.