SQL express-"failed generate a user instance ..."

Error details

19:20:01. 73 spid7s script level upgrade for database 'master' failed because upgrade step' repl _ Master. SQL 'encountered error 5598, state 1, severity 16. this is a serious error condition which might interfere with regular operation and the database will be taken offline. if the error happened during upgrade of the 'master' database, it will prevent the entire SQL server instance from starting. examine the previous errorlog entries for errors, take the appropriate corrective actions and re-start the database so that the script upgrade Steps Run to completion.
2010-04-11 19:20:01. 73 spid7s error: 3417, severity: 21, state: 3.
19:20:01. 73 spid7s cannot recover the master database. SQL Server is unable to run. restore master from a full backup, repair it, or rebuild it. for more information about how to rebuild the master database, see SQL Server books online.
2010-04-11 19:20:01. 73 spid7s SQL trace was stopped due to server shutdown. Trace id = '1'. This is an informational message only; no user action is required.

 

Ref: http://blogs.msdn.com/joestagner/archive/2008/03/12/sql-express-failed-generate-a-user-instance.aspx? Commentposted = true # commentmessage

 

I love SQL Server Express. I write demos. lots of them. SQL Express is great because it's free and works. MDF files so that I can just bundle up the database with my demo and folks can download a demo, run, and experiment.

I'm "Learning" to love Windows Vista.

My only real complaint is that we over did security. I want a switch that says .....

1. Use Vista's maximum security (I never wocould .)
2. Lighten up a bit (You know, turn of UAC and such .)
3. Make security on this vista box just like Windows XP
4. Make me a God on this box (Super Grand admin-I accept the responsibility .)
5. Windows 98 mode (turn it all off .)

Life's been very busy these days and I'm working on some new alternative strative demos for my Ajax world talks next week.

Trying to connect to My SQL express database from my ASP. NET code yields the following message.

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

... "A failure ."

Can you be a bit more specific ????????

I know, I know, this is a typical Microsoft error message.

I know SQL express installers locked down to some extend so I thought maybe the issue was disabled protocols as I was carrying forward some code, but alas-nothing seamed to help. I tried all the configuration tools, used the surface area tool and added everyone to the SQL admin's groups. nothing

After searching and playing for some time I got things working again and wanted to share the solution.

If you're running from the IDE then you are running as yourself so:

Delete c: \ Documents ents and Settings \ USERNAME \ Local Settings \ Application Data \ Microsoft SQL server data \ sqlexpress.

I am using Windows 7, the path is

"C: \ Users \ xxxxxx \ appdata \ Local \ Microsoft SQL Server Data"

 

If you're running via iis the user is usually ASPnet so ....

Delete c: \ Documents and Settings \ computername \ USERNAME \ Local Settings \ Application Data \ Microsoft SQL server data \ sqlexpress

Hope you found this and it saves you some time.

SQL express-"failed generate a user instance ..."

I love SQL Server Express. I write demos. lots of them. SQL Express is great because it's free and works. MDF files so that I can just bundle up the database with my demo and folks can download a demo, run, and experiment.

I'm "Learning" to love Windows Vista.

My only real complaint is that we over did security. I want a switch that says .....

1. Use Vista's maximum security (I never wocould .)
2. Lighten up a bit (You know, turn of UAC and such .)
3. Make security on this vista box just like Windows XP
4. Make me a God on this box (Super Grand admin-I accept the responsibility .)
5. Windows 98 mode (turn it all off .)

Life's been very busy these days and I'm working on some new alternative strative demos for my Ajax world talks next week.

Trying to connect to My SQL express database from my ASP. NET code yields the following message.

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

... "A failure ."

Can you be a bit more specific ????????

I know, I know, this is a typical Microsoft error message.

I know SQL express installers locked down to some extend so I thought maybe the issue was disabled protocols as I was carrying forward some code, but alas-nothing seamed to help. I tried all the configuration tools, used the surface area tool and added everyone to the SQL admin's groups. nothing

After searching and playing for some time I got things working again and wanted to share the solution.

If you're running from the IDE then you are running as yourself so:

Delete c: \ Documents ents and Settings \ USERNAME \ Local Settings \ Application Data \ Microsoft SQL server data \ sqlexpress.

If you're running via iis the user is usually ASPnet so ....

Delete c: \ Documents and Settings \ computername \ USERNAME \ Local Settings \ Application Data \ Microsoft SQL server data \ sqlexpress

Hope you found this and it saves you some time.