Deploying SQL package across ad domains

Automated deployment for web applications and databases

Moderators: Mike Upton, justin.caldicott, Sean.newham, csmith, chirayu, DavidSimner, david.conlin

Deploying SQL package across ad domains

Postby SteveVolpex » Fri Feb 07, 2014 12:47 pm

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()
SteveVolpex
 
Posts: 2
Joined: Fri Feb 07, 2014 12:39 pm

Sorry made a mistake there was a problem in the SQL scripts.

Postby SteveVolpex » Fri Feb 07, 2014 2:54 pm

Sorry made a mistake there was a problem in the SQL scripts.
SteveVolpex
 
Posts: 2
Joined: Fri Feb 07, 2014 12:39 pm

Postby james.billings » Mon Feb 10, 2014 4:19 pm

No worries- is the problem resolved now?
james.billings
 
Posts: 1144
Joined: Wed Jun 16, 2010 11:10 am
Location: My desk.


Return to Deployment Manager

Who is online

Users browsing this forum: robin and 2 guests