Extracting Sql: instaled

Showing posts with label instaled. Show all posts

Monday, March 26, 2012

Failed to generate a user instance of SQL Server

Hello Everyone,
I have instaled SQLExpress September on my Windows Server 2003 Standard.
and I work on a windows XP SP2 for development using Visual studio Web Edition (Beta2) which comes with sql server 2005 too.
I've built my application and tested it on my computer and everything went fine.
But When I copied the application to the server, it showed the following error:

"Failed to generate a user instance of SQL Server due to failure in retrieving the user's local application data path. Please make sure the user has a local user profile on the computer. The connection will be closed.

Exception Details: System.Data.SqlClient.SqlException: Failed to generate a user instance of SQL Server due to failure in retrieving the user's local application data path. Please make sure the user has a local user profile on the computer. The connection will be closed."

I've read alot of threads but it doesn't seem that any of them deals with my problem.

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

|||Dear Sir,
Thanks for your reply, but I'm using Windows server 2003 Web Edition on my server.|||

While I might be suggesting the obvious, but have you checked what the error suggests?

What account SQL Server is running under? If it is a user account, does it have a user profile?

If you create an app that just connects to a SQL Server instance, does it work?

|||

Q:have you checked what the error suggests?
A:what I wrote in the first message was what I got as a suggestion
Q:What account SQL Server is running under?
A:I connect using the administrator account.
Q:does it have a user profile?
A:To be honest with you,
Second, SQL Server connects using "Network Service"
The error suggests checking the local user profile, I've checked it, it only shows profile1.
Q:If it is a user account, does it have a user profile?
A:Yes its a user account,about user profile it has one, but do I need to do any extra configs especially for SQL express?
Q:If you create an app that just connects to a SQL Server instance, does it work?
A:when I create one through VS2005 and start it from VS it works fine, but when I copy it to the inetpub location it shows the error. strange!

Boris Bon thanks for trying to help, I appreciate it... Smile but still no solution

|||

Dennis,

The reason for the error your are seeing is that the account under which you are trying to create a user instance of SQL Express does not have a local profile on the server. The error message suggests verifying this.

To fix this you either need to locally login using that account or adjust your impersonation settings on the application or modify the connection string.

When you are working in VS you are using an account which does have a local profile, so this problem does not exist. When however, you copy the application to the Intepub folder you are starting to run application in a different user context, thus the problem.

Describe your application in greater detail. Is it ASP.NET app? Does it use impersonation? Is the IIS server on the same machine where you develop the application? How does you connection string look like? How do you change it when you move the application?

You misunderstood my previous questions.

Account SQL Server running under is not the same thing as the account you use to connect to SQL Server. Apparently, you are running SQL Server as NETWORK SERVICE. Next, profile1 looks like a hardware profile, not a user profile, what you need to check is User profiles on Advanced Tab of System properties.

You may also want to look in the error log to understand what account it tries to create a user instance under.

Boris.

|||

Well, I was able to solve my problem as follows:
I checked my IIS Application pool that my domain uses, it appeare that I it was using an account that doesn't have a local user profile, so I changed the Application pool Identity to local system and it started working...
Thanks for everyone that has been trying to help...

|||

i did try to change "IIS Admin" Windows service to run as administrator, which has a local user profile, but it still didn't work in my case (running iis on xp professional, IIS version 5.0)

Sorry, i am new to IIS and SQl server 2005, can anyone give further help on this issue? I really want to make my app. run on IIS, it ran ok on VS 2005 though.

Thanks in advance!

|||

Dear mw2005,

Do you have service pack 2 installed on your windows XP? its a requirement for working with SQL Server 2005, to view all the requirements:

http://www.microsoft.com/sql/editions/express/sysreqs.mspx

|||

Hi, DennisCIS,

Yes, I have xp SP2 installed, I had to install it first before I can install VWD 2005. I may have missed something, it didn't work for me.

Regards,

mw2005

|||

Anyone made it work under IIS 5.x + XP SP2 environment? or do I have to upgrade to Windows 2003 Server env.?

One interesting thing is that I changed my application to use "Local impersonation", the error of "Failed to generate a user instance of SQL Server ... " is gone, but I got the other error instead as follows, I still didn't make it run on IIS 5.x + XP SP2 environment, I ran out of ideas now, if anyone could give a helping hand, it'd be very much appreciated.

Object reference not set to an instance of an object.

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.NullReferenceException: Object reference not set to an instance of an object.
Source Error:

Line 13: SiteMapNode temp; Line 14: temp = SiteMap.CurrentNode.Clone(true); Line 15: Uri u = new Uri(e.Context.Request.Url.ToString()); Line 16: temp.Url += u.Query; Line 17: if (temp.ParentNode != null) {

Source File: c:\my_apps\test1\Global.asax Line: 15

|||Were you able to resolve this? I am running into the same problem. I am using the personal site starter kit for VS2005 Express running on PWS on XP sp2. Any assitance you can offer would be appreciated. Thanks. My email is: igaydos @. ptd dot net|||I had this problem with the Commerce Starter Kit, running XP SP2. I changed the connection strings for both the SQLExpress DBs by setting the User Instance=False (was true). This sorted it out for development... I'll probably get into trouble with deployment like earlier in this thread, but I'll cross that bridge when I get there.|||

I've had to add new line to my connection string in web.config file to fix the problem:

Then the IIS application pool I used an acount that has a local user profile (local system is an example) but this could make a security hole in your system.

Hope this was helpful

|||FYI: I get this error when the other computer on my home network (2 computers total) is turned on. It works fine when the other computer is turned off. This other computer is not used remotely (or in any way) with my SQL Server Express / VB 2005 Express application.

Failed to generate a user instance of SQL Server

"Failed to generate a user instance of SQL Server due to failure in retrieving the user's local application data path. Please make sure the user has a local user profile on the computer. The connection will be closed.

I've read alot of threads but it doesn't seem that any of them deals with my problem.

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

|||Dear Sir,
Thanks for your reply, but I'm using Windows server 2003 Web Edition on my server.|||

While I might be suggesting the obvious, but have you checked what the error suggests?

What account SQL Server is running under? If it is a user account, does it have a user profile?

If you create an app that just connects to a SQL Server instance, does it work?

|||

Boris Bon thanks for trying to help, I appreciate it... Smile but still no solution

|||

Dennis,

To fix this you either need to locally login using that account or adjust your impersonation settings on the application or modify the connection string.

You misunderstood my previous questions.

You may also want to look in the error log to understand what account it tries to create a user instance under.

Boris.

|||

i did try to change "IIS Admin" Windows service to run as administrator, which has a local user profile, but it still didn't work in my case (running iis on xp professional, IIS version 5.0)

Sorry, i am new to IIS and SQl server 2005, can anyone give further help on this issue? I really want to make my app. run on IIS, it ran ok on VS 2005 though.

Thanks in advance!

|||

Dear mw2005,

Do you have service pack 2 installed on your windows XP? its a requirement for working with SQL Server 2005, to view all the requirements:

http://www.microsoft.com/sql/editions/express/sysreqs.mspx

|||

Hi, DennisCIS,

Yes, I have xp SP2 installed, I had to install it first before I can install VWD 2005. I may have missed something, it didn't work for me.

Regards,

mw2005

|||

Anyone made it work under IIS 5.x + XP SP2 environment? or do I have to upgrade to Windows 2003 Server env.?

Object reference not set to an instance of an object.

Line 13: SiteMapNode temp;Line 14: temp = SiteMap.CurrentNode.Clone(true);
Line 15: Uri u = new Uri(e.Context.Request.Url.ToString());
Line 16: temp.Url += u.Query;
Line 17: if (temp.ParentNode != null) {

Source File: c:\my_apps\test1\Global.asax Line: 15

I've had to add new line to my connection string in web.config file to fix the problem:

Then the IIS application pool I used an acount that has a local user profile (local system is an example) but this could make a security hole in your system.

Hope this was helpful

Failed to generate a user instance of SQL Server

"Failed to generate a user instance of SQL Server due to failure in retrieving the user's local application data path. Please make sure the user has a local user profile on the computer. The connection will be closed.

I've read alot of threads but it doesn't seem that any of them deals with my problem.

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

|||Dear Sir,
Thanks for your reply, but I'm using Windows server 2003 Web Edition on my server.|||

While I might be suggesting the obvious, but have you checked what the error suggests?

What account SQL Server is running under? If it is a user account, does it have a user profile?

If you create an app that just connects to a SQL Server instance, does it work?

|||

Boris Bon thanks for trying to help, I appreciate it... Smile but still no solution

|||

Dennis,

To fix this you either need to locally login using that account or adjust your impersonation settings on the application or modify the connection string.

You misunderstood my previous questions.

You may also want to look in the error log to understand what account it tries to create a user instance under.

Boris.

|||

i did try to change "IIS Admin" Windows service to run as administrator, which has a local user profile, but it still didn't work in my case (running iis on xp professional, IIS version 5.0)

Sorry, i am new to IIS and SQl server 2005, can anyone give further help on this issue? I really want to make my app. run on IIS, it ran ok on VS 2005 though.

Thanks in advance!

|||

Dear mw2005,

Do you have service pack 2 installed on your windows XP? its a requirement for working with SQL Server 2005, to view all the requirements:

http://www.microsoft.com/sql/editions/express/sysreqs.mspx

|||

Hi, DennisCIS,

Yes, I have xp SP2 installed, I had to install it first before I can install VWD 2005. I may have missed something, it didn't work for me.

Regards,

mw2005

|||

Anyone made it work under IIS 5.x + XP SP2 environment? or do I have to upgrade to Windows 2003 Server env.?

Object reference not set to an instance of an object.

Line 13: SiteMapNode temp;Line 14: temp = SiteMap.CurrentNode.Clone(true);
Line 15: Uri u = new Uri(e.Context.Request.Url.ToString());
Line 16: temp.Url += u.Query;
Line 17: if (temp.ParentNode != null) {

Source File: c:\my_apps\test1\Global.asax Line: 15

I've had to add new line to my connection string in web.config file to fix the problem:

Then the IIS application pool I used an acount that has a local user profile (local system is an example) but this could make a security hole in your system.

Hope this was helpful

Failed to generate a user instance of SQL Server

"Failed to generate a user instance of SQL Server due to failure in retrieving the user's local application data path. Please make sure the user has a local user profile on the computer. The connection will be closed.

I've read alot of threads but it doesn't seem that any of them deals with my problem.

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

|||Dear Sir,
Thanks for your reply, but I'm using Windows server 2003 Web Edition on my server.|||

While I might be suggesting the obvious, but have you checked what the error suggests?

What account SQL Server is running under? If it is a user account, does it have a user profile?

If you create an app that just connects to a SQL Server instance, does it work?

|||

Boris Bon thanks for trying to help, I appreciate it... Smile but still no solution

|||

Dennis,

To fix this you either need to locally login using that account or adjust your impersonation settings on the application or modify the connection string.

You misunderstood my previous questions.

You may also want to look in the error log to understand what account it tries to create a user instance under.

Boris.

|||

i did try to change "IIS Admin" Windows service to run as administrator, which has a local user profile, but it still didn't work in my case (running iis on xp professional, IIS version 5.0)

Sorry, i am new to IIS and SQl server 2005, can anyone give further help on this issue? I really want to make my app. run on IIS, it ran ok on VS 2005 though.

Thanks in advance!

|||

Dear mw2005,

Do you have service pack 2 installed on your windows XP? its a requirement for working with SQL Server 2005, to view all the requirements:

http://www.microsoft.com/sql/editions/express/sysreqs.mspx

|||

Hi, DennisCIS,

Yes, I have xp SP2 installed, I had to install it first before I can install VWD 2005. I may have missed something, it didn't work for me.

Regards,

mw2005

|||

Anyone made it work under IIS 5.x + XP SP2 environment? or do I have to upgrade to Windows 2003 Server env.?

Object reference not set to an instance of an object.

Line 13: SiteMapNode temp; Line 14: temp = SiteMap.CurrentNode.Clone(true); Line 15: Uri u = new Uri(e.Context.Request.Url.ToString()); Line 16: temp.Url += u.Query; Line 17: if (temp.ParentNode != null) {

Source File: c:\my_apps\test1\Global.asax Line: 15

I've had to add new line to my connection string in web.config file to fix the problem:

Then the IIS application pool I used an acount that has a local user profile (local system is an example) but this could make a security hole in your system.

Hope this was helpful

Failed to generate a user instance of SQL Server

"Failed to generate a user instance of SQL Server due to failure in retrieving the user's local application data path. Please make sure the user has a local user profile on the computer. The connection will be closed.

I've read alot of threads but it doesn't seem that any of them deals with my problem.

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

|||Dear Sir,
Thanks for your reply, but I'm using Windows server 2003 Web Edition on my server.|||

While I might be suggesting the obvious, but have you checked what the error suggests?

What account SQL Server is running under? If it is a user account, does it have a user profile?

If you create an app that just connects to a SQL Server instance, does it work?

|||

Boris Bon thanks for trying to help, I appreciate it... Smile but still no solution

|||

Dennis,

To fix this you either need to locally login using that account or adjust your impersonation settings on the application or modify the connection string.

You misunderstood my previous questions.

You may also want to look in the error log to understand what account it tries to create a user instance under.

Boris.

|||

i did try to change "IIS Admin" Windows service to run as administrator, which has a local user profile, but it still didn't work in my case (running iis on xp professional, IIS version 5.0)

Sorry, i am new to IIS and SQl server 2005, can anyone give further help on this issue? I really want to make my app. run on IIS, it ran ok on VS 2005 though.

Thanks in advance!

|||

Dear mw2005,

Do you have service pack 2 installed on your windows XP? its a requirement for working with SQL Server 2005, to view all the requirements:

http://www.microsoft.com/sql/editions/express/sysreqs.mspx

|||

Hi, DennisCIS,

Yes, I have xp SP2 installed, I had to install it first before I can install VWD 2005. I may have missed something, it didn't work for me.

Regards,

mw2005

|||

Anyone made it work under IIS 5.x + XP SP2 environment? or do I have to upgrade to Windows 2003 Server env.?

Object reference not set to an instance of an object.

Line 13: SiteMapNode temp; Line 14: temp = SiteMap.CurrentNode.Clone(true); Line 15: Uri u = new Uri(e.Context.Request.Url.ToString()); Line 16: temp.Url += u.Query; Line 17: if (temp.ParentNode != null) {

Source File: c:\my_apps\test1\Global.asax Line: 15

I've had to add new line to my connection string in web.config file to fix the problem:

Then the IIS application pool I used an acount that has a local user profile (local system is an example) but this could make a security hole in your system.

Hope this was helpful

Monday, March 12, 2012

Fail to uninstall SQLServer 2005

I can't uninstall a default instance of SQLServer 2005.

i have instaled a MSDE2000 then i uninstall it and when a try to uninstall the default instance of SQLServer2005 a have a error the log following:

Instance Name = MSSQLSERVER
Trying to find install through Instance Name
Install Type = 1
If possible, determine action
Failed to determine installSkuId due to property load failure.SKU is set to SKU_EXPRESS.
Source File Name: datastore\cachedpropertycollection.cpp
Compiler Timestamp: Wed Oct 26 16:37:20 2005
Function Name: CachedPropertyCollection::findProperty
Source Line Number: 130
-
Failed to find property "InstallSku" {"SetupStateScope", "", ""} in cache
Source File Name: datastore\propertycollection.cpp
Compiler Timestamp: Wed Oct 26 16:37:21 2005
Function Name: SetupStateScope.InstallSku
Source Line Number: 44
-
No collector registered for scope: "SetupStateScope"
Machine = EMILIO, Article = WMIServiceWin32OSWorking, Result = 0 (0x0)
Machine = EMILIO, Article = WMIServiceWin32CompSystemWorking, Result = 0 (0x0)
Machine = EMILIO, Article = WMIServiceWin32ProcessorWorking, Result = 0 (0x0)
Machine = EMILIO, Article = WMIServiceReadRegWorking, Result = 0 (0x0)
Machine = EMILIO, Article = WMIServiceWin32DirectoryWorking, Result = 0 (0x0)
Machine = EMILIO, Article = WMIServiceCIMDataWorking, Result = 0 (0x0)
Machine = EMILIO, Article = XMLDomDocument, Result = 0 (0x0)
Failed to determine installSkuId due to property load failure.SKU is set to SKU_EXPRESS.
Source File Name: datastore\cachedpropertycollection.cpp
Compiler Timestamp: Wed Oct 26 16:37:20 2005
Function Name: CachedPropertyCollection::findProperty
Source Line Number: 130
-
Failed to find property "InstallSku" {"SetupStateScope", "", ""} in cache
Source File Name: datastore\propertycollection.cpp
Compiler Timestamp: Wed Oct 26 16:37:21 2005
Function Name: SetupStateScope.InstallSku
Source Line Number: 44
-
No collector registered for scope: "SetupStateScope"
Machine = EMILIO, Article = Processor, Result = 0 (0x0)
Machine = EMILIO, Article = PhysicalMemory, Result = 0 (0x0)
Machine = EMILIO, Article = DiskFreeSpace, Result = 0 (0x0)
Machine = EMILIO, Article = OSVersion, Result = 0 (0x0)
Machine = EMILIO, Article = OSServicePack, Result = 0 (0x0)
Machine = EMILIO, Article = OSType, Result = 0 (0x0)
Machine = EMILIO, Article = AdminShare, Result = 0 (0x0)
Machine = EMILIO, Article = PendingReboot, Result = 0 (0x0)
Machine = EMILIO, Article = IEVersion, Result = 0 (0x0)
Machine = EMILIO, Article = DriveWriteAccess, Result = 0 (0x0)
Machine = EMILIO, Article = COMPlus, Result = 0 (0x0)
Machine = EMILIO, Article = ASPNETVersionRegistration, Result = 0 (0x0)
Machine = EMILIO, Article = MDAC25Version, Result = 0 (0x0)
Machine = EMILIO, Article = SKUUpgrade, Result = 0 (0x0)

HOW I CAN RESOLVED THE PROBLEM THKS,

Emilio Ferreira

How are you trying to uninstall? Through Add/Remove Programs or through command line? If it is command line, can you share out your cmd line call?

Thanks,
Samuel Lester (MSFT)

|||

i try Through Add/Remove Programs.

Thks,

Emilio Ferreira

(MCAD.NET)

|||

I have the same problem when using Add/Remove programs on a customer computer. Any idea on how to get it to unisntall?

Eric Renken

|||Hi,

Did anyone find a fix for this as we are experiencing the same error here?

"Failed to determine installSkuId due to property load failure."

Any help is much appreciated

Iain

|||

You can try to manually uninstall SQL Server 2005. Detail steps please refer to "How to uninstall an instance of SQL Server 2005 manually http://support.microsoft.com/kb/909967".

Fail to uninstall SQLServer 2005

I can't uninstall a default instance of SQLServer 2005.

i have instaled a MSDE2000 then i uninstall it and when a try to uninstall the default instance of SQLServer2005 a have a error the log following:

HOW I CAN RESOLVED THE PROBLEM THKS,

Emilio Ferreira

How are you trying to uninstall? Through Add/Remove Programs or through command line? If it is command line, can you share out your cmd line call?

Thanks,
Samuel Lester (MSFT)

|||

i try Through Add/Remove Programs.

Thks,

Emilio Ferreira

(MCAD.NET)

|||

I have the same problem when using Add/Remove programs on a customer computer. Any idea on how to get it to unisntall?

Eric Renken

|||Hi,

Did anyone find a fix for this as we are experiencing the same error here?

"Failed to determine installSkuId due to property load failure."

Any help is much appreciated

Iain

|||

You can try to manually uninstall SQL Server 2005. Detail steps please refer to "How to uninstall an instance of SQL Server 2005 manually http://support.microsoft.com/kb/909967".

Fail to uninstall SQLServer 2005

I can't uninstall a default instance of SQLServer 2005.

i have instaled a MSDE2000 then i uninstall it and when a try to uninstall the default instance of SQLServer2005 a have a error the log following:

HOW I CAN RESOLVED THE PROBLEM THKS,

Emilio Ferreira

How are you trying to uninstall? Through Add/Remove Programs or through command line? If it is command line, can you share out your cmd line call?

Thanks,
Samuel Lester (MSFT)

|||

i try Through Add/Remove Programs.

Thks,

Emilio Ferreira

(MCAD.NET)

|||

I have the same problem when using Add/Remove programs on a customer computer. Any idea on how to get it to unisntall?

Eric Renken

|||Hi,

Did anyone find a fix for this as we are experiencing the same error here?

"Failed to determine installSkuId due to property load failure."

Any help is much appreciated

Iain

|||

You can try to manually uninstall SQL Server 2005. Detail steps please refer to "How to uninstall an instance of SQL Server 2005 manually http://support.microsoft.com/kb/909967".

Fail to uninstall SQLServer 2005

I can't uninstall a default instance of SQLServer 2005.

i have instaled a MSDE2000 then i uninstall it and when a try to uninstall the default instance of SQLServer2005 a have a error the log following:

HOW I CAN RESOLVED THE PROBLEM THKS,

Emilio Ferreira

How are you trying to uninstall? Through Add/Remove Programs or through command line? If it is command line, can you share out your cmd line call?

Thanks,
Samuel Lester (MSFT)

|||

i try Through Add/Remove Programs.

Thks,

Emilio Ferreira

(MCAD.NET)

|||

I have the same problem when using Add/Remove programs on a customer computer. Any idea on how to get it to unisntall?

Eric Renken

|||Hi,

Did anyone find a fix for this as we are experiencing the same error here?

"Failed to determine installSkuId due to property load failure."

Any help is much appreciated

Iain

|||

You can try to manually uninstall SQL Server 2005. Detail steps please refer to "How to uninstall an instance of SQL Server 2005 manually http://support.microsoft.com/kb/909967".

Monday, March 26, 2012

Failed to generate a user instance of SQL Server

"Failed to generate a user instance of SQL Server due to failure in retrieving the user's local application data path. Please make sure the user has a local user profile on the computer. The connection will be closed.

Object reference not set to an instance of an object.

Failed to generate a user instance of SQL Server

"Failed to generate a user instance of SQL Server due to failure in retrieving the user's local application data path. Please make sure the user has a local user profile on the computer. The connection will be closed.

Object reference not set to an instance of an object.

Failed to generate a user instance of SQL Server

"Failed to generate a user instance of SQL Server due to failure in retrieving the user's local application data path. Please make sure the user has a local user profile on the computer. The connection will be closed.

Object reference not set to an instance of an object.

Failed to generate a user instance of SQL Server

"Failed to generate a user instance of SQL Server due to failure in retrieving the user's local application data path. Please make sure the user has a local user profile on the computer. The connection will be closed.

Object reference not set to an instance of an object.

Failed to generate a user instance of SQL Server

"Failed to generate a user instance of SQL Server due to failure in retrieving the user's local application data path. Please make sure the user has a local user profile on the computer. The connection will be closed.

Object reference not set to an instance of an object.

Monday, March 12, 2012

Fail to uninstall SQLServer 2005

Fail to uninstall SQLServer 2005

Fail to uninstall SQLServer 2005

Fail to uninstall SQLServer 2005

Extracting Sql

Blog Archive

About Me