Hi All,

Couple of days ago my Express User Instances stopped working, this I
think, after a Windows Update. All of my data connections in Visual
Studio also disappeared!

Using XP, Sql 2005, and SQL Express, VS 2008.

Is there a way (SP) to find out if the user instances are currently
enabled or not ? I can see the last (instance) connection was OK on
the 7th July. Would like to establish the cause and status before
trying to re-enable by sp_configure , we have several remote clients
in the field without SSMS or access to Internet.


Hope someone can ,

Casey

casy
It will be much easier if download and install SSMS of Express Edition



"casy" <mailkerry@gmail.com> wrote in message
news:48ff8ab5-80d7-4316-ab98-4d072ef786be@m3g2000hsc.googlegroups.com...
> Hi All,
>
> Couple of days ago my Express User Instances stopped working, this I
> think, after a Windows Update. All of my data connections in Visual
> Studio also disappeared!
>
> Using XP, Sql 2005, and SQL Express, VS 2008.
>
> Is there a way (SP) to find out if the user instances are currently
> enabled or not ? I can see the last (instance) connection was OK on
> the 7th July. Would like to establish the cause and status before
> trying to re-enable by sp_configure , we have several remote clients
> in the field without SSMS or access to Internet.
>
>
> Hope someone can ,
>
> Casey
>

Uri,

Thanks for the reply, I have the full SSMS installed..

Casey

On Jul 14, 2:00pm, "Uri Dimant" <u...@iscar.co.il> wrote:
> casy
> It will be much easier if download and install SSMS of Express Edition
>
> "casy" <mailke...@gmail.com> wrote in message
>
> news:48ff8ab5-80d7-4316-ab98-4d072ef786be@m3g2000hsc.googlegroups.com...
>
> > Hi All,
>

> > Couple of days ago my Express User Instances stopped working, this I

> > think, after a Windows Update. All of my data connections in Visual
> > Studio also disappeared!
>
> > Using XP, Sql 2005, and SQL Express, VS 2008.
>
> > Is there a way (SP) to find out if the user instances are currently
> > enabled or not ? I can see the last (instance) connection was OK on
> > the 7th July. Would like to establish the cause and status before
> > trying to re-enable by sp_configure , we have several remote clients
> > in the field without SSMS or access to Internet.
>
> > Hope someone can ,
>
> > Casey

casy
Now that you got SSMS , see whether SQL Server Services are running or
not. Also , check ERROR.LOG to see any entries since that worked.

I hope you had deafult trace enabled as well , so you can see what happened
just before something happened
SELECT * FROM sys.traces

---change log_98.trc to your file name
SELECT * FROM

fn_trace_gettable('c:\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\log_98.trc',
default)


"casy" <mailkerry@gmail.com> wrote in message
news:ae031509-b279-45a5-be38-5f9766deccf9@34g2000hsh.googlegroups.com...
Uri,

Thanks for the reply, I have the full SSMS installed..

Casey

On Jul 14, 2:00 pm, "Uri Dimant" <u...@iscar.co.il> wrote:
> casy
> It will be much easier if download and install SSMS of Express Edition
>
> "casy" <mailke...@gmail.com> wrote in message
>
> news:48ff8ab5-80d7-4316-ab98-4d072ef786be@m3g2000hsc.googlegroups.com...
>
> > Hi All,
>

> > Couple of days ago my Express User Instances stopped working, this I

> > think, after a Windows Update. All of my data connections in Visual
> > Studio also disappeared!
>
> > Using XP, Sql 2005, and SQL Express, VS 2008.
>
> > Is there a way (SP) to find out if the user instances are currently
> > enabled or not ? I can see the last (instance) connection was OK on
> > the 7th July. Would like to establish the cause and status before
> > trying to re-enable by sp_configure , we have several remote clients
> > in the field without SSMS or access to Internet.
>
> > Hope someone can ,
>
> > Casey

Hello Uri,

Nothing of interest inthe logs only error 15383 and the same user
message that user instances are disabled...

Casey

On Jul 14, 2:27pm, "Uri Dimant" <u...@iscar.co.il> wrote:
> casy
> Now that you got SSMS , see whether SQL Server Services are running or
> not. Also , check ERROR.LOG to see any entries since that worked.
>
> I hope you had deafult trace enabled as well , so you can see what happened
> just before something happened
> SELECT * FROM sys.traces
>
> ---change log_98.trc to your file name
> SELECT * FROM
>
> fn_trace_gettable('c:\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\log_98.trc',
> default)
>
> "casy" <mailke...@gmail.com> wrote in message
>
> news:ae031509-b279-45a5-be38-5f9766deccf9@34g2000hsh.googlegroups.com...
> Uri,
>
> Thanks for the reply, I have the full SSMS installed..
>
> Casey
>
> On Jul 14, 2:00 pm, "Uri Dimant" <u...@iscar.co.il> wrote:
>
> > casy
> > It will be much easier if download and install SSMS of Express Edition
>
> > "casy" <mailke...@gmail.com> wrote in message
>
> >news:48ff8ab5-80d7-4316-ab98-4d072ef786be@m3g2000hsc.googlegroups.com...
>
> > > Hi All,
>
> > > Couple of days ago my Express User Instances stopped working, this I
> > > think, after a Windows Update. All of my data connections in Visual
> > > Studio also disappeared!
>
> > > Using XP, Sql 2005, and SQL Express, VS 2008.
>
> > > Is there a way (SP) to find out if the user instances are currently
> > > enabled or not ? I can see the last (instance) connection was OK on
> > > the 7th July. Would like to establish the cause and status before
> > > trying to re-enable by sp_configure , we have several remote clients
> > > in the field without SSMS or access to Internet.
>
> > > Hope someone can ,
>
> > > Casey

Does anyone have any other ideas ?

On Jul 14, 3:50pm, casy <mailke...@gmail.com> wrote:
> Hello Uri,
>
> Nothing of interest inthe logs only error 15383 and the same user
> message that user instances are disabled...
>
> Casey
>
> On Jul 14, 2:27pm, "Uri Dimant" <u...@iscar.co.il> wrote:
>
> > casy
> > Now that you got SSMS , see whether SQL Server Services are running or
> > not. Also , check ERROR.LOG to see any entries since that worked.
>
> > I hope you had deafult trace enabled as well , so you can see what happened
> > just before something happened
> > SELECT * FROM sys.traces
>
> > ---change log_98.trc to your file name
> > SELECT * FROM
>
> > fn_trace_gettable('c:\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\log_98.trc',
> > default)
>
> > "casy" <mailke...@gmail.com> wrote in message
>
> >news:ae031509-b279-45a5-be38-5f9766deccf9@34g2000hsh.googlegroups.com...
> > Uri,
>
> > Thanks for the reply, I have the full SSMS installed..
>
> > Casey
>
> > On Jul 14, 2:00 pm, "Uri Dimant" <u...@iscar.co.il> wrote:
>
> > > casy
> > > It will be much easier if download and install SSMS of Express Edition
>
> > > "casy" <mailke...@gmail.com> wrote in message
>
> > >news:48ff8ab5-80d7-4316-ab98-4d072ef786be@m3g2000hsc.googlegroups.com....
>
> > > > Hi All,
>
> > > > Couple of days ago my Express User Instances stopped working, this I
> > > > think, after a Windows Update. All of my data connections in Visual
> > > > Studio also disappeared!
>
> > > > Using XP, Sql 2005, and SQL Express, VS 2008.
>
> > > > Is there a way (SP) to find out if the user instances are currently
> > > > enabled or not ? I can see the last (instance) connection was OK on
> > > > the 7th July. Would like to establish the cause and status before
> > > > trying to re-enable by sp_configure , we have several remote clients
> > > > in the field without SSMS or access to Internet.
>
> > > > Hope someone can ,
>
> > > > Casey

I have the same problem and did a post in another group this morning without
a response. My problem server is Windows Server 2000. I have a server with
W2K3 and there a copy of the db works fine.
Here is a copy of my post, for what it is worth.
-------------------------------------------------
A client has a web server with a site where access is controlled via the
"System.Web.Security.SqlMembershipProvider" running on a copy of sqlexpress
dedicated to this function. It has been working without change for over a
year until sometime between early June (the last time anyone logged in) and
yesterday. The error message is:
Stack Trace:
[SqlException (0x80131904): Failed to generate a user instance of SQL Server
due to a failure in starting the process for the user instance. The
connection will be closed.]
And of course there is a lot more, but I think this is the important part.
**********************
http://localhost/ASP.NETWebAdminFile...Providers.aspx
The test from here establishes a connection.

Opening the database with Managemet Studio Express appears normal.
**********************
Google has a lot of incidences of this error but no clean solutions. One
suggestion was to remove the "User Instance=true" element from the
connection string, but this did not produce a change.
I uninstalled and reinstalled sqlexpress (moved it to a different drive). No
change

I deleted the sqlexpress directory from documents and settings, again no
change.
------------------------------------------------------------


Kal


"casy" <mailkerry@gmail.com> wrote in message
news:df549c8f-6c07-4a5b-9265-994cdc78869e@z72g2000hsb.googlegroups.com...
Does anyone have any other ideas ?

On Jul 14, 3:50 pm, casy <mailke...@gmail.com> wrote:
> Hello Uri,
>
> Nothing of interest inthe logs only error 15383 and the same user
> message that user instances are disabled...
>
> Casey
>
> On Jul 14, 2:27 pm, "Uri Dimant" <u...@iscar.co.il> wrote:
>
> > casy
> > Now that you got SSMS , see whether SQL Server Services are running or
> > not. Also , check ERROR.LOG to see any entries since that worked.
>
> > I hope you had deafult trace enabled as well , so you can see what
> > happened
> > just before something happened
> > SELECT * FROM sys.traces
>
> > ---change log_98.trc to your file name
> > SELECT * FROM
>
> > fn_trace_gettable('c:\Microsoft SQL
> > Server\MSSQL.1\MSSQL\LOG\log_98.trc',
> > default)
>
> > "casy" <mailke...@gmail.com> wrote in message
>
> >news:ae031509-b279-45a5-be38-5f9766deccf9@34g2000hsh.googlegroups.com...
> > Uri,
>
> > Thanks for the reply, I have the full SSMS installed..
>
> > Casey
>
> > On Jul 14, 2:00 pm, "Uri Dimant" <u...@iscar.co.il> wrote:
>
> > > casy
> > > It will be much easier if download and install SSMS of Express Edition
>
> > > "casy" <mailke...@gmail.com> wrote in message
>
> > >news:48ff8ab5-80d7-4316-ab98-4d072ef786be@m3g2000hsc.googlegroups.com...
>
> > > > Hi All,
>
> > > > Couple of days ago my Express User Instances stopped working, this I
> > > > think, after a Windows Update. All of my data connections in Visual
> > > > Studio also disappeared!
>
> > > > Using XP, Sql 2005, and SQL Express, VS 2008.
>
> > > > Is there a way (SP) to find out if the user instances are currently
> > > > enabled or not ? I can see the last (instance) connection was OK on
> > > > the 7th July. Would like to establish the cause and status before
> > > > trying to re-enable by sp_configure , we have several remote clients
> > > > in the field without SSMS or access to Internet.
>
> > > > Hope someone can ,
>
> > > > Casey

Thanks for the input Kai,

I have had to re-enable the user instances using SP_configure, but the
original concern is still there as I still do not have an answer why/
how they became "disabled", and with clients in the field its a worry.

Is it a June service pack issue?

Casey

On Jul 17, 9:03am, "Kal" <K...@community.nospam> wrote:
> I have the same problem and did a post in another group this morning without
> a response. My problem server is Windows Server 2000. I have a server with
> W2K3 and there a copy of the db works fine.
> Here is a copy of my post, for what it is worth.
> -------------------------------------------------
> A client has a web server with a site where access is controlled via the
> "System.Web.Security.SqlMembershipProvider" running on a copy of sqlexpress
> dedicated to this function. It has been working without change for over a
> year until sometime between early June (the last time anyone logged in) and
> yesterday. The error message is:
> Stack Trace:
> [SqlException (0x80131904): Failed to generate a user instance of SQL Server
> due to a failure in starting the process for the user instance. The
> connection will be closed.]
> And of course there is a lot more, but I think this is the important part..
> **********************http://localhost/ASP.NETWebAdminFile...onsolidatedPro...
> The test from here establishes a connection.
>
> Opening the database with Managemet Studio Express appears normal.
> **********************
> Google has a lot of incidences of this error but no clean solutions. One
> suggestion was to remove the "User Instance=true" element from the
> connection string, but this did not produce a change.
> I uninstalled and reinstalled sqlexpress (moved it to a different drive).No
> change
>
> I deleted the sqlexpress directory from documents and settings, again no
> change.
> ------------------------------------------------------------
>
> Kal
>
> "casy" <mailke...@gmail.com> wrote in message
>
> news:df549c8f-6c07-4a5b-9265-994cdc78869e@z72g2000hsb.googlegroups.com...
> Does anyone have any other ideas ?
>
> On Jul 14, 3:50 pm, casy <mailke...@gmail.com> wrote:
>
> > Hello Uri,
>
> > Nothing of interest inthe logs only error 15383 and the same user
> > message that user instances are disabled...
>
> > Casey
>
> > On Jul 14, 2:27 pm, "Uri Dimant" <u...@iscar.co.il> wrote:
>
> > > casy
> > > Now that you got SSMS , see whether SQL Server Services are running or
> > > not. Also , check ERROR.LOG to see any entries since that worked.
>
> > > I hope you had deafult trace enabled as well , so you can see what
> > > happened
> > > just before something happened
> > > SELECT * FROM sys.traces
>
> > > ---change log_98.trc to your file name
> > > SELECT * FROM
>
> > > fn_trace_gettable('c:\Microsoft SQL
> > > Server\MSSQL.1\MSSQL\LOG\log_98.trc',
> > > default)
>
> > > "casy" <mailke...@gmail.com> wrote in message
>
> > >news:ae031509-b279-45a5-be38-5f9766deccf9@34g2000hsh.googlegroups.com....
> > > Uri,
>
> > > Thanks for the reply, I have the full SSMS installed..
>
> > > Casey
>
> > > On Jul 14, 2:00 pm, "Uri Dimant" <u...@iscar.co.il> wrote:
>
> > > > casy
> > > > It will be much easier if download and install SSMS of Express Edition
>
> > > > "casy" <mailke...@gmail.com> wrote in message
>
> > > >news:48ff8ab5-80d7-4316-ab98-4d072ef786be@m3g2000hsc.googlegroups.com...
>
> > > > > Hi All,
>
> > > > > Couple of days ago my Express User Instances stopped working, this I
> > > > > think, after a Windows Update. All of my data connections in Visual
> > > > > Studio also disappeared!
>
> > > > > Using XP, Sql 2005, and SQL Express, VS 2008.
>
> > > > > Is there a way (SP) to find out if the user instances are currently
> > > > > enabled or not ? I can see the last (instance) connection was OK on
> > > > > the 7th July. Would like to establish the cause and status before
> > > > > trying to re-enable by sp_configure , we have several remote clients
> > > > > in the field without SSMS or access to Internet.
>
> > > > > Hope someone can ,
>
> > > > > Casey

The SP_configure trick did nothing for me.

I suspect one of the updates also, but it is not happening on a different
server (W2K3 though) with identical application and the same database. I
have already invested quite a few hours in trying to find this and am about
to change to a standard connection string access. An MS rep is working with
me on it so if we come up with anything I will let you know.

Kal

"casy" <mailkerry@gmail.com> wrote in message
news:f15b939b-ff31-4987-9a94-d870c2fe9210@c58g2000hsc.googlegroups.com...
Thanks for the input Kai,

I have had to re-enable the user instances using SP_configure, but the
original concern is still there as I still do not have an answer why/
how they became "disabled", and with clients in the field its a worry.

Is it a June service pack issue?

Casey

On Jul 17, 9:03 am, "Kal" <K...@community.nospam> wrote:
> I have the same problem and did a post in another group this morning
> without
> a response. My problem server is Windows Server 2000. I have a server with
> W2K3 and there a copy of the db works fine.
> Here is a copy of my post, for what it is worth.
> -------------------------------------------------
> A client has a web server with a site where access is controlled via the
> "System.Web.Security.SqlMembershipProvider" running on a copy of
> sqlexpress
> dedicated to this function. It has been working without change for over a
> year until sometime between early June (the last time anyone logged in)
> and
> yesterday. The error message is:
> Stack Trace:
> [SqlException (0x80131904): Failed to generate a user instance of SQL
> Server
> due to a failure in starting the process for the user instance. The
> connection will be closed.]
> And of course there is a lot more, but I think this is the important part.
> **********************http://localhost/ASP.NETWebAdminFile...onsolidatedPro...
> The test from here establishes a connection.
>
> Opening the database with Managemet Studio Express appears normal.
> **********************
> Google has a lot of incidences of this error but no clean solutions. One
> suggestion was to remove the "User Instance=true" element from the
> connection string, but this did not produce a change.
> I uninstalled and reinstalled sqlexpress (moved it to a different drive).
> No
> change
>
> I deleted the sqlexpress directory from documents and settings, again no
> change.
> ------------------------------------------------------------
>
> Kal
>
> "casy" <mailke...@gmail.com> wrote in message
>
> news:df549c8f-6c07-4a5b-9265-994cdc78869e@z72g2000hsb.googlegroups.com...
> Does anyone have any other ideas ?
>
> On Jul 14, 3:50 pm, casy <mailke...@gmail.com> wrote:
>
> > Hello Uri,
>
> > Nothing of interest inthe logs only error 15383 and the same user
> > message that user instances are disabled...
>
> > Casey
>
> > On Jul 14, 2:27 pm, "Uri Dimant" <u...@iscar.co.il> wrote:
>
> > > casy
> > > Now that you got SSMS , see whether SQL Server Services are running or
> > > not. Also , check ERROR.LOG to see any entries since that worked.
>
> > > I hope you had deafult trace enabled as well , so you can see what
> > > happened
> > > just before something happened
> > > SELECT * FROM sys.traces
>
> > > ---change log_98.trc to your file name
> > > SELECT * FROM
>
> > > fn_trace_gettable('c:\Microsoft SQL
> > > Server\MSSQL.1\MSSQL\LOG\log_98.trc',
> > > default)
>
> > > "casy" <mailke...@gmail.com> wrote in message
>
> > >news:ae031509-b279-45a5-be38-5f9766deccf9@34g2000hsh.googlegroups.com...
> > > Uri,
>
> > > Thanks for the reply, I have the full SSMS installed..
>
> > > Casey
>
> > > On Jul 14, 2:00 pm, "Uri Dimant" <u...@iscar.co.il> wrote:
>
> > > > casy
> > > > It will be much easier if download and install SSMS of Express
> > > > Edition
>
> > > > "casy" <mailke...@gmail.com> wrote in message
>
> > > >news:48ff8ab5-80d7-4316-ab98-4d072ef786be@m3g2000hsc.googlegroups.com...
>
> > > > > Hi All,
>
> > > > > Couple of days ago my Express User Instances stopped working, this
> > > > > I
> > > > > think, after a Windows Update. All of my data connections in
> > > > > Visual
> > > > > Studio also disappeared!
>
> > > > > Using XP, Sql 2005, and SQL Express, VS 2008.
>
> > > > > Is there a way (SP) to find out if the user instances are
> > > > > currently
> > > > > enabled or not ? I can see the last (instance) connection was OK
> > > > > on
> > > > > the 7th July. Would like to establish the cause and status before
> > > > > trying to re-enable by sp_configure , we have several remote
> > > > > clients
> > > > > in the field without SSMS or access to Internet.
>
> > > > > Hope someone can ,
>
> > > > > Casey

Hi again,

I once again deleted the aspnet sqlexpress directory and rebooted the
server. Whether it was this or one of the other changes, including running
sp_configure to disable and renable user instances, I do not know. But it is
working once again.

Kal

"Kal" <KalK@community.nospam> wrote in message
news:uvD$7GE6IHA.4596@TK2MSFTNGP03.phx.gbl...
> The SP_configure trick did nothing for me.
>
> I suspect one of the updates also, but it is not happening on a different
> server (W2K3 though) with identical application and the same database. I
> have already invested quite a few hours in trying to find this and am
> about to change to a standard connection string access. An MS rep is
> working with me on it so if we come up with anything I will let you know.
>
> Kal
>
> "casy" <mailkerry@gmail.com> wrote in message
> news:f15b939b-ff31-4987-9a94-d870c2fe9210@c58g2000hsc.googlegroups.com...
> Thanks for the input Kai,
>
> I have had to re-enable the user instances using SP_configure, but the
> original concern is still there as I still do not have an answer why/
> how they became "disabled", and with clients in the field its a worry.
>
> Is it a June service pack issue?
>
> Casey
>
> On Jul 17, 9:03 am, "Kal" <K...@community.nospam> wrote:
>> I have the same problem and did a post in another group this morning
>> without
>> a response. My problem server is Windows Server 2000. I have a server
>> with
>> W2K3 and there a copy of the db works fine.
>> Here is a copy of my post, for what it is worth.
>> -------------------------------------------------
>> A client has a web server with a site where access is controlled via the
>> "System.Web.Security.SqlMembershipProvider" running on a copy of
>> sqlexpress
>> dedicated to this function. It has been working without change for over a
>> year until sometime between early June (the last time anyone logged in)
>> and
>> yesterday. The error message is:
>> Stack Trace:
>> [SqlException (0x80131904): Failed to generate a user instance of SQL
>> Server
>> due to a failure in starting the process for the user instance. The
>> connection will be closed.]
>> And of course there is a lot more, but I think this is the important
>> part.
>> **********************http://localhost/ASP.NETWebAdminFile...onsolidatedPro...
>> The test from here establishes a connection.
>>
>> Opening the database with Managemet Studio Express appears normal.
>> **********************
>> Google has a lot of incidences of this error but no clean solutions. One
>> suggestion was to remove the "User Instance=true" element from the
>> connection string, but this did not produce a change.
>> I uninstalled and reinstalled sqlexpress (moved it to a different drive).
>> No
>> change
>>
>> I deleted the sqlexpress directory from documents and settings, again no
>> change.
>> ------------------------------------------------------------
>>
>> Kal
>>
>> "casy" <mailke...@gmail.com> wrote in message
>>
>> news:df549c8f-6c07-4a5b-9265-994cdc78869e@z72g2000hsb.googlegroups.com...
>> Does anyone have any other ideas ?
>>
>> On Jul 14, 3:50 pm, casy <mailke...@gmail.com> wrote:
>>
>> > Hello Uri,
>>
>> > Nothing of interest inthe logs only error 15383 and the same user
>> > message that user instances are disabled...
>>
>> > Casey
>>
>> > On Jul 14, 2:27 pm, "Uri Dimant" <u...@iscar.co.il> wrote:
>>
>> > > casy
>> > > Now that you got SSMS , see whether SQL Server Services are running
>> > > or
>> > > not. Also , check ERROR.LOG to see any entries since that worked.
>>
>> > > I hope you had deafult trace enabled as well , so you can see what
>> > > happened
>> > > just before something happened
>> > > SELECT * FROM sys.traces
>>
>> > > ---change log_98.trc to your file name
>> > > SELECT * FROM
>>
>> > > fn_trace_gettable('c:\Microsoft SQL
>> > > Server\MSSQL.1\MSSQL\LOG\log_98.trc',
>> > > default)
>>
>> > > "casy" <mailke...@gmail.com> wrote in message
>>
>> > >news:ae031509-b279-45a5-be38-5f9766deccf9@34g2000hsh.googlegroups.com...
>> > > Uri,
>>
>> > > Thanks for the reply, I have the full SSMS installed..
>>
>> > > Casey
>>
>> > > On Jul 14, 2:00 pm, "Uri Dimant" <u...@iscar.co.il> wrote:
>>
>> > > > casy
>> > > > It will be much easier if download and install SSMS of Express
>> > > > Edition
>>
>> > > > "casy" <mailke...@gmail.com> wrote in message
>>
>> > > >news:48ff8ab5-80d7-4316-ab98-4d072ef786be@m3g2000hsc.googlegroups.com...
>>
>> > > > > Hi All,
>>
>> > > > > Couple of days ago my Express User Instances stopped working,
>> > > > > this I
>> > > > > think, after a Windows Update. All of my data connections in
>> > > > > Visual
>> > > > > Studio also disappeared!
>>
>> > > > > Using XP, Sql 2005, and SQL Express, VS 2008.
>>
>> > > > > Is there a way (SP) to find out if the user instances are
>> > > > > currently
>> > > > > enabled or not ? I can see the last (instance) connection was OK
>> > > > > on
>> > > > > the 7th July. Would like to establish the cause and status before
>> > > > > trying to re-enable by sp_configure , we have several remote
>> > > > > clients
>> > > > > in the field without SSMS or access to Internet.
>>
>> > > > > Hope someone can ,
>>
>> > > > > Casey
>

I am writing an application that relies on SQL Express User Instances.
I have also run into this issue and am very interested in know what
causes this error. I have seen this issue on our build machine that has
very little user intervention. From all of the logs, it does not appear
anything in particular caused this error. Has anyone seen a response
out there that points to the cause of this?

Thanks in advance.



*** Sent via Developersdex http://www.developersdex.com ***

Just returned to my SQl Express app, first time since my last post and
"voila" its happened again, the user instances were disabled,

Anyone at MS have any ideas on this ???

casy


On Jul 26, 12:21am, Justin Richmond <golg...@yahoo.com> wrote:
> I am writing an application that relies on SQL ExpressUserInstances.
> I have also run into this issue and am very interested in know what
> causes this error. I have seen this issue on our build machine that has
> very littleuserintervention. From all of the logs, it does not appear
> anything in particular caused this error. Has anyone seen a response
> out there that points to the cause of this?
>
> Thanks in advance.
>
> *** Sent via Developersdexhttp://www.developersdex.com***

What does this yield?

USE master;
GO
EXEC sp_configure 'user instances enabled';




"casy" <mailkerry@gmail.com> wrote in message
news:b1178f6d-2f9f-4052-ba6f-e249354d9f46@k37g2000hsf.googlegroups.com...
Just returned to my SQl Express app, first time since my last post and
"voila" its happened again, the user instances were disabled,

Anyone at MS have any ideas on this ???

casy


On Jul 26, 12:21 am, Justin Richmond <golg...@yahoo.com> wrote:
> I am writing an application that relies on SQL ExpressUserInstances.
> I have also run into this issue and am very interested in know what
> causes this error. I have seen this issue on our build machine that has
> very littleuserintervention. From all of the logs, it does not appear
> anything in particular caused this error. Has anyone seen a response
> out there that points to the cause of this?
>
> Thanks in advance.
>
> *** Sent via Developersdexhttp://www.developersdex.com***

user instances enabled min= 0 max= 1 configvalue=1 runvalue=1

This is after I have run sp_configure to re-enable

Casey

On Jul 31, 6:16pm, "Aaron Bertrand [SQL Server MVP]"
<ten....@dnartreb.noraa> wrote:
> What does this yield?
>
> USE master;
> GO
> EXEC sp_configure 'user instances enabled';
>
> "casy" <mailke...@gmail.com> wrote in message
>
> news:b1178f6d-2f9f-4052-ba6f-e249354d9f46@k37g2000hsf.googlegroups.com...
> Just returned to my SQl Express app, first time since my last post and
> "voila" its happened again, the user instances were disabled,
>
> Anyone at MS have any ideas on this ???
>
> casy
>
> On Jul 26, 12:21 am, Justin Richmond <golg...@yahoo.com> wrote:
>
> > I am writing an application that relies on SQL ExpressUserInstances.
> > I have also run into this issue and am very interested in know what
> > causes this error. I have seen this issue on our build machine that has
> > very littleuserintervention. From all of the logs, it does not appear
> > anything in particular caused this error. Has anyone seen a response
> > out there that points to the cause of this?
>
> > Thanks in advance.
>
> > *** Sent via Developersdexhttp://www.developersdex.com***

Well it seems like something is disabling them. Maybe you can run a
lightweight trace in the background, filtering on SP:Completed for
%sp_configure%...


On 7/31/08 2:04 PM, in article
001d6669-877c-422c-9ebe-79dc46eb2619...oglegroups.com, "casy"
<mailkerry@gmail.com> wrote:

>
> user instances enabled min= 0 max= 1 configvalue=1 runvalue=1
>
> This is after I have run sp_configure to re-enable
>
> Casey
>
> On Jul 31, 6:16pm, "Aaron Bertrand [SQL Server MVP]"
> <ten....@dnartreb.noraa> wrote:
>> What does this yield?
>>
>> USE master;
>> GO
>> EXEC sp_configure 'user instances enabled';
>>
>> "casy" <mailke...@gmail.com> wrote in message
>>
>> news:b1178f6d-2f9f-4052-ba6f-e249354d9f46@k37g2000hsf.googlegroups.com...
>> Just returned to my SQl Express app, first time since my last post and
>> "voila" its happened again, the user instances were disabled,
>>
>> Anyone at MS have any ideas on this ???
>>
>> casy
>>
>> On Jul 26, 12:21 am, Justin Richmond <golg...@yahoo.com> wrote:
>>
>>> I am writing an application that relies on SQL ExpressUserInstances.
>>> I have also run into this issue and am very interested in know what
>>> causes this error. I have seen this issue on our build machine that has
>>> very littleuserintervention. From all of the logs, it does not appear
>>> anything in particular caused this error. Has anyone seen a response
>>> out there that points to the cause of this?
>>
>>> Thanks in advance.
>>
>>> *** Sent via Developersdexhttp://www.developersdex.com***
>

OK will do, and report back with any result
Casey
On Jul 31, 8:29pm, "Aaron Bertrand [SQL Server MVP]"
<ten....@dnartreb.noraa> wrote:
> Well it seems like something is disabling them. Maybe you can run a
> lightweight trace in the background, filtering on SP:Completed for
> %sp_configure%...
>
> On 7/31/08 2:04 PM, in article
> 001d6669-877c-422c-9ebe-79dc46eb2...@e39g2000hsf.googlegroups.com, "casy"
>
> <mailke...@gmail.com> wrote:
>
> > user instances enabled min= 0 max= 1 configvalue=1 runvalue=1
>
> > This is after I have run sp_configure to re-enable
>
> > Casey
>
> > On Jul 31, 6:16pm, "Aaron Bertrand [SQL Server MVP]"
> > <ten....@dnartreb.noraa> wrote:
> >> What does this yield?
>
> >> USE master;
> >> GO
> >> EXEC sp_configure 'user instances enabled';
>
> >> "casy" <mailke...@gmail.com> wrote in message
>
> >>news:b1178f6d-2f9f-4052-ba6f-e249354d9f46@k37g2000hsf.googlegroups.com....
> >> Just returned to my SQl Express app, first time since my last post and
> >> "voila" its happened again, the user instances were disabled,
>
> >> Anyone at MS have any ideas on this ???
>
> >> casy
>
> >> On Jul 26, 12:21 am, Justin Richmond <golg...@yahoo.com> wrote:
>
> >>> I am writing an application that relies on SQL ExpressUserInstances.
> >>> I have also run into this issue and am very interested in know what
> >>> causes this error. I have seen this issue on our build machine that has
> >>> very littleuserintervention. From all of the logs, it does not appear
> >>> anything in particular caused this error. Has anyone seen a response
> >>> out there that points to the cause of this?
>
> >>> Thanks in advance.
>
> >>> *** Sent via Developersdexhttp://www.developersdex.com***

Sorry, I did not notice the new posts.

Mine was not disabled when I ran tha way back when. It is still working.

Kal
"casy" <mailkerry@gmail.com> wrote in message
news:f6169a79-1695-4716-95ce-d35269b66270@p25g2000hsf.googlegroups.com...
OK will do, and report back with any result
Casey
On Jul 31, 8:29 pm, "Aaron Bertrand [SQL Server MVP]"
<ten....@dnartreb.noraa> wrote:
> Well it seems like something is disabling them. Maybe you can run a
> lightweight trace in the background, filtering on SP:Completed for
> %sp_configure%...
>
> On 7/31/08 2:04 PM, in article
> 001d6669-877c-422c-9ebe-79dc46eb2...@e39g2000hsf.googlegroups.com, "casy"
>
> <mailke...@gmail.com> wrote:
>
> > user instances enabled min= 0 max= 1 configvalue=1 runvalue=1
>
> > This is after I have run sp_configure to re-enable
>
> > Casey
>
> > On Jul 31, 6:16 pm, "Aaron Bertrand [SQL Server MVP]"
> > <ten....@dnartreb.noraa> wrote:
> >> What does this yield?
>
> >> USE master;
> >> GO
> >> EXEC sp_configure 'user instances enabled';
>
> >> "casy" <mailke...@gmail.com> wrote in message
>
> >>news:b1178f6d-2f9f-4052-ba6f-e249354d9f46@k37g2000hsf.googlegroups.com...
> >> Just returned to my SQl Express app, first time since my last post and
> >> "voila" its happened again, the user instances were disabled,
>
> >> Anyone at MS have any ideas on this ???
>
> >> casy
>
> >> On Jul 26, 12:21 am, Justin Richmond <golg...@yahoo.com> wrote:
>
> >>> I am writing an application that relies on SQL ExpressUserInstances.
> >>> I have also run into this issue and am very interested in know what
> >>> causes this error. I have seen this issue on our build machine that
> >>> has
> >>> very littleuserintervention. From all of the logs, it does not appear
> >>> anything in particular caused this error. Has anyone seen a response
> >>> out there that points to the cause of this?
>
> >>> Thanks in advance.
>
> >>> *** Sent via Developersdexhttp://www.developersdex.com***