CLR Integration and SQL Express XCOPY deployment hell
-
I originally developed my application using SQL 2005 Developer Edition, but want to switch to using an XCOPY deployed DB on SQL Express for deployement. I have successfully copied the database.mdf/ldf files over to me project, and can connect using Data Source=.\SQLExpress and AttachDbFilename=|DataDirectory|\[database].mdf attributes. The question is, how do I enable CLR integration for my C# SP's? I've tried executing the following in various places: sp_configure 'clr enabled', 1 go reconfigure go But I obviously haven't hit the spot because I'm getting the following error when VS deploys my SP library: Error: starting database upload transaction failed. Error: Access is denied. (Exception from HRESULT: 0x80070005 (E_ACCESSDENIED)) Any ideas?