Hello, Mike,

Nice to hear that (about plans)!

As for the error, this one is more clear that in neighbor thread, because in your case error message says that server is found, but application pool can't connect to it due to access rights of the IIS APPPOOL\TBM user. You have 2 choices: find a way to grant this user access to SQL server (I can't give instructions, it's better to find it in somewhere in Internet or SQL Server manual), or open advanced settings of the application pool, and change identity to Administrator (at least for example, to check that it works, and then you can change it to other user with fewer rights).

This is also mentioned in the step 3 here:

https://community.rws.com/product-groups/trados-portfolio/business-manager/w/wiki/5101/installing-sdl-trados-business-manager-team-enterprise

Hope it helps!

Hi Eugene,

I changed identity to Administrator sucessfully, then when I tried to log in, the error looks exactly the same as that in the neighbor thread.

Database update in process. Please wait...
Please, wait when the operation completes. DO NOT refresh this page.
Error
Error during update:
Unable to open database. Connection string: 'Data Source=.\SQLExpress;Initial Catalog=TBM;Integrated Security=True;Connect Timeout=30;Encrypt=False;TrustServerCertificate=true;MultiSubnetFailover=False;'; Error: 'Microsoft.Data.SqlClient.SqlException (0x80131904): A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SNI_PN11, error: 26 - Error Locating Server/Instance Specified) at Microsoft.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at Microsoft.Data.SqlClient.TdsParser.Connect(ServerInfo serverInfo, SqlInternalConnectionTds connHandler, Boolean ignoreSniOpenTimeout, Int64 timerExpire, Boolean encrypt, Boolean trustServerCert, Boolean integratedSecurity, Boolean withFailover, SqlAuthenticationMethod authType) at Microsoft.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, SecureString newSecurePassword, Boolean ignoreSniOpenTimeout, TimeoutTimer timeout, Boolean withFailover) at Microsoft.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(ServerInfo serverInfo, String newPassword, SecureString newSecurePassword, Boolean redirectedUserInstance, SqlConnectionString connectionOptions, SqlCredential credential, TimeoutTimer timeout) at Microsoft.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(TimeoutTimer timeout, SqlConnectionString connectionOptions, SqlCredential credential, String newPassword, SecureString newSecurePassword, Boolean redirectedUserInstance) at Microsoft.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, SqlCredential credential, Object providerInfo, String newPassword, SecureString newSecurePassword, Boolean redirectedUserInstance, SqlConnectionString userConnectionOptions, SessionData reconnectSessionData, Boolean applyTransientFaultHandling, String accessToken, DbConnectionPool pool) at Microsoft.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, DbConnectionPoolKey poolKey, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection, DbConnectionOptions userOptions) at Microsoft.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup, DbConnectionOptions userOptions) at Microsoft.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection)
at Microsoft.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions) at Microsoft.Data.ProviderBase.DbConnectionClosed.TryOpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions) at Microsoft.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry, SqlConnectionOverrides overrides) at Microsoft.Data.SqlClient.SqlConnection.Open(SqlConnectionOverrides overrides) at Microsoft.Data.SqlClient.SqlConnection.Open() at DevExpress.Xpo.DB.MSSqlConnectionProvider.CreateDataBase(IDbConnection conn) ClientConnectionId:xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx Error Number:-1,State:0,Class:20'

What should I do now? I wonder if it is possible for you to use Teamviewer/Ultraviewer to help me remotely because I'm not a tech savvy. Thank you!

Hi Mike,

I think it's better to use forums, as current questions are not about TBM, but about server/database, which is not related to TBM (of course related, but it's not TBM itself). And since I'm developer, not system admin, I can only try to give advises, but not work on a server to avoid any security-related issues. We have special team for such things (and if nothing helps, we'll try to ask for additional help).

So,

Mike Nguyen said:

A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections.

says that provided server (.\SQLExpress) is not visible. You can try to put computer name instead of dot, and please check that installed SQL Server instance is indeed named SQLExpress. For example, in the mentioned neighbor thread instance name is MSSQLSERVER. I'm sure it must start working if you try to make this change in the connection string!

Hi Mike,

I think it's better to use forums, as current questions are not about TBM, but about server/database, which is not related to TBM (of course related, but it's not TBM itself). And since I'm developer, not system admin, I can only try to give advises, but not work on a server to avoid any security-related issues. We have special team for such things (and if nothing helps, we'll try to ask for additional help).

So,

Mike Nguyen said:

A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections.

says that provided server (.\SQLExpress) is not visible. You can try to put computer name instead of dot, and please check that installed SQL Server instance is indeed named SQLExpress. For example, in the mentioned neighbor thread instance name is MSSQLSERVER. I'm sure it must start working if you try to make this change in the connection string!

Hi Eugene,

Sorry for the late reply. I ordered TBM (Team version) and the local reseller helped me fixe this issue. Now here it comes a small query: I could not find the batch user creation button in the Vendor section (as shown in your tutorial video on Youtube). Did I miss something?

Hi Mike,

No problem, I also reply with delays pretty frequently.

As for batch user creation, we only have this functionality under RWS button (3rd from end), it allows to quickly import vendors from LC or GS. Or you mean something different?

Hi, in the tutorial video on Youtube, I found this button - Batch create users

When being clicked on, the following window pops up, allowing batch user creation functionality:

The Youtube link is https://www.youtube.com/watch?v=LudAIzkULRA&t=665s

I hope it clearly illustrates my point.

Hi Mike, the only reason I can suggest why you can't see this button is that you're using older version, where this functionality is not yet impleneted, Could it be?

I don't think so, because I'm pretty sure that I'm using the latest version 6.1.64 while the Youtube video's TBM version is lower/outdated (Still it has this functionality). Or do you mean this functionality is only for users with associated Trados Live/Groupshare accounts? This normal yet time-saving feature should be made available to normal users imo.

Hi Mike,

That's very strange. If you see Archive and Test pieces buttons, Create users button should also be visible. There is no any login in the applicaiton which hides this button. I also checked different working TBM instances, and this button exists in all of them.

Can you please hove mouse pointer over i icon in the bottom left corner to be sure which version you are running?  

Hi Eugene,

You're right! I've updated the TBM and now I can find some more features/buttons, including "batch create users". Thank you for your great support!