Re: There was a problem loading data: Generating user instance in SQL Server is disabled.

I read it, and I still can not make sense of the damn thing

When I installed VBExpress and C# Express 2008, using the default settings with only one exception it was the path for the installation since there is nothing else than the OS on C: so everything else is on D:

BTW your BOL***, says nothing about what I need except for the command it self, and when I tried it in CMD I got an error saying that the command is not know

"Norman Yuan" <FakeName@xxxxxxxxxxxxx> wrote in message news:%23Z6l2RDjIHA.3940@xxxxxxxxxxxxxxxxxxxxxxx
So, you still haven't read BOL on SQL Server Express' USER INSTANCE. I really suggest that even you can enable User Instance by using the SQL statement I provided previously, please read BOL before post again.

Yes, I talk SQL Server and SQL Server Express without dsitinguashing them because in most cases, there is not differece in the regards of inexperienced users. USER INSTANCE, however, is only available to SQL Server Express. and no, you are completely wrong by saying "SERVER Express, a very light weight that does only local database and not network".

If you really want to sovle your "USER INSTANCE is disabled" issue without bothering to understand what User Instance and SQL Server/Express is, fine, try the two approach I provides in previous post; Yes, if your goal is get over the trouble for now and get you started, you can go ahead without knowing more on SQL Server/Express, only you can get the issue fixed.

Because you only post the error message, it is really not much more can be said, other than letting you know this is USER INSTANCE problem, which you should learn more about.

It is definitely not the "end-of-world" by default, but could turned to one if you wre not lucky enough while installating VS and SQL Server Express without carefully preparing and studying(!). Since you have already get it installed into a setting that is not meet the default requirement for those sample apps, you need to learn(!) to reconfigure the system, or you could try to uninstall and then re-install, so you have chance to study(!) before installing and configuring your OS to meet the all requirements and to get the installation right.


"Martin Racette" <rat7_2001@xxxxxxxxxxx> wrote in message news:27A74F5A-144B-448A-B0D5-AF41624BAB0C@xxxxxxxxxxxxxxxx
You keep saying that we will gewt into trouble, what kind of trouble, and it is not a SERVER, it SERVER Express, a very light weight that does only local database and not network, so we can not get into end-of-the-world

"Norman Yuan" <FakeName@xxxxxxxxxxxxx> wrote in message news:umILKZ5iIHA.5080@xxxxxxxxxxxxxxxxxxxxxxx
SQL Server is a very complicated server software. If you had it installed automatically with your VS, you missed chance to configure it as you need. I can only say, study more is the only way to get you there to know it well. I do not know what and how studied, cannot tell why and what get you where you are now.

Anyways, as the error you get, apparently, the SQL Server Express installed had USER INSTANCE capabilty disabled.

No, as complicated software as SQL Server, I do not think a couple of sentences will solve your issue. But try this:

You can simply run

sp_configure 'user instances enabled','1'

from SSMS to enable it.

Or, try this, if you want to learn more. You can uninstall the Sql Server express and re-install. When installing, use "advanced" installing steps, so you get chance to specify if you want to use USER INSTANCE or not.

Again, study, study and study (and study it right), without knowing USER INSTANCE well, it only get you into more troubles.


"M Skabialka" <mskabialka@xxxxxxxxxxxxx> wrote in message news:OgT9vN1iIHA.4712@xxxxxxxxxxxxxxxxxxxxxxx
As a newbie toVisual Studio I haven't been able to make it work whenever I try any web application. I try it - errors happen - I try everything I can think of or find on the Internet and give up for a while. I download a starter kit - more errors... Now you are saying to read a book on another topic (SQL Server) so I can fix a glitch in the first one (Visual Studio)! Is it something that can be explained in a couple of sentences so I can try to learn Visual Studio, then I can work on SQL Server down the road!

"Norman Yuan" <FakeName@xxxxxxxxxxxxx> wrote in message news:uv3bDzriIHA.1212@xxxxxxxxxxxxxxxxxxxxxxx
SQL Server Express has a special feature "USER INSTANCE". This feature can be enabled or disabled. It very unfortunate that many sample app, books use it automatically, assuming newbies know what it is. It is an advanced feature IMO, you need to know what it is (please study SQL Server Book On Line) before using it. Anyway, you can either enable it, or change the ConnectionString to not use it.


"M Skabialka" <mskabialka@xxxxxxxxxxxxx> wrote in message news:OGszbSqiIHA.4376@xxxxxxxxxxxxxxxxxxxxxxx
I downloaded the Microsoft Web Enabled Movie Collected starter kit in VB and created a new project using the template, but when I try to debug I get the message:
There was a problem loading data: Generating user instance in SQL Server is disabled. Use sp_configure 'user instance enabled' to generate user instances.
I installed VS 2005 a long time ago, and SQL Express and haven't used either in a while.
Where do I enter this code: sp_configure 'user instance enabled' ?







--
Thank You in Advance
Merci a l'avance

Martin


--
Thank You in Advance
Merci a l'avance

Martin

.