<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>topic I'm not sure why that is… in Product Forum</title>
    <link>https://community.blueprism.com/t5/Product-Forum/Data-SQL-Server-VBO/m-p/46111#M2178</link>
    <description>I'm not sure why that is text, but you should be able to case a password to text using a calculation stage (unsure all logging is turned off where you do that).</description>
    <pubDate>Wed, 07 Feb 2018 15:53:00 GMT</pubDate>
    <dc:creator>Denis__Dennehy</dc:creator>
    <dc:date>2018-02-07T15:53:00Z</dc:date>
    <item>
      <title>Data - SQL Server VBO</title>
      <link>https://community.blueprism.com/t5/Product-Forum/Data-SQL-Server-VBO/m-p/46110#M2177</link>
      <description>Hello,

&amp;nbsp;

I'm trying to use the SQL Server VBO to connect to a SQL server via the Set Connection page/action. And I'm running into an issue where the input parameter for the Set Connection action requires a text input for a password and the password I'm trying to pass is retrieved from Credential manager and stored in a password data item.

The VBO won't simply let me modify it and change the input parameter &amp;amp; data type from a text field to a password field.

Any suggestions on this?

&amp;nbsp;

Thanks!</description>
      <pubDate>Tue, 06 Feb 2018 23:27:00 GMT</pubDate>
      <guid>https://community.blueprism.com/t5/Product-Forum/Data-SQL-Server-VBO/m-p/46110#M2177</guid>
      <dc:creator>MattDavis</dc:creator>
      <dc:date>2018-02-06T23:27:00Z</dc:date>
    </item>
    <item>
      <title>I'm not sure why that is…</title>
      <link>https://community.blueprism.com/t5/Product-Forum/Data-SQL-Server-VBO/m-p/46111#M2178</link>
      <description>I'm not sure why that is text, but you should be able to case a password to text using a calculation stage (unsure all logging is turned off where you do that).</description>
      <pubDate>Wed, 07 Feb 2018 15:53:00 GMT</pubDate>
      <guid>https://community.blueprism.com/t5/Product-Forum/Data-SQL-Server-VBO/m-p/46111#M2178</guid>
      <dc:creator>Denis__Dennehy</dc:creator>
      <dc:date>2018-02-07T15:53:00Z</dc:date>
    </item>
    <item>
      <title>Thanks Dennis! We were able…</title>
      <link>https://community.blueprism.com/t5/Product-Forum/Data-SQL-Server-VBO/m-p/46112#M2179</link>
      <description>Thanks Dennis! We were able to do that and it didn't work. So we actually had to change the connection string to connect similar to how a CE device connects. Which made us edit the connection string in the Set Connection Page of the Data-SQL Server VBO (under the No Username Path) to:
""Data Source=""&amp;amp;[Server]&amp;amp; "";Initial Catalog="" &amp;amp; [Database] &amp;amp; "";Integrated Security=SSPI;
User ID=[User];Password=""&amp;amp;[Password]&amp;amp;"";""
&amp;nbsp;
We made this a custom object because we need to pass the user data item as a parameter and we had to force the set connection path to connect through the no path despite having a user name passed.
&amp;nbsp;
I'm not too clear on how our infrastructure is set up, but we found this solution because one of the many attempts we had, gave us an error: ""The login is from an untrusted domain and cannot be used with windows authentication"" so we figured we'd try a trusted connection setting where we are able to pass the domain as a parameter in the username data item.</description>
      <pubDate>Wed, 07 Feb 2018 17:46:00 GMT</pubDate>
      <guid>https://community.blueprism.com/t5/Product-Forum/Data-SQL-Server-VBO/m-p/46112#M2179</guid>
      <dc:creator>MattDavis</dc:creator>
      <dc:date>2018-02-07T17:46:00Z</dc:date>
    </item>
  </channel>
</rss>

