Showing posts with label install. Show all posts
Showing posts with label install. Show all posts

Wednesday, March 28, 2012

IA64 SP4 Install Problem

I am having trouble installing SP4 on my IA64. Like the instructions said in
section 1.1 of the help file I have changed it to allow Unsigned drivers to
Silently Succeed. However I am still getting a failure.
On thing to note when I run the following command I get some different
results than the help file say I sould.
SELECT SERVERPROPERTY('ProductLevel'), @.@.VERSION,
SERVERPROPERTY('ProductVersion')
SP3
Microsoft SQL Server 2000 - 8.00.818 (Intel IA-64) Jun 1 2003 15:32:45
Copyright (c) 1988-2003 Microsoft Corporation Enterprise Edition (64-bit) on
Windows NT 5.2 (Build 3790: )
8.00.818
About a year ago MS and Oracle were working with me to solve a memory leak
issue and I think that may be related to why SP4 wont install but I cant be
sure.
The only hint as to what the error is at the begining of the logfile (See
below).
05/18/2005 08:29:49.910
================================================== ==============================
05/18/2005 08:29:49.910 Hotfix package launched
05/18/2005 08:29:49.910 Local Computer:
05/18/2005 08:29:49.910 Target Details: SG1
05/18/2005 08:29:49.910 commonfilesdir = C:\Program Files\Common Files
05/18/2005 08:29:49.910 programfilesdir = C:\Program Files
05/18/2005 08:29:49.910 supportdir = C:\SQL2KSP4\IA64
05/18/2005 08:29:49.910 windir = C:\WINDOWS
05/18/2005 08:29:49.910 winsysdir = C:\WINDOWS\system32
05/18/2005 08:29:49.910
05/18/2005 08:29:50.850 The following product instance was disqualified
because a parent product instance of the same product code was found:
{0F34966C-4EF4-45AE-B78E-486BEFB71698}
05/18/2005 08:29:51.100 The following product instance was disqualified
because a parent product instance of the same product code was found:
{0F34966C-4EF4-45AE-B78E-486BEFB71698}
05/18/2005 08:29:51.100 Product Details:
05/18/2005 08:29:51.110 INF File Name: C:\SQL2KSP4\IA64\HotFix1.inf
05/18/2005 08:29:51.110 build = 2039
05/18/2005 08:29:51.110 description = SQL Server 2000 (64-bit)
05/18/2005 08:29:51.110 description2 = Analysis Services 2000 (64-bit)
05/18/2005 08:29:51.110 details = This Service Pack can be applied on all
SQL Server 2000 64-bit features including the relational database engine and
Analysis Services. If you have not done so already, back up the master and
msdb databases and stop all database programs and services before proceeding.
05/18/2005 08:29:51.110 kbarticle = KB884525
05/18/2005 08:29:51.110 lcid = 1033
05/18/2005 08:29:51.110 package = HotFix1
05/18/2005 08:29:51.110 productname = SQLOLAP64
05/18/2005 08:29:51.110 servicepackname = SQL Server 2000 (64-bit) Service
Pack 4
05/18/2005 08:29:51.110 splevel = RTM,4
05/18/2005 08:29:51.110 supportdir = C:\SQL2KSP4\IA64
05/18/2005 08:29:51.110 version = 8
05/18/2005 08:29:51.110
05/18/2005 08:29:51.110 File Group Details: MSP
05/18/2005 08:29:51.110 sourcepath = <SUPPORTDIR>\<PACKAGE>\Files
05/18/2005 08:29:51.110 File Details: OverridePreSP4QFE.msp
05/18/2005 08:29:51.110 parameters = SQLBUILD=2039 KBNUMBER=KB884525
REBOOT=ReallySuppress
05/18/2005 08:29:51.110 File Details: sqlrun.msp
05/18/2005 08:29:51.110 lockedfilecheck = 1
05/18/2005 08:29:51.110 parameters = SQLBUILD=2039 KBNUMBER=KB884525
REBOOT=ReallySuppress FORCEPATCH=DISTMDL SUPPORTFTPATCH=1
SUPPORTMSSEARCHPATCH=1 FTPATCHPATH="<SUPPORTDIR>\<PACKAGE>\Files"
MSSEARCHPATCHPATH="<SUPPORTDIR>\<PACKAGE>\Files"
05/18/2005 08:29:51.110
05/18/2005 08:29:51.110 Instance Details: MSSQLServer
05/18/2005 08:29:51.110 = Software\Microsoft\MSSQLServer\Setup
05/18/2005 08:29:51.110 agentservicename = SQLSERVERAGENT
05/18/2005 08:29:51.110 default = TRUE
05/18/2005 08:29:51.110 hiveregpath = Software\Microsoft\MSSQLServer
05/18/2005 08:29:51.110 id = MSSQLServer
05/18/2005 08:29:51.110 installsqldatadir = C:\Program Files\Microsoft
SQL Server\MSSQL
05/18/2005 08:29:51.110 installsqldir = C:\Program Files\Microsoft SQL
Server\MSSQL
05/18/2005 08:29:51.110 lcid = 1033
05/18/2005 08:29:51.110 name = MSSQLServer
05/18/2005 08:29:51.110 olapservicename = MSSQLServerOLAPService
05/18/2005 08:29:51.110 productcode =
{0F34966C-4EF4-45AE-B78E-486BEFB71698}
05/18/2005 08:29:51.110 servicename = MSSQLServer
05/18/2005 08:29:51.110 sku = ENTERPRISE
05/18/2005 08:29:51.110 sp = RTM
05/18/2005 08:29:51.110 type = Liberty
05/18/2005 08:29:51.110 version = 8
Anybody?
"Jim" wrote:

> I am having trouble installing SP4 on my IA64. Like the instructions said in
> section 1.1 of the help file I have changed it to allow Unsigned drivers to
> Silently Succeed. However I am still getting a failure.
> On thing to note when I run the following command I get some different
> results than the help file say I sould.
> SELECT SERVERPROPERTY('ProductLevel'), @.@.VERSION,
> SERVERPROPERTY('ProductVersion')
> SP3
> Microsoft SQL Server 2000 - 8.00.818 (Intel IA-64) Jun 1 2003 15:32:45
> Copyright (c) 1988-2003 Microsoft Corporation Enterprise Edition (64-bit) on
> Windows NT 5.2 (Build 3790: )
> 8.00.818
> About a year ago MS and Oracle were working with me to solve a memory leak
> issue and I think that may be related to why SP4 wont install but I cant be
> sure.
> The only hint as to what the error is at the begining of the logfile (See
> below).
> 05/18/2005 08:29:49.910
> ================================================== ==============================
> 05/18/2005 08:29:49.910 Hotfix package launched
> 05/18/2005 08:29:49.910 Local Computer:
> 05/18/2005 08:29:49.910 Target Details: SG1
> 05/18/2005 08:29:49.910 commonfilesdir = C:\Program Files\Common Files
> 05/18/2005 08:29:49.910 programfilesdir = C:\Program Files
> 05/18/2005 08:29:49.910 supportdir = C:\SQL2KSP4\IA64
> 05/18/2005 08:29:49.910 windir = C:\WINDOWS
> 05/18/2005 08:29:49.910 winsysdir = C:\WINDOWS\system32
> 05/18/2005 08:29:49.910
> 05/18/2005 08:29:50.850 The following product instance was disqualified
> because a parent product instance of the same product code was found:
> {0F34966C-4EF4-45AE-B78E-486BEFB71698}
> 05/18/2005 08:29:51.100 The following product instance was disqualified
> because a parent product instance of the same product code was found:
> {0F34966C-4EF4-45AE-B78E-486BEFB71698}
> 05/18/2005 08:29:51.100 Product Details:
> 05/18/2005 08:29:51.110 INF File Name: C:\SQL2KSP4\IA64\HotFix1.inf
> 05/18/2005 08:29:51.110 build = 2039
> 05/18/2005 08:29:51.110 description = SQL Server 2000 (64-bit)
> 05/18/2005 08:29:51.110 description2 = Analysis Services 2000 (64-bit)
> 05/18/2005 08:29:51.110 details = This Service Pack can be applied on all
> SQL Server 2000 64-bit features including the relational database engine and
> Analysis Services. If you have not done so already, back up the master and
> msdb databases and stop all database programs and services before proceeding.
> 05/18/2005 08:29:51.110 kbarticle = KB884525
> 05/18/2005 08:29:51.110 lcid = 1033
> 05/18/2005 08:29:51.110 package = HotFix1
> 05/18/2005 08:29:51.110 productname = SQLOLAP64
> 05/18/2005 08:29:51.110 servicepackname = SQL Server 2000 (64-bit) Service
> Pack 4
> 05/18/2005 08:29:51.110 splevel = RTM,4
> 05/18/2005 08:29:51.110 supportdir = C:\SQL2KSP4\IA64
> 05/18/2005 08:29:51.110 version = 8
> 05/18/2005 08:29:51.110
> 05/18/2005 08:29:51.110 File Group Details: MSP
> 05/18/2005 08:29:51.110 sourcepath = <SUPPORTDIR>\<PACKAGE>\Files
> 05/18/2005 08:29:51.110 File Details: OverridePreSP4QFE.msp
> 05/18/2005 08:29:51.110 parameters = SQLBUILD=2039 KBNUMBER=KB884525
> REBOOT=ReallySuppress
> 05/18/2005 08:29:51.110 File Details: sqlrun.msp
> 05/18/2005 08:29:51.110 lockedfilecheck = 1
> 05/18/2005 08:29:51.110 parameters = SQLBUILD=2039 KBNUMBER=KB884525
> REBOOT=ReallySuppress FORCEPATCH=DISTMDL SUPPORTFTPATCH=1
> SUPPORTMSSEARCHPATCH=1 FTPATCHPATH="<SUPPORTDIR>\<PACKAGE>\Files"
> MSSEARCHPATCHPATH="<SUPPORTDIR>\<PACKAGE>\Files"
> 05/18/2005 08:29:51.110
> 05/18/2005 08:29:51.110 Instance Details: MSSQLServer
> 05/18/2005 08:29:51.110 = Software\Microsoft\MSSQLServer\Setup
> 05/18/2005 08:29:51.110 agentservicename = SQLSERVERAGENT
> 05/18/2005 08:29:51.110 default = TRUE
> 05/18/2005 08:29:51.110 hiveregpath = Software\Microsoft\MSSQLServer
> 05/18/2005 08:29:51.110 id = MSSQLServer
> 05/18/2005 08:29:51.110 installsqldatadir = C:\Program Files\Microsoft
> SQL Server\MSSQL
> 05/18/2005 08:29:51.110 installsqldir = C:\Program Files\Microsoft SQL
> Server\MSSQL
> 05/18/2005 08:29:51.110 lcid = 1033
> 05/18/2005 08:29:51.110 name = MSSQLServer
> 05/18/2005 08:29:51.110 olapservicename = MSSQLServerOLAPService
> 05/18/2005 08:29:51.110 productcode =
> {0F34966C-4EF4-45AE-B78E-486BEFB71698}
> 05/18/2005 08:29:51.110 servicename = MSSQLServer
> 05/18/2005 08:29:51.110 sku = ENTERPRISE
> 05/18/2005 08:29:51.110 sp = RTM
> 05/18/2005 08:29:51.110 type = Liberty
> 05/18/2005 08:29:51.110 version = 8
|||Sorry don't have an answer for you. If no one else pipes in you may want to
give MS PSS a call.
http://support.microsoft.com/default...d=fh;EN-US;sql SQL Support
http://www.mssqlserver.com/faq/general-pss.asp MS PSS
Andrew J. Kelly SQL MVP
"Jim" <Jim@.discussions.microsoft.com> wrote in message
news:D129328E-93E4-4E2A-BC6B-129B9D7341AE@.microsoft.com...[vbcol=seagreen]
> Anybody?
> "Jim" wrote:
|||I'm getting the same error as well. I'm thinking it has something to
do with a previous version of a hotfix that was applied:
SELECT @.@.Version
Microsoft SQL Server 2000 - 8.00.818 (Intel IA-64) Jun 1 2003
15:32:45 Copyright (c) 1988-2003 Microsoft Corporation Enterprise
Edition (64-bit) on Windows NT 5.2 (Build 3790: )
05/26/2005 21:10:33.107
================================================== ==============================
05/26/2005 21:10:33.107 Hotfix package launched
05/26/2005 21:10:33.107 Local Computer:
05/26/2005 21:10:33.107 Target Details: OLYMPOS
05/26/2005 21:10:33.107 commonfilesdir = C:\Program Files\Common
Files
05/26/2005 21:10:33.107 programfilesdir = C:\Program Files
05/26/2005 21:10:33.107 supportdir =
\\Pontos\IT\pontos\it\SQL2KSP4\IA64
05/26/2005 21:10:33.107 windir = C:\WINDOWS
05/26/2005 21:10:33.107 winsysdir = C:\WINDOWS\system32
05/26/2005 21:10:33.107
05/26/2005 21:10:34.756 The following product instance was
disqualified because a parent product instance of the same product
code was found: {0F34966C-4EF4-45AE-B78E-486BEFB71698}
05/26/2005 21:10:34.959 The following product instance was
disqualified because a parent product instance of the same product
code was found: {FA0BA25D-6D7B-4E7F-8BD6-FC8C53B5D47F}
05/26/2005 21:10:34.959 Product Details:
05/26/2005 21:10:34.959 INF File Name:
\\Pontos\IT\pontos\it\SQL2KSP4\IA64\HotFix1.inf
05/26/2005 21:10:34.959 build = 2039
05/26/2005 21:10:34.959 description = SQL Server 2000 (64-bit)
05/26/2005 21:10:34.959 description2 = Analysis Services 2000
(64-bit)
05/26/2005 21:10:34.959 details = This Service Pack can be applied
on all SQL Server 2000 64-bit features including the relational
database engine and Analysis Services. If you have not done so
already, back up the master and msdb databases and stop all database
programs and services before proceeding.
05/26/2005 21:10:34.959 kbarticle = KB884525
05/26/2005 21:10:34.959 lcid = 1033
05/26/2005 21:10:34.959 package = HotFix1
05/26/2005 21:10:34.959 productname = SQLOLAP64
05/26/2005 21:10:34.959 servicepackname = SQL Server 2000 (64-bit)
Service Pack 4
05/26/2005 21:10:34.959 splevel = RTM,4
05/26/2005 21:10:34.959 supportdir =
\\Pontos\IT\pontos\it\SQL2KSP4\IA64
05/26/2005 21:10:34.959 version = 8
05/26/2005 21:10:34.959
05/26/2005 21:10:34.959 File Group Details: MSP
05/26/2005 21:10:34.959 sourcepath =
<SUPPORTDIR>\<PACKAGE>\Files
05/26/2005 21:10:34.959 File Details: OverridePreSP4QFE.msp
05/26/2005 21:10:34.959 parameters = SQLBUILD=2039
KBNUMBER=KB884525 REBOOT=ReallySuppress
05/26/2005 21:10:34.959 File Details: sqlrun.msp
05/26/2005 21:10:34.959 lockedfilecheck = 1
05/26/2005 21:10:34.959 parameters = SQLBUILD=2039
KBNUMBER=KB884525 REBOOT=ReallySuppress FORCEPATCH=DISTMDL
SUPPORTFTPATCH=1 SUPPORTMSSEARCHPATCH=1
FTPATCHPATH="<SUPPORTDIR>\<PACKAGE>\Files"
MSSEARCHPATCHPATH="<SUPPORTDIR>\<PACKAGE>\Files"
05/26/2005 21:10:34.959
05/26/2005 21:10:34.959 Instance Details: PRODUCTION
05/26/2005 21:10:34.959 = Software\Microsoft\Microsoft SQL
Server\PRODUCTION\Setup
05/26/2005 21:10:34.959 agentservicename = SQLAgent$PRODUCTION
05/26/2005 21:10:34.959 hiveregpath = Software\Microsoft\Microsoft
SQL Server\PRODUCTION
05/26/2005 21:10:34.959 id = PRODUCTION
05/26/2005 21:10:34.959 installsqldatadir = C:\Program
Files\Microsoft SQL Server\MSSQL$PRODUCTION
05/26/2005 21:10:34.959 installsqldir = C:\Program Files\Microsoft
SQL Server\MSSQL$PRODUCTION
05/26/2005 21:10:34.959 lcid = 1033
05/26/2005 21:10:34.969 name = PRODUCTION
05/26/2005 21:10:34.969 productcode =
{0F34966C-4EF4-45AE-B78E-486BEFB71698}
05/26/2005 21:10:34.969 servicename = MSSQL$PRODUCTION
05/26/2005 21:10:34.969 sku = ENTERPRISE
05/26/2005 21:10:34.969 sp = RTM
05/26/2005 21:10:34.969 type = Liberty
05/26/2005 21:10:34.969 version = 8
05/26/2005 21:10:34.969
05/26/2005 21:10:34.969 Instance Details: RMSWORK
05/26/2005 21:10:34.969 = Software\Microsoft\Microsoft SQL
Server\RMSWORK\Setup
05/26/2005 21:10:34.969 agentservicename = SQLAgent$RMSWORK
05/26/2005 21:10:34.969 hiveregpath = Software\Microsoft\Microsoft
SQL Server\RMSWORK
05/26/2005 21:10:34.969 id = RMSWORK
05/26/2005 21:10:34.969 installsqldatadir = C:\Program
Files\Microsoft SQL Server\MSSQL$RMSWORK
05/26/2005 21:10:34.969 installsqldir = C:\Program Files\Microsoft
SQL Server\MSSQL$RMSWORK
05/26/2005 21:10:34.969 lcid = 1033
05/26/2005 21:10:34.969 name = RMSWORK
05/26/2005 21:10:34.969 olapservicename = MSSQLServerOLAPService
05/26/2005 21:10:34.969 productcode =
{FA0BA25D-6D7B-4E7F-8BD6-FC8C53B5D47F}
05/26/2005 21:10:34.969 servicename = MSSQL$RMSWORK
05/26/2005 21:10:34.969 sku = ENTERPRISE
05/26/2005 21:10:34.969 sp = RTM
05/26/2005 21:10:34.969 type = Liberty
05/26/2005 21:10:34.969 version = 8
05/26/2005 21:10:34.969
05/26/2005 21:10:34.969 Product Details:
05/26/2005 21:10:34.969 INF File Name:
\\Pontos\IT\pontos\it\SQL2KSP4\IA64\HotFix1.inf
05/26/2005 21:10:34.969 build = 2039
05/26/2005 21:10:34.969 description = Analysis Services 2000
(64-bit)
05/26/2005 21:10:34.969 description2 = Analysis Services 2000
(64-bit)
05/26/2005 21:10:34.969 details = This Service Pack can be applied
on all SQL Server 2000 64-bit features including the relational
database engine and Analysis Services. If you have not done so
already, back up the master and msdb databases and stop all database
programs and services before proceeding.
05/26/2005 21:10:34.969 kbarticle = KB884525
05/26/2005 21:10:34.969 lcid = 1033
05/26/2005 21:10:34.969 package = HotFix1
05/26/2005 21:10:34.969 productname = SQLOLAP64
05/26/2005 21:10:34.969 servicepackname = SQL Server 2000 (64-bit)
Service Pack 4
05/26/2005 21:10:34.969 splevel = RTM,4
05/26/2005 21:10:34.969 supportdir =
\\Pontos\IT\pontos\it\SQL2KSP4\IA64
05/26/2005 21:10:34.969 version = 8
05/26/2005 21:10:34.969
05/26/2005 21:10:34.969 File Group Details: MSP
05/26/2005 21:10:34.969 sourcepath =
<SUPPORTDIR>\<PACKAGE>\Files
05/26/2005 21:10:34.969 File Details: OverridePreSP4QFE.msp
05/26/2005 21:10:34.969 parameters = SQLBUILD=2039
KBNUMBER=KB884525 REBOOT=ReallySuppress
05/26/2005 21:10:34.969 File Details: sqlrun.msp
05/26/2005 21:10:34.969 lockedfilecheck = 1
05/26/2005 21:10:34.969 parameters = SQLBUILD=2039
KBNUMBER=KB884525 REBOOT=ReallySuppress FORCEPATCH=DISTMDL
SUPPORTFTPATCH=1 SUPPORTMSSEARCHPATCH=1
FTPATCHPATH="<SUPPORTDIR>\<PACKAGE>\Files"
MSSEARCHPATCHPATH="<SUPPORTDIR>\<PACKAGE>\Files"
05/26/2005 21:10:34.969
05/26/2005 21:10:34.969 Instance Details: RMSWORK
05/26/2005 21:10:34.969 = Software\Microsoft\OLAP Server\Setup
05/26/2005 21:10:34.969 agentservicename = SQLAgent$RMSWORK
05/26/2005 21:10:34.969 hiveregpath = Software\Microsoft\Microsoft
SQL Server\RMSWORK
05/26/2005 21:10:34.969 id = RMSWORK
05/26/2005 21:10:34.969 installsqldatadir = C:\Program
Files\Microsoft SQL Server\MSSQL$RMSWORK
05/26/2005 21:10:34.969 installsqldir = C:\Program Files\Microsoft
SQL Server\MSSQL$RMSWORK
05/26/2005 21:10:34.969 lcid = 1033
05/26/2005 21:10:34.969 name = RMSWORK
05/26/2005 21:10:34.969 olapservicename = MSSQLServerOLAPService
05/26/2005 21:10:34.969 productcode =
{FA0BA25D-6D7B-4E7F-8BD6-FC8C53B5D47F}
05/26/2005 21:10:34.969 servicename = MSSQL$RMSWORK
05/26/2005 21:10:34.969 sku = ENTERPRISE
05/26/2005 21:10:34.969 sp = RTM
05/26/2005 21:10:34.969 type = OLAP
05/26/2005 21:10:34.969 version = 8
05/26/2005 21:10:34.969
05/26/2005 21:10:34.969 Product Details:
05/26/2005 21:10:34.969 INF File Name:
\\Pontos\IT\pontos\it\SQL2KSP4\IA64\HotFix1.inf
05/26/2005 21:10:34.969 build = 2039
05/26/2005 21:10:34.969 description = SQL Server 2000 (64-bit)
05/26/2005 21:10:34.969 description2 = Analysis Services 2000
(64-bit)
05/26/2005 21:10:34.969 details = This Service Pack can be applied
on all SQL Server 2000 64-bit features including the relational
database engine and Analysis Services. If you have not done so
already, back up the master and msdb databases and stop all database
programs and services before proceeding.
05/26/2005 21:10:34.969 kbarticle = KB884525
05/26/2005 21:10:34.969 lcid = 1033
05/26/2005 21:10:34.969 package = HotFix1
05/26/2005 21:10:34.969 productname = SQLOLAP64
05/26/2005 21:10:34.969 servicepackname = SQL Server 2000 (64-bit)
Service Pack 4
05/26/2005 21:10:34.969 splevel = RTM,4
05/26/2005 21:10:34.969 supportdir =
\\Pontos\IT\pontos\it\SQL2KSP4\IA64
05/26/2005 21:10:34.969 version = 8
05/26/2005 21:10:34.969
05/26/2005 21:10:34.969 File Group Details: MSP
05/26/2005 21:10:34.969 sourcepath =
<SUPPORTDIR>\<PACKAGE>\Files
05/26/2005 21:10:34.969 File Details: OverridePreSP4QFE.msp
05/26/2005 21:10:34.969 parameters = SQLBUILD=2039
KBNUMBER=KB884525 REBOOT=ReallySuppress
05/26/2005 21:10:34.969 File Details: sqlrun.msp
05/26/2005 21:10:34.969 lockedfilecheck = 1
05/26/2005 21:10:34.969 parameters = SQLBUILD=2039
KBNUMBER=KB884525 REBOOT=ReallySuppress FORCEPATCH=DISTMDL
SUPPORTFTPATCH=1 SUPPORTMSSEARCHPATCH=1
FTPATCHPATH="<SUPPORTDIR>\<PACKAGE>\Files"
MSSEARCHPATCHPATH="<SUPPORTDIR>\<PACKAGE>\Files"
05/26/2005 21:10:34.969
05/26/2005 21:10:34.969 Instance Details: SQL Tools
05/26/2005 21:10:34.969 = Software\Microsoft\Microsoft SQL
Server\80\Tools\ClientSetup\Setup
05/26/2005 21:10:34.969 installsqldir = C:\Program Files\Microsoft
SQL Server\80\Tools
05/26/2005 21:10:34.969 lcid = 1033
05/26/2005 21:10:34.969 name = SQL Tools
05/26/2005 21:10:34.969 productcode =
{0F34966C-4EF4-45AE-B78E-486BEFB71698}
05/26/2005 21:10:34.969 sp = RTM
05/26/2005 21:10:34.969 version = 8
05/26/2005 21:10:34.969
05/26/2005 21:10:34.969 Product Details:
05/26/2005 21:10:34.969 INF File Name:
\\Pontos\IT\pontos\it\SQL2KSP4\IA64\HotFix1.inf
05/26/2005 21:10:34.969 build = 2039
05/26/2005 21:10:34.969 description = Analysis Services 2000
(64-bit)
05/26/2005 21:10:34.969 description2 = Analysis Services 2000
(64-bit)
05/26/2005 21:10:34.969 details = This Service Pack can be applied
on all SQL Server 2000 64-bit features including the relational
database engine and Analysis Services. If you have not done so
already, back up the master and msdb databases and stop all database
programs and services before proceeding.
05/26/2005 21:10:34.969 kbarticle = KB884525
05/26/2005 21:10:34.969 lcid = 1033
05/26/2005 21:10:34.969 package = HotFix1
05/26/2005 21:10:34.969 productname = SQLOLAP64
05/26/2005 21:10:34.969 servicepackname = SQL Server 2000 (64-bit)
Service Pack 4
05/26/2005 21:10:34.969 splevel = RTM,4
05/26/2005 21:10:34.969 supportdir =
\\Pontos\IT\pontos\it\SQL2KSP4\IA64
05/26/2005 21:10:34.969 version = 8
05/26/2005 21:10:34.969
05/26/2005 21:10:34.969 File Group Details: MSP
05/26/2005 21:10:34.969 sourcepath =
<SUPPORTDIR>\<PACKAGE>\Files
05/26/2005 21:10:34.969 File Details: OverridePreSP4QFE.msp
05/26/2005 21:10:34.969 parameters = SQLBUILD=2039
KBNUMBER=KB884525 REBOOT=ReallySuppress
05/26/2005 21:10:34.969 File Details: sqlrun.msp
05/26/2005 21:10:34.969 lockedfilecheck = 1
05/26/2005 21:10:34.969 parameters = SQLBUILD=2039
KBNUMBER=KB884525 REBOOT=ReallySuppress FORCEPATCH=DISTMDL
SUPPORTFTPATCH=1 SUPPORTMSSEARCHPATCH=1
FTPATCHPATH="<SUPPORTDIR>\<PACKAGE>\Files"
MSSEARCHPATCHPATH="<SUPPORTDIR>\<PACKAGE>\Files"
05/26/2005 21:10:34.969
05/26/2005 21:10:34.969 Instance Details: OLAPClient
05/26/2005 21:10:34.969 = Software\Microsoft\OLAP Server\Setup
05/26/2005 21:10:34.969 installsqldir = C:\Program Files\Common
Files\system\OLE DB
05/26/2005 21:10:34.969 lcid = 1033
05/26/2005 21:10:34.969 name = OLAPClient
05/26/2005 21:10:34.969 productcode =
{FA0BA25D-6D7B-4E7F-8BD6-FC8C53B5D47F}
05/26/2005 21:10:34.969 sp = RTM
05/26/2005 21:10:34.969 version = 8
05/26/2005 21:10:34.969
05/26/2005 21:10:51.286 Authenticating user using Windows
Authentication
05/26/2005 21:10:51.306 SQL Service MSSQL$PRODUCTION was previously
running, ready for authentication
05/26/2005 21:10:51.306 SQL Agent Service SQLAgent$PRODUCTION was
previously running
05/26/2005 21:10:51.489 User authentication was successful
05/26/2005 21:10:54.787 Attempting to install product: SQLOLAP64
|||Hi there:
i am also facing the same problem when i try installing SQL2k SP4 on IA serversWere you able ti fix it. Will appreciate any help.
Kind Regards,
Roshan
From http://www.developmentnow.com/g/118_2005_5_0_0_524275/IA64-SP4-Install-Problem.htm
Posted via DevelopmentNow.com Groups
http://www.developmentnow.com

IA64 SP4 Install Problem

I am having trouble installing SP4 on my IA64. Like the instructions said in
section 1.1 of the help file I have changed it to allow Unsigned drivers to
Silently Succeed. However I am still getting a failure.
On thing to note when I run the following command I get some different
results than the help file say I sould.
SELECT SERVERPROPERTY('ProductLevel'), @.@.VERSION,
SERVERPROPERTY('ProductVersion')
SP3
Microsoft SQL Server 2000 - 8.00.818 (Intel IA-64) Jun 1 2003 15:32:45
Copyright (c) 1988-2003 Microsoft Corporation Enterprise Edition (64-bit) o
n
Windows NT 5.2 (Build 3790: )
8.00.818
About a year ago MS and Oracle were working with me to solve a memory leak
issue and I think that may be related to why SP4 wont install but I cant be
sure.
The only hint as to what the error is at the begining of the logfile (See
below).
05/18/2005 08:29:49.910
========================================
====================================
====
05/18/2005 08:29:49.910 Hotfix package launched
05/18/2005 08:29:49.910 Local Computer:
05/18/2005 08:29:49.910 Target Details: SG1
05/18/2005 08:29:49.910 commonfilesdir = C:\Program Files\Common Files
05/18/2005 08:29:49.910 programfilesdir = C:\Program Files
05/18/2005 08:29:49.910 supportdir = C:\SQL2KSP4\IA64
05/18/2005 08:29:49.910 windir = C:\WINDOWS
05/18/2005 08:29:49.910 winsysdir = C:\WINDOWS\system32
05/18/2005 08:29:49.910
05/18/2005 08:29:50.850 The following product instance was disqualified
because a parent product instance of the same product code was found:
{0F34966C-4EF4-45AE-B78E-486BEFB71698}
05/18/2005 08:29:51.100 The following product instance was disqualified
because a parent product instance of the same product code was found:
{0F34966C-4EF4-45AE-B78E-486BEFB71698}
05/18/2005 08:29:51.100 Product Details:
05/18/2005 08:29:51.110 INF File Name: C:\SQL2KSP4\IA64\HotFix1.inf
05/18/2005 08:29:51.110 build = 2039
05/18/2005 08:29:51.110 description = SQL Server 2000 (64-bit)
05/18/2005 08:29:51.110 description2 = Analysis Services 2000 (64-bit)
05/18/2005 08:29:51.110 details = This Service Pack can be applied on all
SQL Server 2000 64-bit features including the relational database engine and
Analysis Services. If you have not done so already, back up the master and
msdb databases and stop all database programs and services before proceeding
.
05/18/2005 08:29:51.110 kbarticle = KB884525
05/18/2005 08:29:51.110 lcid = 1033
05/18/2005 08:29:51.110 package = HotFix1
05/18/2005 08:29:51.110 productname = SQLOLAP64
05/18/2005 08:29:51.110 servicepackname = SQL Server 2000 (64-bit) Service
Pack 4
05/18/2005 08:29:51.110 splevel = RTM,4
05/18/2005 08:29:51.110 supportdir = C:\SQL2KSP4\IA64
05/18/2005 08:29:51.110 version = 8
05/18/2005 08:29:51.110
05/18/2005 08:29:51.110 File Group Details: MSP
05/18/2005 08:29:51.110 sourcepath = <SUPPORTDIR>\<PACKAGE>\Files
05/18/2005 08:29:51.110 File Details: OverridePreSP4QFE.msp
05/18/2005 08:29:51.110 parameters = SQLBUILD=2039 KBNUMBER=KB884525
REBOOT=ReallySuppress
05/18/2005 08:29:51.110 File Details: sqlrun.msp
05/18/2005 08:29:51.110 lockedfilecheck = 1
05/18/2005 08:29:51.110 parameters = SQLBUILD=2039 KBNUMBER=KB884525
REBOOT=ReallySuppress FORCEPATCH=DISTMDL SUPPORTFTPATCH=1
SUPPORTMSSEARCHPATCH=1 FTPATCHPATH="<SUPPORTDIR>\<PACKAGE>\Files"
MSSEARCHPATCHPATH="<SUPPORTDIR>\<PACKAGE>\Files"
05/18/2005 08:29:51.110
05/18/2005 08:29:51.110 Instance Details: MSSQLServer
05/18/2005 08:29:51.110 = Software\Microsoft\MSSQLServer\Setup
05/18/2005 08:29:51.110 agentservicename = SQLSERVERAGENT
05/18/2005 08:29:51.110 default = TRUE
05/18/2005 08:29:51.110 hiveregpath = Software\Microsoft\MSSQLServer
05/18/2005 08:29:51.110 id = MSSQLServer
05/18/2005 08:29:51.110 installsqldatadir = C:\Program Files\Microsoft
SQL Server\MSSQL
05/18/2005 08:29:51.110 installsqldir = C:\Program Files\Microsoft SQL
Server\MSSQL
05/18/2005 08:29:51.110 lcid = 1033
05/18/2005 08:29:51.110 name = MSSQLServer
05/18/2005 08:29:51.110 olapservicename = MSSQLServerOLAPService
05/18/2005 08:29:51.110 productcode =
{0F34966C-4EF4-45AE-B78E-486BEFB71698}
05/18/2005 08:29:51.110 servicename = MSSQLServer
05/18/2005 08:29:51.110 sku = ENTERPRISE
05/18/2005 08:29:51.110 sp = RTM
05/18/2005 08:29:51.110 type = Liberty
05/18/2005 08:29:51.110 version = 8Anybody?
"Jim" wrote:

> I am having trouble installing SP4 on my IA64. Like the instructions said
in
> section 1.1 of the help file I have changed it to allow Unsigned drivers t
o
> Silently Succeed. However I am still getting a failure.
> On thing to note when I run the following command I get some different
> results than the help file say I sould.
> SELECT SERVERPROPERTY('ProductLevel'), @.@.VERSION,
> SERVERPROPERTY('ProductVersion')
> SP3
> Microsoft SQL Server 2000 - 8.00.818 (Intel IA-64) Jun 1 2003 15:32:45
> Copyright (c) 1988-2003 Microsoft Corporation Enterprise Edition (64-bit)
on
> Windows NT 5.2 (Build 3790: )
> 8.00.818
> About a year ago MS and Oracle were working with me to solve a memory leak
> issue and I think that may be related to why SP4 wont install but I cant b
e
> sure.
> The only hint as to what the error is at the begining of the logfile (See
> below).
> 05/18/2005 08:29:49.910
> ========================================
==================================
======
> 05/18/2005 08:29:49.910 Hotfix package launched
> 05/18/2005 08:29:49.910 Local Computer:
> 05/18/2005 08:29:49.910 Target Details: SG1
> 05/18/2005 08:29:49.910 commonfilesdir = C:\Program Files\Common Files
> 05/18/2005 08:29:49.910 programfilesdir = C:\Program Files
> 05/18/2005 08:29:49.910 supportdir = C:\SQL2KSP4\IA64
> 05/18/2005 08:29:49.910 windir = C:\WINDOWS
> 05/18/2005 08:29:49.910 winsysdir = C:\WINDOWS\system32
> 05/18/2005 08:29:49.910
> 05/18/2005 08:29:50.850 The following product instance was disqualified
> because a parent product instance of the same product code was found:
> {0F34966C-4EF4-45AE-B78E-486BEFB71698}
> 05/18/2005 08:29:51.100 The following product instance was disqualified
> because a parent product instance of the same product code was found:
> {0F34966C-4EF4-45AE-B78E-486BEFB71698}
> 05/18/2005 08:29:51.100 Product Details:
> 05/18/2005 08:29:51.110 INF File Name: C:\SQL2KSP4\IA64\HotFix1.inf
> 05/18/2005 08:29:51.110 build = 2039
> 05/18/2005 08:29:51.110 description = SQL Server 2000 (64-bit)
> 05/18/2005 08:29:51.110 description2 = Analysis Services 2000 (64-bit)
> 05/18/2005 08:29:51.110 details = This Service Pack can be applied on al
l
> SQL Server 2000 64-bit features including the relational database engine a
nd
> Analysis Services. If you have not done so already, back up the master an
d
> msdb databases and stop all database programs and services before proceedi
ng.
> 05/18/2005 08:29:51.110 kbarticle = KB884525
> 05/18/2005 08:29:51.110 lcid = 1033
> 05/18/2005 08:29:51.110 package = HotFix1
> 05/18/2005 08:29:51.110 productname = SQLOLAP64
> 05/18/2005 08:29:51.110 servicepackname = SQL Server 2000 (64-bit) Servi
ce
> Pack 4
> 05/18/2005 08:29:51.110 splevel = RTM,4
> 05/18/2005 08:29:51.110 supportdir = C:\SQL2KSP4\IA64
> 05/18/2005 08:29:51.110 version = 8
> 05/18/2005 08:29:51.110
> 05/18/2005 08:29:51.110 File Group Details: MSP
> 05/18/2005 08:29:51.110 sourcepath = <SUPPORTDIR>\<PACKAGE>\Files
> 05/18/2005 08:29:51.110 File Details: OverridePreSP4QFE.msp
> 05/18/2005 08:29:51.110 parameters = SQLBUILD=2039 KBNUMBER=KB884525
> REBOOT=ReallySuppress
> 05/18/2005 08:29:51.110 File Details: sqlrun.msp
> 05/18/2005 08:29:51.110 lockedfilecheck = 1
> 05/18/2005 08:29:51.110 parameters = SQLBUILD=2039 KBNUMBER=KB884525
> REBOOT=ReallySuppress FORCEPATCH=DISTMDL SUPPORTFTPATCH=1
> SUPPORTMSSEARCHPATCH=1 FTPATCHPATH="<SUPPORTDIR>\<PACKAGE>\Files"
> MSSEARCHPATCHPATH="<SUPPORTDIR>\<PACKAGE>\Files"
> 05/18/2005 08:29:51.110
> 05/18/2005 08:29:51.110 Instance Details: MSSQLServer
> 05/18/2005 08:29:51.110 = Software\Microsoft\MSSQLServer\Setup
> 05/18/2005 08:29:51.110 agentservicename = SQLSERVERAGENT
> 05/18/2005 08:29:51.110 default = TRUE
> 05/18/2005 08:29:51.110 hiveregpath = Software\Microsoft\MSSQLServer
> 05/18/2005 08:29:51.110 id = MSSQLServer
> 05/18/2005 08:29:51.110 installsqldatadir = C:\Program Files\Microsoft
> SQL Server\MSSQL
> 05/18/2005 08:29:51.110 installsqldir = C:\Program Files\Microsoft SQL
> Server\MSSQL
> 05/18/2005 08:29:51.110 lcid = 1033
> 05/18/2005 08:29:51.110 name = MSSQLServer
> 05/18/2005 08:29:51.110 olapservicename = MSSQLServerOLAPService
> 05/18/2005 08:29:51.110 productcode =
> {0F34966C-4EF4-45AE-B78E-486BEFB71698}
> 05/18/2005 08:29:51.110 servicename = MSSQLServer
> 05/18/2005 08:29:51.110 sku = ENTERPRISE
> 05/18/2005 08:29:51.110 sp = RTM
> 05/18/2005 08:29:51.110 type = Liberty
> 05/18/2005 08:29:51.110 version = 8|||Sorry don't have an answer for you. If no one else pipes in you may want to
give MS PSS a call.
http://support.microsoft.com/defaul...id=fh;EN-US;sql SQL Support
http://www.mssqlserver.com/faq/general-pss.asp MS PSS
Andrew J. Kelly SQL MVP
"Jim" <Jim@.discussions.microsoft.com> wrote in message
news:D129328E-93E4-4E2A-BC6B-129B9D7341AE@.microsoft.com...[vbcol=seagreen]
> Anybody?
> "Jim" wrote:
>|||I'm getting the same error as well. I'm thinking it has something to
do with a previous version of a hotfix that was applied:
SELECT @.@.Version
Microsoft SQL Server 2000 - 8.00.818 (Intel IA-64) Jun 1 2003
15:32:45 Copyright (c) 1988-2003 Microsoft Corporation Enterprise
Edition (64-bit) on Windows NT 5.2 (Build 3790: )
05/26/2005 21:10:33.107
========================================
====================================
====
05/26/2005 21:10:33.107 Hotfix package launched
05/26/2005 21:10:33.107 Local Computer:
05/26/2005 21:10:33.107 Target Details: OLYMPOS
05/26/2005 21:10:33.107 commonfilesdir = C:\Program Files\Common
Files
05/26/2005 21:10:33.107 programfilesdir = C:\Program Files
05/26/2005 21:10:33.107 supportdir =
\\Pontos\IT\pontos\it\SQL2KSP4\IA64
05/26/2005 21:10:33.107 windir = C:\WINDOWS
05/26/2005 21:10:33.107 winsysdir = C:\WINDOWS\system32
05/26/2005 21:10:33.107
05/26/2005 21:10:34.756 The following product instance was
disqualified because a parent product instance of the same product
code was found: {0F34966C-4EF4-45AE-B78E-486BEFB71698}
05/26/2005 21:10:34.959 The following product instance was
disqualified because a parent product instance of the same product
code was found: {FA0BA25D-6D7B-4E7F-8BD6-FC8C53B5D47F}
05/26/2005 21:10:34.959 Product Details:
05/26/2005 21:10:34.959 INF File Name:
\\Pontos\IT\pontos\it\SQL2KSP4\IA64\HotF
ix1.inf
05/26/2005 21:10:34.959 build = 2039
05/26/2005 21:10:34.959 description = SQL Server 2000 (64-bit)
05/26/2005 21:10:34.959 description2 = Analysis Services 2000
(64-bit)
05/26/2005 21:10:34.959 details = This Service Pack can be applied
on all SQL Server 2000 64-bit features including the relational
database engine and Analysis Services. If you have not done so
already, back up the master and msdb databases and stop all database
programs and services before proceeding.
05/26/2005 21:10:34.959 kbarticle = KB884525
05/26/2005 21:10:34.959 lcid = 1033
05/26/2005 21:10:34.959 package = HotFix1
05/26/2005 21:10:34.959 productname = SQLOLAP64
05/26/2005 21:10:34.959 servicepackname = SQL Server 2000 (64-bit)
Service Pack 4
05/26/2005 21:10:34.959 splevel = RTM,4
05/26/2005 21:10:34.959 supportdir =
\\Pontos\IT\pontos\it\SQL2KSP4\IA64
05/26/2005 21:10:34.959 version = 8
05/26/2005 21:10:34.959
05/26/2005 21:10:34.959 File Group Details: MSP
05/26/2005 21:10:34.959 sourcepath =
<SUPPORTDIR>\<PACKAGE>\Files
05/26/2005 21:10:34.959 File Details: OverridePreSP4QFE.msp
05/26/2005 21:10:34.959 parameters = SQLBUILD=2039
KBNUMBER=KB884525 REBOOT=ReallySuppress
05/26/2005 21:10:34.959 File Details: sqlrun.msp
05/26/2005 21:10:34.959 lockedfilecheck = 1
05/26/2005 21:10:34.959 parameters = SQLBUILD=2039
KBNUMBER=KB884525 REBOOT=ReallySuppress FORCEPATCH=DISTMDL
SUPPORTFTPATCH=1 SUPPORTMSSEARCHPATCH=1
FTPATCHPATH="<SUPPORTDIR>\<PACKAGE>\Files"
MSSEARCHPATCHPATH="<SUPPORTDIR>\<PACKAGE>\Files"
05/26/2005 21:10:34.959
05/26/2005 21:10:34.959 Instance Details: PRODUCTION
05/26/2005 21:10:34.959 = Software\Microsoft\Microsoft SQL
Server\PRODUCTION\Setup
05/26/2005 21:10:34.959 agentservicename = SQLAgent$PRODUCTION
05/26/2005 21:10:34.959 hiveregpath = Software\Microsoft\Microsoft
SQL Server\PRODUCTION
05/26/2005 21:10:34.959 id = PRODUCTION
05/26/2005 21:10:34.959 installsqldatadir = C:\Program
Files\Microsoft SQL Server\MSSQL$PRODUCTION
05/26/2005 21:10:34.959 installsqldir = C:\Program Files\Microsoft
SQL Server\MSSQL$PRODUCTION
05/26/2005 21:10:34.959 lcid = 1033
05/26/2005 21:10:34.969 name = PRODUCTION
05/26/2005 21:10:34.969 productcode =
{0F34966C-4EF4-45AE-B78E-486BEFB71698}
05/26/2005 21:10:34.969 servicename = MSSQL$PRODUCTION
05/26/2005 21:10:34.969 sku = ENTERPRISE
05/26/2005 21:10:34.969 sp = RTM
05/26/2005 21:10:34.969 type = Liberty
05/26/2005 21:10:34.969 version = 8
05/26/2005 21:10:34.969
05/26/2005 21:10:34.969 Instance Details: RMSWORK
05/26/2005 21:10:34.969 = Software\Microsoft\Microsoft SQL
Server\RMSWORK\Setup
05/26/2005 21:10:34.969 agentservicename = SQLAgent$RMSWORK
05/26/2005 21:10:34.969 hiveregpath = Software\Microsoft\Microsoft
SQL Server\RMSWORK
05/26/2005 21:10:34.969 id = RMSWORK
05/26/2005 21:10:34.969 installsqldatadir = C:\Program
Files\Microsoft SQL Server\MSSQL$RMSWORK
05/26/2005 21:10:34.969 installsqldir = C:\Program Files\Microsoft
SQL Server\MSSQL$RMSWORK
05/26/2005 21:10:34.969 lcid = 1033
05/26/2005 21:10:34.969 name = RMSWORK
05/26/2005 21:10:34.969 olapservicename = MSSQLServerOLAPService
05/26/2005 21:10:34.969 productcode =
{FA0BA25D-6D7B-4E7F-8BD6-FC8C53B5D47F}
05/26/2005 21:10:34.969 servicename = MSSQL$RMSWORK
05/26/2005 21:10:34.969 sku = ENTERPRISE
05/26/2005 21:10:34.969 sp = RTM
05/26/2005 21:10:34.969 type = Liberty
05/26/2005 21:10:34.969 version = 8
05/26/2005 21:10:34.969
05/26/2005 21:10:34.969 Product Details:
05/26/2005 21:10:34.969 INF File Name:
\\Pontos\IT\pontos\it\SQL2KSP4\IA64\HotF
ix1.inf
05/26/2005 21:10:34.969 build = 2039
05/26/2005 21:10:34.969 description = Analysis Services 2000
(64-bit)
05/26/2005 21:10:34.969 description2 = Analysis Services 2000
(64-bit)
05/26/2005 21:10:34.969 details = This Service Pack can be applied
on all SQL Server 2000 64-bit features including the relational
database engine and Analysis Services. If you have not done so
already, back up the master and msdb databases and stop all database
programs and services before proceeding.
05/26/2005 21:10:34.969 kbarticle = KB884525
05/26/2005 21:10:34.969 lcid = 1033
05/26/2005 21:10:34.969 package = HotFix1
05/26/2005 21:10:34.969 productname = SQLOLAP64
05/26/2005 21:10:34.969 servicepackname = SQL Server 2000 (64-bit)
Service Pack 4
05/26/2005 21:10:34.969 splevel = RTM,4
05/26/2005 21:10:34.969 supportdir =
\\Pontos\IT\pontos\it\SQL2KSP4\IA64
05/26/2005 21:10:34.969 version = 8
05/26/2005 21:10:34.969
05/26/2005 21:10:34.969 File Group Details: MSP
05/26/2005 21:10:34.969 sourcepath =
<SUPPORTDIR>\<PACKAGE>\Files
05/26/2005 21:10:34.969 File Details: OverridePreSP4QFE.msp
05/26/2005 21:10:34.969 parameters = SQLBUILD=2039
KBNUMBER=KB884525 REBOOT=ReallySuppress
05/26/2005 21:10:34.969 File Details: sqlrun.msp
05/26/2005 21:10:34.969 lockedfilecheck = 1
05/26/2005 21:10:34.969 parameters = SQLBUILD=2039
KBNUMBER=KB884525 REBOOT=ReallySuppress FORCEPATCH=DISTMDL
SUPPORTFTPATCH=1 SUPPORTMSSEARCHPATCH=1
FTPATCHPATH="<SUPPORTDIR>\<PACKAGE>\Files"
MSSEARCHPATCHPATH="<SUPPORTDIR>\<PACKAGE>\Files"
05/26/2005 21:10:34.969
05/26/2005 21:10:34.969 Instance Details: RMSWORK
05/26/2005 21:10:34.969 = Software\Microsoft\OLAP Server\Setup
05/26/2005 21:10:34.969 agentservicename = SQLAgent$RMSWORK
05/26/2005 21:10:34.969 hiveregpath = Software\Microsoft\Microsoft
SQL Server\RMSWORK
05/26/2005 21:10:34.969 id = RMSWORK
05/26/2005 21:10:34.969 installsqldatadir = C:\Program
Files\Microsoft SQL Server\MSSQL$RMSWORK
05/26/2005 21:10:34.969 installsqldir = C:\Program Files\Microsoft
SQL Server\MSSQL$RMSWORK
05/26/2005 21:10:34.969 lcid = 1033
05/26/2005 21:10:34.969 name = RMSWORK
05/26/2005 21:10:34.969 olapservicename = MSSQLServerOLAPService
05/26/2005 21:10:34.969 productcode =
{FA0BA25D-6D7B-4E7F-8BD6-FC8C53B5D47F}
05/26/2005 21:10:34.969 servicename = MSSQL$RMSWORK
05/26/2005 21:10:34.969 sku = ENTERPRISE
05/26/2005 21:10:34.969 sp = RTM
05/26/2005 21:10:34.969 type = OLAP
05/26/2005 21:10:34.969 version = 8
05/26/2005 21:10:34.969
05/26/2005 21:10:34.969 Product Details:
05/26/2005 21:10:34.969 INF File Name:
\\Pontos\IT\pontos\it\SQL2KSP4\IA64\HotF
ix1.inf
05/26/2005 21:10:34.969 build = 2039
05/26/2005 21:10:34.969 description = SQL Server 2000 (64-bit)
05/26/2005 21:10:34.969 description2 = Analysis Services 2000
(64-bit)
05/26/2005 21:10:34.969 details = This Service Pack can be applied
on all SQL Server 2000 64-bit features including the relational
database engine and Analysis Services. If you have not done so
already, back up the master and msdb databases and stop all database
programs and services before proceeding.
05/26/2005 21:10:34.969 kbarticle = KB884525
05/26/2005 21:10:34.969 lcid = 1033
05/26/2005 21:10:34.969 package = HotFix1
05/26/2005 21:10:34.969 productname = SQLOLAP64
05/26/2005 21:10:34.969 servicepackname = SQL Server 2000 (64-bit)
Service Pack 4
05/26/2005 21:10:34.969 splevel = RTM,4
05/26/2005 21:10:34.969 supportdir =
\\Pontos\IT\pontos\it\SQL2KSP4\IA64
05/26/2005 21:10:34.969 version = 8
05/26/2005 21:10:34.969
05/26/2005 21:10:34.969 File Group Details: MSP
05/26/2005 21:10:34.969 sourcepath =
<SUPPORTDIR>\<PACKAGE>\Files
05/26/2005 21:10:34.969 File Details: OverridePreSP4QFE.msp
05/26/2005 21:10:34.969 parameters = SQLBUILD=2039
KBNUMBER=KB884525 REBOOT=ReallySuppress
05/26/2005 21:10:34.969 File Details: sqlrun.msp
05/26/2005 21:10:34.969 lockedfilecheck = 1
05/26/2005 21:10:34.969 parameters = SQLBUILD=2039
KBNUMBER=KB884525 REBOOT=ReallySuppress FORCEPATCH=DISTMDL
SUPPORTFTPATCH=1 SUPPORTMSSEARCHPATCH=1
FTPATCHPATH="<SUPPORTDIR>\<PACKAGE>\Files"
MSSEARCHPATCHPATH="<SUPPORTDIR>\<PACKAGE>\Files"
05/26/2005 21:10:34.969
05/26/2005 21:10:34.969 Instance Details: SQL Tools
05/26/2005 21:10:34.969 = Software\Microsoft\Microsoft SQL
Server\80\Tools\ClientSetup\Setup
05/26/2005 21:10:34.969 installsqldir = C:\Program Files\Microsoft
SQL Server\80\Tools
05/26/2005 21:10:34.969 lcid = 1033
05/26/2005 21:10:34.969 name = SQL Tools
05/26/2005 21:10:34.969 productcode =
{0F34966C-4EF4-45AE-B78E-486BEFB71698}
05/26/2005 21:10:34.969 sp = RTM
05/26/2005 21:10:34.969 version = 8
05/26/2005 21:10:34.969
05/26/2005 21:10:34.969 Product Details:
05/26/2005 21:10:34.969 INF File Name:
\\Pontos\IT\pontos\it\SQL2KSP4\IA64\HotF
ix1.inf
05/26/2005 21:10:34.969 build = 2039
05/26/2005 21:10:34.969 description = Analysis Services 2000
(64-bit)
05/26/2005 21:10:34.969 description2 = Analysis Services 2000
(64-bit)
05/26/2005 21:10:34.969 details = This Service Pack can be applied
on all SQL Server 2000 64-bit features including the relational
database engine and Analysis Services. If you have not done so
already, back up the master and msdb databases and stop all database
programs and services before proceeding.
05/26/2005 21:10:34.969 kbarticle = KB884525
05/26/2005 21:10:34.969 lcid = 1033
05/26/2005 21:10:34.969 package = HotFix1
05/26/2005 21:10:34.969 productname = SQLOLAP64
05/26/2005 21:10:34.969 servicepackname = SQL Server 2000 (64-bit)
Service Pack 4
05/26/2005 21:10:34.969 splevel = RTM,4
05/26/2005 21:10:34.969 supportdir =
\\Pontos\IT\pontos\it\SQL2KSP4\IA64
05/26/2005 21:10:34.969 version = 8
05/26/2005 21:10:34.969
05/26/2005 21:10:34.969 File Group Details: MSP
05/26/2005 21:10:34.969 sourcepath =
<SUPPORTDIR>\<PACKAGE>\Files
05/26/2005 21:10:34.969 File Details: OverridePreSP4QFE.msp
05/26/2005 21:10:34.969 parameters = SQLBUILD=2039
KBNUMBER=KB884525 REBOOT=ReallySuppress
05/26/2005 21:10:34.969 File Details: sqlrun.msp
05/26/2005 21:10:34.969 lockedfilecheck = 1
05/26/2005 21:10:34.969 parameters = SQLBUILD=2039
KBNUMBER=KB884525 REBOOT=ReallySuppress FORCEPATCH=DISTMDL
SUPPORTFTPATCH=1 SUPPORTMSSEARCHPATCH=1
FTPATCHPATH="<SUPPORTDIR>\<PACKAGE>\Files"
MSSEARCHPATCHPATH="<SUPPORTDIR>\<PACKAGE>\Files"
05/26/2005 21:10:34.969
05/26/2005 21:10:34.969 Instance Details: OLAPClient
05/26/2005 21:10:34.969 = Software\Microsoft\OLAP Server\Setup
05/26/2005 21:10:34.969 installsqldir = C:\Program Files\Common
Files\system\OLE DB
05/26/2005 21:10:34.969 lcid = 1033
05/26/2005 21:10:34.969 name = OLAPClient
05/26/2005 21:10:34.969 productcode =
{FA0BA25D-6D7B-4E7F-8BD6-FC8C53B5D47F}
05/26/2005 21:10:34.969 sp = RTM
05/26/2005 21:10:34.969 version = 8
05/26/2005 21:10:34.969
05/26/2005 21:10:51.286 Authenticating user using Windows
Authentication
05/26/2005 21:10:51.306 SQL Service MSSQL$PRODUCTION was previously
running, ready for authentication
05/26/2005 21:10:51.306 SQL Agent Service SQLAgent$PRODUCTION was
previously running
05/26/2005 21:10:51.489 User authentication was successful
05/26/2005 21:10:54.787 Attempting to install product: SQLOLAP64|||Hi there:
i am also facing the same problem when i try installing SQL2k SP4 on IA serv
ersWere you able ti fix it. Will appreciate any help.
Kind Regards,
Roshan
From m.htm" target="_blank">http://www.developmentnow.com/g/118...le
m.htm
Posted via DevelopmentNow.com Groups
http://www.developmentnow.com

IA64 SP4 Install Problem

I am having trouble installing SP4 on my IA64. Like the instructions said in
section 1.1 of the help file I have changed it to allow Unsigned drivers to
Silently Succeed. However I am still getting a failure.
On thing to note when I run the following command I get some different
results than the help file say I sould.
SELECT SERVERPROPERTY('ProductLevel'), @.@.VERSION,
SERVERPROPERTY('ProductVersion')
SP3
Microsoft SQL Server 2000 - 8.00.818 (Intel IA-64) Jun 1 2003 15:32:45
Copyright (c) 1988-2003 Microsoft Corporation Enterprise Edition (64-bit) on
Windows NT 5.2 (Build 3790: )
8.00.818
About a year ago MS and Oracle were working with me to solve a memory leak
issue and I think that may be related to why SP4 wont install but I cant be
sure.
The only hint as to what the error is at the begining of the logfile (See
below).
05/18/2005 08:29:49.910
================================================================================ 05/18/2005 08:29:49.910 Hotfix package launched
05/18/2005 08:29:49.910 Local Computer:
05/18/2005 08:29:49.910 Target Details: SG1
05/18/2005 08:29:49.910 commonfilesdir = C:\Program Files\Common Files
05/18/2005 08:29:49.910 programfilesdir = C:\Program Files
05/18/2005 08:29:49.910 supportdir = C:\SQL2KSP4\IA64
05/18/2005 08:29:49.910 windir = C:\WINDOWS
05/18/2005 08:29:49.910 winsysdir = C:\WINDOWS\system32
05/18/2005 08:29:49.910
05/18/2005 08:29:50.850 The following product instance was disqualified
because a parent product instance of the same product code was found:
{0F34966C-4EF4-45AE-B78E-486BEFB71698}
05/18/2005 08:29:51.100 The following product instance was disqualified
because a parent product instance of the same product code was found:
{0F34966C-4EF4-45AE-B78E-486BEFB71698}
05/18/2005 08:29:51.100 Product Details:
05/18/2005 08:29:51.110 INF File Name: C:\SQL2KSP4\IA64\HotFix1.inf
05/18/2005 08:29:51.110 build = 2039
05/18/2005 08:29:51.110 description = SQL Server 2000 (64-bit)
05/18/2005 08:29:51.110 description2 = Analysis Services 2000 (64-bit)
05/18/2005 08:29:51.110 details = This Service Pack can be applied on all
SQL Server 2000 64-bit features including the relational database engine and
Analysis Services. If you have not done so already, back up the master and
msdb databases and stop all database programs and services before proceeding.
05/18/2005 08:29:51.110 kbarticle = KB884525
05/18/2005 08:29:51.110 lcid = 1033
05/18/2005 08:29:51.110 package = HotFix1
05/18/2005 08:29:51.110 productname = SQLOLAP64
05/18/2005 08:29:51.110 servicepackname = SQL Server 2000 (64-bit) Service
Pack 4
05/18/2005 08:29:51.110 splevel = RTM,4
05/18/2005 08:29:51.110 supportdir = C:\SQL2KSP4\IA64
05/18/2005 08:29:51.110 version = 8
05/18/2005 08:29:51.110
05/18/2005 08:29:51.110 File Group Details: MSP
05/18/2005 08:29:51.110 sourcepath = <SUPPORTDIR>\<PACKAGE>\Files
05/18/2005 08:29:51.110 File Details: OverridePreSP4QFE.msp
05/18/2005 08:29:51.110 parameters = SQLBUILD=2039 KBNUMBER=KB884525
REBOOT=ReallySuppress
05/18/2005 08:29:51.110 File Details: sqlrun.msp
05/18/2005 08:29:51.110 lockedfilecheck = 1
05/18/2005 08:29:51.110 parameters = SQLBUILD=2039 KBNUMBER=KB884525
REBOOT=ReallySuppress FORCEPATCH=DISTMDL SUPPORTFTPATCH=1
SUPPORTMSSEARCHPATCH=1 FTPATCHPATH="<SUPPORTDIR>\<PACKAGE>\Files"
MSSEARCHPATCHPATH="<SUPPORTDIR>\<PACKAGE>\Files"
05/18/2005 08:29:51.110
05/18/2005 08:29:51.110 Instance Details: MSSQLServer
05/18/2005 08:29:51.110 = Software\Microsoft\MSSQLServer\Setup
05/18/2005 08:29:51.110 agentservicename = SQLSERVERAGENT
05/18/2005 08:29:51.110 default = TRUE
05/18/2005 08:29:51.110 hiveregpath = Software\Microsoft\MSSQLServer
05/18/2005 08:29:51.110 id = MSSQLServer
05/18/2005 08:29:51.110 installsqldatadir = C:\Program Files\Microsoft
SQL Server\MSSQL
05/18/2005 08:29:51.110 installsqldir = C:\Program Files\Microsoft SQL
Server\MSSQL
05/18/2005 08:29:51.110 lcid = 1033
05/18/2005 08:29:51.110 name = MSSQLServer
05/18/2005 08:29:51.110 olapservicename = MSSQLServerOLAPService
05/18/2005 08:29:51.110 productcode = {0F34966C-4EF4-45AE-B78E-486BEFB71698}
05/18/2005 08:29:51.110 servicename = MSSQLServer
05/18/2005 08:29:51.110 sku = ENTERPRISE
05/18/2005 08:29:51.110 sp = RTM
05/18/2005 08:29:51.110 type = Liberty
05/18/2005 08:29:51.110 version = 8Anybody?
"Jim" wrote:
> I am having trouble installing SP4 on my IA64. Like the instructions said in
> section 1.1 of the help file I have changed it to allow Unsigned drivers to
> Silently Succeed. However I am still getting a failure.
> On thing to note when I run the following command I get some different
> results than the help file say I sould.
> SELECT SERVERPROPERTY('ProductLevel'), @.@.VERSION,
> SERVERPROPERTY('ProductVersion')
> SP3
> Microsoft SQL Server 2000 - 8.00.818 (Intel IA-64) Jun 1 2003 15:32:45
> Copyright (c) 1988-2003 Microsoft Corporation Enterprise Edition (64-bit) on
> Windows NT 5.2 (Build 3790: )
> 8.00.818
> About a year ago MS and Oracle were working with me to solve a memory leak
> issue and I think that may be related to why SP4 wont install but I cant be
> sure.
> The only hint as to what the error is at the begining of the logfile (See
> below).
> 05/18/2005 08:29:49.910
> ================================================================================> 05/18/2005 08:29:49.910 Hotfix package launched
> 05/18/2005 08:29:49.910 Local Computer:
> 05/18/2005 08:29:49.910 Target Details: SG1
> 05/18/2005 08:29:49.910 commonfilesdir = C:\Program Files\Common Files
> 05/18/2005 08:29:49.910 programfilesdir = C:\Program Files
> 05/18/2005 08:29:49.910 supportdir = C:\SQL2KSP4\IA64
> 05/18/2005 08:29:49.910 windir = C:\WINDOWS
> 05/18/2005 08:29:49.910 winsysdir = C:\WINDOWS\system32
> 05/18/2005 08:29:49.910
> 05/18/2005 08:29:50.850 The following product instance was disqualified
> because a parent product instance of the same product code was found:
> {0F34966C-4EF4-45AE-B78E-486BEFB71698}
> 05/18/2005 08:29:51.100 The following product instance was disqualified
> because a parent product instance of the same product code was found:
> {0F34966C-4EF4-45AE-B78E-486BEFB71698}
> 05/18/2005 08:29:51.100 Product Details:
> 05/18/2005 08:29:51.110 INF File Name: C:\SQL2KSP4\IA64\HotFix1.inf
> 05/18/2005 08:29:51.110 build = 2039
> 05/18/2005 08:29:51.110 description = SQL Server 2000 (64-bit)
> 05/18/2005 08:29:51.110 description2 = Analysis Services 2000 (64-bit)
> 05/18/2005 08:29:51.110 details = This Service Pack can be applied on all
> SQL Server 2000 64-bit features including the relational database engine and
> Analysis Services. If you have not done so already, back up the master and
> msdb databases and stop all database programs and services before proceeding.
> 05/18/2005 08:29:51.110 kbarticle = KB884525
> 05/18/2005 08:29:51.110 lcid = 1033
> 05/18/2005 08:29:51.110 package = HotFix1
> 05/18/2005 08:29:51.110 productname = SQLOLAP64
> 05/18/2005 08:29:51.110 servicepackname = SQL Server 2000 (64-bit) Service
> Pack 4
> 05/18/2005 08:29:51.110 splevel = RTM,4
> 05/18/2005 08:29:51.110 supportdir = C:\SQL2KSP4\IA64
> 05/18/2005 08:29:51.110 version = 8
> 05/18/2005 08:29:51.110
> 05/18/2005 08:29:51.110 File Group Details: MSP
> 05/18/2005 08:29:51.110 sourcepath = <SUPPORTDIR>\<PACKAGE>\Files
> 05/18/2005 08:29:51.110 File Details: OverridePreSP4QFE.msp
> 05/18/2005 08:29:51.110 parameters = SQLBUILD=2039 KBNUMBER=KB884525
> REBOOT=ReallySuppress
> 05/18/2005 08:29:51.110 File Details: sqlrun.msp
> 05/18/2005 08:29:51.110 lockedfilecheck = 1
> 05/18/2005 08:29:51.110 parameters = SQLBUILD=2039 KBNUMBER=KB884525
> REBOOT=ReallySuppress FORCEPATCH=DISTMDL SUPPORTFTPATCH=1
> SUPPORTMSSEARCHPATCH=1 FTPATCHPATH="<SUPPORTDIR>\<PACKAGE>\Files"
> MSSEARCHPATCHPATH="<SUPPORTDIR>\<PACKAGE>\Files"
> 05/18/2005 08:29:51.110
> 05/18/2005 08:29:51.110 Instance Details: MSSQLServer
> 05/18/2005 08:29:51.110 = Software\Microsoft\MSSQLServer\Setup
> 05/18/2005 08:29:51.110 agentservicename = SQLSERVERAGENT
> 05/18/2005 08:29:51.110 default = TRUE
> 05/18/2005 08:29:51.110 hiveregpath = Software\Microsoft\MSSQLServer
> 05/18/2005 08:29:51.110 id = MSSQLServer
> 05/18/2005 08:29:51.110 installsqldatadir = C:\Program Files\Microsoft
> SQL Server\MSSQL
> 05/18/2005 08:29:51.110 installsqldir = C:\Program Files\Microsoft SQL
> Server\MSSQL
> 05/18/2005 08:29:51.110 lcid = 1033
> 05/18/2005 08:29:51.110 name = MSSQLServer
> 05/18/2005 08:29:51.110 olapservicename = MSSQLServerOLAPService
> 05/18/2005 08:29:51.110 productcode => {0F34966C-4EF4-45AE-B78E-486BEFB71698}
> 05/18/2005 08:29:51.110 servicename = MSSQLServer
> 05/18/2005 08:29:51.110 sku = ENTERPRISE
> 05/18/2005 08:29:51.110 sp = RTM
> 05/18/2005 08:29:51.110 type = Liberty
> 05/18/2005 08:29:51.110 version = 8|||Sorry don't have an answer for you. If no one else pipes in you may want to
give MS PSS a call.
http://support.microsoft.com/default.aspx?scid=fh;EN-US;sql SQL Support
http://www.mssqlserver.com/faq/general-pss.asp MS PSS
--
Andrew J. Kelly SQL MVP
"Jim" <Jim@.discussions.microsoft.com> wrote in message
news:D129328E-93E4-4E2A-BC6B-129B9D7341AE@.microsoft.com...
> Anybody?
> "Jim" wrote:
>> I am having trouble installing SP4 on my IA64. Like the instructions said
>> in
>> section 1.1 of the help file I have changed it to allow Unsigned drivers
>> to
>> Silently Succeed. However I am still getting a failure.
>> On thing to note when I run the following command I get some different
>> results than the help file say I sould.
>> SELECT SERVERPROPERTY('ProductLevel'), @.@.VERSION,
>> SERVERPROPERTY('ProductVersion')
>> SP3
>> Microsoft SQL Server 2000 - 8.00.818 (Intel IA-64) Jun 1 2003
>> 15:32:45
>> Copyright (c) 1988-2003 Microsoft Corporation Enterprise Edition
>> (64-bit) on
>> Windows NT 5.2 (Build 3790: )
>> 8.00.818
>> About a year ago MS and Oracle were working with me to solve a memory
>> leak
>> issue and I think that may be related to why SP4 wont install but I cant
>> be
>> sure.
>> The only hint as to what the error is at the begining of the logfile (See
>> below).
>> 05/18/2005 08:29:49.910
>> ================================================================================>> 05/18/2005 08:29:49.910 Hotfix package launched
>> 05/18/2005 08:29:49.910 Local Computer:
>> 05/18/2005 08:29:49.910 Target Details: SG1
>> 05/18/2005 08:29:49.910 commonfilesdir = C:\Program Files\Common Files
>> 05/18/2005 08:29:49.910 programfilesdir = C:\Program Files
>> 05/18/2005 08:29:49.910 supportdir = C:\SQL2KSP4\IA64
>> 05/18/2005 08:29:49.910 windir = C:\WINDOWS
>> 05/18/2005 08:29:49.910 winsysdir = C:\WINDOWS\system32
>> 05/18/2005 08:29:49.910
>> 05/18/2005 08:29:50.850 The following product instance was disqualified
>> because a parent product instance of the same product code was found:
>> {0F34966C-4EF4-45AE-B78E-486BEFB71698}
>> 05/18/2005 08:29:51.100 The following product instance was disqualified
>> because a parent product instance of the same product code was found:
>> {0F34966C-4EF4-45AE-B78E-486BEFB71698}
>> 05/18/2005 08:29:51.100 Product Details:
>> 05/18/2005 08:29:51.110 INF File Name: C:\SQL2KSP4\IA64\HotFix1.inf
>> 05/18/2005 08:29:51.110 build = 2039
>> 05/18/2005 08:29:51.110 description = SQL Server 2000 (64-bit)
>> 05/18/2005 08:29:51.110 description2 = Analysis Services 2000 (64-bit)
>> 05/18/2005 08:29:51.110 details = This Service Pack can be applied on
>> all
>> SQL Server 2000 64-bit features including the relational database engine
>> and
>> Analysis Services. If you have not done so already, back up the master
>> and
>> msdb databases and stop all database programs and services before
>> proceeding.
>> 05/18/2005 08:29:51.110 kbarticle = KB884525
>> 05/18/2005 08:29:51.110 lcid = 1033
>> 05/18/2005 08:29:51.110 package = HotFix1
>> 05/18/2005 08:29:51.110 productname = SQLOLAP64
>> 05/18/2005 08:29:51.110 servicepackname = SQL Server 2000 (64-bit)
>> Service
>> Pack 4
>> 05/18/2005 08:29:51.110 splevel = RTM,4
>> 05/18/2005 08:29:51.110 supportdir = C:\SQL2KSP4\IA64
>> 05/18/2005 08:29:51.110 version = 8
>> 05/18/2005 08:29:51.110
>> 05/18/2005 08:29:51.110 File Group Details: MSP
>> 05/18/2005 08:29:51.110 sourcepath = <SUPPORTDIR>\<PACKAGE>\Files
>> 05/18/2005 08:29:51.110 File Details: OverridePreSP4QFE.msp
>> 05/18/2005 08:29:51.110 parameters = SQLBUILD=2039
>> KBNUMBER=KB884525
>> REBOOT=ReallySuppress
>> 05/18/2005 08:29:51.110 File Details: sqlrun.msp
>> 05/18/2005 08:29:51.110 lockedfilecheck = 1
>> 05/18/2005 08:29:51.110 parameters = SQLBUILD=2039
>> KBNUMBER=KB884525
>> REBOOT=ReallySuppress FORCEPATCH=DISTMDL SUPPORTFTPATCH=1
>> SUPPORTMSSEARCHPATCH=1 FTPATCHPATH="<SUPPORTDIR>\<PACKAGE>\Files"
>> MSSEARCHPATCHPATH="<SUPPORTDIR>\<PACKAGE>\Files"
>> 05/18/2005 08:29:51.110
>> 05/18/2005 08:29:51.110 Instance Details: MSSQLServer
>> 05/18/2005 08:29:51.110 = Software\Microsoft\MSSQLServer\Setup
>> 05/18/2005 08:29:51.110 agentservicename = SQLSERVERAGENT
>> 05/18/2005 08:29:51.110 default = TRUE
>> 05/18/2005 08:29:51.110 hiveregpath = Software\Microsoft\MSSQLServer
>> 05/18/2005 08:29:51.110 id = MSSQLServer
>> 05/18/2005 08:29:51.110 installsqldatadir = C:\Program
>> Files\Microsoft
>> SQL Server\MSSQL
>> 05/18/2005 08:29:51.110 installsqldir = C:\Program Files\Microsoft
>> SQL
>> Server\MSSQL
>> 05/18/2005 08:29:51.110 lcid = 1033
>> 05/18/2005 08:29:51.110 name = MSSQLServer
>> 05/18/2005 08:29:51.110 olapservicename = MSSQLServerOLAPService
>> 05/18/2005 08:29:51.110 productcode =>> {0F34966C-4EF4-45AE-B78E-486BEFB71698}
>> 05/18/2005 08:29:51.110 servicename = MSSQLServer
>> 05/18/2005 08:29:51.110 sku = ENTERPRISE
>> 05/18/2005 08:29:51.110 sp = RTM
>> 05/18/2005 08:29:51.110 type = Liberty
>> 05/18/2005 08:29:51.110 version = 8|||I'm getting the same error as well. I'm thinking it has something t
do with a previous version of a hotfix that was applied
SELECT @.@.Versio
Microsoft SQL Server 2000 - 8.00.818 (Intel IA-64) Jun 1 200
15:32:45 Copyright (c) 1988-2003 Microsoft Corporation Enterpris
Edition (64-bit) on Windows NT 5.2 (Build 3790: )
05/26/2005 21:10:33.10
===============================================================================05/26/2005 21:10:33.107 Hotfix package launche
05/26/2005 21:10:33.107 Local Computer
05/26/2005 21:10:33.107 Target Details: OLYMPO
05/26/2005 21:10:33.107 commonfilesdir = C:\Program Files\Commo
File
05/26/2005 21:10:33.107 programfilesdir = C:\Program File
05/26/2005 21:10:33.107 supportdir
\\Pontos\IT\pontos\it\SQL2KSP4\IA6
05/26/2005 21:10:33.107 windir = C:\WINDOW
05/26/2005 21:10:33.107 winsysdir = C:\WINDOWS\system3
05/26/2005 21:10:33.107
05/26/2005 21:10:34.756 The following product instance wa
disqualified because a parent product instance of the same produc
code was found: {0F34966C-4EF4-45AE-B78E-486BEFB71698
05/26/2005 21:10:34.959 The following product instance wa
disqualified because a parent product instance of the same produc
code was found: {FA0BA25D-6D7B-4E7F-8BD6-FC8C53B5D47F
05/26/2005 21:10:34.959 Product Details
05/26/2005 21:10:34.959 INF File Name
\\Pontos\IT\pontos\it\SQL2KSP4\IA64\HotFix1.in
05/26/2005 21:10:34.959 build = 203
05/26/2005 21:10:34.959 description = SQL Server 2000 (64-bit
05/26/2005 21:10:34.959 description2 = Analysis Services 200
(64-bit
05/26/2005 21:10:34.959 details = This Service Pack can be applie
on all SQL Server 2000 64-bit features including the relationa
database engine and Analysis Services. If you have not done s
already, back up the master and msdb databases and stop all databas
programs and services before proceeding
05/26/2005 21:10:34.959 kbarticle = KB88452
05/26/2005 21:10:34.959 lcid = 103
05/26/2005 21:10:34.959 package = HotFix
05/26/2005 21:10:34.959 productname = SQLOLAP6
05/26/2005 21:10:34.959 servicepackname = SQL Server 2000 (64-bit
Service Pack
05/26/2005 21:10:34.959 splevel = RTM,
05/26/2005 21:10:34.959 supportdir
\\Pontos\IT\pontos\it\SQL2KSP4\IA6
05/26/2005 21:10:34.959 version =05/26/2005 21:10:34.959
05/26/2005 21:10:34.959 File Group Details: MS
05/26/2005 21:10:34.959 sourcepath
<SUPPORTDIR>\<PACKAGE>\File
05/26/2005 21:10:34.959 File Details: OverridePreSP4QFE.ms
05/26/2005 21:10:34.959 parameters = SQLBUILD=203
KBNUMBER=KB884525 REBOOT=ReallySuppres
05/26/2005 21:10:34.959 File Details: sqlrun.ms
05/26/2005 21:10:34.959 lockedfilecheck =05/26/2005 21:10:34.959 parameters = SQLBUILD=203
KBNUMBER=KB884525 REBOOT=ReallySuppress FORCEPATCH=DISTMD
SUPPORTFTPATCH=1 SUPPORTMSSEARCHPATCH=FTPATCHPATH="<SUPPORTDIR>\<PACKAGE>\Files
MSSEARCHPATCHPATH="<SUPPORTDIR>\<PACKAGE>\Files
05/26/2005 21:10:34.959
05/26/2005 21:10:34.959 Instance Details: PRODUCTIO
05/26/2005 21:10:34.959 = Software\Microsoft\Microsoft SQ
Server\PRODUCTION\Setu
05/26/2005 21:10:34.959 agentservicename = SQLAgent$PRODUCTIO
05/26/2005 21:10:34.959 hiveregpath = Software\Microsoft\Microsof
SQL Server\PRODUCTIO
05/26/2005 21:10:34.959 id = PRODUCTIO
05/26/2005 21:10:34.959 installsqldatadir = C:\Progra
Files\Microsoft SQL Server\MSSQL$PRODUCTIO
05/26/2005 21:10:34.959 installsqldir = C:\Program Files\Microsof
SQL Server\MSSQL$PRODUCTIO
05/26/2005 21:10:34.959 lcid = 103
05/26/2005 21:10:34.969 name = PRODUCTIO
05/26/2005 21:10:34.969 productcode
{0F34966C-4EF4-45AE-B78E-486BEFB71698
05/26/2005 21:10:34.969 servicename = MSSQL$PRODUCTIO
05/26/2005 21:10:34.969 sku = ENTERPRIS
05/26/2005 21:10:34.969 sp = RT
05/26/2005 21:10:34.969 type = Libert
05/26/2005 21:10:34.969 version =05/26/2005 21:10:34.969
05/26/2005 21:10:34.969 Instance Details: RMSWOR
05/26/2005 21:10:34.969 = Software\Microsoft\Microsoft SQ
Server\RMSWORK\Setu
05/26/2005 21:10:34.969 agentservicename = SQLAgent$RMSWOR
05/26/2005 21:10:34.969 hiveregpath = Software\Microsoft\Microsoft
SQL Server\RMSWORK
05/26/2005 21:10:34.969 id = RMSWORK
05/26/2005 21:10:34.969 installsqldatadir = C:\Program
Files\Microsoft SQL Server\MSSQL$RMSWORK
05/26/2005 21:10:34.969 installsqldir = C:\Program Files\Microsoft
SQL Server\MSSQL$RMSWORK
05/26/2005 21:10:34.969 lcid = 1033
05/26/2005 21:10:34.969 name = RMSWORK
05/26/2005 21:10:34.969 olapservicename = MSSQLServerOLAPService
05/26/2005 21:10:34.969 productcode ={FA0BA25D-6D7B-4E7F-8BD6-FC8C53B5D47F}
05/26/2005 21:10:34.969 servicename = MSSQL$RMSWORK
05/26/2005 21:10:34.969 sku = ENTERPRISE
05/26/2005 21:10:34.969 sp = RTM
05/26/2005 21:10:34.969 type = Liberty
05/26/2005 21:10:34.969 version = 8
05/26/2005 21:10:34.969
05/26/2005 21:10:34.969 Product Details:
05/26/2005 21:10:34.969 INF File Name:
\\Pontos\IT\pontos\it\SQL2KSP4\IA64\HotFix1.inf
05/26/2005 21:10:34.969 build = 2039
05/26/2005 21:10:34.969 description = Analysis Services 2000
(64-bit)
05/26/2005 21:10:34.969 description2 = Analysis Services 2000
(64-bit)
05/26/2005 21:10:34.969 details = This Service Pack can be applied
on all SQL Server 2000 64-bit features including the relational
database engine and Analysis Services. If you have not done so
already, back up the master and msdb databases and stop all database
programs and services before proceeding.
05/26/2005 21:10:34.969 kbarticle = KB884525
05/26/2005 21:10:34.969 lcid = 1033
05/26/2005 21:10:34.969 package = HotFix1
05/26/2005 21:10:34.969 productname = SQLOLAP64
05/26/2005 21:10:34.969 servicepackname = SQL Server 2000 (64-bit)
Service Pack 4
05/26/2005 21:10:34.969 splevel = RTM,4
05/26/2005 21:10:34.969 supportdir =\\Pontos\IT\pontos\it\SQL2KSP4\IA64
05/26/2005 21:10:34.969 version = 8
05/26/2005 21:10:34.969
05/26/2005 21:10:34.969 File Group Details: MSP
05/26/2005 21:10:34.969 sourcepath =<SUPPORTDIR>\<PACKAGE>\Files
05/26/2005 21:10:34.969 File Details: OverridePreSP4QFE.msp
05/26/2005 21:10:34.969 parameters = SQLBUILD=2039
KBNUMBER=KB884525 REBOOT=ReallySuppress
05/26/2005 21:10:34.969 File Details: sqlrun.msp
05/26/2005 21:10:34.969 lockedfilecheck = 1
05/26/2005 21:10:34.969 parameters = SQLBUILD=2039
KBNUMBER=KB884525 REBOOT=ReallySuppress FORCEPATCH=DISTMDL
SUPPORTFTPATCH=1 SUPPORTMSSEARCHPATCH=1
FTPATCHPATH="<SUPPORTDIR>\<PACKAGE>\Files"
MSSEARCHPATCHPATH="<SUPPORTDIR>\<PACKAGE>\Files"
05/26/2005 21:10:34.969
05/26/2005 21:10:34.969 Instance Details: RMSWORK
05/26/2005 21:10:34.969 = Software\Microsoft\OLAP Server\Setup
05/26/2005 21:10:34.969 agentservicename = SQLAgent$RMSWORK
05/26/2005 21:10:34.969 hiveregpath = Software\Microsoft\Microsoft
SQL Server\RMSWORK
05/26/2005 21:10:34.969 id = RMSWORK
05/26/2005 21:10:34.969 installsqldatadir = C:\Program
Files\Microsoft SQL Server\MSSQL$RMSWORK
05/26/2005 21:10:34.969 installsqldir = C:\Program Files\Microsoft
SQL Server\MSSQL$RMSWORK
05/26/2005 21:10:34.969 lcid = 1033
05/26/2005 21:10:34.969 name = RMSWORK
05/26/2005 21:10:34.969 olapservicename = MSSQLServerOLAPService
05/26/2005 21:10:34.969 productcode ={FA0BA25D-6D7B-4E7F-8BD6-FC8C53B5D47F}
05/26/2005 21:10:34.969 servicename = MSSQL$RMSWORK
05/26/2005 21:10:34.969 sku = ENTERPRISE
05/26/2005 21:10:34.969 sp = RTM
05/26/2005 21:10:34.969 type = OLAP
05/26/2005 21:10:34.969 version = 8
05/26/2005 21:10:34.969
05/26/2005 21:10:34.969 Product Details:
05/26/2005 21:10:34.969 INF File Name:
\\Pontos\IT\pontos\it\SQL2KSP4\IA64\HotFix1.inf
05/26/2005 21:10:34.969 build = 2039
05/26/2005 21:10:34.969 description = SQL Server 2000 (64-bit)
05/26/2005 21:10:34.969 description2 = Analysis Services 2000
(64-bit)
05/26/2005 21:10:34.969 details = This Service Pack can be applied
on all SQL Server 2000 64-bit features including the relational
database engine and Analysis Services. If you have not done so
already, back up the master and msdb databases and stop all database
programs and services before proceeding.
05/26/2005 21:10:34.969 kbarticle = KB884525
05/26/2005 21:10:34.969 lcid = 1033
05/26/2005 21:10:34.969 package = HotFix1
05/26/2005 21:10:34.969 productname = SQLOLAP64
05/26/2005 21:10:34.969 servicepackname = SQL Server 2000 (64-bit)
Service Pack 4
05/26/2005 21:10:34.969 splevel = RTM,4
05/26/2005 21:10:34.969 supportdir =\\Pontos\IT\pontos\it\SQL2KSP4\IA64
05/26/2005 21:10:34.969 version = 8
05/26/2005 21:10:34.969
05/26/2005 21:10:34.969 File Group Details: MSP
05/26/2005 21:10:34.969 sourcepath =<SUPPORTDIR>\<PACKAGE>\Files
05/26/2005 21:10:34.969 File Details: OverridePreSP4QFE.msp
05/26/2005 21:10:34.969 parameters = SQLBUILD=2039
KBNUMBER=KB884525 REBOOT=ReallySuppress
05/26/2005 21:10:34.969 File Details: sqlrun.msp
05/26/2005 21:10:34.969 lockedfilecheck = 1
05/26/2005 21:10:34.969 parameters = SQLBUILD=2039
KBNUMBER=KB884525 REBOOT=ReallySuppress FORCEPATCH=DISTMDL
SUPPORTFTPATCH=1 SUPPORTMSSEARCHPATCH=1
FTPATCHPATH="<SUPPORTDIR>\<PACKAGE>\Files"
MSSEARCHPATCHPATH="<SUPPORTDIR>\<PACKAGE>\Files"
05/26/2005 21:10:34.969
05/26/2005 21:10:34.969 Instance Details: SQL Tools
05/26/2005 21:10:34.969 = Software\Microsoft\Microsoft SQL
Server\80\Tools\ClientSetup\Setup
05/26/2005 21:10:34.969 installsqldir = C:\Program Files\Microsoft
SQL Server\80\Tools
05/26/2005 21:10:34.969 lcid = 1033
05/26/2005 21:10:34.969 name = SQL Tools
05/26/2005 21:10:34.969 productcode ={0F34966C-4EF4-45AE-B78E-486BEFB71698}
05/26/2005 21:10:34.969 sp = RTM
05/26/2005 21:10:34.969 version = 8
05/26/2005 21:10:34.969
05/26/2005 21:10:34.969 Product Details:
05/26/2005 21:10:34.969 INF File Name:
\\Pontos\IT\pontos\it\SQL2KSP4\IA64\HotFix1.inf
05/26/2005 21:10:34.969 build = 2039
05/26/2005 21:10:34.969 description = Analysis Services 2000
(64-bit)
05/26/2005 21:10:34.969 description2 = Analysis Services 2000
(64-bit)
05/26/2005 21:10:34.969 details = This Service Pack can be applied
on all SQL Server 2000 64-bit features including the relational
database engine and Analysis Services. If you have not done so
already, back up the master and msdb databases and stop all database
programs and services before proceeding.
05/26/2005 21:10:34.969 kbarticle = KB884525
05/26/2005 21:10:34.969 lcid = 1033
05/26/2005 21:10:34.969 package = HotFix1
05/26/2005 21:10:34.969 productname = SQLOLAP64
05/26/2005 21:10:34.969 servicepackname = SQL Server 2000 (64-bit)
Service Pack 4
05/26/2005 21:10:34.969 splevel = RTM,4
05/26/2005 21:10:34.969 supportdir =\\Pontos\IT\pontos\it\SQL2KSP4\IA64
05/26/2005 21:10:34.969 version = 8
05/26/2005 21:10:34.969
05/26/2005 21:10:34.969 File Group Details: MSP
05/26/2005 21:10:34.969 sourcepath =<SUPPORTDIR>\<PACKAGE>\Files
05/26/2005 21:10:34.969 File Details: OverridePreSP4QFE.msp
05/26/2005 21:10:34.969 parameters = SQLBUILD=2039
KBNUMBER=KB884525 REBOOT=ReallySuppress
05/26/2005 21:10:34.969 File Details: sqlrun.msp
05/26/2005 21:10:34.969 lockedfilecheck = 1
05/26/2005 21:10:34.969 parameters = SQLBUILD=2039
KBNUMBER=KB884525 REBOOT=ReallySuppress FORCEPATCH=DISTMDL
SUPPORTFTPATCH=1 SUPPORTMSSEARCHPATCH=1
FTPATCHPATH="<SUPPORTDIR>\<PACKAGE>\Files"
MSSEARCHPATCHPATH="<SUPPORTDIR>\<PACKAGE>\Files"
05/26/2005 21:10:34.969
05/26/2005 21:10:34.969 Instance Details: OLAPClient
05/26/2005 21:10:34.969 = Software\Microsoft\OLAP Server\Setup
05/26/2005 21:10:34.969 installsqldir = C:\Program Files\Common
Files\system\OLE DB
05/26/2005 21:10:34.969 lcid = 1033
05/26/2005 21:10:34.969 name = OLAPClient
05/26/2005 21:10:34.969 productcode ={FA0BA25D-6D7B-4E7F-8BD6-FC8C53B5D47F}
05/26/2005 21:10:34.969 sp = RTM
05/26/2005 21:10:34.969 version = 8
05/26/2005 21:10:34.969
05/26/2005 21:10:51.286 Authenticating user using Windows
Authentication
05/26/2005 21:10:51.306 SQL Service MSSQL$PRODUCTION was previously
running, ready for authentication
05/26/2005 21:10:51.306 SQL Agent Service SQLAgent$PRODUCTION was
previously running
05/26/2005 21:10:51.489 User authentication was successful
05/26/2005 21:10:54.787 Attempting to install product: SQLOLAP64|||Hi there:
i am also facing the same problem when i try installing SQL2k SP4 on IA serversWere you able ti fix it. Will appreciate any help.
Kind Regards,
Rosha
From http://www.developmentnow.com/g/118_2005_5_0_0_524275/IA64-SP4-Install-Problem.ht
Posted via DevelopmentNow.com Group
http://www.developmentnow.com

Monday, March 26, 2012

I was fianlly able to install VS tools over the weekend....Re: Help with installing VS Tools

Hi,

I have a problem with the installation of SSCE31VSTools-ENU.exe into VS2005. The installation ended after a few seconds although in the event log there is information that the product is successfuly installed. However, when I run Visual studio there is no project under Smart Device regarding SQL Compact database or something similar (there are only templates for: device application, class library, control library, console application, empty project and nothing more)

VS2005 is in this version 8.0.50727.762 (SP.050727-7600)

In application event log there is: Product: Microsoft SQL Server 2005 Compact Edition Tools for Visual Studio 2005 [ENU] -- Configuration completed successfully.'"

Has anyone some idea if there is a problem or how to create SQL Compact database?

Thank you

Jarda

Have you tried installing the released bits?|||

Hi William,

I have the same problem that the gentlemen in the initial message described. I tried installing the released bits as you recommended, but the problem continued. Do you have any other suggestions?

Thanks for your help.

Mario

|||

Hi,

yes, it's yesterday release (Date Published: 1/11/2007).

Thanks

Jarda

|||

Did you install in the correct order?

The VSTools must be installed before the SQL Server ce Runtime.

Robert Wishlaw

|||

Hi,

my installastion order was:

Compact SDK

Compact Tools

Compact SQL edition

I hope that SDK didn't install runtime.

Thanks

Jarda

|||

Hi,

I made another try with installation. Uninstall all items regarding SQL Compact edition and try to install VS Tools first. However I got this message

"The upgrade patch cannot be installed by the Windows Installer service because the program to be upgraded may be missing, or the upgrade patch may update a different version of the program. Verify that the program to be upgraded exists on your computer and that you have the correct upgrade patch." :-(

Other items can be installed well (SDK, runtime).

I have no previous (beta) installation of Compact edition on my machine.

Please help me

Thanks

Jarda

btw. the link to download the VS Tools from MS site is wrong.

|||

jardajirava wrote:


the link to download the VS Tools from MS site is wrong.

Which link?

Robert Wishlaw|||

jardajirava wrote:

Hi,

I made another try with installation. Uninstall all items regarding SQL Compact edition and try to install VS Tools first. However I got this message

"The upgrade patch cannot be installed by the Windows Installer service because the program to be upgraded may be missing, or the upgrade patch may update a different version of the program. Verify that the program to be upgraded exists on your computer and that you have the correct upgrade patch." :-(

Other items can be installed well (SDK, runtime).

I have no previous (beta) installation of Compact edition on my machine.

Please help me

Thanks

Jarda

btw. the link to download the VS Tools from MS site is wrong.

Are you installing

Microsoft SQL Server 2005 Compact Edition Server Tools

or

Microsoft SQL Server 2005 Compact Edition Tools for Visual Studio 2005 Service Pack 1

?

The first is only for installations with IIS and SQL Server 2005. (not Express)

Be sure that the versions of the VS tools and runtime are the same. Get the current version of the VSTools from the link in the Related Resources section of the runtime download page at

http://www.microsoft.com/downloads/details.aspx?FamilyID=85e0c3ce-3fa1-453a-8ce9-af6ca20946c3&DisplayLang=en#QuickInfoContainer

Robert Wishlaw|||

Hi,

it is Tools for Visual Studio 2005 Service Pack 1 (VSTools). All downloads I made yesterday (11.1.2007) I try to download it again now but same information is displayed.

I have installed this extensions/addons in my Visual studio 2005:

Microsoft Visual Studio 2005
Version 8.0.50727.762 (SP.050727-7600)
Microsoft .NET Framework
Version 2.0.50727

Installed Edition: Professional

Microsoft Visual Basic 2005 77626-009-0000007-41168
Microsoft Visual Basic 2005

Microsoft Visual C# 2005 77626-009-0000007-41168
Microsoft Visual C# 2005

Microsoft Visual C++ 2005 77626-009-0000007-41168
Microsoft Visual C++ 2005

Microsoft Visual Studio Tools for Office 77626-009-0000007-41168
Microsoft Visual Studio Tools for the Microsoft Office System

Microsoft Visual Web Developer 2005 77626-009-0000007-41168
Microsoft Visual Web Developer 2005

Microsoft Web Application Projects 2005 77626-009-0000007-41168
Microsoft Web Application Projects 2005
Version 8.0.50727.762

Visual Studio 2005 Tools for Office Second Edition 77626-009-0000007-41168
Microsoft Visual Studio 2005 Tools for the 2007 Microsoft Office System

Extensions for Windows WF
Windows Workflow Foundation Tools for Visual Studio

Microsoft Visual Studio 2005 Professional Edition - ENU Service Pack 1 (KB926601)
This service pack is for Microsoft Visual Studio 2005 Professional Edition - ENU.
If you later install a more recent service pack, this service pack will be uninstalled automatically.
For more information, visit http://support.microsoft.com/kb/926601

SQL Server Analysis Services
Microsoft SQL Server Analysis Services Designer
Version 9.00.2047.00

SQL Server Integration Services
Microsoft SQL Server Integration Services Designer
Version 9.00.1399.00

SQL Server Reporting Services
Microsoft SQL Server Reporting Services Designers
Version 9.00.1399.00

Windows Installer XML Version 3.0
Votive 2005
Windows Installer XML (WiX) Toolset, Version 3.0
Primary Contributor: Justin Rockwood
Additional Contributors: Bob Arnson
Copyright ? Microsoft Corporation. All rights reserved.

XmlMvp.XPathmania 1.0
XmlMvp.XPathmania

Maybe this helps

Thanks

Jarda

|||

I am experiencing the same problem. After downloading the most recent bits (1/11/07) from the MS website I receive the error, on attempting to install the VS Tools for Visual Studio 2005 SP1 (SSCE31VStools-Enu.msi) that:

"The upgrade patch cannot be installed by the Windows Installer service because the program to be upgraded may be missing, or the upgrade patch may update a different version of the program. Verify that the program to be upgraded exists on your computer and that you have the correct upgrade patch."

I have confirmed I have installed VS 2005 SP1.

So... why does it reference an upgrade patch? I am installing the RTW version fresh, as I never installed the Beta.

Anyway... pretty frustrating :(

Ryan

|||

Sorry to reply to myself here... I discovered yesterday that my WMI installation is all messed up. This is rather odd as I develop WMI queries all the time against my localhost (just read queries, so I don't mess with the repositories etc).

I know WMI was working on Thursday before I installed the 3.1 Release of January 11 (in which I also uninstalled RC1). At any rate, WMI's class registrations are really messed up in a way the support articles and WMIDiag can't fix. Error message from WMI is 0x80040154 - Class not registered.

So... it makes some sense that the installer would not be able to find the correct product installed if it uses WMI to do so.

I am not able to point to the uninstall of RC1 or the install of the release version as "the problem", but it's an odd coincidence.

|||

I also get the same "The upgrade patch cannot be installed ..." message on VS SP1 when trying to install the tools.

|||

these post were helpful - I'm not going to try to install upgrade

Thanks

|||

Hi,

I just wanted to share that I was finally able to install the VS tools. The problem was that I had to uninstall and reinstall Visual Studio 2005 completely, then installed Visual Studio 2005 SP1, and finally installed the newly released code (including VS tools--> "SSCE31VSTools-ENU.exe").

I hope it helps.

Regards,

Mario

Wednesday, March 21, 2012

I want to move an existing table from another

I want to move an existing table from another.

Example

B.mdf dbo.xx toC.mdf dbo.xx

B.mdf dbo.xx has records - I created a script and install the script for C.mdf dbo.xx

C.mdf dbo.xx is empty -

All I need now is to populate the records from B.mdf dbo.xx to the empty C.mdf dbo.xx

I was telling I could do a cut and paste to copy the dbo.xx

Thank you in advance.

~ Peaches ~

With SQL 2000 use DTS to copy to contents. With SQL2005 use SSIS.

|||

There is another way and you don't need to create the target table first:

You can copy database tables from one database to another. Here is a sample for you to move one table from one database to another database without creating the new table first.

Run this from the database you want to export data:

SELECT*INTO newDataBaseName.dbo.yourNewTableFROM tableToExpost

|||

Couple of things to keep in mind are:

(1) If you already created the target table with PK-FK relationships, indexes, you can either use DTS or

INSERT INTO TargetDB.dbo.TargetTable (<columns>)

SELECT <columns> FROM SourceDb.dbo.SourceTable

(2) If the target table does not exist, then you can uss limno's approach and do a SELECT * INTO TargetDb.dbo.TargetTable FROM SourceDB.dbo.SourceTable WHERE <Condition>

(3) IF there is lot of data ( as in > few million rows) you might also want to look into BCP utility in Books On Line.

|||

Thank you very much !!!!!

I was able to take care of this in 5 minutes ...

Whew::: This makes my life easier today.

~ Peaches ~

I want to install SSIS on a 64 bit server without SQL Server on it

I want to install SSIS on a 64 bit server without SQL Server on it.

Say I want to install the SSIS engine on one server and have it call packages stored on another servers msdb.

It this possible?

Yes. It does require a SQL license for the server with SSIS on it, as well as the server with the database engine.

Friday, March 9, 2012

I need to install only the database

I want to download the Sql 2000 Database.
I need it only to do programing things from the .net
environment so i want to connect to the sql 2000 database.
Thanks...
If you only want to work with SQL Server from dot net, consider getting the
free MSDE or SQL Server 2005 Express (the next version of MSDE).
Or you can purchase the developer edition of SQL Server 2000 for $50.
hth
Eric
"houssam hamdan" <hamdan_houssam@.hotmail.com> wrote in message
news:39ab01c4725d$cb3db380$a401280a@.phx.gbl...
> I want to download the Sql 2000 Database.
> I need it only to do programing things from the .net
> environment so i want to connect to the sql 2000 database.
> Thanks...

I need to install only the database

I want to download the Sql 2000 Database.
I need it only to do programing things from the .net
environment so i want to connect to the sql 2000 database.
Thanks...If you only want to work with SQL Server from dot net, consider getting the
free MSDE or SQL Server 2005 Express (the next version of MSDE).
Or you can purchase the developer edition of SQL Server 2000 for $50.
hth
Eric
"houssam hamdan" <hamdan_houssam@.hotmail.com> wrote in message
news:39ab01c4725d$cb3db380$a401280a@.phx.gbl...
> I want to download the Sql 2000 Database.
> I need it only to do programing things from the .net
> environment so i want to connect to the sql 2000 database.
> Thanks...

I need to install only the database

I want to download the Sql 2000 Database.
I need it only to do programing things from the .net
environment so i want to connect to the sql 2000 database.
Thanks...If you only want to work with SQL Server from dot net, consider getting the
free MSDE or SQL Server 2005 Express (the next version of MSDE).
Or you can purchase the developer edition of SQL Server 2000 for $50.
hth
Eric
"houssam hamdan" <hamdan_houssam@.hotmail.com> wrote in message
news:39ab01c4725d$cb3db380$a401280a@.phx.gbl...
> I want to download the Sql 2000 Database.
> I need it only to do programing things from the .net
> environment so i want to connect to the sql 2000 database.
> Thanks...

Friday, February 24, 2012

I need help with what appears to be a botched install.

Okay, i'm learning VB.NET (and having quite a bit of fun with it). Well, I had the old beta version. Anyway, went away for a week and found I could no longer use it. Why?

"Beta period is over.".

Yeah, it sucks.

Well, I uninstalled it via the uninstaller. I upgraded my .NET framework, etc, and redownloaded VB.NET. Everything installed okay, save for the SQL server. It repeatedly fails.

I have hunted down and shot each component quite ruthlessly, but I don't know what beta component remains. I can't get it to install because it says I have beta components left.

And VB.NET works. Barely. I had to disable the hosting process, otherwise it gives me a message about an invalid binding handle. Not often that a Beta product works better than the production one.

The uninstall tool won't work for some reason. I'm this close to just reformatting.

Please help, I'd like to code again.

Thanks.

bump|||Hi,

if you also had SQL Server beta installed you should also deinstall SQL Server as in the Beta period the SQL Server framework version and the version of the framework VS uses had to be in line.So installing VS / SQL Server / Framework version, reboot, installing SQL Server / VS (Framework is installed with one of the two) should make your system running :-)

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de

I need help with what appears to be a botched install.

Okay, i'm learning VB.NET (and having quite a bit of fun with it). Well, I had the old beta version. Anyway, went away for a week and found I could no longer use it. Why?

"Beta period is over.".

Yeah, it sucks.

Well, I uninstalled it via the uninstaller. I upgraded my .NET framework, etc, and redownloaded VB.NET. Everything installed okay, save for the SQL server. It repeatedly fails.

I have hunted down and shot each component quite ruthlessly, but I don't know what beta component remains. I can't get it to install because it says I have beta components left.

And VB.NET works. Barely. I had to disable the hosting process, otherwise it gives me a message about an invalid binding handle. Not often that a Beta product works better than the production one.

The uninstall tool won't work for some reason. I'm this close to just reformatting.

Please help, I'd like to code again.

Thanks.

bump|||Hi,

if you also had SQL Server beta installed you should also deinstall SQL Server as in the Beta period the SQL Server framework version and the version of the framework VS uses had to be in line.So installing VS / SQL Server / Framework version, reboot, installing SQL Server / VS (Framework is installed with one of the two) should make your system running :-)

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de