The user instance login flag is not supported on this version of S

[Morris Neuman]

I copied a C# project from one machine to another both XP Pro with VS2005.

Then solution compiles but when I run the app I get the error message on the
first dataadapter.FILL() command:

"The user instance login flag is not supported on this version of SQL
Server. "

SQLExpress and SQ 2000 is installed, but I am specifiing SQL Express in the
connection string see below and the SQL 2000 server is not started.

Do I need to uninstall the SQL 2000 server? Shouldn't this work with the
SQL 2000 on the same machine?

When I just remove the "User Instance =True" from the connection string I
still get this message. What am I doing wrong?

<connectionStrings>
<add name="CMMB1.Properties.Settings.CallMasterSQLConnectionString"
connectionString="Data
Source=.\SQLEXPRESS;AttachDbFilename="C:\Program
Files\CALLMaster\Data\CallMasterSQL.mdf";Integrated Security=True;Connect
Timeout=30;User Instance=True"
providerName="System.Data.SqlClient" />
</connectionStrings>

 

[Wen Yuan Wang [MSFT]]

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: (e-mail address removed).
==================================================
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.

 

[Morris Neuman]

That worked. Is that feature on by default? And how can it be disabled?
Only through the command line? Since I dodn't even know it was a feature I
couldn't have turned it off except by mistake.

 

[Wen Yuan Wang [MSFT]]

Hello Morris,

User Instance is only supported on SQL 2005 Express. Thereby, UI doesn't
provide property to turn off this feature. We have to disable it through
command line and it should be enabled by default. At least, it is enabled
on my SQL 2005 Express.

Hope this helps. If you have any more concern, please feel free to let us
know. We are glad 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:
(e-mail address removed).
==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.

 

[Wen Yuan Wang [MSFT]]

Hello Morris,

This is Wen Yuan, again. This feature should be enabled by default. I have
checked other machines on my side.
Do you have any more concern on this issue? Please feel free to let us know
if there is anything unclear. We are glad 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:
(e-mail address removed).
==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.