When I'm trying to debug a SQL CLR via a SQL Test script in VS2010 (with MSSQL 2008) I get "Canceled by user" in the Debug output window as soon the deployment finish (which is successful.)
I have been up and down the Internet and tried all found solutions and still no go.
System:
Windows Server 2008 R2 Standard SP 1
64 bit Visual Studio 2010
Ultimate SQL Server 2008 R2 (Both running on the same computer)
Steps taken:
- VS 2010 is run as administrator.
- SQL Connection User has sysadmin rights on SQL 2008
- Firewall is set up to allow inbound on the required ports for both VS 2010 and SQL 2008
Been through: http://msdn.microsoft.com/en-us/library/ms165051.aspx
And: http://msdn.microsoft.com/en-us/library/ee828498.aspx
Tried set set Target Framework to 2.0 (from 3.5)
Tried unchecked "Deploy code" in Project Properties under "Deploy" section.
Under Database in Project Properties is set to "Unsafe" and Assembly owner to "dbo".