error: "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.

Am new to Sql Server Express but using it doesn't seem "easy" . When
executing a very simple sample program in Visual Studio 2005, this message
occurs:
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.
The mdf is a local database inside a App_Data folder. Everything (VS
2005, SQL Express, IIS, ...) resides on my local XP workstation.

I've read in some forum that mentions deleting the SQL Server folder in the
Documents and Settings folder. Tried that but still doesn't work.

This is getting extremely frustrating. Any insight much appreciated.
Thanks.


.

Relevant Pages

  • Re: error: "Failed to generate a user instance of SQL Server due to a failure in starting the proces
    ... time the user creates a User Instance connection, ... Files\Microsoft SQL Server] directory. ... folder to the Microsoft supposed "default" folder, ... I've checked the permissions and found that the ASPNET user not listed on ...
    (microsoft.public.sqlserver.connect)
  • Re: Question about "Distribution clean up: distribution" Job
    ... I granted the SQL Server Service Account "Full Control" over ... the Snapshot Folder and the job has been running successfully ever since. ... Then I went into the job step and copied the command it was ...
    (microsoft.public.sqlserver.replication)
  • Re: install/configure SQL Server 2000, SQL Server CE for merge rep
    ... I was wondering what the significance is to sharing the snapshot folder. ... Does the Pocket PC directly access the shared folder? ... >> check the replication monitor in SQL Server 2000 Enterprise Manager ...
    (microsoft.public.sqlserver.ce)
  • Re: Build
    ... As Kalen already mentioned, there is no such thing "build" in SQL Server, that term is must be about "Building a Project or Solution in Visual ... here you are talking about a specific application which seems to need more than one database and noone here except for you knows about the sample application you are working on now. ... From what I've learned, there are actually several databases that exist for every "solution", located in the output folder and project folders. ... If you can explain what you mean by "build" and some examples of what files you refer to then we might be able to add some... ...
    (microsoft.public.sqlserver.setup)
  • Re: Database Backup
    ... Have you checked the actual permissions for the folder? ... Columnist, SQL Server Professional ... > I am trying to backup the database, ...
    (microsoft.public.sqlserver.security)
Loading