MSSQL
Public
MSSQL loadable plugin
Source
171
171
```172
172
mssql.ping[sqlserver://localhost:1433,stage_user,stage_password]173
173
```174
174
175
175
**Note:** User and password are separate parameters. Don't embed credentials in176
176
URI.177
177
178
178
- WRONG: `mssql.ping[sqlserver://stage_user:stage_password@localhost:1433]`179
179
- CORRECT: `mssql.ping[sqlserver://localhost:1433,stage_user,stage_password]`180
180
181
+
It is also possible to connect to named instance by providing instance name in path part of the URI.182
+
183
+
Example:184
+
```185
+
sqlserver://localhost/InstanceName186
+
```187
+
188
+
**Note:** If both host and port are provided, the port will be used for the connection.189
+
181
190
Read more about what parameters are available for each metric key in the182
191
section - metric keys.183
192
184
193
<!-- TOC --><a name="as-a-named-session"></a>185
194
186
195
## As a named session187
196
188
197
Named sessions allow grouping database connection settings under a name. Define189
198
named session configuration parameters the following way:190
199