I've installed EPiServer using the SDK in VS 2005 and therefore i didn't have the CMS Manager installed. (Using Vista)
Now I'm trying to upgrade my installation to SP2...
Did all the tricks with IIS 6 compability and setup the site in IIS.Downloaded the CMS Manager.Started the CMS Manager as administrator picked the site. It started downloading files and then is stopped at the database upgrade with error "...does not allow remote connections..."
But it clearly accepts remote connections since I'm using it with the development server , ok it's not using the windows account then so i tried connecting with SQL Management Studio (both with "run as administrator" and without)with windows credentials and it works.
The final thing I saw was in the upgrade wizard it says "(local)" for the database... So how can I know where the problem is, is the manager just not displaying the correct information in the summary or isn't it reading the connectionstring from web.config?