Deploying SQL package across ad domains

SteveVolpexSteveVolpex Posts: 3
edited February 10, 2014 10:19AM in Deployment Manager
Hi,

I am trying to deploy a sql package to a remote server on a ad different domain.

The Sql server is setup for SQL authentication and the deploy package as well.

I replaced the my username and domain with "domain\username" in the error log

The below error is generated when I do the deployment:
2014-02-07 12:57:27 +02:00 INFO Running DB Deploy plugin 0.0.2.1115 on package [CFSGServicePortal_Database\1.0.0.0]
2014-02-07 12:57:27 +02:00 INFO Configured with SQL Authentication, user name: sa (you can switch to Windows Authentication in the Environments menu, by editing the database server and setting "Authentication mode" to "Windows Authentication")
2014-02-07 12:57:30 +02:00 INFO The last deployment details were not found in the target database. Static upgrade is not available
2014-02-07 12:57:30 +02:00 INFO Upgrade script not available; performing dynamic database upgrade
2014-02-07 12:57:30 +02:00 INFO Loading source database from db\state
2014-02-07 12:57:30 +02:00 INFO - SOC filter file not detected at db\state\Filter.scpf; using default filter
2014-02-07 12:57:30 +02:00 INFO - Using default Compare options
2014-02-07 12:57:31 +02:00 INFO - Loading as case-insensitive (based on target database)
2014-02-07 12:57:31 +02:00 INFO Registering target database
2014-02-07 12:57:47 +02:00 INFO Registering scripts folder
2014-02-07 12:57:48 +02:00 INFO Comparing database schemas
2014-02-07 12:57:48 +02:00 INFO Building dynamic schema change script
2014-02-07 12:57:52 +02:00 INFO Comparing static data
2014-02-07 12:58:10 +02:00 INFO Building static data change script
2014-02-07 12:58:12 +02:00 INFO Running dynamic change script
2014-02-07 12:58:12 +02:00 INFO Saving generated upgrade script to C:\Windows\TEMP\2bbxu0gb.ars\Applications\CFSG -PROD\CFSGServicePortal_Database\1.0.0.0\upgradeScript.sql
2014-02-07 12:58:12 +02:00 INFO Executing SQL
2014-02-07 12:58:21 +02:00 ERROR Error while executing job: Dynamic deployment failed
2014-02-07 12:58:21 +02:00 ERROR Windows NT user or group 'domain\username' not found. Check the name again.
2014-02-07 12:58:21 +02:00 ERROR RedGate.Deploy.SqlServerDbPackage.Shared.Exceptions.InvalidSqlException: Dynamic deployment failed
2014-02-07 12:58:21 +02:00 ERROR Windows NT user or group 'domain\username' not found. Check the name again. ---> System.Data.SqlClient.SqlException: Windows NT user or group 'domain\username' not found. Check the name again.
2014-02-07 12:58:21 +02:00 ERROR at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
2014-02-07 12:58:21 +02:00 ERROR at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
2014-02-07 12:58:21 +02:00 ERROR at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
2014-02-07 12:58:21 +02:00 ERROR at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
2014-02-07 12:58:21 +02:00 ERROR at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite)
2014-02-07 12:58:21 +02:00 ERROR at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite)
2014-02-07 12:58:21 +02:00 ERROR at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
2014-02-07 12:58:21 +02:00 ERROR at RedGate.Shared.SQL.ExecutionBlock.BlockExecutor.ExecuteBlock(ExecutionBlock block, DbConnection connection)
2014-02-07 12:58:21 +02:00 ERROR at RedGate.Shared.SQL.ExecutionBlock.BlockExecutor.ExecuteBlock(ExecutionBlock block, String server, String database, Boolean integratedSecurity, String userName, String password)
2014-02-07 12:58:21 +02:00 ERROR at #3B7c.#dp4c.#u3.#4Pd()
2014-02-07 12:58:21 +02:00 ERROR at #0z7c.#bdE.#u3.#wp4c()
2014-02-07 12:58:21 +02:00 ERROR at #0z7c.#bdE.#up4c[#NrPb](Func`1 #kMk)
2014-02-07 12:58:21 +02:00 ERROR --- End of inner exception stack trace ---
2014-02-07 12:58:21 +02:00 ERROR at ##.#mj5c(IDeployLog , String , String , Action )
2014-02-07 12:58:21 +02:00 ERROR at ##.#1Gfd(#R21c )
2014-02-07 12:58:21 +02:00 ERROR at ##.#iz3c(String , #FG3c , #8gL , IDeployLog , #Ty3c , String )
2014-02-07 12:58:21 +02:00 ERROR at RedGate.Deploy.SqlServerDbPackage.AgentPlugin.DbPackageConvention.Apply(IConventionContext context)
2014-02-07 12:58:21 +02:00 ERROR at RedGate.Deploy.Agent.Deployment.Conventions.ConventionRunner.<>c__DisplayClassf.<ApplyConventions>b__e(IConvention convention)
2014-02-07 12:58:21 +02:00 ERROR at System.Collections.Generic.List`1.ForEach(Action`1 action)
2014-02-07 12:58:21 +02:00 ERROR at RedGate.Deploy.Agent.Deployment.Conventions.ConventionRunner.ApplyConventions(IConventionContext context)
2014-02-07 12:58:21 +02:00 ERROR at RedGate.Deploy.Agent.Deployment.DeploymentController.Execute(PackageMetadata package, IVariableDictionary variables, IFolderCollection folderCollection)
2014-02-07 12:58:21 +02:00 ERROR at RedGate.Deploy.Agent.Services.Jobs.DeployPackageJobExecutor.Execute(DeployPackageJob job)
2014-02-07 12:58:21 +02:00 ERROR at CallSite.Target(Closure , CallSite , Object , Object )
2014-02-07 12:58:21 +02:00 ERROR at System.Dynamic.UpdateDelegates.UpdateAndExecuteVoid2[T0,T1](CallSite site, T0 arg0, T1 arg1)
2014-02-07 12:58:21 +02:00 ERROR at RedGate.Deploy.Agent.Services.Jobs.JobRunner.ExecuteJob(IJob job, String& errorMessage, ILogScope additionalLogTarget)
2014-02-07 12:58:21 +02:00 ERROR Command RedGate.Deploy.Agent.Commands.SingleShotDeploymentCommand failed
2014-02-07 12:58:21 +02:00 ERROR RedGate.Deploy.Shared.Startup.CommandException: Dynamic deployment failed
2014-02-07 12:58:21 +02:00 ERROR Windows NT user or group 'domain\username' not found. Check the name again.
2014-02-07 12:58:21 +02:00 ERROR
2014-02-07 12:58:21 +02:00 ERROR Server stack trace:
2014-02-07 12:58:21 +02:00 ERROR at RedGate.Deploy.Agent.Commands.SingleShotDeploymentCommand.ExecuteInner()
2014-02-07 12:58:21 +02:00 ERROR at System.Threading.Tasks.Task.InnerInvoke()
2014-02-07 12:58:21 +02:00 ERROR at System.Threading.Tasks.Task.Execute()
2014-02-07 12:58:21 +02:00 ERROR
2014-02-07 12:58:21 +02:00 ERROR Exception rethrown at [0]:
2014-02-07 12:58:21 +02:00 ERROR at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
2014-02-07 12:58:21 +02:00 ERROR at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccess(Task task)
2014-02-07 12:58:21 +02:00 ERROR at RedGate.Deploy.Shared.Startup.CommandProcessor.<ProcessAsync>d__4.MoveNext()
· Share on Twitter

Comments

Sign In or Register to comment.