Announcement

As of April 17, 2018, this site is now in read-only mode. To start new Blackbaud Developer’s discussions, you will find Developer Discussions in the Blackbaud CRM Community.

To post or respond to Blackbaud Community discussions, you will have to login using a www.blackbaud.com login. Learn how to login here. If you have questions or need assistance, please email community@blackbaud.com.

BBIS Troubleshooting – The user ‘NT AUTHORITY\NETWORK SERVICE’ is not an application user in the BBInfinity database

By: Joseph Styons

Posted on: February 4, 2013

Ok, today’s error is an easy one.  When clicking on “Sites & Settings” within BBIS, you may get this error:

 

The user ‘NT AUTHORITY\NETWORK SERVICE’ is not an application user in the BBInfinity database

 

image

If you get that, the solution is pretty easy.  Just add that user in CRM under Administration->Security->Application Users, as shown here:

image

image

 

The corresponding script would be this:

   1: declare @SID varbinary(85) = (select SUSER_SID('NT AUTHORITY\NETWORK SERVICE'));

   2: declare @changeagentid uniqueidentifier = null;

   3: exec USP_CHANGEAGENT_GETORCREATECHANGEAGENT @changeagentid output;

   4: declare @now datetime = getdate();

   5:

   6: --depending on your CRM version, EMAILADDRESS may need to be removed

   7: insert into APPUSER(ID,USERSID,DISPLAYNAME,ISSYSADMIN,ADDEDBYID,CHANGEDBYID,DATEADDED,DATECHANGED,CUSTOM_AUTHENTICATION_USERID,EMAILADDRESS)

   8: select NEWID(), @SID, 'NT AUTHORITY\NETWORK SERVICE', 1, @CHANGEAGENTID, @CHANGEAGENTID,@now,@now,'','';

 

Remember that BBIS runs through whatever application pool you’ve assigned to it.

Everything that BBIS done, is done in the name of the user assigned to that app pool.

So if BBIS tries to access, say, a Datalist (as is the case here, if you look at the ASP.NET call stack pictured above), then CRM is going to perceive that as some weirdo named “nt authority\network service” making the request.

 

You can control the user that BBIS runs under.  To do that, follow these steps:

 

1 – Open IIS

2 – Find your Site under “Sites”.  Click “Basic Settings” and make a note of the Application Pool. (The default is “NetCommunity”)

image

3 – Now browse up to “Application Pools”, and find the one you noted in step 2.

The Identity of the app pool is the user we are talking about here.

 

image

 

Don’t forget to consult your physician before making any changes on a production box.

 

Oh and yes, here’s the obligatory link to the handbook.

Leave a Reply

Privacy Policy | Sitemap | © 2011 Blackbaud, Inc. All Rights Reserved

Digital Ocean