Databases
StackOverflow2013
Postsdbo
POInvoke-SQLCmd with Different Credential
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POInvoke-SQLCmd with Different Credential
    primarykey
    data
    text
    <p>Background: I am running a script locally that has to be run as SYSTEM, lets not get into why that is. :) The script attempts to check the health of my MSSQL cluster with a simple query. The problem I am running into however is that the local SYSTEM account doesn't have access to the remote database. At this point I've tried a number of things, which I'll get into in a moment, but I'm honestly up for any solution that makes sense. If it means creating a local account in the database that can answer my simple query that's fine too.</p> <p>There is what I have so far:</p> <pre><code>$Server = 'myserver.domain.tld' $Database = 'myDatabase' $Query = 'SELECT DB_NAME() AS DataBaseName' $Username = 'myDomain\myUsername' $Password = 'myPasswordWithPlainText' Invoke-SQLCmd -ServerInstance $Server -Database $Database -ConnectionTimeout 300 -QueryTimeout 600 -Query $Query -Username $Username -Password $Password </code></pre> <p>The result: <code>Invoke-Sqlcmd : Login failed for user 'myDomain\myUsername'</code></p> <p>Maybe Invoke-SQL doesn't take Windows authentication I thought, but it doesn't use -Credential. So then I tried to use Invoke-Command as a wrapper.</p> <pre><code>$Server = 'myserver.domain.tld' $Database = 'myDatabase' $Query = 'SELECT DB_NAME() AS DataBaseName' $Username = 'myDomain\myUsername' $Password = 'myPasswordWithPlainText' $secpasswd = ConvertTo-SecureString $Password -AsPlainText -Force $credential = New-Object System.Management.Automation.PSCredential ($Username, $secpasswd) Invoke-Command -script {Invoke-SQLCmd -ServerInstance $Server -Database $Database -ConnectionTimeout 300 -QueryTimeout 600 -Query $Query} -Credential $Credential </code></pre> <p>Which got me: <code>Invoke-Command : Parameter set cannot be resolved using the specified named parameters.</code></p> <p>So.. I'm stuck. Any thoughts? </p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. This table or related slice is empty.
    1. USAaron Wurthmann
    plurals
    1. PL
      singulars
      1. LTLinked
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    3. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POInvoke-SQLCmd with Different Credential
      1. This table or related slice is empty.
      1. VTUpMod
    1. COsure you've checked this but the user (mydomain\myusername) does have access to the database?
      singulars
      1. POInvoke-SQLCmd with Different Credential
      1. USMatt
    2. COYou could grant a machine access to a remote SQL Server. This can't be setup via the GUI, but on the remote machine added myDomain\myMachine$ using CREATE LOGIN [myDomain\myMachine$] FROM WINDOWS; Then remove all teh user name, password stuff from your script.
      singulars
      1. POInvoke-SQLCmd with Different Credential
      1. USChad Miller
    3. CO@Matt yes of course as the account works when run from the Shell. But hey its the little things we overlook sometimes that come back to bite us.
      singulars
      1. POInvoke-SQLCmd with Different Credential
      1. USAaron Wurthmann
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload