Creating a SQL Server database - but I get an error

Question

I'm trying to create a SQL Server database, and I get this error

Exception calling ".ctor" with "2" arguments error.

I'm also supposed to create a table from a csv, but I'm executing the code in segments first to make sure I'm doing it right.

Import-Module -Name sqlps -DisableNameChecking
$srv = New-Object Microsoft.SqlServer.Management.Smo.Server("(localhost)")
$db = New-Object Microsoft.SqlServer.Management.Smo.Database($srv, "Test_Database")
$db.Create()
Write-Host $db.Name "created" $db.CreateDate

The "local" machine in SQL Server can be specified as . (just a dot), (local) (with the parenthesis), or localhost (without any parens) - your spelling of (localhost) is not valid — marc_s
– marc_s, Commented Jun 22, 2019 at 18:38

Lukasz Szozda · Accepted Answer · 2019-06-22 18:14:17Z

2

My guess is that there is a issue with server instance name:

$srv = New-Object Microsoft.SqlServer.Management.Smo.Server("(localhost)")
=>
$srv = New-Object Microsoft.SqlServer.Management.Smo.Server(".")

answered Jun 22, 2019 at 18:14

Lukasz Szozda

181k26 gold badges278 silver badges326 bronze badges

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

1 Comment

Gamble Over a year ago

So I believe the instance name is UCERTIFY3 and I've replaced localhost with that. I'm pretty much learning SQL for school and I'm definitely not experienced in it.

AdminOfThings · Accepted Answer · 2019-06-22 19:01:40Z

0

If the instance is the default instance, then you can use the following:

$srv = New-Object Microsoft.SqlServer.Management.Smo.Server
$db = New-Object Microsoft.SqlServer.Management.Smo.Database($srv, "Test_Database")
$db.Create()

For the named instance, UCERTIFY3, you can use the following syntax:

$srv = New-Object Microsoft.SqlServer.Management.Smo.Server("SERVERNAME\UCERTIFY3")
$db = New-Object Microsoft.SqlServer.Management.Smo.Database($srv, "Test_Database")
$db.Create()

edited Jun 22, 2019 at 19:01

answered Jun 22, 2019 at 18:54

AdminOfThings

25.2k4 gold badges22 silver badges30 bronze badges

Collectives™ on Stack Overflow

Creating a SQL Server database - but I get an error

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related