Comments (7)
check it, @wsmelton! when MSFT figures this out, we can too 😅 I know you said it had to do with sqlbulkcopy so i think it'll have to be fixed in the sqlclient.
from sqlserverpsmodule.
Still fails with v22.1.1
from sqlserverpsmodule.
Same here
from sqlserverpsmodule.
Sorry folks. I completely missed this issue.
I do not know on top of my head how to setup all that stuff and my MI is not configured for User Managed Identities.
If you have a script to set it up, it would help me debugging.
The cmdlets are not really doing much: they typically pass around the token to either SMO or the driver (Microsoft.Data.SqlClient). It is possible that the way the Read-Sql* cmdlet is passing the token to SMO is incorrect for some reason; Invoke-Sqlcmd passed the token straight to the driver... so that could be a difference.
What is the behavior if you don't pass the full token object -AccessToken (Get-AzAccessToken -ResourceUrl https://database.windows.net)
instead of just the text blob -AccessToken (Get-AzAccessToken -ResourceUrl https://database.windows.net).Token
: same error?
Also, what is the real error? Can you just capture the $Error[0].Exception.ToString()
and see if it reveals anything interesting?
from sqlserverpsmodule.
Sorry for my mistake, it seems the issue had been fixed with v22.1.1
I´ve had an additional issue with multiple az-contexts within the running script.
Both of your variants (with and withoud .Token
are working.
from sqlserverpsmodule.
Thanks for confirming!
from sqlserverpsmodule.
... as a parent issue is marked as "closed", I shifted a description to a new issue
from sqlserverpsmodule.
Related Issues (20)
- Expose ObjectId parameter via Add-SqlLogin to create logins using ObjectId
- Data conversion error while writing table with Write-SqlTableData HOT 1
- Get-SqlDatabase and Invoke-Sqlcmd Piping HOT 2
- Backup-SqlDatabase File Splitting
- Method not found: 'Void Microsoft.Data.SqlClient.AlwaysEncrypted.AzureKeyVaultProvider.SqlColumnEncryptionAzureKeyVaultProvider HOT 7
- Read-/Write-SqlTableData not working with -AccessToken and managed-identity (Azure Function to work with Azure SQL DB) HOT 2
- Enclave enabled keys in a database without an enclave HOT 1
- Invoke-SqlAssessment - IndexFragmentation rule doesn't take partitions into consideration
- Using Invoke-SqlCmd in ForEach-Object -Parallel loop - not threadsafe? HOT 3
- Received parsing error for current version that I never received in 21.1.18256 HOT 3
- Invoke-Sqlcmd documentation incorrectly says -InputFile parameter disallows spaces HOT 3
- Adding module to azure automation runtime 7.2 fails with This module requires PowerShell 7.2.1+. Please, upgrade your PowerShell version by checking https://aka.ms/pscore6. HOT 9
- Invoke-Sqlcmd gets TypeInitializationException with 22.1.1 HOT 4
- Consider adding a new parameter -ServerCertificate where applicable
- Write-SqlTableData doesn't clear Write-Progress bar HOT 3
- Write-SqlTableData : A parameter cannot be found that matches parameter name 'TrustServerCertificate' HOT 2
- SQLRegistration does not work with SSMS 20.0 and SqlServer module 22.2.0 HOT 5
- Question: Version 22.2 Release Notes Aren't Yet Populated HOT 2
- Add-SqlLogin: DenyWindowsLogin: unknown property. HOT 3
- Set-SqlColumnEncryption: Login failed for user '' HOT 2
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from sqlserverpsmodule.