User instances are useful for users who are running Windows under a least-privilege user account (LUA) because each user has SQL Server system administrator (sysadmin) privileges over the instance running on her computer without needing to run as a Windows administrator as well.
To enable user instances, do as follows
1. Open the SQL Server Management Studio Express.
2. In the query editor type this text: exec sp_configure 'user instances enabled', 1.
Then type: Reconfigure.
3. Then restart the SQL Server database.
For more info, go to
http://tarriniluca.spaces.live.com/blog/cns!EC6B91E5AAED519B!728.entry
Subscribe to:
Posts (Atom)