I've installed SQL Server Express with a named instance 'SQLSERVER2'. I was able to connect to it and reference it in the management studio. There was a problem though with Visual Studio 9 when running an ASP.NET web application that required connecting to the same instance. So, I went into the configuration manager to change the security level of the instance from network to local service. The change went through but could not restart the instance. That is what has created my next round of problems. I can't go in and change it back to network because the instance is permanently stopped. I cannot start it with the services manager. How can I fix this?
Here is the connection log:
2009-12-21 11:36:32.20 Server Microsoft SQL Server 2008 (RTM) - 10.0.1600.22 (Intel X86)
Jul 9 2008 14:43:34
Copyright (c) 1988-2008 Microsoft Corporation
Express Edition with Advanced Services on Windows NT 5.1 <X86> (Build 2600: Service Pack 3)
2009-12-21 11:36:32.50 Server (c) 2005 Microsoft Corporation.
2009-12-21 11:36:32.51 Server All rights reserved.
2009-12-21 11:36:32.51 Server Server process ID is 21856.
2009-12-21 11:36:32.51 Server Authentication mode
View Complete Post