Support all auth options using bulk copy

[MeinAccount]

Describe the bug

Using Authentication=ActiveDirectoryServicePrincipal causes bulkcopy to carsh with RuntimeError: Failed to connect to SQL Server: Connection Error: Authentication method 'ActiveDirectoryServicePrincipal' is not supported. No token provider was registered for this method.

The docs to not mention supported auth options.

Further technical details

Python version: Python 3.12.9
SQL Server version: Azure SQL
Library Version: 1.5.0

[MeinAccount]

Using the trick from #127 also doesn't work: RuntimeError: Failed to connect to SQL Server: Sql Error: 18456: Class 14: State 1: Login failed for user ''. on Unknown in Unknown at line 0

[github-actions]

Hi @MeinAccount, thank you for opening this issue!

Our team will review it shortly. We aim to triage all new issues within 24-48 hours and get back to you.

If you have additional information to share, please feel free to update the issue.

Thank you for your patience!