Example DB Connection Strings

Example DB Connection Strings

< Guide Menu

MySQL: host=IPAddress;user=username;passwd=password;db=db_name

SQL Server: Driver={SQL Server Native Client 11.0};Server=hostname\instance;Database=AdventureWorks2012;Uid=username;Pwd=password

SQL Server with Windows credential management (aka Trusted Connection): Driver={SQL Server Native Client 11.0};Server=hostname\instance;Database=AdventureWorks2012;Trusted_Connection=Yes

MS Access: "Driver={Microsoft Access Driver (*.mdb)};DBQ=Path\\to\\db.mdb"

See http://connectionstrings.com for more info on ODBC connection strings (for SQL Server).

Oracle: “host=computer.department.com;user=username;password=examplepassword;SID=ORCL”

Previous Configuring Agents for SQL Scanning
Next SQL Configuration Options
Table of Contents