Decided to put MS SQL Express 2008 on my Windows Server 2003 machine to replace MSSE2005. All was working fine with the website with the 2005 version.
Now, however, I can build and then connect to the site through the MS Visual Web Developer Express 2008, but when I try to hit the web site remotely, I get the 'failure to create an instance...'
I've uninstalled and installed several times. When I try to get to the website remotely, I make sure the VWDE2008 is closed and not locking any files. I've set the SQL service to run as 'Local System'; I've looked for stray \SQLEXPRESS directories to delete.
Very frustrating that everything works in the VWDE, but not when I try to connect remotely. This was not a problem when using the 2005 VWDE and 2005 SQL Express.
Any help would be greatly appreciated.