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
This is a known issue.
Network Discovery 8.1 RU6 or RU7
A point-fix is available for this issue.
NOTE: A backup folder will be created in the location of PFInstaller2.exe, allowing you to uninstall the PF if needed.