SSRS – Specify Windows Account for SSRS Data Source in SSDT Project

ssdtssrs

In the properties of a data source in SSRS, I can specify a Windows domain account to use, like this:

This data source was originally deployed from a SSDT project and I need these settings to be reflected in that project – otherwise the data source will no longer work correctly the next time that the project is deployed.

Unfortunately SSDT does not seem to provide a way of doing this. If I specify credentials here it automatically assumes SQL Server authentication (which is of no use to me).

Am I missing something, or am I once again the victim of Microsoft's inability to be consistent?

Best Answer

There is no option to set a data source within the client tool to use a different Windows account. This is by design and is consistent with how Microsoft designed most all client tools (e.g. works the same way in BIDS, SSMS, etc.).

Your only option I know of would be to simply not redeploy the shared data source.

Related Solutions

How to authenticate the database connection when using Reporting Services Forms authentication

I somehow missed seeing the Credentials section you can set for a data source. This way I can use SQL Server authentication and it works.

Sql-server – Registering a SSDT database project as a data tier application fails

I had this error recently so I'll add my solution for anyone else who comes across this,

Turns out in my publish.xml I had RegisterDataTierApplication set to True. The first time I published the database it worked fine, but then I got the same error, as the database was already registered as a Data Tier application.

By setting to false (or unchecking the checkbox in the gui) it works fine.

 <?xml version="1.0" encoding="utf-8"?>
<Project ToolsVersion="12.0" xmlns="http://schemas.microsoft.com/developer/msbuild/2003">
  <PropertyGroup>
    <IncludeCompositeObjects>True</IncludeCompositeObjects>
    <TargetDatabaseName>foo</TargetDatabaseName>
    <DeployScriptFileName>foo.sql</DeployScriptFileName>
    <BlockWhenDriftDetected>False</BlockWhenDriftDetected>
    <RegisterDataTierApplication>False</RegisterDataTierApplication>
    <ProfileVersionNumber>1</ProfileVersionNumber>
    <TargetConnectionString>Data Source=foo;Integrated Security=True;Pooling=False</TargetConnectionString>
  </PropertyGroup>
</Project>

As a note about extracting the dacpac - you will always get an error if extracting via ssms,

If you use the SQL Server Object Explorer in VisualStudio, you can set more options, including unchecking the 'Verify Extraction' option, which will then allow you to create the dacpac.

Best Answer

Related Solutions

How to authenticate the database connection when using Reporting Services Forms authentication

Sql-server – Registering a SSDT database project as a data tier application fails

Related Question