Generating user instances in SQL Server is disabled. Use sp_configure 'user instances enabled' to generate user instances.
HI
I am trying to run club web starter kit and get this message "Generating user instances in SQL Server disabled. Use sp config 'user instances enabled' to generate user instances'
MS SQL server 2005 does not support user instances which are enabled and are accessed through the sp_configure. However, SQL server 2005 express edition supports it.
If you are using UserInstance feature of SQL Server Express ,then check your connection string
Refer : http://www.connectionstrings.com/?carrier=sqlserver2005 and check SQL Server express Userinstance connection string
also refer :
http://blogs.msdn.com/sqlexpress/archive/2006/11/22/connecting-to-sql-express-user-instances-in-management-studio.aspx
Tony Spencer
0 Points
2 Posts
Club Web starter kit
Jun 28, 2008 12:54 PM|LINK
Generating user instances in SQL Server is disabled. Use sp_configure 'user instances enabled' to generate user instances.
HI
I am trying to run club web starter kit and get this message "Generating user instances in SQL Server disabled. Use sp config 'user instances enabled' to generate user instances'
Very new to asp.net can anyone help
Thanks
LockH
Contributor
2807 Points
578 Posts
Re: Club Web starter kit
Jun 28, 2008 02:25 PM|LINK
Suggest you ask this in the starter kits club site section.
I'm still confused, but now I'm confused on a higher plane.
Tony Spencer
0 Points
2 Posts
Re: Club Web starter kit
Jun 28, 2008 04:25 PM|LINK
Sorry thought this was the starter kit section
LockH
Contributor
2807 Points
578 Posts
Re: Club Web starter kit
Jun 28, 2008 11:16 PM|LINK
Oops. I seem to have had a blonde moment and walked through the wrong door.[:$]
I'm still confused, but now I'm confused on a higher plane.
varunnchopra
Member
20 Points
18 Posts
Re: Club Web starter kit
Aug 08, 2008 02:14 AM|LINK
MS SQL server 2005 does not support user instances which are enabled and are accessed through the sp_configure. However, SQL server 2005 express edition supports it.
varunnchopra
Member
20 Points
18 Posts
Re: Club Web starter kit
Aug 08, 2008 02:27 AM|LINK
Refer : http://www.connectionstrings.com/?carrier=sqlserver2005 and check SQL Server express Userinstance connection string
also refer :
http://blogs.msdn.com/sqlexpress/archive/2006/11/22/connecting-to-sql-express-user-instances-in-management-studio.aspx
http://msdn2.microsoft.com/en-us/library/bb264564.aspx