PowerShell script not accepting $ (dollar) sign

powershell escaping
Murtaza Mandvi picture Murtaza Mandvi · Oct 23, 2009 · Viewed 65.7k times · Source

I am trying to open an SQL data connection using a PowerShell script and my password contains a $ sign:

$cn = new-object system.data.SqlClient.SqlConnection("Data Source=DBNAME;Initial Catalog=Catagory;User ID=User;Password=pass$word;")

When I try to open a connection it says:

Login failed

Answer

Shankar R10N picture Shankar R10N · Oct 23, 2009

Escape it by using backtick (`) as an escape character for the dollar sign ($).

Also, try to enclose the statement in single-quotes instead of the double-quotes you are using now.

Related questions

Select-string escape character

I'm trying to search directory c:\bats\ for batch files containing the unc path \\server\public Command: Get-ChildItem -path c:\bats\ -recurse | Select-string -pattern "\\server\public" I receive an error related to the string \\server\public: Select-string : The string \\server\…

Read More
How to run appCmd in PowerShell to add custom headers to the Default Web Site

Please help me figure out how to properly escape the arguments so they work when calling appcmd inside of powershell. My script looks like this: $defaultWebSite = "Default Web Site" $appCmd = "C:\windows\system32\inetsrv\appcmd.exe" $addHeaderP3P = "set config ""$…

Read More
Determine installed PowerShell version

How can I determine what version of PowerShell is installed on a computer, and indeed if it is installed at all?

Read More