SQL Server 2005 express connection with Visual Web Developer 2008 express
Ok so I had first downloaded SQL Server Express 2008 and Wed Developer Express 2008, and I could not integrate the two together. Was getting error messages that were wasking for the correct version of SQL Server 2005, so....
I uninstalled SQL Server Express 2008, and installed SQL Server Express 2005.
Now I open the Visual Web Developer and tried to add an item (SQL Database) to the App_Data folder in a web site project, and now I am getting the below error.
"generating user instances in SQL Server is disabled. Use sp_configure 'user instances enabled' to generate user instances."
Ok so I know I can create databases, and tables in the SMS Express, however I have a bunch of training material that is based on the above approach. SO can someone please help me with the above error please??? Thanks very much.....
also should note t开发者_如何学JAVAhat the above are installed on my home computer for learning purposes.
The following asp.net forum post has a possible solution:
http://forums.asp.net/p/1035148/1429516.aspx
You have to run the following query
sp_configure 'user instances enabled', 1; RECONFIGURE
This can be done in SMS express.
精彩评论