Hi,
I get an error when I try to obliterate some deleted items.
From the server log:
----6/6/2007 10:54:47 AM admin--andyj(xxx.xxx.xxx.xxx)--SSL Disabled Vault Failed to establish a connection to the database.
----6/6/2007 10:54:47 AM admin--andyj(xxx.xxx.xxx.xxx)--SSL Disabled System.Data.SqlClient.SqlException: Login failed for user 'STA\MEDDEV$'.
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlInternalConnectionTds.CompleteLogin(Boolean enlistOK)
at System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance)
at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance)
at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection)
at System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options)
at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject)
at System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject)
at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject)
at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
at System.Data.SqlClient.SqlConnection.Open()
at VaultServiceSQL.VaultSqlConn.OpenConn()
at VaultServiceAPILib.VaultServiceAPISystem.GetOpenSqlConn(VaultSqlConn& conn) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlInternalConnectionTds.CompleteLogin(Boolean enlistOK)
at System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance)
at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance)
at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection)
at System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options)
at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject)
at System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject)
at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject)
at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
at System.Data.SqlClient.SqlConnection.Open()
at VaultServiceSQL.VaultSqlConn.OpenConn()
at VaultServiceAPILib.VaultServiceAPISystem.GetOpenSqlConn(VaultSqlConn& conn)
----6/6/2007 10:54:47 AM admin--andyj(xxx.xxx.xxx.xxx)--SSL Disabled Exception caught in obliterate worker thread, BeginObliterate(): Error in the application.
Error when obliterating
Moderator: SourceGear
We've never seen this before, so it would be very helpful if you can give us more information. We spawn a separate worker thread to perform the obliterate, and it's possible that it's getting the impersonation wrong for the worker thread.
What impersonation are you using? What method are you using to connect to the Vault DB. What do the DB security settings look like?
What impersonation are you using? What method are you using to connect to the Vault DB. What do the DB security settings look like?
I think that's what's happening, as I did notice sta\meddev$ (the machine account) trying to log into Sql Server, when I would expect sta\user.
Fortress is set to run under a domain account, which has permissions to access the server. The web.config has this line:
<identity impersonate="true" userName="sta\user" password="password" />
The connection string just uses integrated security:
<add key="ConnectString" value="Application Name='SourceGear Fortress'; Connection Reset='true'; Server=db_server; Database=sgvault; Integrated Security='true'" />
Let me know if you still need more info.
Fortress is set to run under a domain account, which has permissions to access the server. The web.config has this line:
<identity impersonate="true" userName="sta\user" password="password" />
The connection string just uses integrated security:
<add key="ConnectString" value="Application Name='SourceGear Fortress'; Connection Reset='true'; Server=db_server; Database=sgvault; Integrated Security='true'" />
Let me know if you still need more info.