Melbourne Web Solutions|Design - Providing Web Design and Development for Brevard County, Florida
Contact Search Archive Portfolio Services

Windows 7 and SQL Server fail: Failed to generate a user instance of SQL Server due to a failure in starting the process for the user instance. The connection will be closed.

by Nicole Tuesday, May 17, 2011 4:58 PM
I was super stoked to get Visual Studio 2010 for my machine but had major issues installing Microsoft SQL Server 2008 R2 to go along with it. I ran through setup and had a successful install, but when I went to create a new local SQL Server database in Visual Studio, the following extremely annoying error message would occur: "Failed to generate a user instance of SQL Server due to a failure in starting the process for the user instance. The connection will be closed." [More]

Random Testimonials For Your Site

by Nicole Thursday, December 02, 2010 8:02 PM
One of my freelance projects is a redesign for a client in the health industry. They wanted a random testimonial to appear in the master page template on each page load. Here I created a custom user control that will display a random testimonial on each page load in a very nice looking way. [More]

Using SQL RETURNING INTO to get newly created ID

by Nicole Tuesday, April 06, 2010 11:56 AM
A common problem for developers is how to get a newly created ID after a database insert. For example, let's say that we have two database tables. One table is called Customers and the other table is named Orders. The integrity relationship requires that a customer record exist before an order record for that customer is created. [More]

How to reset the admin password for BlogEngine using SQL Server

by Nicole Wednesday, February 24, 2010 7:27 PM
The down and dirty way to reset your Blog Engine password when using MSSQL and BlogEngine 1.5.0.7. [More]