Just done a test on my EV8 SP1 system and when I create a plain user and give them the file server administrator rights I too get the same error message when trying to bring up the archivepoints GUI.
So currently my test user is just a basic domain user with no extra rights anywhere and everyone has F/C access to my file share that I am archiving from. I setup a DTRACE of the mmc process on the client and see the following as the issue:-
205 08:35:38.408 [480] (mmc) <800> EV-H {DirectoryDBAccess.GetOpenSqlConnection} Exception: Login failed for user 'BAUER\ftorres'. Info:DNS Alias: evsite.bauer.local Diag:Num:18456 State:1 Sev:14 Svr
:sql2005.bauer.local Proc: Line:65536 Type:System.Data.SqlClient.SqlException ST: 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 owningConnect
ion, 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 KVS.EnterpriseVault.Directory.DirectoryDBAccess.GetOpenSqlConnection(String dnsAlias)
206 08:35:38.408 [480] (mmc) <800> EV-M {DirectoryDBAccess.UnMapSQLServer} Unmap DNS Alias: evsite.
bauer.local
207 08:35:38.408 [480] (mmc) <800> EV-H {DirectorySP.GetTaskIdFromVolumeId} Exception: Login failedfor user 'BAUER\ftorres'. Info:GetTaskIdFromVolumeId, DNS Alias:evsite.bauer.local Diag:Num:18456 State:1 Sev:14 Svr:sql2005.bauer.local Proc: Line:65536 Type:System.Data.SqlClient.SqlException ST:
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 KVS.EnterpriseVault.Directory.DirectoryDBAccess.GetOpenSqlConnection(String dnsAlias)
at KVS.EnterpriseVault.Directory.DirectorySP.GetTaskIdFromVolumeId(String volumeEntryId)
208 08:35:38.423 [480] (mmc) <800> EV-L {FileServerManagementStub.KVS.EnterpriseVault.FileServerArchive.IFileServerManagement.IsAutoEnable} Exception: Login failed for user 'BAUER\ftorres'. Info: Diag:Num:18456 State:1 Sev:14 Svr:sql2005.bauer.local Proc: Line:65536 Type:System.Data.SqlClient.SqlException ST: 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 KVS.EnterpriseVault.Directory.DirectoryDBAccess.GetOpenSqlConnection(String dnsAlias)
at KVS.EnterpriseVault.Directory.DirectorySP.GetTaskIdFromVolumeId(String volumeEntryId)
at KVS.EnterpriseVault.FileServerArchive.FileServerManagementStub.KVS.EnterpriseVault.FileServerArchive.IFileServerManagement.IsAutoEnable(String volumeId, String folder)
So we are clearly having login problems to the SQL server
I then add the test user to the local administrators group of my vault server - No Change
I then add the test user to the local administrators group of my file server which also happens to be my SQL server - Now Works
I then take out the test user from the local admin group of my file server/sql server and I get the same error message again.
To rule out the fact that this may be because my user is a local admin of my sql server I created a file server and did the same test but it did not work
So the above tests led me to believe that this would only work if my user was a local administrator of my SQL server. When I did add my user again to the local administrators of my SQL server then both file servers archive points GUI would work, hence proving this.
This obviously should not be needed and believe that this is either a problem in the code or there is something somewhere else that can be done but that would need more investigation. You say you logged a case with us so I am sure that this is being looked into