note 118018 added to ref.pdo-dblib

When using dblib to connect to azure sql in linux, the connecting user must have at least access rights to the master database (no read/write necessary), as you cannot change the default database on a user in azure like you can with sql server. It would appear that even though you specify a database in the DSN, freetds is making a connection to the default database (master), then changing to the specified database. jTDS (used by tools like DBeaver) build a connection string that specifies the connection database, and thus doesn't need access to master. I also had to specify the server name in the user (e.g. - "username@servername" in PHP, though not in tsql (which also uses the freetds library). ---- Server IP: 72.52.91.14 Probable Submitter: 205.234.179.170 ---- Manual Page -- http://php.net/manual/en/ref.pdo-dblib.php Edit -- https://master.php.net/note/edit/118018 Del: integrated -- https://master.php.net/note/delete/118018/integrated Del: useless -- https://master.php.net/note/delete/118018/useless Del: bad code -- https://master.php.net/note/delete/118018/bad+code Del: spam -- https://master.php.net/note/delete/118018/spam Del: non-english -- https://master.php.net/note/delete/118018/non-english Del: in docs -- https://master.php.net/note/delete/118018/in+docs Del: other reasons-- https://master.php.net/note/delete/118018 Reject -- https://master.php.net/note/reject/118018 Search -- https://master.php.net/manage/user-notes.php