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.

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.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... 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:

<connectionStrings>
<remove name="LocalSqlServer"/>
<add name="LocalSqlServer" connectionString="Data Source=.\SQLExpress;Integrated Security=True;User Instance=True;AttachDBFilename=|DataDirectory|aspnetdb.mdf"/>

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

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.

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.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... 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:

<connectionStrings>
<remove name="LocalSqlServer"/>
<add name="LocalSqlServer" connectionString="Data Source=.\SQLExpress;Integrated Security=True;User Instance=True;AttachDBFilename=|DataDirectory|aspnetdb.mdf"/>

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

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.

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.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... 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:

<connectionStrings>
<remove name="LocalSqlServer"/>
<add name="LocalSqlServer" connectionString="Data Source=.\SQLExpress;Integrated Security=True;User Instance=True;AttachDBFilename=|DataDirectory|aspnetdb.mdf"/>

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

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.

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.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... 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:

<connectionStrings>
<remove name="LocalSqlServer"/>
<add name="LocalSqlServer" connectionString="Data Source=.\SQLExpress;Integrated Security=True;User Instance=True;AttachDBFilename=|DataDirectory|aspnetdb.mdf"/>

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

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.

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.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... 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:

<connectionStrings>
<remove name="LocalSqlServer"/>
<add name="LocalSqlServer" connectionString="Data Source=.\SQLExpress;Integrated Security=True;User Instance=True;AttachDBFilename=|DataDirectory|aspnetdb.mdf"/>

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.sql

Failed install of standard SQL 2005 server on XP

I have an issue with trying to install SQL 2005 standard on my XP machine.

I get an .hta file that is not readable and when I btpass that I get a pop-up message:

please go to the control panel to install and configure system components.

WTH?

PLease assist....

Gene

Is your XP on Service Pack 2?|||Yes, I am completely up to date with all of my SP's and patches.|||

I did not relize this but this was a simple fix.

All I had to do was go into the SQL disk was to open it up and execute the Setup.exe instead of opening it up from the .hta file.

Fail to setup sql 2000 on win standard 2003

I can not install SQl 2000 on my new win 2003 server.
It says: setup failed to configure the server.
What should I do?

This is my Sqlstp.log file

01:51:11 Begin Setup
01:51:11 8.00.194
01:51:11 Mode = Normal
01:51:11 ModeType = NORMAL
01:51:11 GetDefinitionEx returned: 0, Extended: 0x0
01:51:11 ValueFTS returned: 1
01:51:11 ValuePID returned: 1
01:51:11 ValueLic returned: 1
01:51:11 System: Windows NT Terminal Server
01:51:11 SQL Server ProductType: Standard Edition [0x2]
01:51:11 Begin Action: SetupInitialize
01:51:11 End Action SetupInitialize
01:51:11 Begin Action: SetupInstall
01:51:11 Reading Software\Microsoft\Windows\CurrentVersion\CommonFi

lesDir ...
01:51:11 CommonFilesDir=C:\Program Files\Common Files
01:51:11 Windows Directory=C:\WINDOWS\
01:51:11 Program Files=C:\Program Files\
01:51:11 TEMPDIR=C:\WINDOWS\TEMP\
01:51:11 Begin Action: SetupInstall
01:51:11 digpid size : 256
01:51:11 digpid size : 164
01:51:11 Begin Action: CheckFixedRequirements
01:51:11 Platform ID: 0xf00
01:51:11 Version: 5.2.3790
01:51:11 File Version - C:\WINDOWS\system32\shdocvw.dll: 6.0.3790.94
01:51:11 End Action: CheckFixedRequirements
01:51:11 Begin Action: ShowDialogs
01:51:11 Initial Dialog Mask: 0x183000f7, Disable Back=0x1
01:51:11 Begin Action ShowDialogsHlpr: 0x1
01:51:11 Begin Action: DialogShowSdWelcome
01:51:12 End Action DialogShowSdWelcome
01:51:12 Dialog 0x1 returned: 1
01:51:12 End Action ShowDialogsHlpr
01:51:12 ShowDialogsGetDialog returned: nCurrent=0x2,index=1
01:51:12 Begin Action ShowDialogsHlpr: 0x2
01:51:12 Begin Action: DialogShowSdMachineName
01:51:14 ShowDlgMachine returned: 1
01:51:14 Name = ETOUCHHOST, Type = 0x1
01:51:14 Begin Action: CheckRequirements
01:51:14 Processor Architecture: x86 (Pentium)
01:51:14 ComputerName: ETOUCHHOST
01:51:14 User Name: Administrator
01:51:14 IsAllAccessAllowed returned: 1
01:51:14 OS Language: 0xc09
01:51:14 End Action CheckRequirements
01:51:14 This combination of Package and Operating System allows a full product install.
01:51:14 CreateSetupTopology(ETOUCHHOST), Handle : 0x1134168, returned : 0
01:51:14 CreateSetupTopology returned : 0, Handle : 0x1134168
01:51:14 Topology Type : 1, Return Value : 0
01:51:14 ST_GetPhysicalNode returned : 0, PNHandle : 0x11341b8
01:51:14 PN_EnumerateEx returned : 0
01:51:14 PN_GetSQLStates returned : 0, SqlStates : 0x0
01:51:14 PN_StartScan [0x11341b8] returned : 0
01:51:14 PN_GetNext [0x11341b8] returned : 18, Handle: [0x0]
01:51:14 No more items in enumeration.
01:51:14 ReleaseSetupTopology
01:51:14 Named instance limit: 100, quota: 0
01:51:14 End Action DialogShowSdMachineName
01:51:14 begin ShowDialogsUpdateMask
01:51:14 nFullMask = 0x183000f7, nCurrent = 0x2, nDirection = 0
01:51:14 Updated Dialog Mask: 0xbf00037, Disable Back = 0x1
01:51:14 Dialog 0x2 returned: 0
01:51:14 End Action ShowDialogsHlpr
01:51:14 ShowDialogsGetDialog returned: nCurrent=0x4,index=2
01:51:14 Begin Action ShowDialogsHlpr: 0x4
01:51:14 Begin Action: DialogShowSdInstallMode
01:51:15 ShowDlgInstallMode returned: 1
01:51:15 InstallMode : 0x1
01:51:15 End Action DialogShowSdInstallMode
01:51:15 begin ShowDialogsUpdateMask
01:51:15 nFullMask = 0xbf00037, nCurrent = 0x4, nDirection = 1
01:51:15 Updated Dialog Mask: 0x1bf40037, Disable Back = 0x1
01:51:15 Dialog 0x4 returned: 1
01:51:15 End Action ShowDialogsHlpr
01:51:15 ShowDialogsGetDialog returned: nCurrent=0x10,index=4
01:51:15 Begin Action ShowDialogsHlpr: 0x10
01:51:15 Begin Action: DialogShowSdRegisterUserEx
01:51:24 End Action DialogShowSdRegisterUserEx
01:51:24 Dialog 0x10 returned: 1
01:51:24 End Action ShowDialogsHlpr
01:51:24 ShowDialogsGetDialog returned: nCurrent=0x20,index=5
01:51:24 Begin Action ShowDialogsHlpr: 0x20
01:51:24 Begin Action: DialogShowSdLicense
01:51:27 End Action DialogShowSdLicense
01:51:27 Dialog 0x20 returned: 1
01:51:27 End Action ShowDialogsHlpr
01:51:27 ShowDialogsGetDialog returned: nCurrent=0x40000,index=18
01:51:27 Begin Action ShowDialogsHlpr: 0x40000
01:51:27 Begin Action: DialogShowSdCliSvr
01:51:27 DisplaySystemPreReq
01:51:28 ShowDlgClientServerSelect returned: 1
01:51:28 Type : 0x2
01:51:28 End Action DialogShowSdCliSvr
01:51:28 begin ShowDialogsUpdateMask
01:51:28 nFullMask = 0x1bf40037, nCurrent = 0x40000, nDirection = 1
01:51:28 Updated Dialog Mask: 0x1bfc0037, Disable Back = 0x1
01:51:28 Dialog 0x40000 returned: 1
01:51:28 End Action ShowDialogsHlpr
01:51:28 ShowDialogsGetDialog returned: nCurrent=0x80000,index=19
01:51:28 Begin Action ShowDialogsHlpr: 0x80000
01:51:28 Begin Action: DialogShowSdInstanceName
01:51:28 Begin Action: ShowDlgInstanceName
01:51:29 End Action: ShowDlgInstanceName
01:51:29 ShowDlgInstanceName returned : 1
01:51:29 InstanceName : MSSQLSERVER
01:51:29 CreateSetupTopology(ETOUCHHOST), Handle : 0x1134730, returned : 0
01:51:29 CreateSetupTopology returned : 0, Handle : 0x1134730
01:51:29 Topology Type : 1, Return Value : 0
01:51:29 ST_GetPhysicalNode returned : 0, PNHandle : 0x11341b8
01:51:29 PN_EnumerateEx returned : 0
01:51:29 PN_GetSQLStates returned : 0, SqlStates : 0x0
01:51:29 PN_StartScan [0x11341b8] returned : 0
01:51:29 PN_GetNext [0x11341b8] returned : 18, Handle: [0x0]
01:51:29 No more items in enumeration.
01:51:29 ReleaseSetupTopology
01:51:29 End Action DialogShowSdInstanceName
01:51:29 begin ShowDialogsUpdateMask
01:51:29 nFullMask = 0x1bfc0037, nCurrent = 0x80000, nDirection = 1
01:51:29 Updated Dialog Mask: 0x1bfc0037, Disable Back = 0x1
01:51:29 Dialog 0x80000 returned: 1
01:51:29 End Action ShowDialogsHlpr
01:51:29 ShowDialogsGetDialog returned: nCurrent=0x100000,index=20
01:51:29 Begin Action ShowDialogsHlpr: 0x100000
01:51:29 Begin Action: DialogShowSdSetupType
01:51:29 Begin Action: Setup Type
01:51:31 SQL program folder: C:\Program Files\Microsoft SQL Server
01:51:31 SQL data folder: C:\Program Files\Microsoft SQL Server
01:51:31 Windows system folder: C:\WINDOWS\system32\
01:51:31 Prog req: 38205, Data req: 34432, Sys req: 182917
01:51:31 Prog avail: 73899760, Data avail: 73899760, Sys avail: 73899760
01:51:31 Prog req vs. avail, 255554, 73899760
01:51:31 Data req vs. avail, 34432, 73899760
01:51:31 Sys req vs. avail, 217349, 73899760
01:51:31 DisplaySystemPreReq
01:51:31 [SetupTypeSQL]
01:51:31 szDir = C:\Program Files\Microsoft SQL Server
01:51:31 szDir = %PROGRAMFILES%\Microsoft SQL Server
01:51:31 Result = 301
01:51:31 szDataDir = C:\Program Files\Microsoft SQL Server
01:51:31 szDataDir = %PROGRAMFILES%\Microsoft SQL Server
01:51:31 End Action: Setup Type
01:51:31 Setup Type: Typical (301)
01:51:31 End Action DialogShowSdSetupType
01:51:31 begin ShowDialogsUpdateMask
01:51:31 nFullMask = 0x1bfc0037, nCurrent = 0x100000, nDirection = 301
01:51:31 Updated Dialog Mask: 0x1bdc0037, Disable Back = 0x1
01:51:31 Dialog 0x100000 returned: 301
01:51:31 End Action ShowDialogsHlpr
01:51:31 ShowDialogsGetDialog returned: nCurrent=0x400000,index=22
01:51:31 Begin Action ShowDialogsHlpr: 0x400000
01:51:31 Begin Action: DlgServices
01:51:36 ShowDlgServices returned: 1
01:51:36 [DlgServices]
01:51:36 Local-Domain = 3855
01:51:36 AutoStart = 15
01:51:36 Result = 1
01:51:36 End Action DlgServices
01:51:36 begin ShowDialogsUpdateMask
01:51:36 nFullMask = 0x1bdc0037, nCurrent = 0x400000, nDirection = 1
01:51:36 Updated Dialog Mask: 0x1bdc0037, Disable Back = 0x1
01:51:36 Dialog 0x400000 returned: 1
01:51:36 End Action ShowDialogsHlpr
01:51:36 ShowDialogsGetDialog returned: nCurrent=0x800000,index=23
01:51:36 Begin Action ShowDialogsHlpr: 0x800000
01:51:36 Begin Action: DlgSQLSecurity
01:51:38 ShowDlgSQLSecurity returned: 1
01:51:38 LoginMode = 1,szPwd
01:51:38 End Action DlgSQLSecurity
01:51:38 begin ShowDialogsUpdateMask
01:51:38 nFullMask = 0x1bdc0037, nCurrent = 0x800000, nDirection = 1
01:51:38 Updated Dialog Mask: 0x1bdc0037, Disable Back = 0x1
01:51:38 Dialog 0x800000 returned: 1
01:51:38 End Action ShowDialogsHlpr
01:51:38 ShowDialogsGetDialog returned:nCurrent=0x1000000,index=24
01:51:38 Begin Action ShowDialogsHlpr: 0x1000000
01:51:38 Begin Action: DlgCollation
01:51:38 ShowDlgCollation returned: 1
01:51:38 collation_name = Latin1_General_CI_AS,locale_name = Latin1_General,lcid = 0xc09,SortId = 0,dwCompFlags = 0x30001
01:51:38 End Action DlgCollation
01:51:38 begin ShowDialogsUpdateMask
01:51:38 nFullMask = 0x1bdc0037, nCurrent = 0x1000000, nDirection = 1
01:51:38 Updated Dialog Mask: 0x1bdc0037, Disable Back = 0x1
01:51:38 Dialog 0x1000000 returned: 1
01:51:38 End Action ShowDialogsHlpr
01:51:38 ShowDialogsGetDialog returned: nCurrent=0x2000000,index=25
01:51:38 Begin Action ShowDialogsHlpr: 0x2000000
01:51:38 Begin Action: DlgNetwork
01:51:38 ShowDlgNetwork returned: 1
01:51:38 [DlgServerNetwork]
01:51:38 NetworkLibs = 255
01:51:38 TCPPort = 1433
01:51:38 TCPPrxy = Default
01:51:38 NMPPipeName = \\.\pipe\sql\query
01:51:38 Result = 1
01:51:38 End Action DlgNetwork
01:51:38 begin ShowDialogsUpdateMask
01:51:38 nFullMask = 0x1bdc0037, nCurrent = 0x2000000, nDirection = 1
01:51:38 Updated Dialog Mask: 0x1bdc0037, Disable Back = 0x1
01:51:38 Dialog 0x2000000 returned: 1
01:51:38 End Action ShowDialogsHlpr
01:51:38 ShowDialogsGetDialog returned: nCurrent=0x8000000,index=27
01:51:38 Begin Action ShowDialogsHlpr: 0x8000000
01:51:38 Begin Action: DialogShowSdStartCopy
01:51:38 End Action DialogShowSdStartCopy
01:51:38 begin ShowDialogsUpdateMask
01:51:38 nFullMask = 0x1bdc0037, nCurrent = 0x8000000, nDirection = 1
01:51:38 Updated Dialog Mask: 0x1bdc0037, Disable Back = 0x1
01:51:38 Dialog 0x8000000 returned: 1
01:51:38 End Action ShowDialogsHlpr
01:51:38 ShowDialogsGetDialog returned: nCurrent=0x10000000,index=28
01:51:38 Begin Action ShowDialogsHlpr: 0x10000000
01:51:38 Begin Action: DialogShowSdLicenseMode
01:51:40 ShowDlgLicense returned: 1
01:51:40 ShowDlgLicense returned: LicenseMode = 0, LicenseLimit = 5
01:51:40 End Action DialogShowSdLicenseMode
01:51:40 Dialog 0x10000000 returned: 1
01:51:40 End Action ShowDialogsHlpr
01:51:40 ShowDialogsGetDialog returned: nCurrent=0x0,index=0
01:51:40 End Action ShowDialogs
01:51:40 Begin Action ProcessBeforeDataMove:
01:51:40 DeinstallStart returned (C:\Program Files\Microsoft SQL Server\MSSQL): 0
01:51:40 End Action ProcessBeforeDataMove:
01:51:40 Begin Action SetToolsComponentSelection:
01:51:40 End Action SetToolsComponentSelection:
01:51:40 Begin Action ProcessComponentSelection:
01:51:40 End Action ProcessComponentSelection
01:51:40 Begin Action LogSelectedComponents:
01:51:40 SQLProg
01:51:40 SQLProg\SQLServr
01:51:40 SQLProg\SQLServr\Help
01:51:40 SQLProg\SQLServr\SCMDev
01:51:40 SQLProg\SQLServr\SCMDev\SCMh
01:51:40 SQLProg\SQLServr\SCMDev\SCMX86Lb
01:51:40 SQLProg\SQLServr\SCMDev\SCMALb
01:51:40 SQLProg\SQLServr\Rs1033
01:51:40 SQLProg\SQLServr\RsIntl
01:51:40 SQLProg\SQLServr\ActiveX
01:51:40 SQLProg\SQLServr\System
01:51:40 SQLProg\UpgTools
01:51:40 SQLProg\UpgTools\UpgSys
01:51:40 SQLProg\UpgTools\ActiveX
01:51:40 SQLProg\UpgTools\Res1033
01:51:40 SQLProg\UpgTools\ResOther
01:51:40 SQLProg\UpgTools\Resld
01:51:40 SQLProg\ReplSupp
01:51:40 SQLProg\ReplSupp\ReplDat
01:51:40 SQLProg\ReplSupp\RepComm
01:51:40 SQLProg\ReplSupp\RepNoDk
01:51:40 SQLProg\ReplSupp\ActiveX
01:51:40 SQLProg\Install
01:51:40 SQLProg\System
01:51:40 SQLProg\SvrExt
01:51:40 SQLProg\SvrExt\Help
01:51:40 SQLProg\SvrExt\SvrExtRs
01:51:40 SQLProg\SvrExt\ResIntl
01:51:40 SQLProg\Dat
01:51:40 SQLProg\DatSmpl
01:51:40 SQLProg\BaseSys
01:51:40 SQLProg\BaseBinn
01:51:40 SQLProg\MSSearch
01:51:40 SQLProg\MSSearch\Help
01:51:40 SQLProg\MSSearch\ActiveX
01:51:40 SQLProg\BaseInst
01:51:40 SQLProg\Symbols
01:51:40 SQLProg\Symbols\EXE
01:51:40 SQLProg\Symbols\DLL
01:51:40 SQLProg\Perfmon
01:51:40 SQLProg\Perfmon\System
01:51:40 SQLProg\Root
01:51:40 MgtTool
01:51:40 MgtTool\SEM
01:51:40 MgtTool\SEM\HTML
01:51:40 MgtTool\SEM\MSD98
01:51:40 MgtTool\SEM\MSD98SYS
01:51:40 MgtTool\SEM\MSD98Res
01:51:40 MgtTool\SEM\MSD98Hlp
01:51:40 MgtTool\SEM\Help
01:51:40 MgtTool\SEM\Res1033
01:51:40 MgtTool\SEM\ResIntl
01:51:40 MgtTool\SEM\MSD98RsI
01:51:40 MgtTool\SEM\ActiveX
01:51:40 MgtTool\SEM\ActiveX\Res1033
01:51:40 MgtTool\SEM\ActiveX\ResIntl
01:51:40 MgtTool\SEM\Scripts
01:51:40 MgtTool\SEM\OLEDB
01:51:40 MgtTool\SEM\OLEDB\Res1033
01:51:40 MgtTool\SEM\OLEDB\ResIntl
01:51:40 MgtTool\Profiler
01:51:40 MgtTool\Profiler\Help
01:51:40 MgtTool\Profiler\Res1033
01:51:40 MgtTool\Profiler\ResIntl
01:51:40 MgtTool\Qryanlz
01:51:40 MgtTool\Qryanlz\Help
01:51:40 MgtTool\Qryanlz\Res1033
01:51:40 MgtTool\Qryanlz\ResIntl
01:51:40 MgtTool\DTCCLi
01:51:40 MgtTool\Wzcnflct
01:51:40 MgtTool\Wzcnflct\WzcnHlp
01:51:40 MgtTool\Wzcnflct\Wzcn1033
01:51:40 MgtTool\Wzcnflct\WzcnOthr
01:51:40 MgtTool\Wzcnflct\WzcnCmn
01:51:40 MgtTool\UtilSys
01:51:40 MgtTool\UtilBinn
01:51:40 Connect
01:51:40 Connect\ConnSys
01:51:40 Books
01:51:40 Books\Bookso
01:51:40 Books\Bookso\Utils
01:51:40 DevTools
01:51:40 DevTools\Dbg Int
01:51:40 DevTools\Dbg Int\Dbg Int Common
01:51:40 DevTools\Dbg Int\EXE
01:51:40 CoreRepl
01:51:40 CoreRepl\Res1033
01:51:40 CoreRepl\ResIntl
01:51:40 Core
01:51:40 Core\Res1033
01:51:40 Core\ResOther
01:51:40 Repostry
01:51:40 Repostry\RepstSys
01:51:40 Repostry\Res1033
01:51:40 Repostry\ResIntl
01:51:40 CoreMisc
01:51:40 CoreMisc\ActiveX
01:51:40 CoreMisc\ActiveX\Res1033
01:51:40 CoreMisc\ActiveX\ResIntl
01:51:40 CoreMisc\Res1033
01:51:40 Monarch
01:51:40 Monarch\Monr1033
01:51:40 Monarch\MonrIntl
01:51:40 Jet
01:51:40 CoreInst
01:51:40 CoreCOM
01:51:40 CoreCOM\Res1033
01:51:40 CoreCOM\ResIntl
01:51:40 CoreTool
01:51:40 CoreTool\Res1033
01:51:40 CoreTool\ResOther
01:51:40 DBLibCli
01:51:40 SFExt
01:51:40 SFExt\ActiveX
01:51:40 SFExt\ActiveX\Res1033
01:51:40 SFExt\ActiveX\ResIntl
01:51:40 SFExt\Res1033
01:51:40 SFExt\ResIntl
01:51:40 Trace
01:51:40 Trace\Res1033
01:51:40 Trace\ResOther
01:51:40 MiscCore
01:51:40 MC
01:51:40 MC\MC1033
01:51:40 MC\MCIntl
01:51:40 MC\Help
01:51:40 SQLMgr
01:51:40 SQLMgr\Res1033
01:51:40 SQLMgr\ResIntl
01:51:40 SvrTool
01:51:40 SvrTool\Res1033
01:51:40 SvrTool\ResIntl
01:51:40 DTSUI
01:51:40 DTSUI\Res1033
01:51:40 DTSUI\ResIntl
01:51:40 MSOlap
01:51:40 MSOlap\Res1033
01:51:40 MSOlap\ResIntl
01:51:40 ATL
01:51:40 ATL\winnt
01:51:40 ATL\win9x
01:51:40 MFC42U
01:51:40 VC
01:51:40 VB
01:51:40 OCX1
01:51:40 SQLAdHlp
01:51:40 SQLAdHlp\Res1033
01:51:40 SQLAdHlp\ResOther
01:51:40 {E07FDDBE-5A21-11d2-9DAD-00C04F79D434}
01:51:40 {E07FDDC7-5A21-11d2-9DAD-00C04F79D434}
01:51:40 {E07FDDC0-5A21-11d2-9DAD-00C04F79D434}
01:51:40 {E07FDDBF-5A21-11d2-9DAD-00C04F79D434}
01:51:40 End Action LogSelectedComponents
01:51:40 Begin Action InstallPkgs:
01:51:40 Begin Action: Locked Connectivity Files Check
01:51:40 ConnectivityLocked returned: 0
01:51:40 The operation completed successfully.

01:51:40 End Action: Locked Connectivity Files Check
01:51:41 Setup is installing Microsoft Data Access Components (MDAC) ...
01:51:41 C:\INETPUB\FTPROOT\x86\Other\sqlredis.exe /q:a /C:"setupre.exe WARN=1 -s -SMS"
01:51:58 ExitCode: 0
01:51:58 Setup is installing Microsoft Distributed Transaction Coordinator (MSDTC) ...
01:51:58 C:\WINDOWS\TEMP\SqlSetup\Bin\cldtcstp.exe -SupportDir "C:\WINDOWS\TEMP\SqlSetup\Bin" -DTCPkg "C:\INETPUB\FTPROOT\x86\Other\dtcsetup.exe" -LogFile "C:\WINDOWS\sqlstp.log"
01:51:58 Process Exit Code: (0)
01:51:58 InstallMSSearch instance: MSSQLSERVER
01:51:58 Software\Microsoft\Search\Install:Version not present
01:51:58 MSSearch 2.0 or greater version check returned -1
01:51:58 Setup is installing the Microsoft Full-Text Search Engine ...
01:51:58 " C:\INETPUB\FTPROOT\x86\FullText\MSSearch\Search\Se

archStp.exe" /s /a:SQLServer
01:52:11 Process Exit Code: (0)
01:52:11 /Q:A /T:C:\WINDOWS\TEMP\ixp001.tmp
01:52:11 Setup is installing HTML Help ...
01:52:11 HTML Help installer exit code: 0
01:52:32 End Action InstallPkgs
01:52:32 Begin Action MoveFileData:
01:52:32 Enabled SELFREGISTERBATCH
01:52:32 Enabled CORECOMPONENTHANDLING
01:52:54 Begin Action: MoveFileDataSpecial|||01:52:55 End Action: MoveFileDataSpecial
01:52:55 End Action MoveFileData
01:52:55 Begin Action ProcessAfterDataMove:
01:52:55 C:\INETPUB\FTPROOT\x86\Binn\hhcol.exe C:\Program Files\Microsoft SQL Server\80\Tools\Books
01:52:55 End Action ProcessAfterDataMove
01:52:55 Begin Action BuildServer:
01:52:55 C:\WINDOWS\TEMP\SqlSetup\Bin\scm.exe -Silent 1 -Action 5 -ExePath "C:\Program Files\Microsoft SQL Server\MSSQL\binn\sqlservr.exe" -Service "MSSQLSERVER"
01:52:55 Process Exit Code: (0)
01:52:55 Begin Action: CreateRegistrySetSQL
01:52:55 End Action: CreateRegistrySetSQL
01:52:55 Begin Action: RegWriteSetupEntry
01:52:55 End Action: RegWriteSetupEntry
01:52:55 Begin Action: CreateSer
01:52:55 End Action: CreateSer
01:52:55 Begin Action: SkuIt
01:52:55 End Action: SkuIt
01:52:56 SetFileSecuritySQLAndAdmin for C:\Program Files\Microsoft SQL Server\MSSQL returned: 0, 0
01:52:56 SetRegSecuritySQLAndAdmin for Software\Microsoft\MSSQLServer\MSSQLServer returned: 0, 0
01:52:56 Begin Action: UpdateSystemPath
01:52:56 Path successfully updated.
01:52:56 %SystemRoot%\system32;%SystemRoot%;%SystemRoot%\Sy

stem32\Wbem;C:\Program Files\Microsoft SQL Server\80\Tools\BINN
01:52:56 End Action: UpdateSystemPath
01:52:57 C:\Program Files\Microsoft SQL Server\80\Tools\Binn\cnfgsvr.exe -F "C:\WINDOWS\sqlstp.log" -I MSSQLSERVER -V 1 -M 0 -Q "Latin1_General_CI_AS" -H 131390 -U sa -P
01:52:57 Process Exit Code: (193)
01:54:06 Setup failed to configure the server. Refer to the server error logs and C:\WINDOWS\sqlstp.log for more information.
01:54:06 Action CleanUpInstall:
01:54:06 C:\WINDOWS\TEMP\SqlSetup\Bin\scm.exe -Silent 1 -Action 4 -Service SQLSERVERAGENT
01:54:06 Process Exit Code: (1060) The specified service does not exist as an installed service.

01:54:06 C:\WINDOWS\TEMP\SqlSetup\Bin\scm.exe -Silent 1 -Action 4 -Service MSSQLSERVER
01:54:07 Process Exit Code: (0)
01:54:07 StatsGenerate returned: 2
01:54:07 StatsGenerate (0x0,0x1,0xf00,0x0,1033,303,0x0,0x1,0,0,0
01:54:07 StatsGenerate -1,Administrator)
01:54:07 Installation Failed.|||Check the sqlstp.log under c:\winnt. Also look for information in the event logs. I am not sure if these will exist yet, but check for errorlog files under the sql server directory.|||there is no errorlog files under the sql server directory. I already check it. Also the above is my Sqlstp.log file.

I have try so many way to solve the problem, however I can't ...pls help|||How about sqlsp.log and event logs ? Did the log end on "01:52:54 Begin Action: MoveFileDataSpecial" ?|||Its end with 01:54:07 Installation Failed.|||This is another one

06:20:21 Begin Setup
06:20:21 8.00.194
06:20:21 Mode = Normal
06:20:21 ModeType = NORMAL
06:20:21 GetDefinitionEx returned: 0, Extended: 0x0
06:20:21 ValueFTS returned: 1
06:20:21 ValuePID returned: 1
06:20:21 ValueLic returned: 1
06:20:21 System: Windows NT Terminal Server
06:20:21 SQL Server ProductType: Standard Edition [0x2]
06:20:21 Begin Action: SetupInitialize
06:20:21 End Action SetupInitialize
06:20:21 Begin Action: SetupInstall
06:20:21 Reading Software\Microsoft\Windows\CurrentVersion\CommonFi lesDir ...
06:20:21 CommonFilesDir=C:\Program Files\Common Files
06:20:21 Windows Directory=C:\WINDOWS\
06:20:21 Program Files=C:\Program Files\
06:20:21 TEMPDIR=C:\WINDOWS\TEMP\
06:20:21 Begin Action: SetupInstall
06:20:21 digpid size : 256
06:20:21 digpid size : 164
06:20:21 Begin Action: CheckFixedRequirements
06:20:21 Platform ID: 0xf00
06:20:21 Version: 5.2.3790
06:20:21 File Version - C:\WINDOWS\system32\shdocvw.dll: 6.0.3790.94
06:20:21 End Action: CheckFixedRequirements
06:20:21 Begin Action: ShowDialogs
06:20:21 Initial Dialog Mask: 0x183000f7, Disable Back=0x1
06:20:21 Begin Action ShowDialogsHlpr: 0x1
06:20:21 Begin Action: DialogShowSdWelcome
06:20:23 End Action DialogShowSdWelcome
06:20:23 Dialog 0x1 returned: 1
06:20:23 End Action ShowDialogsHlpr
06:20:23 ShowDialogsGetDialog returned: nCurrent=0x2,index=1
06:20:23 Begin Action ShowDialogsHlpr: 0x2
06:20:23 Begin Action: DialogShowSdMachineName
06:20:29 ShowDlgMachine returned: -1
06:20:29 ShowDlgMachine: GetLastError returned: 0
06:20:29 The operation completed successfully.

06:20:29 End Action DialogShowSdMachineName
06:20:29 End Action ShowDialogs
06:20:29 Action CleanUpInstall:
06:20:29 StatsGenerate returned: 2
06:20:29 StatsGenerate (0x0,0x0,0xf00,0x0,1033,0,0x0,0x0,0,0,0
06:20:29 StatsGenerate -1,)
06:20:29 Installation Failed.|||I missed the 3rd post with the log dump. Anyway, try running the sql setup in debug mode - using \x86\setup\setupsql.exe k=Dbq. When you get to the server configuration portion - see if you can start the sql server service.|||hi,

It doesn't work. samw problem. any more suggestion?|||What happens when you are in debug and the configure server prompts and you attempt to start the sql server service - without proceeding with the configure server (just leave it at the prompt) ?|||it quit automatically after it says setup failed to configure the server

Fail to remotely connect to SQL 2005 named instance

I have 2 instances on a remote machine:
- SQL Server 2000 - default instance
- SQL Server 2005 Standard - named instance called: SQL2005.
I am able to connect to SQL2005 from within the remote machine itself
(loopback). I am also able to connect to the SQL 2000 engine remotely
(remember - it is in default instance).
I am NOT able to connect to SQL2005 engine remotely. I enter server name:
remote\SQL2005, user name: sa, password: xxx, but I get "SQL Server does not
exist or access denied". Trying from various clients: Management Studio, UDL
file, connection string, etc.
I marked "Local and remote connections" in Surface Area Configuration;
TCP/IP is enabled and I have no problem of port definitions (all standard -
1433).
I have no firewall or other limitation accessing that remote machine at all.
I checked all Microsoft docs about SQL connectivity issues - that didn't
help.
I'd appreciate any help...
OferStart the SQL Browser service or connect to the named instance via the IP
address and port number.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Ofer Zelig" <ofer@.newsgroups.nospam> wrote in message
news:%23GhXSTBVGHA.5852@.TK2MSFTNGP10.phx.gbl...
>I have 2 instances on a remote machine:
> - SQL Server 2000 - default instance
> - SQL Server 2005 Standard - named instance called: SQL2005.
> I am able to connect to SQL2005 from within the remote machine itself
> (loopback). I am also able to connect to the SQL 2000 engine remotely
> (remember - it is in default instance).
> I am NOT able to connect to SQL2005 engine remotely. I enter server name:
> remote\SQL2005, user name: sa, password: xxx, but I get "SQL Server does
> not
> exist or access denied". Trying from various clients: Management Studio,
> UDL
> file, connection string, etc.
> I marked "Local and remote connections" in Surface Area Configuration;
> TCP/IP is enabled and I have no problem of port definitions (all
> standard -
> 1433).
> I have no firewall or other limitation accessing that remote machine at
> all.
> I checked all Microsoft docs about SQL connectivity issues - that didn't
> help.
> I'd appreciate any help...
> Ofer
>|||SQL Browser doesn't work.
About the IP number - which IP should I use? As far as I know, it is the
same 1433 port as in SQL 2000.
What should be the full server name if the machine is called "remote" and
the SQL 2005 instance is called "SQL2005" ? Isn't it: remote\SQL2005 ?
"Geoff N. Hiten" <SQLCraftsman@.gmail.com> wrote in message
news:%23cP4edCVGHA.5828@.TK2MSFTNGP10.phx.gbl...
> Start the SQL Browser service or connect to the named instance via the IP
> address and port number.
> --
> Geoff N. Hiten
> Senior Database Administrator
> Microsoft SQL Server MVP
>
> "Ofer Zelig" <ofer@.newsgroups.nospam> wrote in message
> news:%23GhXSTBVGHA.5852@.TK2MSFTNGP10.phx.gbl...
name:[vbcol=seagreen]
>|||Hello Ofer,
May I suggest that we focus on the theard in setup newsgroup? This might be
easier for community to track this issue. Thanks.
Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
========================================
=============
This posting is provided "AS IS" with no warranties, and confers no rights.
--
>From: "Ofer Zelig" <ofer@.newsgroups.nospam>
>References: <#GhXSTBVGHA.5852@.TK2MSFTNGP10.phx.gbl>
<#cP4edCVGHA.5828@.TK2MSFTNGP10.phx.gbl>
>Subject: Re: Fail to remotely connect to SQL 2005 named instance
>Date: Sun, 2 Apr 2006 15:13:30 +0200
>Lines: 53
>X-Priority: 3
>X-MSMail-Priority: Normal
>X-Newsreader: Microsoft Outlook Express 6.00.2800.1506
>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1506
>Message-ID: <OLnTq8kVGHA.6084@.TK2MSFTNGP14.phx.gbl>
>Newsgroups:
microsoft.public.sqlserver.setup,microsoft.public.sqlserver.connect
>NNTP-Posting-Host: line134-75.adsl.actcom.co.il 192.115.134.75
>Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP14.phx.gbl
>Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.connect:47287
microsoft.public.sqlserver.setup:76030
>X-Tomcat-NG: microsoft.public.sqlserver.connect
>SQL Browser doesn't work.
>About the IP number - which IP should I use? As far as I know, it is the
>same 1433 port as in SQL 2000.
>What should be the full server name if the machine is called "remote" and
>the SQL 2005 instance is called "SQL2005" ? Isn't it: remote\SQL2005 ?
>
>"Geoff N. Hiten" <SQLCraftsman@.gmail.com> wrote in message
>news:%23cP4edCVGHA.5828@.TK2MSFTNGP10.phx.gbl...
>name:
does[vbcol=seagreen]
Studio,[vbcol=seagreen]
didn't[vbcol=seagreen]
>
>

Fail to remotely connect to SQL 2005 named instance

I have 2 instances on a remote machine:
- SQL Server 2000 - default instance
- SQL Server 2005 Standard - named instance called: SQL2005.
I am able to connect to SQL2005 from within the remote machine itself
(loopback). I am also able to connect to the SQL 2000 engine remotely
(remember - it is in default instance).
I am NOT able to connect to SQL2005 engine remotely. I enter server name:
remote\SQL2005, user name: sa, password: xxx, but I get "SQL Server does not
exist or access denied". Trying from various clients: Management Studio, UDL
file, connection string, etc.
I marked "Local and remote connections" in Surface Area Configuration;
TCP/IP is enabled and I have no problem of port definitions (all standard -
1433).
I have no firewall or other limitation accessing that remote machine at all.
I checked all Microsoft docs about SQL connectivity issues - that didn't
help.
I'd appreciate any help...
Ofer
Start the SQL Browser service or connect to the named instance via the IP
address and port number.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Ofer Zelig" <ofer@.newsgroups.nospam> wrote in message
news:%23GhXSTBVGHA.5852@.TK2MSFTNGP10.phx.gbl...
>I have 2 instances on a remote machine:
> - SQL Server 2000 - default instance
> - SQL Server 2005 Standard - named instance called: SQL2005.
> I am able to connect to SQL2005 from within the remote machine itself
> (loopback). I am also able to connect to the SQL 2000 engine remotely
> (remember - it is in default instance).
> I am NOT able to connect to SQL2005 engine remotely. I enter server name:
> remote\SQL2005, user name: sa, password: xxx, but I get "SQL Server does
> not
> exist or access denied". Trying from various clients: Management Studio,
> UDL
> file, connection string, etc.
> I marked "Local and remote connections" in Surface Area Configuration;
> TCP/IP is enabled and I have no problem of port definitions (all
> standard -
> 1433).
> I have no firewall or other limitation accessing that remote machine at
> all.
> I checked all Microsoft docs about SQL connectivity issues - that didn't
> help.
> I'd appreciate any help...
> Ofer
>
|||SQL Browser doesn't work.
About the IP number - which IP should I use? As far as I know, it is the
same 1433 port as in SQL 2000.
What should be the full server name if the machine is called "remote" and
the SQL 2005 instance is called "SQL2005" ? Isn't it: remote\SQL2005 ?
"Geoff N. Hiten" <SQLCraftsman@.gmail.com> wrote in message
news:%23cP4edCVGHA.5828@.TK2MSFTNGP10.phx.gbl...[vbcol=seagreen]
> Start the SQL Browser service or connect to the named instance via the IP
> address and port number.
> --
> Geoff N. Hiten
> Senior Database Administrator
> Microsoft SQL Server MVP
>
> "Ofer Zelig" <ofer@.newsgroups.nospam> wrote in message
> news:%23GhXSTBVGHA.5852@.TK2MSFTNGP10.phx.gbl...
name:
>
|||Hello Ofer,
May I suggest that we focus on the theard in setup newsgroup? This might be
easier for community to track this issue. Thanks.
Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
================================================== ===
This posting is provided "AS IS" with no warranties, and confers no rights.
--
>From: "Ofer Zelig" <ofer@.newsgroups.nospam>
>References: <#GhXSTBVGHA.5852@.TK2MSFTNGP10.phx.gbl>
<#cP4edCVGHA.5828@.TK2MSFTNGP10.phx.gbl>
>Subject: Re: Fail to remotely connect to SQL 2005 named instance
>Date: Sun, 2 Apr 2006 15:13:30 +0200
>Lines: 53
>X-Priority: 3
>X-MSMail-Priority: Normal
>X-Newsreader: Microsoft Outlook Express 6.00.2800.1506
>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1506
>Message-ID: <OLnTq8kVGHA.6084@.TK2MSFTNGP14.phx.gbl>
>Newsgroups:
microsoft.public.sqlserver.setup,microsoft.public. sqlserver.connect
>NNTP-Posting-Host: line134-75.adsl.actcom.co.il 192.115.134.75
>Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFT NGP14.phx.gbl
>Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.connect:47287
microsoft.public.sqlserver.setup:76030[vbcol=seagreen]
>X-Tomcat-NG: microsoft.public.sqlserver.connect
>SQL Browser doesn't work.
>About the IP number - which IP should I use? As far as I know, it is the
>same 1433 port as in SQL 2000.
>What should be the full server name if the machine is called "remote" and
>the SQL 2005 instance is called "SQL2005" ? Isn't it: remote\SQL2005 ?
>
>"Geoff N. Hiten" <SQLCraftsman@.gmail.com> wrote in message
>news:%23cP4edCVGHA.5828@.TK2MSFTNGP10.phx.gbl...
>name:
does[vbcol=seagreen]
Studio,[vbcol=seagreen]
didn't
>
>

Fail to install RS 2k on windows 2k3 with IIS configuration error

***Environment:
Windows 2003 Standard, IIS 6.0, SQL Server 2000
***Error:
When installing, warning message appears as:
"IIS is either not installed or not configurated for a server component
installation"
After the installation is finished by ignoreing the preceding warning, no
virtual dir is crated for RS to run.
***My idea:
After reading the setup document, I find out that:
"If you are using IIS 6.x, Setup uses the default application pool. If the
default Web site or application pool is not available, Setup will continue,
but your installation will not work once Setup is finished." That might be
the major cause of the problem...
***My problem:
Actually, I have the Default Application Pool (DefaultAppPool) in my IIS
6.0. The only thing is that RS can not recognize it...
Is there anybody could give some advice? Thanks in advance!!!i found this once when i hadnt got aspnet reg'd for iis
i went to
C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\aspnet_regiis.exe -i
i then went into start > programs > sql server 2005 > reporting
services configuration
and you can get it to have another go at creating the websites (an
option on the left). this worked for me.
db
--
http://www.osix.net
the open source institute
home of the geek programming challenges
CrazyCalculator wrote:
> ***Environment:
> Windows 2003 Standard, IIS 6.0, SQL Server 2000
> ***Error:
> When installing, warning message appears as:
> "IIS is either not installed or not configurated for a server component
> installation"
> After the installation is finished by ignoreing the preceding warning, no
> virtual dir is crated for RS to run.
> ***My idea:
> After reading the setup document, I find out that:
> "If you are using IIS 6.x, Setup uses the default application pool. If the
> default Web site or application pool is not available, Setup will continue,
> but your installation will not work once Setup is finished." That might be
> the major cause of the problem...
> ***My problem:
> Actually, I have the Default Application Pool (DefaultAppPool) in my IIS
> 6.0. The only thing is that RS can not recognize it...
> Is there anybody could give some advice? Thanks in advance!!!|||Thank bb for your suggestion :)
However, I am install Reporting services 2000 on SQL Server 2000 and my
ASP.NET 1.1 seems to be perfectly registed...|||then sorry friend, cant really help as ive not tried with 2000
tell your techies to get update with the latest stuff!
good luck
db
CrazyCalculator wrote:
> Thank bb for your suggestion :)
> However, I am install Reporting services 2000 on SQL Server 2000 and my
> ASP.NET 1.1 seems to be perfectly registed...|||At last, with the inspiration of the goddess in my dream, I solve the evil
problem...
(1) Cause
SQL Server 2000 Need the "Default Web Site" as one of its installation
prerequisite. When I say "Default Web Site", I mean the Site with the
identifier 1. You can view the indentifier once you click "Web Sites" in your
IIS Manager.
(2) Why I fail
Really simple, I deleted the "Default Web Site" long time ago. The install
program can not find one Web Site with identifier 1, so it fails.
(3) How to do
Create a Web Site with identifier 1. This could be done by "IIS 6.0 Resource
Kit Tools, with Metabase Explorer", Download it from
http://www.microsoft.com/downloads/details.aspx?FamilyID=56fc92ee-a71a-4c73-b628-ade629c89499&DisplayLang=en
(4) And there is a document to help you
"http://www.gafvert.info/notes/IISDefaultWebsite.htm"
Hope you lucky.|||Hi, I have the same problem, it is just that I have a nr 1 and when I tried
to change I got the erroe that I didn´t have IIS installed, prior to this I
"only" have the error that I dont have asp.net installed or configured,
despite that it is installed and configured, I have both asp.net 1.1 and 2.0,
I have tried to switch between both, but the result is the same error, any
ideas?
DQ
"CrazyCalculator" wrote:
> At last, with the inspiration of the goddess in my dream, I solve the evil
> problem...
> (1) Cause
> SQL Server 2000 Need the "Default Web Site" as one of its installation
> prerequisite. When I say "Default Web Site", I mean the Site with the
> identifier 1. You can view the indentifier once you click "Web Sites" in your
> IIS Manager.
> (2) Why I fail
> Really simple, I deleted the "Default Web Site" long time ago. The install
> program can not find one Web Site with identifier 1, so it fails.
> (3) How to do
> Create a Web Site with identifier 1. This could be done by "IIS 6.0 Resource
> Kit Tools, with Metabase Explorer", Download it from
> http://www.microsoft.com/downloads/details.aspx?FamilyID=56fc92ee-a71a-4c73-b628-ade629c89499&DisplayLang=en
> (4) And there is a document to help you
> "http://www.gafvert.info/notes/IISDefaultWebsite.htm"
>
> Hope you lucky.|||SOLUTION that helped me!!
FIX: Error "ASP.NET v1.1 not Installed" while installing Sql Server 2000
Reporting Services
I finally had the chance to rebuild my dev machine with the RTM version of
Sql Server 200 Reporting Services [SQL2kRS] and ran into an unusual error.
During the "Check Prerequisites" stage of installation, it said that I didnt
have ASP.NET v1.1 installed on my PC. Considering that I do web-development
with VS.NET 2003 on this PC I was a bit perplexed why it said that.
After much digging and exploring, I finally discovered the problem. A
recent install of the new XP version of the Longhorn Command Shell had
installed the .NET Framework v2.0.31113.33 and set it as the Root Version of
the framework for ASP.NET.
So, the fix is pretty trivial, just update the RootVer registry value to
correctly (or temporarily) show v1.1.4322.573.
[\\HKLM\SOFTWARE\Microsoft\ASP.NET\RootVer] = "1.1.4322.573"
Strangely enough, this didnt seem to be affecting my ASP.NET applications.
*shrug*
None of this was documented in the verbose Help files that shipped with
SQL2kRS. This got me thinking about the nature of help files. Far too
often, I see FAQ's and "Common Issues" under the Troubleshooting section of
help files, yet rarely do I have those "common" problems.
I would much prefer a generic section on, "How to troubleshoot", "Where to
look for error clues", and provide deep lists of "Why an application or
installation might fail".
In this case, I actually did find a good reference in the Help entitled "Log
Files Used During Installation". This section explained how to locate the
log files created during installation, and this is how I eventually solved
the problem.
For reference, in SQL2kRS there are 3 main places to look for log files;
C:\Program Files\Microsoft SQL Server\80\RS Setup Bootstrap\Log\RSStp_.cab
(inside the CAB)
AND
%temp%\rsstp<integer>.log
(<integer> = number to make filename unique. e.g. rsstp2.log)
AND
%temp%\RSMSI<integer>.log
The latter 2 log files are the same ones that get copied into the CAB file
listed above, but its still useful knowledge in case something fails before
they get added to the CAB.
"DQ" wrote:
> Hi, I have the same problem, it is just that I have a nr 1 and when I tried
> to change I got the erroe that I didn´t have IIS installed, prior to this I
> "only" have the error that I dont have asp.net installed or configured,
> despite that it is installed and configured, I have both asp.net 1.1 and 2.0,
> I have tried to switch between both, but the result is the same error, any
> ideas?
> DQ
> "CrazyCalculator" wrote:
> > At last, with the inspiration of the goddess in my dream, I solve the evil
> > problem...
> >
> > (1) Cause
> > SQL Server 2000 Need the "Default Web Site" as one of its installation
> > prerequisite. When I say "Default Web Site", I mean the Site with the
> > identifier 1. You can view the indentifier once you click "Web Sites" in your
> > IIS Manager.
> >
> > (2) Why I fail
> > Really simple, I deleted the "Default Web Site" long time ago. The install
> > program can not find one Web Site with identifier 1, so it fails.
> >
> > (3) How to do
> > Create a Web Site with identifier 1. This could be done by "IIS 6.0 Resource
> > Kit Tools, with Metabase Explorer", Download it from
> >
> > http://www.microsoft.com/downloads/details.aspx?FamilyID=56fc92ee-a71a-4c73-b628-ade629c89499&DisplayLang=en
> >
> > (4) And there is a document to help you
> > "http://www.gafvert.info/notes/IISDefaultWebsite.htm"
> >
> >
> > Hope you lucky.