How to create a new instance in MSSQL Server using PowerShell, PS+WMI or C#

Question

To create extra named instances for a already installed MS-SQL server
I usually re-run the installer...
and choose to add a new instance supplying the new name...

How can I do this from Powershell???
(I installed the SQLServer module but there is no 'New-Instance' commandlet there...)

Googlin' I saw some solution with Powershell+WMI but couldn't find one for new instance creation...

In last case...
if this can be done with c# (cs/csx) it is also an option...

?any ideas,,, Thx!

Excellent Question. Why would anyone downvote this question? — rjt
– rjt, Commented Dec 24, 2020 at 19:13

David Browne - Microsoft · Accepted Answer · 2019-08-12 18:14:21Z

2

The only way to add a additional named instance is to use the installer. You can, Install SQL Server from the Command Prompt You can alternatively, run SQL Server instances in Docker containers.

answered Aug 12, 2019 at 18:14

David Browne - Microsoft

90.7k7 gold badges52 silver badges87 bronze badges

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

1 Comment

rjt Over a year ago

David, any chance in the future, creating another instance will be available from powershell?

Collectives™ on Stack Overflow

How to create a new instance in MSSQL Server using PowerShell, PS+WMI or C#

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related