I'm looking for inputs on PI AF and the use of CLR in MS SQL.
Our experience is we have so far met 2 DBAs at our customer sites that are not willing to enable CLR on their MSSQL database hotel (cluster), and espescially the UNSAFE option. This means I will not be able to use PI Webparts and PI OLEDB Enterprise.
Now, as it happens, I kinda want to use those products. So what are my options?
- SQL Express, sure but it has it's limitations and also the customer has a policy of no SQL express installs.
- Another SQL server machine(which is probably what we will end up doing, virtualized)
Other options I'm missing? Whish there was a PM for data access or something around here ;-) What are others doing? It cannot be the DBAs I'm talking to who are the only ones not willing to enable this? Seems to be not a good fit with large enterprises.