Powershell, database connection string and $

Profile pictureToni Petrina
Published on 2016-09-301 min read

    Using connection strings in Powershell can yield some strange errors if the connection string contains the very special sign $.

    Why? Because the dollar sign is a special character and it needs to be escaped. To escape it, just add grave accent before and after. So your connection string becomes

    Server=tcp:mycooldb.database.windows.net,1433;Database=mycooldb;User ID=admin@mycooldb;Password=Pa`$$`w0rd;Encrypt=True;TrustServerCertificate=False;Connection Timeout=30;

    Why would one have the dollar sign in their password is another topic...

    Change code theme: