I mentioned problems experienced while installing SQL Server 2005 on Vista in a previous article and would like to add that I was unable to add a new Administrator via the SQL Server Surface Area configuration. It would allow to move from left to right my user name, clicked OK but it would not stick. Going back into SQL Server Surface Area configuration tool reveals that it is being ignored.

To be on the safe side, during the installation of VS2005 on vista I elected to not include SQL Server 2005 express. After copying over a web site created in IIS 5.1 into IIS 7 I noticed the following. Any connection string in appsetting defined in web.config will not work. In IIS 7 instead create a connection string that will override the setting in web.config. This override fixed my problem and my asp.net web application could now connect to SQL Server 2005. The connection string syntax has changed in IIS 7.



So far I have not been able to run VS 2005 in debug mode after following procedures defined on the net but managed to a get my web site running straight off IE 7.

Visual Studio 2005, Vista, IIS 7


Comments view

Add Comments

: Name   
: Email Address    Will not be showed