Børre Heggernes

PI AF, CLR and SQL servers in enterprises

Discussion created by Børre Heggernes on Oct 28, 2010
Latest reply on Nov 11, 2010 by spilon

Hi there,


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?

  1. SQL Express, sure but it has it's limitations and also the customer has a policy of no SQL express installs.
  2. 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.