Hi, i got the same problem under Windows 10 64 bit.
Thanks to Rockwell Support i could find a solution.
The solution for me was:
- Install/open the SQL Server managenment Studio
- Right click Security/Logins "New Login"
- Search "LOCAL SERVICE" and then ok
- Right click Security/Logins "New Login"
- Search "SERVICE" and then ok
For the new Logins "NT AUTHORITY\LOCAL SERVICE" and NT AUTHORITY\SERVICE
assing the Server roles "sysadmin"
Now it should work.
The explanation why you have "Test completet sucessfully" when you do "Test Data source", but it doesnt work in FactoryTalk View is that
when you test you connect to the database as local user, but when FTV tries to connect it does it as a service.