netspi / daft Goto Github PK

There are scenarios in which master database has set COLLATION to Case-Sensitive, which might result in following rather cryptic connection error message:

] SQL01: SQL Exception Occured: Cannot open database "Master" requested by the login. The login failed.
Login failed for user 'john.doe'.

To check if master is case-sensitive run the following query:

select SERVERPROPERTY('COLLATION');

and look for CS = Case-Sensitive or CI = Case-Insensitive.

That happened to me during the engagement whilst authenticating via SQL Server Authentication.

Simply changing master's hardcoded database name was enough to successfully authenticate and operate using the tool:

This error costed me several hours troubleshooting and banging my head against the wall. I think, that both PowerUpSQL and DAFT could benefit from a global "query-maintenance" functionality adapating database name case-sensitiveness based on supplied parameters.

Kind regards,
Mariusz

The switch case statement in Program.cs to see what module is being used has the module name as "serverdefaultloginpw" instead of "serverlogindefaultpw" as it is everywhere else in the code including the help text.

Also, DefaultCredentials.xml that the module relies on doesn't get embedded in the assembly, so it goes looking for it on-disk instead. I tried to whip up a quick fix for it but i'm mid-engagement and my expected fix isn't working. Posting this so it's written down somewhere, in case i forget to fix it myself and submit a PR.