Last post Jun 13, 2011 03:44 AM by topsearchforyou
Jan 21, 2009 02:29 PM|dancir|LINK
On Windows Server 2008 - I installed Visual Web Developer 2008 Express and SQL Server Express 2008 with Advanced.
I ported over several Websites from a Windows 2003 Web Server.
When I go into the V.W.D. Solution Explorer for a given website, I see the MDF files ported from 2003, but when I go into Database Explorer to work with the data, I get a
Package Load Failure and the database will not connect. Instead it says, "Failure to create a user instance of SQL Server, due to a failure in starting the process for the use instance. The connection will be closed."
And when i try to create a new database, In Solution Explorer, when I right click on App_Data and select Add New Item / SQL Database, I get this error:
"Connections to SQL Server files (*.mdf) require SQL Server 2005 to function properly. Please verify the installation of the component or download it from Microsoft."
Thanks in advance,
Jan 21, 2009 03:46 PM|bullpit|LINK
Can you make sure that all the SQL Services have started on the server?
Jan 21, 2009 04:20 PM|dancir|LINK
IF you mean, go to SQL Configuration Manager, and Select SQL Server Services - I found both the Browser and the Agent to be disabled, and unable to Start.
Jan 21, 2009 04:28 PM|bullpit|LINK
Hmm..can you try to start them from Windows Services window.
Jan 21, 2009 05:26 PM|dancir|LINK
In Windows Services, I was able to change only SQLBrowser to automatic, and then Start.. but alas it did not help
Jan 21, 2009 05:32 PM|gmmastros|LINK
If the services don't start, there is probably a message about it in event viewer.
Click Start -> Run
Check for events in there related to SQL Server.
Jan 21, 2009 10:25 PM|dancir|LINK
eventvwr: SQLServerAgent could not be started (reason: Error creating a new session).
Jan 21, 2009 10:34 PM|dancir|LINK
eventvwr: 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. [CLIENT: <local machine>]
Jan 26, 2009 08:47 AM|Jian Kang - MSFT|LINK
Did you install Visual Web Developer 2008 Express Edition with SP1?
For Visual Studio 2008, we cannot work with SQL Server 2008 without SP1. So I would suggest you upgrade to Visual Web Developer 2008 Express Edition with SP1.
We can get it from:
Also we need make sure the SQL Server instance name is correct in VWD.
Please refer to the following steps in Visual Studio, which I think is same in VWD.
In Visual Studio, go to Tools -> Options ->
Database Tools -> Database Connections, fill the SQL Server Instance Name with the name of SQL Server 2008 Express Edition instance.
There is another thread about the same issue you may refer to:
Jan 27, 2009 02:05 PM|toth3max|LINK
Jun 13, 2011 03:44 AM|topsearchforyou|LINK