When deploying my SSAS solution I am getting error message: "The connection either timed out or was lost"


This document describes that one of the workarounds is to add ";SSPI=NTLM" or ";Integrated Security=SSPI" to the connection string. I found that doing that really helped.

Here are steps how to add additional parameter to the connection string for the BIDS environment:

·         In the BIDS environment select menu item "Project" and then "Properties"

·         Select "Deployment" tab

·         Change Target/Server property value from "YourServerName" to "YourServerName;SSPI=NTLM"

Comments

Popular Posts

Failed to execute the package or element. Build errors were encountered

Restore of database 'DataBase_Name' failed. (Microsoft.SqlServer.Management.RelationalEngineTasks)

Cannot convert "Column" between a unicode and a non-unicode string data types in SSIS