Legal
Recommended Products
-
CoCounsel
Move faster and accomplish more with a professional-grade, generative AI assistant that transforms the way you work. Thomson Reuters CoCounsel is with you every step of the way, backed by authoritative content and industry-leading expertise.
-
Westlaw
Conduct legal research efficiently and confidently using trusted content, proprietary editorial enhancements, and advanced technology.
-
Practical Law
Accelerate how you find answers with powerful generative AI capabilities and the expertise of 650+ attorney editors. With Practical Law, access thousands of expertly maintained how-to guides, templates, checklists, and more across all major practice areas.
Questions? We are here to help
Tax & Accounting
-
Top products for corporations
-
Top products for accounting firms
Recommended Products
-
CoCounsel
Move faster and accomplish more with a professional-grade, generative AI assistant that transforms the way you work. Thomson Reuters CoCounsel is with you every step of the way, backed by authoritative content and industry-leading expertise.
-
UltraTax CS
Provides a full line of federal, state, and local programs. Save time with tax planning, preparation, and compliance.
-
1040SCAN
Automate work paper preparation and eliminate data entry
Questions? We are here to help
Trade & Supply
Recommended Products
-
Foreign Trade Zone Management
Software that keeps supply chain data in one central location. Optimize operations, connect with external partners, create reports and keep inventory accurate.
-
Indirect Tax
Automate sales and use tax, GST, and VAT compliance. Consolidate multiple country-specific spreadsheets into a single, customizable solution and improve tax filing and return accuracy.
Questions? We are here to help
Risk & Fraud
Recommended Products
-
CLEAR
Search volumes of data with intuitive navigation and simple filtering parameters. Prevent, detect, and investigate crime.
-
Fraud Detect
Identify patterns of potentially fraudulent behavior with actionable analytics and protect resources and program integrity.
-
ID Risk Analytics
Analyze data to detect, prevent, and mitigate fraud. Focus investigation resources on the highest risks and protect programs by reducing improper payments.
Questions? We are here to help
News & Media
Recommended Products
-
Reuters Connect
Around the globe, with unmatched speed and scale, Reuters Connect gives you the power to serve your audiences in a whole new way.
-
Reuters Plus - Content Studio
Reuters Plus, the commercial content studio at the heart of Reuters, builds campaign content that helps you to connect with your audiences in meaningful and hyper-targeted ways.
-
Reuters.com Platform
Reuters.com provides readers with a rich, immersive multimedia experience when accessing the latest fast-moving global news and in-depth reporting.
Questions? We are here to help
Books
Recommended Products
-
What's new in legal products
Shop our latest titles
-
Shop tax customer favorites
ProView Quickfinder favorite libraries
Questions? We are here to help
Developers
-
APIs by industry
-
Related sites
-
United States Support
-
International support
-
New releases
-
Join a TR community
-
Free trials & demos
Error: (399 [42000]) Error in ProcessClientSync. System.Data.Odbc.OdbcException... Cannot open database requested in login...
Scenario
You may get an email with the following error message multiple times per day. You may also notice the Lookup List Sync is not working properly and find this error in the log files.
Error message
(
399
) Error in ProcessClientSync. System.Data.Odbc.OdbcException: ERROR [42000
] [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot open database requested in login
'<gfr_login>'. Login fails
. ERROR [42000] [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot open database requested in login '<gfr_login>'. Login fails. at GFR_LookuplistSync.Database.Execute(String strSQL, String strDelimiter) at GFR_LookuplistSync.SyncLookuplist.ProcessClientSync(IniFile& objIniFile)Cause
These errors may be caused by any of the following:
- The name of the time and billing database has changed.
- The login defined in the ODBC connection to the time and billing database has failed.
- The server hosting the time and billing database is offline.
- The time and billing database has moved to a different server than where it was when the lookup list and ODBC data source were originally set up.
- A change to the firewall is not allowing the connection to the time and billing database.
- Settings for the time and billing database server have changed and no longer allow remote connections.
Solution
Try these recommended solutions in the following order.
- Test the ODBC datasource and update passwords or database names as necessary.
- Review the ODBC Connection to a Database article for information on ODBC connections.
- Verify that there is an entry for GoFileRoom under System DSN for ODBC connections.
- Verify that the server with the time and billing client database is online.
- Verify that you are connected to the time and billing application database server.
- Review the SQL server troubleshooting article for resources and information on configuring the Practice CS SQL database.
- Run the GoFileRoom Lookup List service as domain admin.