Azure SQL: Invalid Object Name using Powershell's "Invoke-sqlcmd" on Adventureworks

Question

I'm new to SQL, trying to query an Azure SQL Database (Adventureworks sample) using PowerShell's Invoke-SQLCmd.

When I try the following command in Powershell:

Invoke-Sqlcmd -Query "SELECT * FROM SalesLT.Customer;" -ServerInstance 
"<servername>.database.windows.net" -Username <username> -Password <password>

I get:

Invoke-Sqlcmd : Invalid object name 'SalesLT.Customer'.

Do I need to specify what Database that table is under? Namely, "SQLDatabse" instead of "master"? But when I add Use SQLDatabase to my query it throws another error:

USE statement is not supported to switch between databases. Use a new     
connection to connect to a different database.

Note: Executing these queries from SQL Server Management Studio gets me the table with no errors.

jleach · Accepted Answer · 2017-01-19 01:03:11Z

3

Add a -Database [dbname] to the command parameters:

Invoke-Sqlcmd -Query "SELECT * FROM SalesLT.Customer;" 
    -ServerInstance "<servername>.database.windows.net" 
    -Username <username> -Password <password> -Database <dbname>

https://msdn.microsoft.com/en-us/library/cc281720.aspx

edited Jan 19, 2017 at 1:03

answered Jan 19, 2017 at 1:02

jleach

7,9004 gold badges38 silver badges61 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

jleach Over a year ago

No prob. I've never actually used it, but any time you connect to a server to query, it needs a reference to which database, and a quick look at the docs showed the param (servers can (and do by default) have multiple databases).

Collectives™ on Stack Overflow

Azure SQL: Invalid Object Name using Powershell's "Invoke-sqlcmd" on Adventureworks

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related