Just ugraded to 4.0 but have an issue with how things are connected. With the older system a share was used to connect users to the database. Now residing in that share is an AmazingCharts.xml file along with the .mdf files which belong to SQL. I purposely ushared the directory to see what effect this would have. The remote desktops would not connect because they could not find the xml file that tells it where the mdf files are located.
Since this is now SQL based, why are we having to maintain this share. I am thinking at minumun this information should be stored in the HKEY_Current_User registry. Instead the location is based on the information in the xml file.
My SQL experience tells me that the desktop should only care about where the SQL server is located and what port to talk to it through and not have to worry about a share. SQL should be managing all the SQL files and the desktop should be talking to SQL. Any one have any thoughts on how to get rid of the share and only use server port communication between desktop and server.
