Home› Self-Service Portal - Community

Can not access Self Serv Portal

CláudioCláudio Member IT Monkey ✭
in Self-Service Portal - Community
Hi folks,

After trying to access the portal I receive this error:


2018-06-14 11:39:51,281, ERROR [   5]:  Error accessing SQL Database: Server=PSVC02\SCSM;Database=ServiceManagerCireson;Trusted_Connection=True; Error: System.Data.SqlClient.SqlException (0x80131904): Cannot open database "ServiceManagerCireson" requested by the login. The login failed.
Login failed for user 'SOF\SCSM_Portal_CB'.
   at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity 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(DbConnectionOptions options, DbConnectionPoolKey poolKey, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection, DbConnectionOptions userOptions)
   at System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnectionPool 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(DbConnection 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 Cireson.CacheBuilder.Service.Util.ServiceManagerUtil.<Read>d__5`1.MoveNext()
ClientConnectionId:559d5895-cca7-4c6f-8eec-c5d4913326f0
Error Number:4060,State:1,Class:11


Best Answer

  • CláudioCláudio Member IT Monkey ✭
    Answer ✓
    OOps

    2018-06-14 15:37:55,859, ERROR [  10]:  Error accessing SQL Database: Server=PSVC02\SCSM;Database=ServiceManagement;Trusted_Connection=True; Error: System.Data.SqlClient.SqlException (0x80131904): Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.
       at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity 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(DbConnectionOptions options, DbConnectionPoolKey poolKey, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection, DbConnectionOptions userOptions)
       at System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnectionPool 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(DbConnection 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 Cireson.ServiceManager.DAL.Database.OpenConnection(String context)
    ClientConnectionId:1a659a7b-8b9d-4129-9622-4a092620d3e0
    Error Number:18456,State:1,Class:14
    2018-06-14 15:37:55,869, ERROR [  10]:  OpenStoredProcedureCommand caused an exception.
    2018-06-14 15:37:55,872, ERROR [  10]:  Native Error : Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.

Answers

  • CláudioCláudio Member IT Monkey ✭
    SQL Permission for SOF\SCSM_Portal_CB
  • Brian_WiestBrian_Wiest Customer Super IT Monkey ✭✭✭✭✭
    Is that account locked out?
    Can you open the DB with another account?
    Is the database in a cluster where it has failed over?
  • CláudioCláudio Member IT Monkey ✭
    Hi Brian_Wiest

    Is that account locked out?
    No

    Can you open the DB with another account?
    Yes, including remote network access from another computer.

    Is the database in a cluster where it has failed over?
    The database is in a fail over cluster.
  • Brian_WiestBrian_Wiest Customer Super IT Monkey ✭✭✭✭✭
    So is PSVC02\SCSM the cluster name or a specific server name?
    Did you install the Cireson portal pointed to the cluster name or specific server name?

    Could be something very similar to 
    https://community.cireson.com/discussion/3845/problem-installation-always-on-with-cireson-system-center-service-manager-portal
  • CláudioCláudio Member IT Monkey ✭
    Hi Brian,

    PSVC02\SCSM  = servername\instancename
  • Brian_WiestBrian_Wiest Customer Super IT Monkey ✭✭✭✭✭
    Has it worked ever?
    Have you tried to failed over?
  • CláudioCláudio Member IT Monkey ✭
    Access was pointing to the wrong database. Does not exist
    the ServiceManagerCireson database, but ServiceManagementCireson. After reinstalling the new error happened to be:

    2018-06-14 15:11:22,858, ERROR [   1]:  Unable to retrieve Affected User license info: An object of class ManagementPackClass with ID 4e2ef5f4-7f46-8796-1059-93a836016275 was not found.
    2018-06-14 15:11:23,013, ERROR [   1]:  Unable to validate license. Error: No license found.
    2018-06-14 15:11:23,013, ERROR [   1]:  Unable to validate license. Error: No license found.
    2018-06-14 15:11:23,013, ERROR [   1]:  Unable to validate license. Error: No license found.
    2018-06-14 15:11:23,029, ERROR [   1]:  Unable to validate license. Error: No license found.
  • CláudioCláudio Member IT Monkey ✭
    Answer ✓
    OOps

    2018-06-14 15:37:55,859, ERROR [  10]:  Error accessing SQL Database: Server=PSVC02\SCSM;Database=ServiceManagement;Trusted_Connection=True; Error: System.Data.SqlClient.SqlException (0x80131904): Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.
       at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity 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(DbConnectionOptions options, DbConnectionPoolKey poolKey, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection, DbConnectionOptions userOptions)
       at System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnectionPool 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(DbConnection 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 Cireson.ServiceManager.DAL.Database.OpenConnection(String context)
    ClientConnectionId:1a659a7b-8b9d-4129-9622-4a092620d3e0
    Error Number:18456,State:1,Class:14
    2018-06-14 15:37:55,869, ERROR [  10]:  OpenStoredProcedureCommand caused an exception.
    2018-06-14 15:37:55,872, ERROR [  10]:  Native Error : Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.
Sign In or Register to comment.