search

microsoft / bobsql

demos, scripts, samples, and code from the two bobs who work at Microsoft on SQL Server
MIT License
250 stars 145 forks source link

Polybase access to Azure SQL Database in SQL Server 2019 RTM problem #10

Closed ghotz closed 4 years ago

ghotz commented 4 years ago

I think there's a problem with the definition of an external data source from SQL Server 2019 RTM to Azure SQL Database that affect the demo in https://github.com/microsoft/bobsql/tree/master/demos/sqlserver/polybase/sqldatahub/azuredb

The problem is the one I opened with the documentation here: https://github.com/MicrosoftDocs/sql-docs/issues/3727

In short: it looks like unless you specify the database name in CONNECTION_OPTIONS when creating an external data source to Azure SQL Database with CREATE EXTERNAL DATA SOURCE, you get ODBC error Database is invalid or cannot be accessed.

I'm not changing the example scripts because it may be a regression in 2019 RTM...

rgward commented 4 years ago

Thanks for this report. I'll look into it

rgward commented 4 years ago

I don't see this problem even using the SQL Server 2019 RTM build. I used the exact same script as I have on GitHub and it works just fine. Can you post the details of the T-SQL script you used that failed?

rgward commented 4 years ago

I'm looking at this again because on a different server I got the same error you did

rgward commented 4 years ago

ok, my testing shows this problem is happening with SQL 2019 RTM but appears to be fixed in with our GDR servicing update. Can you apply this and see if the problem is fixed? https://support.microsoft.com/en-us/help/4517790/servicing-update-for-sql-server-2019-rtm

rgward commented 4 years ago

I confirmed there was a bug regression that is fixed in the GDR build. We are looking how best to document this.