Error Message when trying to open AdventureWorksDB in vbexpress

I get the following error message when trying to open the AdventureWordsDB in VBExpress: "Failed to generate a user instance of SQL Server dut to failure in starting the process for the user instance. The connection will be closed." Can someone tell me what the problem is and how to solve it? Thanks, Ray Holt

hi,

you seemed to open a database in User Instace mode.. User Instances are available in SQLExpress edition only and they have to be enabled.. at installation time of SQLExpress a kind of message asks you to enable this feature or not, but you can enable it even later executing the sp_configure system stored procedure with the 'user instances enabled' parameter..

regards

|||How do I execute the sp_configure? Thanks, Ray Holt|||

hi Ray,

for your convenience, you can download and install SQL Server Management Studio Express... you can then execute it, "open a new query", and execute the sp_configure call..

regards