Hello everyone, I am currently encountering an issue while attempting to launch a project on Factory Talk View Studio V8.1. The error message I am receiving is: "FactoryTalk View is unable to authenticate with the SQL Server 2008 express instance 'FTVIEWx64TagDb' on the machine 'MYPCNAME'." It is possible that a Windows update may have disrupted the software's connection to the SQL database since the last time I used Factory Talk View on this computer. Originally, I had a different error message, but I resolved it by reinstalling the SQL server. I now need to reset FTVIEWUSER using the reset tool, but unfortunately, I do not have the password for the SA account. I am unsure about how to proceed with resolving this issue, so any advice or guidance on how to address this would be greatly appreciated. Thank you, Brian.
Hey Brian! I know this is a long shot, but have you found a solution to this issue yet? Let me know if you need any help with it.
McMahobr inquired about opening a project using Factory Talk View Studio V8.1 but encountered an authentication error with SQL Server 2008 Express instance 'FTVIEWx64TagDb' on machine 'MYPCNAME.' This issue may have arisen due to a recent Windows update affecting software access to the SQL database. Initially experiencing a different error, McMahobr reinstalled the SQL server and now needs to reset FTVIEWUSER but lacks the SA account password. Seeking guidance on resolving this issue. One possible solution is to download and install either SQL Server 2008 Express or SQL Server 2014 Express from the official Microsoft website. SQL Server 2008 R2 SP2 Express Edition is a free and powerful database, while SQL Server 2014 Express is a reliable data management system suitable for web applications and desktops.
Hi Brian, it indeed sounds like a challenging issue. If you lost or do not remember the SA account password, you might have to reset it to regain access. Microsoft provides a guideline on how to perform this action in their official documentation; you could follow that. In case this does not resolve your issue, you might want to consider creating a new SQL Server instance if feasible or seeing if your system has a previous restore point before the troubling Windows update, which you could roll back to. Also, remember to back up any important files before making significant changes. Good luck!
Hi Brian, it sounds like the Windows update might have tampered with the settings of Factory Talk View on your PC. If you don't have the password for the SA account, you might try resetting the password using sqlcmd. First, you'll need to stop the MSSQL$FTVIEWx64TAGDB service. Then, start SQL Server 2008 R2 in single-user mode by adding '-m' before -c. Once SQL Server is in single-user mode, you should be able to connect with just windows authentication. You can then create a new sysadmin account and reset the SA password. Remember to restart MSSQL$FTVIEWx64TAGDB after you reset the password. I hope this helps and you manage to get your project up and running again!
Hey Brian, it sounds like you're dealing with a tricky situation! If the Windows update affected your connection, it might be worth checking if the SQL Server services are running and configured properly. As for resetting the FTVIEWUSER, you could try accessing SQL Server Management Studio (SSMS) to log in with a Windows account that has admin privileges and then reset the SA password from there. If you don't have access to SSMS, you might need to reach out to whoever set up the SQL Server for assistance. Good luck—I hope you get it sorted out soon!
✅ Work Order Management
✅ Asset Tracking
✅ Preventive Maintenance
✅ Inspection Report
We have received your information. We will share Schedule Demo details on your Mail Id.
Answer: Answer: This error message indicates that there is an authentication issue between Factory Talk View Studio V8.1 and the SQL Server 2008 express instance on the specified machine.
Answer: Answer: One potential solution is to reset the FTVIEWUSER using the reset tool. However, it may require the SA account password. If you don't have the SA account password, you may need to explore alternative methods for resolving the authentication issue.
Answer: Answer: If you suspect that a Windows update may have disrupted the connection between Factory Talk View Studio and the SQL database, consider checking for any recent updates that could have caused the issue. You may need to troubleshoot and potentially reconfigure the connection settings to restore authentication.
Join hundreds of satisfied customers who have transformed their maintenance processes.
Sign up today and start optimizing your workflow.