That worked. Is that feature on by default? And how can it be disabled?
couldn't have turned it off except by mistake.
""Wen Yuan Wang [MSFT]"" wrote:
> Hello Morris,
>
> You needn't to uninstall SQL 2000. It sounds like you disabled user
> instance on your SQL Express server.
> Please run the following code on your SQL Express server to enable
> UserInstance.
> sp_configure 'user instances enabled','1'
>
> For more detailed information, please refer to
>
http://technet.microsoft.com/en-us/library/ms143684.aspx > [User Instances for Non-Administrators]
>
> Hope this helps, please try the above method and let me know if this method
> resolve the issue. We will follow up. It's my pleasure to assist you.
> Have a great day,
> Best regards,
> Wen Yuan
>
> Microsoft Online Community Support Delighting our customers is our #1
> priority. We welcome your comments and suggestions about how we can improve
> the support we provide to you. Please feel free to let my manager know what
> you think of the level of service provided. You can send feedback directly
> to my manager at: msdnmg@microsoft.com.
> ==================================================
> Get notification to my posts through email? Please refer to
>
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif > ications.
> Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
> where an initial response from the community or a Microsoft Support
> Engineer within 1 business day is acceptable. Please note that each follow
> up response may take approximately 2 business days as the support
> professional working with you may need further investigation to reach the
> most efficient resolution. The offering is not appropriate for situations
> that require urgent, real-time or phone-based interactions or complex
> project analysis and dump analysis issues. Issues of this nature are best
> handled working with a dedicated Microsoft Support Engineer by contacting
> Microsoft Customer Support Services (CSS) at
>
http://msdn.microsoft.com/subscriptions/support/default.aspx. > ==================================================
> This posting is provided "AS IS" with no warranties, and confers no rights.
>