Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
ahme09
Starting Member
6 Posts |
 Posted - 2007-08-17 : 03:29:12
|
| "Failed to generate a user instance of SQL Server due to a failure in starting the process for the user instance "help anyone???? |
|
|
ashley.sql
Constraint Violating Yak Guru
299 Posts |
Posted - 2007-08-17 : 08:42:12
|
| right click on server and start it.-----------------------------------------------------------------------------------------------Ashley Rhodes |
 |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-08-18 : 00:24:17
|
| Where did you get that error? What's your sql2k5 edition? |
|
|
|
askben
Starting Member
8 Posts |
Posted - 2007-08-18 : 10:12:37
|
| This sounds like SQL Express with User Instance=true in the connection string. This has to be enabled in the SQLExpress options.The other thing you need to make sure of is to make sure that the account that you are connecting to SQL with has a local user profile. So Network Service is not a user that you can use with Integrated Security=True.To enable User Instances attach to the SQL Express instance and runsp_configure 'user instances enabled','1' ------------Ben Miller |
|
|
|
|
|
|
SQL server Down