How to run a Microsoft SQL Server query in Read Only mode in Alteryx

ivoiculescu2020

Hello team,

I hope you're all doing well.

I configured the connection to a database in Microsoft SQL Server in Alteryx and I tried running a query. I was warned to run it in Read Only mode because it blocks the database.

When I connect to MSS, I select Read Only mode; how do I do this in Alteryx?

Thank you!

Kind regards,

Ioana

Reporting

Server

Accepted answers

alexnajm

This will likely be set up in the ODBC configuration itself: https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/How-to-setup-ReadOnly-Connection-for-a-particular-database/td-p/995907

All comments

alexnajm

ivoiculescu2020

@alexnajm

Hello,

Thank you so much for your prompt help.

I tried following the steps in the KB you sent me but unfortunately I don't have admin rights on my computer and so it does not give me access to the config settings showed in the KB.

any other thoughts?

Kind regards,

Ioana

alexnajm

No other thoughts on my end - anything related to ODBC configurations will be an ODBC issue, not an Alteryx issue!

Quick Links

This months top contributors

AkimasaKajitani 387

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335