Workflow Soluiton

 View Only

  • 1.  Login failed for user 'domain\ServerName$'.

    Posted Nov 22, 2010 12:15 PM

    Hi

    I created a component that use a Query/Script Generator to pull information from the Altiris_Incidents database (Helpdesk 6).  When I run my project in debug mode everything is fine and I got the results displayed in my browser.

    I have some problems when I publish the project.   When I try to get the results with the component I get a an error message:

    Error Message:
    Login failed for user 'DomainName\WorkflowServerName$'.

    Message Stack:
    at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
    at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
    at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
    at System.Data.SqlClient.SqlInternalConnectionTds.CompleteLogin(Boolean enlistOK)
    at System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, Int64 timerExpire, SqlConnection owningObject)
    at System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(String host, String newPassword, Boolean redirectedUserInstance, SqlConnection owningObject, SqlConnectionString connectionOptions, Int64 timerStart)
    at System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance)
    at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance)
    at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection)
    at System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options)
    at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject)
    at System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject)
    at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject)
    at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
    at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
    at System.Data.SqlClient.SqlConnection.Open()
    at CCR_UpdateHRTickets_PhoneClosed.SqlQuery.CCR_UpdateHRTickets_PhoneClosed.Run(IData data)
    at LogicBase.Core.ExecutionEngine.SinglePathProcessComponentExecutionDelegate.Execute(IData data, IOrchestrationComponent comp, String& outputPath, IExecutionEngine engine, TLExecutionContext context) in c:\build\projects\WF7RC1B\core\LogicBase.Core\ExecutionEngine\ExecutionEngineDelegates.cs:line 236
    at LogicBase.Core.ExecutionEngine.AbstractExecutionEngine.DoRunComp(IOrchestrationComponent comp, IData data, TLExecutionContext context) in c:\build\projects\WF7RC1B\core\LogicBase.Core\ExecutionEngine\ExecutionEngineImplementation.cs:line 465

     

     

     

    My Ensemble database and the Altiris_Incidents database (helpdesk 6) are on separate servers

    I found a couple of posts mentionning that it was a security issue on the ensemble database.  I tried the solutions posted but still no luck.   Maybe I did something wrong.

    - I tried to create a new login for the Ensemble database named DomainName\WorkflowServerName$

    - I also tried to add that same user for the Altiris_Incidents database on the remote SQL server

    Nothing worked so far.   Anyone have an idea?

     

     

     

     



  • 2.  RE: Login failed for user 'domain\ServerName$'.
    Best Answer

    Posted Nov 23, 2010 08:34 AM

    You have 3 choices:

    - Either use SQL authentication instead of Windows authentication or

    - Make your workflow server COMPUTER/SERVER to be a member of the local administrators group on your SQL Server or

    - Change the Application Pool under which your IIS pages run to run under a domain account for which you grant a logon on your SQL server



  • 3.  RE: Login failed for user 'domain\ServerName$'.

    Posted Nov 23, 2010 11:17 AM

    Thanks PeeGee

    Option #2 worked for me.  Since I am still in testing phase I will use that method.   When I will move officially on a PROD server I might try to test options 1 and 3 just in case my server admin don't like the idea of having something new in the local adminsitrators group on the SQL server.

     

    Thanks again, you saved my day

     



  • 4.  RE: Login failed for user 'domain\ServerName$'.

    Posted Dec 23, 2010 10:34 AM

    I'm having this issue as well. how does one configure SQL authentication?