Configuring SQL Protocols through Windows PowerShell

re: Configuring SQL Protocols through Windows PowerShell

Pushpendra — Fri, 12 Sep 2008 09:04:23 GMT

I am unable to connect with the sql server, when I am trying to connect with the server, it shows the connection failed:

SQL State:'01000'

SQL server error:121

re: Configuring SQL Protocols through Windows PowerShell

DonnaO — Thu, 11 Dec 2008 05:35:53 GMT

Can you use PowerShell to add new IP addresses for SQL Server 2008 to use? We installed SQL Server 2008 Developer Edition and then added new IP addresses to the server. We want to use the new IP address for SQL Server, but this IP address is not listed in SQL Server Configuration Manager.

re: Configuring SQL Protocols through Windows PowerShell

goran.peterson@qbranch.se — Mon, 05 Jan 2009 14:01:44 GMT

Do you have any idea about how I could connect to an instance using the "ip address,port" notation?

For example, Microsoft propose that you could connect by using the following format:

cd SQLSERVER:\SQL\MyComputer\MyInstance

This could work ok, but for us it doesn't. If I try to connect from the SQLSERVER:\SQL prompt with

cd (encode-sqlname "10.10.10.10,1234") I get a mixed error message; from WMI saying RPC server is unavailable, and from PS engine saying that the (encoded) path does not exist.

Is there another way/method I could connect?