Invoke-Sqlcmd : A network-related or instance-specific error occurred while establishing a connection to SQL Server

Question

I want to create a table using .sql file through PowerShell.

Running following in Windows PowerShell ISE as Administrator:

Invoke-Sqlcmd -InputFile 'D:\SQL Scripts\test.sql' -ServerInstance 'localhost\MSSQLSERVER' -Database 'Test'

But this is giving following error:

Invoke-Sqlcmd : A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 25 - Connection string is not valid)

Could any one please guide to fix this.

I have already refereed execute .sql using powershell

TylerH · Accepted Answer · 2024-05-29 18:19:05Z

8

Because it's taking server name as localhost, there's no need to mention the instance name; it's connecting to default instance.

This worked:

Invoke-Sqlcmd -InputFile 'D:\SQL Scripts\test.sql' -ServerInstance 'localhost' -Database 'Test'

edited May 29, 2024 at 18:19

TylerH

21.3k84 gold badges84 silver badges122 bronze badges

answered Jun 20, 2015 at 11:39

Jain Prince

4331 gold badge9 silver badges21 bronze badges

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

1 Comment

developer Over a year ago

it is worth mentioning that -ServerInstance can be set to another server and/or a non default named instance: <HOSTNAME>/<INSTANCENAME>

Collectives™ on Stack Overflow

Invoke-Sqlcmd : A network-related or instance-specific error occurred while establishing a connection to SQL Server

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