FMS general SQL error after server move
Have just moved SIMS and FMS to a new server. Now have FMS running successfully on 2 machines, but I get an error when logging on with a 3rd:
General SQL Error.
[Microsoft][SQL Native Client]SQL Network Interfaces: Server doesn't support requested protocol[xFFFFFF]
I thought it was an FMSconnect.ini issue, but have used the same .ini file from the other working machines to no avail.
Logging on as the admin on the same PC I get no errors, FMS works fine, suggesting a permissions issue, but user has same permissions as other users.
I did notice that when I ran odbcad32, in the native client configuration, the SQL server in the drop down box seems to switch back to the old SQL instance (ADMIN_YJB\SIMS2008) after I have selected the new instance (YJB-MIS\2008) and saved.
Any ideas how I can fix this - do you thing an uninstall/install of FMS on the machine to start fresh would be the answer?