Support,
I am changing all of my connection strings to use Windows Authentication to connect and update the database during our deployment. However, I keep getting the following error when the deployment runs:
===========================================================================================
Connection String: < Server=XXXXXXX;Database=XXXXXXX;Trusted_Connection=yes;>
Migrate Path: C:\Octopus\Applications\Development\UniRush.Prepaid.Database\0.0.5556.39213_1\migrate.exe
Working Dir: C:\Octopus\Applications\Development\UniRush.Prepaid.Database\0.0.5556.39213_1
Info 22:49:32
VERBOSE: Target database is: ‘Prepaid’ (DataSource: sqldev, Provider: System.Data.SqlClient, Origin: Explicit).
System.Data.SqlClient.SqlException (0x80131904): Login failed. The login is from an untrusted domain and cannot be used with Windows authentication.
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, TaskCompletionSource1 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, TaskCompletionSource1 retry, DbConnectionOptions userOptions) at System.Data.SqlClient.SqlConnection.TryOpenInner(TaskCompletionSource
1 retry)
at System.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource1 retry) at System.Data.SqlClient.SqlConnection.Open() at System.Data.Entity.Infrastructure.Interception.InternalDispatcher
1.Dispatch[TTarget,TInterceptionContext](TTarget target, Action2 operation, TInterceptionContext interceptionContext, Action
3 executing, Action3 executed) at System.Data.Entity.Infrastructure.Interception.DbConnectionDispatcher.Open(DbConnection connection, DbInterceptionContext interceptionContext) at System.Data.Entity.SqlServer.SqlProviderServices.<>c__DisplayClass33.<UsingConnection>b__32() at System.Data.Entity.SqlServer.DefaultSqlExecutionStrategy.<>c__DisplayClass1.<Execute>b__0() at System.Data.Entity.SqlServer.DefaultSqlExecutionStrategy.Execute[TResult](Func
1 operation)
at System.Data.Entity.SqlServer.SqlProviderServices.UsingMasterConnection(DbConnection sqlConnection, Action1 act) at System.Data.Entity.SqlServer.SqlProviderServices.DbCreateDatabase(DbConnection connection, Nullable
1 commandTimeout, StoreItemCollection storeItemCollection)
at System.Data.Entity.Migrations.Utilities.DatabaseCreator.Create(DbConnection connection)
at System.Data.Entity.Migrations.DbMigrator.EnsureDatabaseExists(Action mustSucceedToKeepDatabase)
at System.AppDomain.DoCallBack(CrossAppDomainDelegate callBackDelegate)
at System.Data.Entity.Migrations.Console.Program.Run()
at System.Data.Entity.Migrations.Console.Program.Main(String[] args)
ClientConnectionId:c2ec2e11-3689-430e-ade1-eb82a65b96ff
ERROR: Login failed. The login is from an untrusted domain and cannot be used with Windows authentication.
Fatal 22:49:32
PowerShell script returned a non-zero exit code: 1
Tentacle version 2.6.4.951
===========================================================================================
I have setup the tentacle service to run under a domain account that has the proper permissions on the sql server and from the look of it, it doesn’t even look like the tentacle is running under the domain user context. If I run the service as Local System, I get the same error. Is there something special that I need to do to enable the service to run under the context of the service account? I’'ve been pulling my hair out for hours, so I figured this was my next step.
Thank you!
Ryan Helms
RushCard