Installing SQL Server 2005 in XP x64 OS

i am using "XP Pro x64 Version 5.2.3790 Serivce Pack 1 Build 3790" Operating system. I had tried installing SQL Server 2005.

Unfortunatelly i ended up with this error

The setup has encountered an unexpected error in datastore. The action is SetInstanceProperty. The error is: Source File Name: datastore\propertyid.h

Source Line Number:168

Failed to load property "InstallIds" {"MachineConfiguration","","BOBXP64"} due to unhandled data store exception

Source File Name:datastore\datastorecache.cpp

-

Existing datastore does not match my bitness11

Thanks in advance for answering this issue.

i am using " XP Pro x64 Version 5.2.3790 Serivce Pack 1 Build 3790". i had tried installing SQL Server 2005 and ended up with the following error.

The setup has encountered an unexpected error in datastore. The action is SetInstanceProperty. The error is: Source File Name: datastore\propertyid.h

Function Name: PropertyId <class StringListProperty>::operator()

--

Failed to load property "InstallIds" {"MachineConfiguration","","BOBXP64"} due to unhandled data store exception

Source File Name: datastore\datastorecache.cpp

Function Name: DataStoreCache::getCachePtr

Existing datastore does not match my bitness11

|||

The suggestion from our devs is that you might be running both a x64 and an x86 installation at the same time. Can you check that out? Look at taskmanager for "setup.exe". If more than one are running, try killing the extras. Then run just the x64 installer.

|||My system was running on only x64 installation. I am still getting the same error. Can you please provide me the a link or a sample where i get all the steps involved in installing SQl server on "XP Pro x64 Version 5.2.3790 Serivce Pack 1 "|||Please provide me the guidelines for installing SQL Server 2005 x-64 bit version.

Integrate Service Pack

Hi,
With Windows XP and its Service Pack 2, one is able to run the service pack
at the command line with an -integrate option, and it will update an RTM
Windows XP install file set to an SP2 Windows XP install file set.
Do the SQL Server service packs have the -integrate option?
Thank you,
Daniel Jameson
SQL Server DBA
Children's Oncology Group
www.childrensoncologygroup.org
No.
Aaron Bertrand
SQL Server MVP
http://www.sqlblog.com/
http://www.aspfaq.com/5006

> With Windows XP and its Service Pack 2, one is able to run the service
> pack at the command line with an -integrate option, and it will update an
> RTM Windows XP install file set to an SP2 Windows XP install file set.
> Do the SQL Server service packs have the -integrate option?
|||You can vote for adding this feature here
https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=125400
HTH,
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
"Daniel Jameson" <djameson@.childrensoncologygroup.org> wrote in message
news:OiqXHipYHHA.448@.TK2MSFTNGP04.phx.gbl...
> Hi,
> With Windows XP and its Service Pack 2, one is able to run the service
> pack at the command line with an -integrate option, and it will update an
> RTM Windows XP install file set to an SP2 Windows XP install file set.
> Do the SQL Server service packs have the -integrate option?
> --
> Thank you,
> Daniel Jameson
> SQL Server DBA
> Children's Oncology Group
> www.childrensoncologygroup.org
>

Integrate Service Pack

Hi,
With Windows XP and its Service Pack 2, one is able to run the service pack
at the command line with an -integrate option, and it will update an RTM
Windows XP install file set to an SP2 Windows XP install file set.
Do the SQL Server service packs have the -integrate option?
Thank you,
Daniel Jameson
SQL Server DBA
Children's Oncology Group
www.childrensoncologygroup.orgNo.
Aaron Bertrand
SQL Server MVP
http://www.sqlblog.com/
http://www.aspfaq.com/5006

> With Windows XP and its Service Pack 2, one is able to run the service
> pack at the command line with an -integrate option, and it will update an
> RTM Windows XP install file set to an SP2 Windows XP install file set.
> Do the SQL Server service packs have the -integrate option?|||You can vote for adding this feature here
https://connect.microsoft.com/SQLSe...=1254
00
HTH,
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
"Daniel Jameson" <djameson@.childrensoncologygroup.org> wrote in message
news:OiqXHipYHHA.448@.TK2MSFTNGP04.phx.gbl...
> Hi,
> With Windows XP and its Service Pack 2, one is able to run the service
> pack at the command line with an -integrate option, and it will update an
> RTM Windows XP install file set to an SP2 Windows XP install file set.
> Do the SQL Server service packs have the -integrate option?
> --
> Thank you,
> Daniel Jameson
> SQL Server DBA
> Children's Oncology Group
> www.childrensoncologygroup.org
>

Integrate Service Pack

Hi,
With Windows XP and its Service Pack 2, one is able to run the service pack
at the command line with an -integrate option, and it will update an RTM
Windows XP install file set to an SP2 Windows XP install file set.
Do the SQL Server service packs have the -integrate option?
--
Thank you,
Daniel Jameson
SQL Server DBA
Children's Oncology Group
www.childrensoncologygroup.orgNo.
--
Aaron Bertrand
SQL Server MVP
http://www.sqlblog.com/
http://www.aspfaq.com/5006
> With Windows XP and its Service Pack 2, one is able to run the service
> pack at the command line with an -integrate option, and it will update an
> RTM Windows XP install file set to an SP2 Windows XP install file set.
> Do the SQL Server service packs have the -integrate option?|||You can vote for adding this feature here
https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=125400
--
HTH,
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
"Daniel Jameson" <djameson@.childrensoncologygroup.org> wrote in message
news:OiqXHipYHHA.448@.TK2MSFTNGP04.phx.gbl...
> Hi,
> With Windows XP and its Service Pack 2, one is able to run the service
> pack at the command line with an -integrate option, and it will update an
> RTM Windows XP install file set to an SP2 Windows XP install file set.
> Do the SQL Server service packs have the -integrate option?
> --
> Thank you,
> Daniel Jameson
> SQL Server DBA
> Children's Oncology Group
> www.childrensoncologygroup.org
>

Installing SQL SERVER 2000 on XP

Hi.. ASP

I want to install SQL SERVER 2000 on XP..But is it only support for client version.

Is there any Service Pack for XP about SQL SERVER 2000 for server version. I have already install XpServicePack2 but problem is still remain.

Thanks & Regards

Ravinder Sharma

No you can install the developer edition, personal and any eval edition. Hope this helps.

Installing SQL Express SP1 with existing User Instances

Hi,

I've read the readme for the Service Pack 1 for Microsoft SQL Server 2005.

http://download.microsoft.com/download/b/d/1/bd1e0745-0e65-43a5-ac6a-f6173f58d80e/ReadmeSQL2005SP1.htm

But I'm not quite clear on what will happen if you currently have SQL Server Express 2005 installed with User Instances, and then you launch the installer for SP1.

Will it also update the User Instance? If so, how could I tell? When I go to the registry for the User Instance it has the older version value ie.

HKLM\SOFTWARE\Microsoft\Microsoft SQL Server\[instance name]\MSSQLServer\CurrentVersion = 9.00.1399.06

Shouldn't it be saying 9.00.2047.00?

Does this mean that I have to uninstall the User Instance before installing SP1?

Any help will be appreciated.

Thanks

Sam

User instances work by cloning the actual instance at startup time, so as long as the main instance is updated then all should work.|||

User Instances are upgrade automatically as Euan says. You really shouldn't be using the registry to judge the success of an upgrade, it's complex and undocumented. You're not looking at the main Key for the SQL version installed.

Rather, after you perform the upgrade, go into the query tool of choice (Managment Studio, SQLCmd, etc.) and run the following:

SELECT @.@.version

This will return the Edition and Version of the server you connected to. If it is not 2047, then you didn't upgrade that Instance.

Regards,

Mike Wachal
SQL Express team

-
Mark the best posts as Answers!

|||

Hi Euan and Mike,

Your comments have been helpful.

What I found was that I actually hadn't upgraded our instance of SQL properly.

I've been using the command line for the SQL installer and worked out that the way for it to update the existing instance (and subsequent user instances) was to use

SQLEXPR.EXE /qb INSTANCENAME=<MyInstance> UPGRADE=SQL_Engine

Using these options for the installer I could confirm the upgrade both in the registry and more importantly using

SELECT @.@.version

Thanks

Sam

Installing Sql CE 2.0

Hi All,

I'm facing a problem while installing SQL CE 2.0 on my Desktop PC. It tells that the system must be installed with service pack 1 or higher for SQL Server 2000. I have installed service pack 3a and tried again. But then also i'm getting the same error message. Can anybody help me on this problem.

thanks in advance.

SQL CE 2.0 is for devices and is not supported on DESKTOP! (and was never even designed). If you want to have a DESKTOP version of it, please use this:http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=898913&SiteID=1

Thanks,

Laxmi

Installing Sql CE 2.0

Hi All,

I'm facing a problem while installing SQL CE 2.0 on my Desktop PC. It tells that the system must be installed with service pack 1 or higher for SQL Server 2000. I have installed service pack 3a and tried again. But then also i'm getting the same error message. Can anybody help me on this problem.

thanks in advance.

SQL CE 2.0 is for devices and is not supported on DESKTOP! (and was never even designed). If you want to have a DESKTOP version of it, please use this:http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=898913&SiteID=1

Thanks,

Laxmi