Creating SQL Server instance via powershell?

Question

I've been looking for a way to create a SQL Server instance and then create and configure a database via PowerShell. I have found ways to create databases, but is there a way to create SQL Server instances?

"Create an instance" means installing SQL Server again (from the installation media) - with a new, unique instance name. This can be done silently, by providing all the necessary answers in an "options file" — marc_s
– marc_s, Commented Jan 2, 2020 at 16:51
This is what I want. I want to install a new instance via powershell. Could you possibly provide a link to somewhere where I can get this information? — GreenSaber
– GreenSaber, Commented Jan 2, 2020 at 16:54
See learn.microsoft.com/en-us/sql/database-engine/install-windows/… and learn.microsoft.com/en-us/sql/database-engine/install-windows/… - or just Google for it .... — marc_s
– marc_s, Commented Jan 2, 2020 at 16:57

codewario · Accepted Answer · 2020-01-02 16:55:13Z

2

As long as you have a Configuration.ini file created, whether it's from a previous manual install or if you've generated it yourself, you can easily install SQL server as you want with the options defined in Configuration.ini:

Setup.exe /ConfigurationFile=MyConfigurationFile.INI

answered Jan 2, 2020 at 16:55

codewario

21.9k25 gold badges107 silver badges179 bronze badges

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

Comments

Daniel Morritt · Accepted Answer · 2020-01-02 16:58:56Z

0

Have you taken a look at SqlServerDsc?

After that https://dbatools.io/ is pretty much the standard for all your SQL PowerShell needs.

answered Jan 2, 2020 at 16:58

Daniel Morritt

1,82718 silver badges26 bronze badges

Collectives™ on Stack Overflow

Creating SQL Server instance via powershell?

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related