Automation Account error - when Try to call stored procedure from Automation account getting error:
Traceback (most recent call last): File "/usr/src/tmp/8643d647-6858-4b74-88c5-96b2e28a66f4/runbooks/Dravosa.py", line 30, in <module> cursor = source_engine.raw_connection().cursor() File "C:\userenv\lib\site-packages\sqlalchemy\engine\base.py", line 3300, in raw_connection return self.pool.connect() File "C:\userenv\lib\site-packages\sqlalchemy\pool\base.py", line 449, in connect return _ConnectionFairy._checkout(self) File "C:\userenv\lib\site-packages\sqlalchemy\pool\base.py", line 1263, in _checkout fairy = _ConnectionRecord.checkout(pool) File "C:\userenv\lib\site-packages\sqlalchemy\pool\base.py", line 712, in checkout rec = pool._do_get() File "C:\userenv\lib\site-packages\sqlalchemy\pool\impl.py", line 180, in _do_get self._dec_overflow() File "C:\userenv\lib\site-packages\sqlalchemy\util\langhelpers.py", line 146, in exit raise exc_value.with_traceback(exc_tb) File "C:\userenv\lib\site-packages\sqlalchemy\pool\impl.py", line 177, in _do_get return self._create_connection() File "C:\userenv\lib\site-packages\sqlalchemy\pool\base.py", line 390, in _create_connection return _ConnectionRecord(self) File "C:\userenv\lib\site-packages\sqlalchemy\pool\base.py", line 674, in init self.__connect() File "C:\userenv\lib\site-packages\sqlalchemy\pool\base.py", line 901, in __connect pool.logger.debug("Error on connect(): %s", e) File "C:\userenv\lib\site-packages\sqlalchemy\util\langhelpers.py", line 146, in exit raise exc_value.with_traceback(exc_tb) File "C:\userenv\lib\site-packages\sqlalchemy\pool\base.py", line 896, in __connect self.dbapi_connection = connection = pool._invoke_creator(self) File "C:\userenv\lib\site-packages\sqlalchemy\engine\create.py", line 643, in connect return dialect.connect(*cargs, **cparams) File "C:\userenv\lib\site-packages\sqlalchemy\engine\default.py", line 620, in connect return self.loaded_dbapi.connect(*cargs, **cparams) pyodbc.InterfaceError: ('IM002', '[IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified (0) (SQLDriverConnect)')