That pesky SQL Server Express. I’m going to have to support it, it’s time to start collecting tips from the veterans….
These problems left me stranded for days, then today, on another machine, I hit a different set of problems I kept getting the following “Failed to generate user instance of SQL Server due to a failure in starting the process for the user instance. The connection will be closed.” and if I set “User Instance” to false the following “An attempt to attach an auto-named database for file C:\[app_path]\ASPNetDB.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share.”
If you don’t want to follow the link, the short answer is that SQLExpress creates a directory per user in “c:\Documents and Settings\[user]\Local Settings\Application Data\Microsoft\Microsoft SQL Server Data\SQLEXPRESS” that it uses to store information. Deleting this directory has fixed both of my problems.
[from Enjoy Every Sandwich]
I’m putting this here to I’ll remember where the bits are
A customer from Las Vegas DevConnections asks:
It seems like, but I may be mistaken, that you said something about posting some new set of toolbar icons on your blog? Was I in a Vegas-induced stupor or did you really say that?
Yes, I really, really did – however I totally forgot to link to it. Aaron talks about the library here. …and Soma talks about how the new image library came to be.
Instructions for finding the image library can be found here:
To install the Visual Studio 2005 Image Library
Locate the file VS2005ImageLibrary.zip. This file is normally installed in \…\Program Files\Microsoft Visual Studio 8\Common7\VS2005ImageLibrary\.
- Right-click VS2005ImageLibrary.zip and click Extract All.
- The Extraction Wizard appears.
- Follow the directions in the wizard to extract the images.
It looks like, this is something you’ll need the full Visual Studio install for – the zip file does not install with the Express editions of Visual Studio.
[via jfo’s coding]