HTTP 401 User Unauthorized trying to fetch connection profile from NSAccess.aspx while attempting a Network Discovery

Products

• Altiris Network Discovery

Issue/Introduction

HTTP 401 User Unauthorized trying to fetch connection profile from NSAccess.aspx while attempting a Network Discovery.

When a Network Discovery Task is run, the following errors appear in the
log:
(Run Targeted Network Scan (Ping) (Restarted)) Discovery task failed:
System.ApplicationException during discovery run: 'Cannot load the
Connection
Profile specified for this task.'.

In IIS for the NSAccess.aspx we see multiple HTTP 401 errors.

For the page we disabled anonymous access, and when we did that we see this
error preceding the above:
[5/5] SQL connection failed, current user=DOMAIN\USER, total
time=00:00:05.0469416

Login failed for user 'DOMAIN\USER'.
   [System.Data.SqlClient.SqlException @ .Net SqlClient Data Provider]
   at
System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentit
y
identity, SqlConnectionString connectionOptions, SqlCredential credential,
Object providerInfo, String newPassword, SecureString newSecurePassword,
Boolean
redirectedUserInstance, SqlConnectionString userConnectionOptions,
SessionData
reconnectSessionData, DbConnectionPool pool, String accessToken, Boolean
applyTransientFaultHandling)
   at
System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOpti
ons
options, DbConnectionPoolKey poolKey, Object poolGroupProviderInfo,
DbConnectionPool pool, DbConnection owningConnection, DbConnectionOptions
userOptions)
   at
System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnec
tionPool
pool, DbConnection owningObject, DbConnectionOptions options,
DbConnectionPoolKey poolKey, DbConnectionOptions userOptions)
   at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection
owningObject, DbConnectionOptions userOptions, DbConnectionInternal
oldConnection)
   at
System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection
owningObject, DbConnectionOptions userOptions, DbConnectionInternal
oldConnection)
   at
System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection
owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean allowCreate,
Boolean
onlyOneCheckConnection, DbConnectionOptions userOptions,
DbConnectionInternal&
connection)
   at
System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection
owningObject, TaskCompletionSource`1 retry, DbConnectionOptions userOptions,
DbConnectionInternal& connection)
   at
System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection
owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions
userOptions,
DbConnectionInternal oldConnection, DbConnectionInternal& connection)
   at
System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbCo
nnection
outerConnection, DbConnectionFactory connectionFactory,
TaskCompletionSource`1
retry, DbConnectionOptions userOptions)
   at
System.Data.SqlClient.SqlConnection.TryOpenInner(TaskCompletionSource`1
retry)
   at System.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1
retry)
   at System.Data.SqlClient.SqlConnection.Open()
   at Altiris.NS.Utilities.DbUtils.TryCreateConnection(String costring,
Int32
retries, Int32 delay, Int32 add)

SQL Exception details: code=18456, line=65536

Exception logged from:
   at Altiris.NS.Utilities.DbUtils.TryCreateConnection(String, Int32, Int32,
Int32)
   at Altiris.NS.Utilities.DbUtils.CreateConnection(String, String, String,
String)
   at Altiris.NS.Utilities.DbUtils.CreateConnection(String)
   at Altiris.NS.ContextManagement.AdminDatabaseContext.OpenDbConnection()
   at Altiris.Database.DatabaseContext<T>.Initialize(Boolean,
System.Data.IsolationLevel)
   at
Altiris.Database.DatabaseContext<T>.CreateFirstContext(Altiris.Database.Cont
extTransactionMode,
System.Nullable<System.Data.IsolationLevel>,
Altiris.Database.DatabaseContextStack<T>, Boolean)
   at
Altiris.Database.DatabaseContext<T>.GetContextImpl(Altiris.Database.ContextT
ransactionMode,
System.Nullable<System.Data.IsolationLevel>, Boolean)
   at
Altiris.Database.DatabaseContext<T>.GetContext(Altiris.Database.ContextTrans
actionMode,
System.Nullable<System.Data.IsolationLevel>, Boolean)
   at
Altiris.NS.DataAccessLayer.Implementation.Altiris_NS_ItemManagement_DataAcce
ssLayerItemDataAccessLayer.spItemClassGetSingle(System.Guid)
   at Altiris.NS.ItemManagement.Item.GetItemInternal(System.Guid,
System.Collections.Generic.IEnumerable<System.Guid>,
Altiris.NS.ItemManagement.ItemLoadFlags, Boolean&)
   at Altiris.NS.ItemManagement.Item.GetItemInternal(System.Guid,
System.Collections.Generic.IEnumerable<System.Guid>,
Altiris.NS.ItemManagement.ItemLoadFlags)
   at
Altiris.PluggableProtocols.NSAccess.CPDataFetcher.GetModifiedTimeInTicks(Str
ing)
   at
Altiris.PluggableProtocols.NSAccess.CPDataFetcher..ctor(Altiris.PluggablePro
tocols.Properties)
   at
Altiris.PluggableProtocols.NSAccess.DBDA.GetData(Altiris.PluggableProtocols.
Properties)
   at .PPA.LocalDBDataAdapter.GetData(PPA.LocalDBDataAdapter*,
PPA.Properties*)

User [DOMAIN\USER], Auth [NT AUTHORITY\SYSTEM], AppDomain [AtrsHost.exe]

----------------------------------------------------------------------------
Name: SERVER, Size: 4.63 KB
Process: AtrsHost (3608), Thread ID: 123, Module: Altiris.NS.dll
Priority: 1, Source: DbUtils.CreateConnection

Cause

This is a known issue.

Environment

Network Discovery 8.1 RU6 or RU7

Resolution

A point-fix is available for this issue.

1. Download the attached archive to the Notification Server.
2. Extract the archived files to a location that is not within the install path for Altiris.
3. Log in to the Notification Server as the Application identity credentials.
4. Run PFInstaller2.exe and choose to Install.

NOTE: A backup folder will be created in the location of PFInstaller2.exe, allowing you to uninstall the PF if needed.