I’m regularly running into the “Cannot open server 'sql-instances-prod' requested by the login. Client with IP address '184.108.40.206' is not allowed to access the server.” error message, especially during overnight executions by the execution scheduler.
But I can’t replicate the connection issue, i.e. it seems to be intermittent:
Has anybody else encountered this issue and do you know what would be causing it / what the workaround might be?
Best answer by Søren SørensenView original