How do you send in multiple commands to Sql PowerShell from the Windows Command Line?

Question

Not sure if this belongs on serverfault or not...

I am following the instructions on this site for adding registered servers to sql studio management studio via powershell. It works great one at a time, but I need to do it for 60 servers.

I have a batch set up with the code for each create that I need. I can't get the syntax right for calling sqlps by the command line and passing in the whole series of commands. My batch is set up like so:

sqlps -NoExit -Command { cd 'SQLSERVER:\sqlregistration\Database Engine Server Group\' new-item $(Encode-Sqlname server1) -itemtype registration -Value "server=server1;integrated security=true" ... and so on }

Any help is appreciated.

That sev17.com link is broken and presently malicious.

matty
– matty

2024-07-09 12:05:22 +00:00
Commented Jul 9, 2024 at 12:05 — matty
– matty, Commented Jul 9, 2024 at 12:05

Chad Miller · Accepted Answer · 2011-07-02 02:59:56Z

1

If you have each individual new-item listed on a separate line in a PS1 file, for example assuming I have a file named register.ps1 with the following lines.:

cd 'SQLSERVER:\sqlregistration\Database Engine Server Group\'; new-item $(Encode-Sqlname server1) -itemtype registration -Value "server=server1;integrated security=true" 
cd 'SQLSERVER:\sqlregistration\Database Engine Server Group\'; new-item $(Encode-Sqlname server2) -itemtype registration -Value "server=server1;integrated security=true"

You could call sqlps like this:

sqlps -NoExit -Command "&{C:\bin\register.ps1}"

A better solution would be to add parameters to the register.ps1

param($ServerInstance)

cd 'SQLSERVER:\sqlregistration\Database Engine Server Group\'
New-Item $(Encode-Sqlname $server) -itemtype registration -Value "server=$serverInstance;integrated security=true"

Then then create a file with the list of SQL Instances, for example server.txt:

server1
server2

Call register.ps1 for each line:

get-content C:\bin\server.txt | foreach {C:\bin\register.ps1 $_ }

answered Jul 2, 2011 at 2:59

Chad Miller

42.4k4 gold badges33 silver badges34 bronze badges

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

1 Comment

IronicMuffin Over a year ago

I tried this, and I would see the lines of code shoot by, but they wouldn't do anything.

JasonMArcher · Accepted Answer · 2011-07-01 18:23:16Z

0

Put semi-colons between the commands.

answered Jul 1, 2011 at 18:23

JasonMArcher

15.1k22 gold badges59 silver badges53 bronze badges

2 Comments

IronicMuffin Over a year ago

No luck...Even running sqlps -NoExit -Command { cd 'SQLSERVER:\sqlregistration\Database Engine Server Group\Stores'; } leaves me at the prompt "PS SQLSERVER:\>" so the directory isn't even changing...

JasonMArcher Over a year ago

Are you running this from PowerShell, or something else? (Like cmd.exe)

IronicMuffin · Accepted Answer · 2011-07-04 13:52:27Z

0

Thanks to @Chad pointing me in the right direction, I came up with this, which worked:

A batch file with multiple lines, each line looking like this:

sqlps -Command "&{ cd 'SQLSERVER:\sqlregistration\Database Engine Server Group'; new-item $(Encode-Sqlname serverX) -itemtype registration -Value \"server=serverX;integrated security=true\";}"

answered Jul 4, 2011 at 13:52

IronicMuffin

4,20212 gold badges51 silver badges91 bronze badges

Collectives™ on Stack Overflow

How do you send in multiple commands to Sql PowerShell from the Windows Command Line?

3 Answers 3

1 Comment

2 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related