Page Comparison

...

The recommended connection string format is:

sqlserver://username<username>:password@host:port/instance

The following connection string URL formats are also supported

• sqlserver://username:password@host/instance?param1=value&param2=value

• sqlserver://username:password@host:port?param1=value&param2=value

• sqlserver://sa@localhost/SQLExpress?database=master&connection+timeout=30 // SQLExpress instance.

• sqlserver://sa:mypass@localhost?database=master&connection+timeout=30 // username=sa, password=mypass.

• sqlserver://sa:mypass@localhost:1234?database=master&connection+timeout=30 // port 1234 on localhost.

• sqlserver://sa:my%7Bpass@somehost?connection+timeout=30 // password is "my{pass"

The connection string can also be provided in ADO and ODBC format, examples as follows:

...

server=localhost\\SQLExpress;user id=sa;database=master;app name=MyAppName

...

server=localhost;user id=sa;database=master;app name=MyAppName

...

odbc:server=localhost\\SQLExpress;user id=sa;database=master;app name=MyAppName

...

odbc:server=localhost;user id=sa;database=master;app name=MyAppName

...

odbc:server=localhost;user id=sa;password={foo;bar} // Value marked with {}, password is "foo;bar"

...

odbc:server=localhost;user id=sa;password={foo{bar} // Value marked with {}, password is "foo{bar"

...

odbc:server=localhost;user id=sa;password={foobar } // Value marked with {}, password is "foobar "

...

odbc:server=localhost;user id=sa;password=foo{bar // Literal {, password is "foo{bar"

...

odbc:server=localhost;user id=sa;password=foo}bar // Literal }, password is "foo}bar"

...

odbc:server=localhost;user id=sa;password={foo{bar} // Literal {, password is "foo{bar"

...

<password>@<ip>:<port>?database=sqltelemetrydb,username,password

• <username>:<password>: leave this section unchanged

• <ip>:<port>: Replace this with the actual IP address and port number

• database=sqltelemetrydb: Replace sqltelemetrydb with the database name

• username,password: Replace these with the username and password

Run sqlserver-telemetry

Windows

...