I am configuring SCCM 2012 for the first time.  All discovery methods work fine, however no boundaries are populated.  I can get a machine to PXE boot and begin the task sequence but fails with message  '...cannot be located on a distribution point'.  I assume that is because there are no boundaries.   When trying to create one manually, I get the error below.  Doesn't matter what type of boundary I try to add, they all come back with the same error.  Any ideas?

I am running Server 2008R2 w/sp1,  SQL server 2008R2 (no CU's), SCCM 2012 (not sp1).  I have SCCM 2007 running,  ifferent site code, both as stand alone.  I am not planning on migrating any settings, wanting to start fresh.   Could that be related?  

ConfigMgr Error Object:
instance of SMS_ExtendedStatus
{
CauseInfo = "";
Description = "SQL command failed: insert into vSMS_Boundary (BoundaryFlags, BoundaryType, DisplayName, Value, CreatedBy, CreatedOn, ModifiedBy, ModifiedOn) values (0, 1, N'Primary Boundary', N'Default-First-Site-Name', N'accountname', N'06/26/2013 18:36:20', N'accountname', N'06/26/2013 18:36:20')\n;\n select scope_identity()";
ErrorCode = 2168851714;
File = "e:\\nts_sccm_release\\sms\\siteserver\\sdk_provider\\smsprov\\ssputility.cpp";
Line = 2123;
ObjectInfo = "Please check SMS Provider log file for details of the SQL errors";
Operation = "PutInstance";
ParameterInfo = "";
ProviderName = "ExtnProv";
SQLMessage = "[42000][524][Microsoft][SQL Server Native Client 10.0][SQL Server]A trigger returned a resultset and the server option 'disallow results from triggers' is true. : vSMS_Boundary_iu";
SQLSeverity = 16;
SQLStatus = 524;
StatusCode = 2147749889;
};

-------------------------------
Microsoft.ConfigurationManagement.ManagementProvider.WqlQueryEngine.WqlQueryException
The SMS Provider reported an error.


Stack Trace:
   at Microsoft.ConfigurationManagement.ManagementProvider.WqlQueryEngine.WqlResultObject.Put(ReportProgress progressReport)
   at Microsoft.ConfigurationManagement.ManagementProvider.WqlQueryEngine.WqlResultObject.Put()
   at Microsoft.ConfigurationManagement.AdminConsole.SmsDialogData.Put(Boolean retainLock)
   at Microsoft.ConfigurationManagement.AdminConsole.DialogFramework.Forms.SmsPropertySheet.Put(ActionTrigger trigger)

-------------------------------

System.Management.ManagementException
Generic failure 


Stack Trace:
   at Microsoft.ConfigurationManagement.ManagementProvider.WqlQueryEngine.WqlResultObject.Put(ReportProgress progressReport)
   at Microsoft.ConfigurationManagement.ManagementProvider.WqlQueryEngine.WqlResultObject.Put()
   at Microsoft.ConfigurationManagement.AdminConsole.SmsDialogData.Put(Boolean retainLock)
   at Microsoft.ConfigurationManagement.AdminConsole.DialogFramework.Forms.SmsPropertySheet.Put(ActionTrigger trigger)

-------------------------------

Hi To start with check SMSPROV.log for errors. Regards, Manohar Pusala

The error is the same as what I included originally: A trigger returned a resultset and the server option 'disallow results from triggers' is true

If my reading is correct, isn't this a required setting in SQL 2012? 

*** insert into vSMS_Boundary (BoundaryFlags, BoundaryType, DisplayName, Value, CreatedBy, CreatedOn, ModifiedBy, ModifiedOn) values (0, 1, N'Primary Boundary', N'Default-First-Site-Name', N'accountname', N'06/27/2013 15:15:11', N'accountname', N'06/27/2013 15:15:11')~;~ select scope_identity() SMS Provider 1/1/1601 12:00:00 AM 1556 (0x0614)
*** [42000][524][Microsoft][SQL Server Native Client 10.0][SQL Server]A trigger returned a resultset and the server option 'disallow results from triggers' is true. : vSMS_Boundary_iu SMS Provider 1/1/1601 12:00:00 AM 1556 (0x0614)
*~*~[42000][524][Microsoft][SQL Server Native Client 10.0][SQL Server]A trigger returned a resultset and the server option 'disallow results from triggers' is true. : vSMS_Boundary_iu     ThreadID : 1556 , DbError: 524 , Sev: 16~*~* SMS Provider 1/1/1601 12:00:00 AM 1556 (0x0614)
*~*~e:\nts_sccm_release\sms\siteserver\sdk_provider\smsprov\ssputility.cpp(2123) : SQL command failed: insert into vSMS_Boundary (BoundaryFlags, BoundaryType, DisplayName, Value, CreatedBy, CreatedOn, ModifiedBy, ModifiedOn) values (0, 1, N'Primary Boundary', N'Default-First-Site-Name', N'accountname', N'06/27/2013 15:15:11', N'accountname', N'06/27/2013 15:15:11')~;~ select scope_identity()~ SQL Error: [42000][524][Microsoft][SQL Server Native Client 10.0][SQL Server]A trigger returned a resultset and the server option 'disallow results from triggers' is true. : vSMS_Boundary_iu~*~* SMS Provider 1/1/1601 12:00:00 AM 1556 (0x0614)
*~*~SQL command failed: insert into vSMS_Boundary (BoundaryFlags, BoundaryType, DisplayName, Value, CreatedBy, CreatedOn, ModifiedBy, ModifiedOn) values (0, 1, N'Primary Boundary', N'Default-First-Site-Name', N'accountname', N'06/27/2013 15:15:11', N'accountname', N'06/27/2013 15:15:11')~;~ select scope_identity() [42000][524][Microsoft][SQL Server Native Client 10.0][SQL Server]A trigger returned a resultset and the server option 'disallow results from triggers' is true. : vSMS_Boundary_iu~*~* SMS Provider 1/1/1601 12:00:00 AM 1556 (0x0614)
ERROR: SQL command failed: insert into vSMS_Boundary (BoundaryFlags, BoundaryType, DisplayName, Value, CreatedBy, CreatedOn, ModifiedBy, ModifiedOn) values (0, 1, N'Primary Boundary', N'Default-First-Site-Name', N'accountname', N'06/27/2013 15:15:11', N'accountname', N'06/27/2013 15:15:11')~;~ select scope_identity() SMS Provider 1/1/1601 12:00:00 AM 1556 (0x0614)
CExtUserContext::LeaveThread : Releasing IWbemContextPtr=73203232 SMS Provider 1/1/1601 12:00:00 AM 1556 (0x0614)

>I am running...SQL server 2008R2 (no CU's)

For SQL Server 2008 R2, SCCM 2012 requires you to be running SP1 CU6 or SP2.

http://technet.microsoft.com/en-us/library/gg682077.aspx#BKMK_SupConfigSQLDBconfig

I apologize for leaving it out.  We are running SQL 2008R2 Standard w/sp2.

Please check if Trustworthy is set to ON, you can do this by going in SQL Server Management Studio > Right click the ConfigMgr database> go to options> under Miscellaneous make sure that TRUSTWORTHY is set to True

You can turn TRUSTWORTHY on by running:

ALTER DATABASE <DB_NAME> SET TRUSTWORTHY ON 

When the database is not configured with this setting ON, <ConfigMgr_Install>\bin\x64\CryptoUtility.dll fails to load into SQL and you get these type of errors in the SMS Provider

http://technet.microsoft.com/en-us/library/ms187861(v=sql.105).aspx

We have verified that trustworthy is set to 'on'.  Thanks for the suggestion.

Same problem here, seems to be a bug in SCCM 2012 SP1 CU2.

Issue occurs when creating a boundary based on a ip adress range. Ip adress subnets work fine.

Same problem here, seems to be a bug in SCCM 2012 SP1 CU2.

No. Just created a boundary based on an IP range and it did work without any issues at all.

Interesting. We are running SQL 2012 on Windows server 2008 r2, and you?

I can confirm I am also experiencing this issue,

I am running SCCM 2012 SP1 (5.0.7804.1000) on Server 2008 R2 SP1, but I am not running CU2.

However I just applied CU4 to SQL Server 2012 SP1 on Server 2008 R2 SP1 and the problem appears to have occurred after this update.

I have a number of existing boundary groups utilizing IP address range but I can't add new IP address range groups, I get the same SQL errors as above.

We are running SQL 2012 on Windows server 2008 r2, and you?

SQL 2012 on server 2012.

This issue has been caused for us by installing some .NET 4 security updates.

The updates in question are KB2835393 KB280457 and KB2840628 (2008R2)

I removed those 3 updates from my SCCM box, it didn't resolve the problem, but after also removing from my SQL box the issue is resolved. I can now add boundary groups again and a number of other SQL/SCCM issues have also disappeared.

Cheers guy