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

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' ?





.

Relevant Pages

  • Re: There was a problem loading data: Generating user instance in SQL Server is disabled.
    ... I figured out that SSMS is probably Microsoft SQL Server Management ... Studio Express, but once I opened it, and connected with Windows ... When installing, use "advanced" installing steps, ... so you get chance to specify if you want to use USER INSTANCE or not. ...
    (microsoft.public.vstudio.general)
  • Re: There was a problem loading data: Generating user instance in SQL Server is disabled.
    ... 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. ... Since you have already get it installed into a setting that is not meet the default requirement for those sample apps, you need to learnto reconfigure the system, or you could try to uninstall and then re-install, so you have chance to studybefore installing and configuring your OS to meet the all requirements and to get the installation right. ...
    (microsoft.public.vstudio.general)
  • Re: There was a problem loading data: Generating user instance in SQL Server is disabled.
    ... I getting the impression that this is a PHD only club, and I thought that it was for newbie as well ... 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. ... Since you have already get it installed into a setting that is not meet the default requirement for those sample apps, you need to learnto reconfigure the system, or you could try to uninstall and then re-install, so you have chance to studybefore installing and configuring your OS to meet the all requirements and to get the installation right. ...
    (microsoft.public.vstudio.general)
  • RE: using Membership on production server (Copy Web Site tool) - U
    ... I was aware of what "user instance" are and since I do want to have all ... "User instance" can let you use sql server mdf database file without ... authentication(instead of putting username/password in connection string). ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: SQL Server Managment Studio
    ... "SQL Server Managment Studio" zu installieren. ... Welche Edition und Service Pack von Visual Studio? ...
    (microsoft.public.de.sqlserver)
Loading