IT Monkey:   


Formal Cireson Support (phone, email, and web) is not included with the free Self-Service Portal – Community app. For trouble shooting assistance, take advantage of the Cireson Community to find answers to your questions. However, if you’d like to purchase a Support Package to access more formal Cireson Support (phone, email, and web), please contact us today to learn more on the pricing options.

Can not access Self Serv Portal

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 ✭
    Accepted 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 ✭
    Accepted 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.