Failed to generate a user instance of SQL Server

Hello all,
I unisntall products as it are recommended (VS 2005 and SQL Server 2005
beta 2) in readme.txt of MSDN products subscription...
I install VS 2005 Pro and I have no problem during install. Now, if I want to open database, I have this error mesage :
"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."

In MBSA report, I see that the folders of SQL doesn't contain another
account than Administrator and VS2005 users. I delete other accounts but the
problem is the same.

If I create a new project with a new database the problem is the same.

Have you an idea to solve this problem ?
Thank you very mutch.
Regards.
Patrice.

This is because of a known problem in Windows. See http://support.microsoft.com/default.aspx?scid=kb;en-us;896613 for more details.

Thanks

|||Thanks Paul; Thank you very mutch because this problem is not solved. I called Msdn support last week without solution after two hours to solve that. We have controlled VS, IIS and others.
Then, I uninstalled VS2005 with all products. I cleaned the registry and then install again VS2005 and SQL Express.
The problem is exactly the same. It seem that the solution is in the account of the Window user.

Sorry for my lack of english.

Thank you for your help.
Patrice.|||Try deleting the directory SQLEXPRESS (Or better rename it say SQLEXPRESS_).

It solved my problem. This directory is at following location...

C:\Documents and Settings\[USERNAME]\Local Settings\Application Data\Microsoft\Microsoft SQL Server Data\SQLEXPRESS

cheers!

Ref. http://forums.microsoft.com/msdn/showpost.aspx?postid=98346&siteid=1|||I was having the same problem and had tried the suggestions on this post with no results. I installed another instance of sql express and used the default instance name and that corrected the problem.
|||Hello,
Even your help and explanations I not solved my problem.
Now, I install SQL Server 2005.
I can attach the database : I use it, I create a new table; non problem here.
I create a connexion with the ODBC data source in Administrator tools in panel settings : Test connexion is OK.
But in VS 2005 I can't access to the database without this error with SQL Express or SQL Server !! :-((

I'm very hangry.

Thanks all.
Patrice.|||

Hello Pat84,
I got your problem yesterday, and I think I've solved it now.
You need to install the SQL Management Studio 2005 Express (CTD) first, create an account named "(YOUR)PC\ASPNET", subsitute (YOUR) with your PC's name. For me it's HENRYPC\ASPNET. Because VS Express will use this default account to access SQLEXPRESS's database.

Then create a database for the use of YOURPC\ASPNET with the help of Mgt Studio Express.
Then in your Visual Web Developer Express or Visual Studio, create a connection to the new database you just created. You need to select "SQL Server" as service provider, ".\SQLEXPRESS" as data source, and you will find your new database name as well as four system databases under the "select database". Then you test your connection. It will works!

Hope it helps! Good Luck,
Henry Li

|||

Thank you very mutch Henry !

I try that and I come back.

Regards.

Patrice.

|||You can get that error if your logging on using "Local Service". Try logging on using "Network Service", if you are not already.
Open the SQL Server Configuration Manager
Wtih the SQL Server 2005 Services node selected, right click SQL Server (SQLEXPRESS)
Select Properties
Make sure "Network Service" is selected
May need to reboot PC (not just restart the server).|||Sorry for that answer to be long. I was very ill...

Thank you all.

My problem is solved.

Patrice.

Failed to generate a user instance of SQL Server

Hello all,
I unisntall products as it are recommended (VS 2005 and SQL Server 2005
beta 2) in readme.txt of MSDN products subscription...
I install VS 2005 Pro and I have no problem during install. Now, if I want to open database, I have this error mesage :
"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."

In MBSA report, I see that the folders of SQL doesn't contain another
account than Administrator and VS2005 users. I delete other accounts but the
problem is the same.

If I create a new project with a new database the problem is the same.

Have you an idea to solve this problem ?
Thank you very mutch.
Regards.
Patrice.

This is because of a known problem in Windows. See http://support.microsoft.com/default.aspx?scid=kb;en-us;896613 for more details.

Thanks

|||Thanks Paul; Thank you very mutch because this problem is not solved. I called Msdn support last week without solution after two hours to solve that. We have controlled VS, IIS and others.
Then, I uninstalled VS2005 with all products. I cleaned the registry and then install again VS2005 and SQL Express.
The problem is exactly the same. It seem that the solution is in the account of the Window user.

Sorry for my lack of english.

Thank you for your help.
Patrice.|||Try deleting the directory SQLEXPRESS (Or better rename it say SQLEXPRESS_).

It solved my problem. This directory is at following location...

C:\Documents and Settings\[USERNAME]\Local Settings\Application Data\Microsoft\Microsoft SQL Server Data\SQLEXPRESS

cheers!

Ref. http://forums.microsoft.com/msdn/showpost.aspx?postid=98346&siteid=1|||I was having the same problem and had tried the suggestions on this post with no results. I installed another instance of sql express and used the default instance name and that corrected the problem.|||Hello,
Even your help and explanations I not solved my problem.
Now, I install SQL Server 2005.
I can attach the database : I use it, I create a new table; non problem here.
I create a connexion with the ODBC data source in Administrator tools in panel settings : Test connexion is OK.
But in VS 2005 I can't access to the database without this error with SQL Express or SQL Server !! :-((

I'm very hangry.

Thanks all.
Patrice.|||

Hello Pat84,
I got your problem yesterday, and I think I've solved it now.
You need to install the SQL Management Studio 2005 Express (CTD) first, create an account named "(YOUR)PC\ASPNET", subsitute (YOUR) with your PC's name. For me it's HENRYPC\ASPNET. Because VS Express will use this default account to access SQLEXPRESS's database.

Then create a database for the use of YOURPC\ASPNET with the help of Mgt Studio Express.
Then in your Visual Web Developer Express or Visual Studio, create a connection to the new database you just created. You need to select "SQL Server" as service provider, ".\SQLEXPRESS" as data source, and you will find your new database name as well as four system databases under the "select database". Then you test your connection. It will works!

Hope it helps! Good Luck,
Henry Li

|||

Thank you very mutch Henry !

I try that and I come back.

Regards.

Patrice.

|||You can get that error if your logging on using "Local Service". Try logging on using "Network Service", if you are not already.
Open the SQL Server Configuration Manager
Wtih the SQL Server 2005 Services node selected, right click SQL Server (SQLEXPRESS)
Select Properties
Make sure "Network Service" is selected
May need to reboot PC (not just restart the server).|||Sorry for that answer to be long. I was very ill...

Thank you all.

My problem is solved.

Patrice.sql

Failed to generate a user instance of SQL Server

Hello all,
I unisntall products as it are recommended (VS 2005 and SQL Server 2005
beta 2) in readme.txt of MSDN products subscription...
I install VS 2005 Pro and I have no problem during install. Now, if I want to open database, I have this error mesage :
"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."

In MBSA report, I see that the folders of SQL doesn't contain another
account than Administrator and VS2005 users. I delete other accounts but the
problem is the same.

If I create a new project with a new database the problem is the same.

Have you an idea to solve this problem ?
Thank you very mutch.
Regards.
Patrice.

This is because of a known problem in Windows. See http://support.microsoft.com/default.aspx?scid=kb;en-us;896613 for more details.

Thanks

|||Thanks Paul; Thank you very mutch because this problem is not solved. I called Msdn support last week without solution after two hours to solve that. We have controlled VS, IIS and others.
Then, I uninstalled VS2005 with all products. I cleaned the registry and then install again VS2005 and SQL Express.
The problem is exactly the same. It seem that the solution is in the account of the Window user.

Sorry for my lack of english.

Thank you for your help.
Patrice.|||Try deleting the directory SQLEXPRESS (Or better rename it say SQLEXPRESS_).

It solved my problem. This directory is at following location...

C:\Documents and Settings\[USERNAME]\Local Settings\Application Data\Microsoft\Microsoft SQL Server Data\SQLEXPRESS

cheers!

Ref. http://forums.microsoft.com/msdn/showpost.aspx?postid=98346&siteid=1|||I was having the same problem and had tried the suggestions on this post with no results. I installed another instance of sql express and used the default instance name and that corrected the problem.
|||Hello,
Even your help and explanations I not solved my problem.
Now, I install SQL Server 2005.
I can attach the database : I use it, I create a new table; non problem here.
I create a connexion with the ODBC data source in Administrator tools in panel settings : Test connexion is OK.
But in VS 2005 I can't access to the database without this error with SQL Express or SQL Server !! :-((

I'm very hangry.

Thanks all.
Patrice.|||

Hello Pat84,
I got your problem yesterday, and I think I've solved it now.
You need to install the SQL Management Studio 2005 Express (CTD) first, create an account named "(YOUR)PC\ASPNET", subsitute (YOUR) with your PC's name. For me it's HENRYPC\ASPNET. Because VS Express will use this default account to access SQLEXPRESS's database.

Then create a database for the use of YOURPC\ASPNET with the help of Mgt Studio Express.
Then in your Visual Web Developer Express or Visual Studio, create a connection to the new database you just created. You need to select "SQL Server" as service provider, ".\SQLEXPRESS" as data source, and you will find your new database name as well as four system databases under the "select database". Then you test your connection. It will works!

Hope it helps! Good Luck,
Henry Li

|||

Thank you very mutch Henry !

I try that and I come back.

Regards.

Patrice.

|||You can get that error if your logging on using "Local Service". Try logging on using "Network Service", if you are not already.
Open the SQL Server Configuration Manager
Wtih the SQL Server 2005 Services node selected, right click SQL Server (SQLEXPRESS)
Select Properties
Make sure "Network Service" is selected
May need to reboot PC (not just restart the server).|||Sorry for that answer to be long. I was very ill...

Thank you all.

My problem is solved.

Patrice.

Failed to enumerate changes in filtered articles

HI, I have configured merge replication with pull subscription on sql server2000 and subscribers running personall sql server 2000. Subscribers connect through VPN. The application written in VB6 was working properly since 4 months with minor replication
problems.
A few days ago we rebuilt the publication. All subscribers got their initial snapshots succesfully while connected with UTP cables. From that time on everytime they try to synchronize through VPN they upload their changes but they can't download changes f
rom the Publisher. They receive the message:
Failed to enumerate changes in the filtered articles.
Coll. Code: x80045063=x80040000 + 20579
{call sp_MSsetupbelongs(?,?,?,?,?,1,?,?,1,?,?,?,?)}
Coll. Code: 0
Incorrect syntax near the keyword 'where'.
Coll.Code: x9C=156
Incorrect syntax near the keyword 'and'.
Coll.Code: x9C=156
We checked our join filters and everything seems OK.
Next a subscriber synchronized with UTP cable (instead of VPN) and it worked! But still everyone trying to synchronize through VPN gets the same error. We increased the timeout of the merge agent but the problem is still there.
Do anyone have found real solution for this problem?
Thanks a lot for your help!!!
Tony,
there are scant details on this on the MS site:
http://msdn.microsoft.com/library/de...odbc_72pl.asp.
The main suggestion is to increase the timeout, which you have already done.
There is a recorded error - http://support.microsoft.com/?id=814916 - which
details a fix, and hopefully this is relevant. Also, rerunning the merge
agent often fixes these issues. If none of this helps, then a PSS call might
be required.
HTH,
Paul Ibison
|||place your merge agent in an infinite loop. Most of the time the failure to
enumerate changes are solved the next time the merge agent runs.
Could you possible post your publication and table schema's here?
Could you also do logging to try to isolate which article is problematic?
http://support.microsoft.com/default...b;EN-US;312292
"Paul Ibison" <Paul.Ibison@.Pygmalion.Com> wrote in message
news:uP3$BWuLEHA.2612@.TK2MSFTNGP10.phx.gbl...
> Tony,
> there are scant details on this on the MS site:
>
http://msdn.microsoft.com/library/de...odbc_72pl.asp.
> The main suggestion is to increase the timeout, which you have already
done.
> There is a recorded error - http://support.microsoft.com/?id=814916 -
which
> details a fix, and hopefully this is relevant. Also, rerunning the merge
> agent often fixes these issues. If none of this helps, then a PSS call
might
> be required.
> HTH,
> Paul Ibison
>
|||Dear Paul and Hilary thank you for your advise. We used the Microsoft Hot Fix of the KB Article Number: 814916 and it fixed our problem.
|||Thanks for the update Tony, I'll update my knowledgebase with this.
Paul
|||Could you mail that hotfix to me ?
please send it to: jk@.bestpriceeu.com
Kind regards
Janus
"Tony2000" <anonymous@.discussions.microsoft.com> wrote in message
news:45730017-39D9-445C-B71C-1B828916F5D2@.microsoft.com...
> Dear Paul and Hilary thank you for your advise. We used the Microsoft Hot
Fix of the KB Article Number: 814916 and it fixed our problem.
>
|||Could you e-mail that hotfix to me too?
please send it to this adress: iulian1978@.yahoo.com
Thank you
Julian
"Janus Knudsen" wrote:

> Could you mail that hotfix to me ?
>
> please send it to: jk@.bestpriceeu.com
> Kind regards
> Janus
> "Tony2000" <anonymous@.discussions.microsoft.com> wrote in message
> news:45730017-39D9-445C-B71C-1B828916F5D2@.microsoft.com...
> Fix of the KB Article Number: 814916 and it fixed our problem.
>
>
|||I have the same probleme here and tried everything but was unable to fix it. Could someone please send me the hotfix to this account? renx@.siol.net
Regards,
Andrej Renko, developer|||Oooh please, could someone send me the hotfix?
asolbesg@.capgemini.es
Thanks in advance.sql

failed to connect to the server

When I have a subscription built for a report it runs at the time expected, but the report send via e-mail fails. I can run the report from a client workstation just fine. I can also run it from the admin tool fine too, it just will not run as part of a subscription. The full context of the error message is as follows:

Failure sending mail: The transport failed to connect to the server

This is not my first Reporting services report, but I am trying to replace all Crystal reports with Reporting services reports and this functionality is greatly needed.

Thanks! - Eric-

The error is telling you the RS server cannot connect to the Mail server. Make sure that the unattended execution account is setup and is a user that has access to the mail server.

Here is a link to help you.

http://msdn2.microsoft.com/en-us/library/ms155851.aspx