It has been an interesting road - Looked on the net- loading sql 2005 when u had a previous version of sql on the server the tools don't fully load even though sql 2005 says it does - fixed that but with the SSMS running still would not connect to the AC instance- called Claire at support today 1st time through!! and set up a net meeting she knew exactly what to do. The AC instance needs a login and password that only support has. She logged me in and I was able to set AC5 at 1GB max. Now have 300 to 400MB free and the page file did not increase. Maybe these guys know something about sql/AC - Anyway food for thought
Last edited by Cary; 07/23/2010 11:26 PM.