Red Gate forums :: View topic - Deploying SQL package across ad domains
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
Deployment Manager
Deployment Manager forum

Deploying SQL package across ad domains

Search in Deployment Manager forum
Post new topic   Reply to topic
Jump to:  
Author Message
SteveVolpex



Joined: 07 Feb 2014
Posts: 2

PostPosted: Fri Feb 07, 2014 12:47 pm    Post subject: Deploying SQL package across ad domains Reply with quote

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:

Quote:

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()
Back to top
View user's profile Send private message
SteveVolpex



Joined: 07 Feb 2014
Posts: 2

PostPosted: Fri Feb 07, 2014 2:54 pm    Post subject: Sorry made a mistake there was a problem in the SQL scripts. Reply with quote

Sorry made a mistake there was a problem in the SQL scripts.
Back to top
View user's profile Send private message
james.billings



Joined: 16 Jun 2010
Posts: 1144
Location: My desk.

PostPosted: Mon Feb 10, 2014 4:19 pm    Post subject: Reply with quote

No worries- is the problem resolved now?
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group