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

dotnet framework


  • 1. SQL Server: get column's default value
    Hi all, whena I fill a DataTable with the .FillSchema method of the sqlDataAdapter class, I lose column's default value. Is there a simple way to get them or have I to query the SQL Server database and manually set them? Thanks
  • 2. Validating an XML file
    Hi there, I've created a strongly-typed "DataSet" using VS. If I save the data via "DataSet.WriteXml()" and later prompt my users for the name of the file in order to read it back in again (using "DataSet.ReadXml()"), how do I validate that the file they enter is valid. That is, while "DataSet.ReadXml()" throws a "System.Xml.XmlException" if they enter a non-XML file, a valid XML file results in no exception even though the schema may be completely incorrect (if they enter some random XML file on the system that is). Is there a clean way of detecting this situatiion. Thank you.
  • 3. Using User-defined Functions in 2005
    Hi Every body I used access succefully for years and I created many scientefic databases with it Now I want to use VB.net2005 environmment with access database I succesfuly loaded my database BUT all the custom functions in the modules had not been imported So I created a module in and put all my custom functions as Public Functions, But this fails too! What Can I Do to make the SQL engine read functions as it was in access? Thanks in advance
  • 4. Iterate a datatable filtering on the default view.
    I have a data table for which I have set the default view's rowfilter. If I bind to a control everything is fine. If I go through the table with a foreach I see everything, not my filtered data. How would I iterate through with respect to the rowfilter? MyDataset.Tables["row"].DefaultView.RowFilter = "region='US'"; foreach (DataRow dr in MyDataset.Tables["row"].Rows) { this.lblFilter.Text = lblFilter.Text + " --- " + dr["region"].ToString(); } TIA, Chris

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

Postby TW9ycmlzIE5ldW1hbg » Fri, 28 Mar 2008 11:59:01 GMT

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?

        <add name="CMMB1.Properties.Settings.CallMasterSQLConnectionString"
Files\CALLMaster\Data\CallMasterSQL.mdf";Integrated Security=True;Connect 
Timeout=30;User Instance=True"
            providerName="System.Data.SqlClient" />

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

Postby v-wywang » Fri, 28 Mar 2008 16:04:50 GMT

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 
sp_configure 'user instances enabled','1'

For more detailed information, please refer to
[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:  XXXX@XXXXX.COM .
Get notification to my posts through email? Please refer to 
 http://www.**--****.com/ #notif
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 
This posting is provided "AS IS" with no warranties, and confers no rights.

Similar Threads:

1.The user instance login flag is not supported on this version

2.Alternative for user instance login flag ?

I have SQL Server 2008 Developer Edition only installed on development
PC, have 2008 Standard Edition on the production server. The DBAs have
the production environemnt locked-down.

I created a VS.NET 2008 web application and setup a MDF to use my Dev
Edition DB instance. When I run the app, I try to connect and get

The user instance login flag is not supported on this version of SQL
Server. The connection will be closed. 

I understand that only SqlExpress supports this functionality. The
professional DBAs are not going to let me just install another
instance on the DB farm. So what is a good workaround or technology to
use something like user instances on Dev Edition and Standard Edition?


3.DateTime problem: how to create datetime format hh:mm:ss AM/PM without the date

my database has separate field for date and time so we can capture
employees' time in and out .  In Sql, date can be present in smalldatetime
format, which contains only time hh:mm:ss AM/PM.  How can I create datetime
format in C# like that in order to update database?   Thanks in advance

4.Convert hh:mm:ss AM/PM into valid time

I am using an edit control to accept time including AM/PM. I can get
the hour/min and seconds but how do I convert the AM/PM part into the
internal representation for time using a DateTime object.
Any help appreciated.

5.Is user instance just support Sql2005 Express

It is amazing about the new AttachDBFilename, I am trying the posible of it.
but I end up with  a problem.
I am using  VS2005 to develop web application
My SqlServer is Sql2005 Standard. When I use the AttachDBFilename in my 
connection, it is ok for general page. but when I use the connection 
as typed dataset, it fail with message: "The user instance login flag is not 
supported on this version of SqlServer.

Is user instance just support Sql2005 Express? 

6. Not more than one instance per user, But allow on different users

7. Why am I flagged differently

8. ASP.NET 2.0 Login Control not working on Apple Mac OS X Version 10

Return to dotnet framework


Who is online

Users browsing this forum: No registered users and 50 guest