Anyone ever had a "micellaneous error" when trying to start AC from a remote computer. Error: invalid function call or something or other?
I recently upgraded the server and encountered this issue. The problem is related to security settings in the SQL Server files. We don't know what caused the problem.
We resolved this issue by going to the program files folder of Amazing Charts. Find all the files that are of SQL Server type. You can sort by this type if it helps. We had 6 files: 3 files that were duplicates. I forgot the names of the files. Right click on each of the files and check the Security permissions. For a quick fix, you can set each file to Everyone. For better security, set the security permissions to each individual user or group accessing the files.
As for the random disconnects with mapped drives, we had this problem too. Some of my map drives were randomly disconnecting and it was causing problems with Amazing Charts. According to Microsoft, this is designed by default to conserve server resources.
Use the
net config server command to adjust settings and check your idle session time. You can disable this feature by typing the following in a command prompt (with admin rights):
net config server /autodisconnect:-1
Do this on all your computers. We have a small network so we don't care about conserving resources and connections but if you have a larger network, you will need a network administrator to monitor this stuff regularly and adjust resources.
References:
http://support.microsoft.com/kb/297684
