Monday, March 19, 2012

Can they co-exist ?

Hi,
Can MSDE and SQl server 2000 standard edition co-exist.
Arvind.Hi
Yes, one just has to be a named instance, not listening on port 1433.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Arvi" <Arvi@.discussions.microsoft.com> wrote in message
news:A8C80E5D-DDAC-4219-9383-712651A275EE@.microsoft.com...
> Hi,
> Can MSDE and SQl server 2000 standard edition co-exist.
> Arvind.|||Yes.
--
Please post DDL, sample data and desired results.
See http://www.aspfaq.com/5006 for info.
"Arvi" <Arvi@.discussions.microsoft.com> wrote in message
news:A8C80E5D-DDAC-4219-9383-712651A275EE@.microsoft.com...
> Hi,
> Can MSDE and SQl server 2000 standard edition co-exist.
> Arvind.|||Hi Mike and Aaron,
Thanks for your reply, in that case why would the installation of SQl
server 2000 std edition on Win 2K3 64 bit server not complete, it just hangs
at the point
"Setup is configuring your selected options " and it never completes the
installation.
No matter what uninstalling previous editions of SQL server or MSDE nothing
helps.
This is waht the end of log file reads like:
--
15:50:34 Monarch
15:50:34 Monarch\Monr1033
15:50:34 Monarch\MonrIntl
15:50:34 Jet
15:50:34 CoreInst
15:50:34 CoreCOM
15:50:34 CoreCOM\Res1033
15:50:34 CoreCOM\ResIntl
15:50:34 CoreTool
15:50:34 CoreTool\Res1033
15:50:34 CoreTool\ResOther
15:50:34 DBLibCli
15:50:34 SFExt
15:50:34 SFExt\ActiveX
15:50:34 SFExt\ActiveX\Res1033
15:50:34 SFExt\ActiveX\ResIntl
15:50:34 SFExt\Res1033
15:50:34 SFExt\ResIntl
15:50:34 Trace
15:50:34 Trace\Res1033
15:50:34 Trace\ResOther
15:50:34 MiscCore
15:50:34 MC
15:50:34 MC\MC1033
15:50:34 MC\MCIntl
15:50:34 MC\Help
15:50:34 SQLMgr
15:50:34 SQLMgr\Res1033
15:50:34 SQLMgr\ResIntl
15:50:34 SvrTool
15:50:34 SvrTool\Res1033
15:50:34 SvrTool\ResIntl
15:50:34 DTSUI
15:50:34 DTSUI\Res1033
15:50:34 DTSUI\ResIntl
15:50:34 MSOlap
15:50:34 MSOlap\Res1033
15:50:34 MSOlap\ResIntl
15:50:34 ATL
15:50:34 ATL\winnt
15:50:34 ATL\win9x
15:50:34 MFC42U
15:50:34 VC
15:50:35 VB
15:50:35 OCX1
15:50:35 SQLAdHlp
15:50:35 SQLAdHlp\Res1033
15:50:35 SQLAdHlp\ResOther
15:50:35 {E07FDDBE-5A21-11d2-9DAD-00C04F79D434}
15:50:35 {E07FDDC7-5A21-11d2-9DAD-00C04F79D434}
15:50:35 {E07FDDC0-5A21-11d2-9DAD-00C04F79D434}
15:50:35 {E07FDDBF-5A21-11d2-9DAD-00C04F79D434}
15:50:35 End Action LogSelectedComponents
15:50:35 Begin Action InstallPkgs:
15:50:35 Begin Action: Locked Connectivity Files Check
15:50:35 ConnectivityLocked returned: 0
15:50:35 The operation completed successfully.
15:50:35 End Action: Locked Connectivity Files Check
15:50:35 Setup is installing Microsoft Data Access Components (MDAC) ...
15:50:35 F:\MS_sql2k\X86\Other\sqlredis.exe /q:a /C:"setupre.exe WARN=1 -s
-SMS"
15:50:45 ExitCode: 0
15:50:45 Setup is installing Microsoft Distributed Transaction Coordinator
(MSDTC) ...
15:50:45 C:\DOCUME~1\ADMINI~1\LOCALS~1\Temp\SqlSetup\Bin\cldtcstp.exe
-SupportDir "C:\DOCUME~1\ADMINI~1\LOCALS~1\Temp\SqlSetup\Bin" -DTCPkg
"F:\MS_sql2k\X86\Other\dtcsetup.exe" -LogFile "C:\WINDOWS\sqlstp.log"
15:50:45 Process Exit Code: (0)
15:50:45 InstallMSSearch instance: MSSQLSERVER
15:50:45 Software\Microsoft\Search\Install:Version : 9.107.5512
15:50:45 MSSearch 2.0 or greater version check returned 1
15:50:45 Setup is installing the Microsoft Full-Text Search Engine ...
15:50:45 "F:\MS_sql2k\X86\FullText\MSSearch\Search\SearchStp.exe" /s
/a:SQLServer
15:50:48 Process Exit Code: (0)
15:50:48 /Q:A /T:C:\DOCUME~1\ADMINI~1\LOCALS~1\Temp\ixp001.tmp
15:50:48 Setup is installing HTML Help ...
15:50:48 HTML Help installer exit code: 0
15:51:10 End Action InstallPkgs
15:51:10 Begin Action MoveFileData:
15:51:10 Enabled SELFREGISTERBATCH
15:51:10 Enabled CORECOMPONENTHANDLING
15:51:34 Begin Action: MoveFileDataSpecial
15:51:35 End Action: MoveFileDataSpecial
15:51:35 End Action MoveFileData
15:51:35 Begin Action ProcessAfterDataMove:
15:51:35 F:\MS_sql2k\X86\Binn\hhcol.exe C:\Program Files (x86)\Microsoft SQL
Server\80\Tools\Books
15:51:35 End Action ProcessAfterDataMove
15:51:35 Begin Action BuildServer:
15:51:36 C:\DOCUME~1\ADMINI~1\LOCALS~1\Temp\SqlSetup\Bin\scm.exe -Silent 1
-Action 5 -ExePath "C:\Program Files (x86)\Microsoft SQL
Server\MSSQL\binn\sqlservr.exe" -Service "MSSQLSERVER"
15:51:36 Process Exit Code: (0)
15:51:36 Begin Action: CreateRegistrySetSQL
15:51:36 End Action: CreateRegistrySetSQL
15:51:36 Begin Action: RegWriteSetupEntry
15:51:36 End Action: RegWriteSetupEntry
15:51:36 Begin Action: CreateSer
15:51:36 End Action: CreateSer
15:51:36 Begin Action: SkuIt
15:51:36 End Action: SkuIt
15:51:36 SetFileSecuritySQLAndAdmin for C:\Program Files (x86)\Microsoft SQL
Server\MSSQL returned: 0, 0
15:51:36 SetRegSecuritySQLAndAdmin for
Software\Microsoft\MSSQLServer\MSSQLServer returned: 0, 0
15:51:36 Begin Action: UpdateSystemPath
15:51:36 Path successfully updated.
15:51:36 C:\Program Files\Support
Tools\;%SystemRoot%\system32;%SystemRoot%;%SystemRoot%\System32\Wbem;C:\Program Files (x86)\Microsoft SQL Server\80\Tools\BINN
15:51:36 End Action: UpdateSystemPath
15:51:37 C:\Program Files (x86)\Microsoft SQL
Server\80\Tools\Binn\cnfgsvr.exe -F "C:\WINDOWS\sqlstp.log" -I MSSQLSERVER
-V 1 -M 0 -Q "SQL_Latin1_General_CP1_CI_AS" -H 131446 -U sa -P
###############################################################################
Starting Service ...
SQL_Latin1_General_CP1_CI_AS
-m -Q -T4022 -T3659
---
"Mike Epprecht (SQL MVP)" wrote:
> Hi
> Yes, one just has to be a named instance, not listening on port 1433.
> Regards
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> IM: mike@.epprecht.net
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
> "Arvi" <Arvi@.discussions.microsoft.com> wrote in message
> news:A8C80E5D-DDAC-4219-9383-712651A275EE@.microsoft.com...
> > Hi,
> > Can MSDE and SQl server 2000 standard edition co-exist.
> >
> > Arvind.
>
>|||Hi
AFAIK, SQL Server 2000 with SP4 is compatible with X64, earlier versions are
not. SP4 is in beta.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Arvi" <Arvi@.discussions.microsoft.com> wrote in message
news:1D6E61ED-713D-4E50-8210-C0696C82AB2A@.microsoft.com...
> Hi Mike and Aaron,
> Thanks for your reply, in that case why would the installation of SQl
> server 2000 std edition on Win 2K3 64 bit server not complete, it just
hangs
> at the point
> "Setup is configuring your selected options " and it never completes the
> installation.
> No matter what uninstalling previous editions of SQL server or MSDE
nothing
> helps.
> This is waht the end of log file reads like:
> --
> 15:50:34 Monarch
> 15:50:34 Monarch\Monr1033
> 15:50:34 Monarch\MonrIntl
> 15:50:34 Jet
> 15:50:34 CoreInst
> 15:50:34 CoreCOM
> 15:50:34 CoreCOM\Res1033
> 15:50:34 CoreCOM\ResIntl
> 15:50:34 CoreTool
> 15:50:34 CoreTool\Res1033
> 15:50:34 CoreTool\ResOther
> 15:50:34 DBLibCli
> 15:50:34 SFExt
> 15:50:34 SFExt\ActiveX
> 15:50:34 SFExt\ActiveX\Res1033
> 15:50:34 SFExt\ActiveX\ResIntl
> 15:50:34 SFExt\Res1033
> 15:50:34 SFExt\ResIntl
> 15:50:34 Trace
> 15:50:34 Trace\Res1033
> 15:50:34 Trace\ResOther
> 15:50:34 MiscCore
> 15:50:34 MC
> 15:50:34 MC\MC1033
> 15:50:34 MC\MCIntl
> 15:50:34 MC\Help
> 15:50:34 SQLMgr
> 15:50:34 SQLMgr\Res1033
> 15:50:34 SQLMgr\ResIntl
> 15:50:34 SvrTool
> 15:50:34 SvrTool\Res1033
> 15:50:34 SvrTool\ResIntl
> 15:50:34 DTSUI
> 15:50:34 DTSUI\Res1033
> 15:50:34 DTSUI\ResIntl
> 15:50:34 MSOlap
> 15:50:34 MSOlap\Res1033
> 15:50:34 MSOlap\ResIntl
> 15:50:34 ATL
> 15:50:34 ATL\winnt
> 15:50:34 ATL\win9x
> 15:50:34 MFC42U
> 15:50:34 VC
> 15:50:35 VB
> 15:50:35 OCX1
> 15:50:35 SQLAdHlp
> 15:50:35 SQLAdHlp\Res1033
> 15:50:35 SQLAdHlp\ResOther
> 15:50:35 {E07FDDBE-5A21-11d2-9DAD-00C04F79D434}
> 15:50:35 {E07FDDC7-5A21-11d2-9DAD-00C04F79D434}
> 15:50:35 {E07FDDC0-5A21-11d2-9DAD-00C04F79D434}
> 15:50:35 {E07FDDBF-5A21-11d2-9DAD-00C04F79D434}
> 15:50:35 End Action LogSelectedComponents
> 15:50:35 Begin Action InstallPkgs:
> 15:50:35 Begin Action: Locked Connectivity Files Check
> 15:50:35 ConnectivityLocked returned: 0
> 15:50:35 The operation completed successfully.
> 15:50:35 End Action: Locked Connectivity Files Check
> 15:50:35 Setup is installing Microsoft Data Access Components (MDAC) ...
> 15:50:35 F:\MS_sql2k\X86\Other\sqlredis.exe /q:a /C:"setupre.exe WARN=1 -s
> -SMS"
> 15:50:45 ExitCode: 0
> 15:50:45 Setup is installing Microsoft Distributed Transaction Coordinator
> (MSDTC) ...
> 15:50:45 C:\DOCUME~1\ADMINI~1\LOCALS~1\Temp\SqlSetup\Bin\cldtcstp.exe
> -SupportDir "C:\DOCUME~1\ADMINI~1\LOCALS~1\Temp\SqlSetup\Bin" -DTCPkg
> "F:\MS_sql2k\X86\Other\dtcsetup.exe" -LogFile "C:\WINDOWS\sqlstp.log"
> 15:50:45 Process Exit Code: (0)
> 15:50:45 InstallMSSearch instance: MSSQLSERVER
> 15:50:45 Software\Microsoft\Search\Install:Version : 9.107.5512
> 15:50:45 MSSearch 2.0 or greater version check returned 1
> 15:50:45 Setup is installing the Microsoft Full-Text Search Engine ...
> 15:50:45 "F:\MS_sql2k\X86\FullText\MSSearch\Search\SearchStp.exe" /s
> /a:SQLServer
> 15:50:48 Process Exit Code: (0)
> 15:50:48 /Q:A /T:C:\DOCUME~1\ADMINI~1\LOCALS~1\Temp\ixp001.tmp
> 15:50:48 Setup is installing HTML Help ...
> 15:50:48 HTML Help installer exit code: 0
> 15:51:10 End Action InstallPkgs
> 15:51:10 Begin Action MoveFileData:
> 15:51:10 Enabled SELFREGISTERBATCH
> 15:51:10 Enabled CORECOMPONENTHANDLING
> 15:51:34 Begin Action: MoveFileDataSpecial
> 15:51:35 End Action: MoveFileDataSpecial
> 15:51:35 End Action MoveFileData
> 15:51:35 Begin Action ProcessAfterDataMove:
> 15:51:35 F:\MS_sql2k\X86\Binn\hhcol.exe C:\Program Files (x86)\Microsoft
SQL
> Server\80\Tools\Books
> 15:51:35 End Action ProcessAfterDataMove
> 15:51:35 Begin Action BuildServer:
> 15:51:36 C:\DOCUME~1\ADMINI~1\LOCALS~1\Temp\SqlSetup\Bin\scm.exe -Silent
1
> -Action 5 -ExePath "C:\Program Files (x86)\Microsoft SQL
> Server\MSSQL\binn\sqlservr.exe" -Service "MSSQLSERVER"
> 15:51:36 Process Exit Code: (0)
> 15:51:36 Begin Action: CreateRegistrySetSQL
> 15:51:36 End Action: CreateRegistrySetSQL
> 15:51:36 Begin Action: RegWriteSetupEntry
> 15:51:36 End Action: RegWriteSetupEntry
> 15:51:36 Begin Action: CreateSer
> 15:51:36 End Action: CreateSer
> 15:51:36 Begin Action: SkuIt
> 15:51:36 End Action: SkuIt
> 15:51:36 SetFileSecuritySQLAndAdmin for C:\Program Files (x86)\Microsoft
SQL
> Server\MSSQL returned: 0, 0
> 15:51:36 SetRegSecuritySQLAndAdmin for
> Software\Microsoft\MSSQLServer\MSSQLServer returned: 0, 0
> 15:51:36 Begin Action: UpdateSystemPath
> 15:51:36 Path successfully updated.
> 15:51:36 C:\Program Files\Support
>
Tools\;%SystemRoot%\system32;%SystemRoot%;%SystemRoot%\System32\Wbem;C:\Prog
ram Files (x86)\Microsoft SQL Server\80\Tools\BINN
> 15:51:36 End Action: UpdateSystemPath
> 15:51:37 C:\Program Files (x86)\Microsoft SQL
> Server\80\Tools\Binn\cnfgsvr.exe -F "C:\WINDOWS\sqlstp.log" -I
MSSQLSERVER
> -V 1 -M 0 -Q "SQL_Latin1_General_CP1_CI_AS" -H 131446 -U sa -P
>
############################################################################
###
>
> Starting Service ...
> SQL_Latin1_General_CP1_CI_AS
> -m -Q -T4022 -T3659
> ---
>
> "Mike Epprecht (SQL MVP)" wrote:
> > Hi
> >
> > Yes, one just has to be a named instance, not listening on port 1433.
> >
> > Regards
> > --
> > Mike Epprecht, Microsoft SQL Server MVP
> > Zurich, Switzerland
> >
> > IM: mike@.epprecht.net
> >
> > MVP Program: http://www.microsoft.com/mvp
> >
> > Blog: http://www.msmvps.com/epprecht/
> >
> > "Arvi" <Arvi@.discussions.microsoft.com> wrote in message
> > news:A8C80E5D-DDAC-4219-9383-712651A275EE@.microsoft.com...
> > > Hi,
> > > Can MSDE and SQl server 2000 standard edition co-exist.
> > >
> > > Arvind.
> >
> >
> >

No comments:

Post a Comment