Unable to log in and connect to a database

Question

Hi Eugene,

My team is planning to use the Team version and has just installed SQL server + TBM. However, the following error was encountered:

Can't connect to a database, please check connection string. Exception details: 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): Cannot open database "TBM" requested by the login. The login failed. Login failed for user 'IIS APPPOOL\TBM'. at Microsoft.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, UInt32 waitForMultipleObject...

Do you have any suggestion?

I used .\SQLExpress - simillar to another user who asked you in previous thread. Thank you in advance

Eugene Kuchynski · Answer

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!

Trados Business Manager > 00 - Licensing and Installation

Unable to log in and connect to a database