Tuesday, May 6, 2008

Enable User Instances with sp_configure

with visual studio2005 ,when i wanted to create a site to use webparts that needs membership spesifications..asp.net server turned the yellow page with

Generating user instances in SQL Server is disabled. Use sp_configure ‘user instances enabled’ to generate user instances.

I googled around and found out the query below to enable user instances on sql server

exec sp_configure 'user instances enabled', 1
reconfigure

No comments: