Not able to deploy sql scripts to database server

Legacy Uncategorised
1

Hello,

I am trying to deploy sql scripts to DB server using the Powershell scripts as suggested.
While deploying I get the following error. It is not using my logged in users login context

2014-02-16 21:22:01.9798 INFO System.Data.SqlClient.SqlException (0x80131904): Login failed for user ‘NT AUTHORITY\ANONYMOUS LOGON’.
2014-02-16 21:22:01.9798 INFO at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action1 wrapCloseInAction) 2014-02-16 21:22:01.9954 INFO at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) 2014-02-16 21:22:01.9954 INFO at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) 2014-02-16 21:22:01.9954 INFO at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) 2014-02-16 21:22:02.0110 INFO at System.Data.SqlClient.SqlInternalConnectionTds.CompleteLogin(Boolean enlistOK) 2014-02-16 21:22:02.0110 INFO at System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, SecureString newSecurePassword, Boolean ignoreSniOpenTimeout, TimeoutTimer timeout, Boolean withFailover) 2014-02-16 21:22:02.0110 INFO at System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(ServerInfo serverInfo, String newPassword, SecureString newSecurePassword, Boolean redirectedUserInstance, SqlConnectionString connectionOptions, SqlCredential credential, TimeoutTimer timeout) 2014-02-16 21:22:02.0266 INFO at System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(TimeoutTimer timeout, SqlConnectionString connectionOptions, SqlCredential credential, String newPassword, SecureString newSecurePassword, Boolean redirectedUserInstance) 2014-02-16 21:22:02.0266 INFO at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, SqlCredential credential, Object providerInfo, String newPassword, SecureString newSecurePassword, Boolean redirectedUserInstance, SqlConnectionString userConnectionOptions) 2014-02-16 21:22:02.0266 INFO at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, DbConnectionPoolKey poolKey, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection, DbConnectionOptions userOptions) 2014-02-16 21:22:02.0266 INFO at System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnectionPool pool, DbConnectionOptions options, DbConnectionPoolKey poolKey, DbConnectionOptions userOptions) 2014-02-16 21:22:02.0422 INFO at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnectionOptions userOptions) 2014-02-16 21:22:02.0422 INFO at System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnectionOptions userOptions) 2014-02-16 21:22:02.0422 INFO at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean allowCreate, Boolean onlyOneCheckConnection, DbConnectionOptions userOptions, DbConnectionInternal& connection) 2014-02-16 21:22:02.0578 INFO at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, TaskCompletionSource1 retry, DbConnectionOptions userOptions, DbConnectionInternal& connection)
2014-02-16 21:22:02.0578 INFO at System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource1 retry, DbConnectionOptions userOptions, DbConnectionInternal& connection) 2014-02-16 21:22:02.0578 INFO at System.Data.ProviderBase.DbConnectionClosed.TryOpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource1 retry, DbConnectionOptions userOptions)
2014-02-16 21:22:02.0734 INFO at System.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource1 retry) 2014-02-16 21:22:02.0734 INFO at System.Data.SqlClient.SqlConnection.Open() 2014-02-16 21:22:02.0890 INFO at DbUp.Engine.Transactions.DatabaseConnectionManager.OperationStarting(IUpgradeLog upgradeLog, List1 executedScripts)
2014-02-16 21:22:02.0890 INFO at DbUp.Engine.UpgradeEngine.PerformUpgrade()
2014-02-16 21:22:02.0890 INFO ClientConnectionId:d931c976-c581-47d2-9e75-77dac41b86f4
2014-02-16 21:22:02.1046 FATAL Script ‘d:\Octopus\Applications\Development\Onvia.DB.Duncan\1.2.0.0_3\Deploy.ps1’ returned non-zero exit code: -1. Deployment terminated.
2014-02-16 21:22:02.1046 ERROR Error running conventions; running rollback conventions…

OctopusTentacle.txt (19 KB)

2

Hi Ajit,

Is the Tentacle service running as a domain user with rights to log on to the database? If not, reconfiguring Tentacle with those credentials should solve this.

If so, there’s possibly a connection string problem here.

Hope this helps.

Nick

3

Hi Nick,

It works. Thanks for reverting back. I changed the tentacle on DB server to run on my account instead of Local system. Redeployed it. it worked great.

I was just wondering, if i could the logged in user’context from Octopus server to tentacle and use it for deployment.

Thanks,
Ajit.