August 23, 2021 at 12:08 pm
I have a SQL Server 2019 instance with Polybase set up (Server A). I am using Polybase to select data from tables on another remote SQL Server instance running SQL 2012 (Server B)
Everything was working just fine up until this morning, when a number of SQL Agent jobs on Server A started failing; the error is:
Msg 7320, Level 16, State 110, Line 18
Cannot execute the query "Remote Query" against OLE DB provider "MSOLEDBSQL" for linked server "(null)". CREATE TABLE permission denied in database 'tempdb'.
Operation cancelled by user.
I'm also getting the same error from SSMS whenever I try to select from external tables.
As far as I know, nothing has changed on either server. The only thing I can see that may or may not be related is that Server A was restarted early Sunday morning, which would have dropped and recreated the tempdb database. Are there any Polybase related permissions on tempdb that may have been dropped when Server A was restarted?
Also, I'm still able to create new external objects on Server A, which suggests that the Polybase credentials are ok - I just can't select from the newly created object because of this error.
Any assistance would be appreciated!
August 23, 2021 at 2:16 pm
Fixed... no idea what caused it but restarting the 2019 instance has fixed it.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply