Can Visual Studio 2005 BI co-exist with Visual Studio 2003?

I ask because I'm still looking for the source of interface problems I have in using the SSIS designer.

Yes. I have the two side by side and develop projects of most types in both.

Not sure if there is an official guide to this but I have found in the past that it always pays to install the older software first, followed by the later version.

|||Thanks Darren. Just wanted to make sure I wasn't making a fundamental mistake.|||Can Visual Studio Orcas and Visual Studio 2005 coexist?sql

Can Visual Studio 2005 BI co-exist with Visual Studio 2003?

I ask because I'm still looking for the source of interface problems I have in using the SSIS designer.

Yes. I have the two side by side and develop projects of most types in both.

Not sure if there is an official guide to this but I have found in the past that it always pays to install the older software first, followed by the later version.

|||Thanks Darren. Just wanted to make sure I wasn't making a fundamental mistake.|||Can Visual Studio Orcas and Visual Studio 2005 coexist?

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

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\cl dtcstp.exe
-SupportDir "C:\DOCUME~1\ADMINI~1\LOCALS~1\Temp\SqlSetup\B in" -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\SearchSt p.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\sc m.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%;%SystemR oot%\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
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\cl dtcstp.exe
> -SupportDir "C:\DOCUME~1\ADMINI~1\LOCALS~1\Temp\SqlSetup\B in" -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\SearchSt p.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\sc m.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%;%SystemR oot%\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
>
################################################## ##########################
###[vbcol=seagreen]
>
> Starting Service ...
> SQL_Latin1_General_CP1_CI_AS
> -m -Q -T4022 -T3659
>
> "Mike Epprecht (SQL MVP)" wrote:

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\SqlSe
tup\Bin\cldtcstp.exe
-SupportDir " C:\DOCUME~1\ADMINI~1\LOCALS~1\Temp\SqlSe
tup\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:Versio
n : 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\ixp
001.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\SqlSe
tup\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\MSSQLServ
er 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
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\SqlSe
tup\Bin\cldtcstp.exe
> -SupportDir " C:\DOCUME~1\ADMINI~1\LOCALS~1\Temp\SqlSe
tup\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:Versio
n : 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\ixp
001.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\SqlSe
tup\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\MSSQLServ
er 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
>
########################################
####################################
###[vbcol=seagreen]
>
> Starting Service ...
> SQL_Latin1_General_CP1_CI_AS
> -m -Q -T4022 -T3659
> ---
>
> "Mike Epprecht (SQL MVP)" wrote:
>

Can SQL2000 & SQL2005 co-exist on the one server?

i realise you can have both SQL2000 & SQL2005 Client software co-existing on one (developement) machine.

but i cant seem to find a definitive answer on whether i can install both complete databases on a server?

we are currently building a new development server and would like to install both version on it if possible?

Cheers,
Craig

You can install both. You'd have to have an instance name, however.

ie. servername\sql2005

I think it's less confusing if you put both servers on separate instances..

instead of

sql2000: servername
sql2005: servername\sql2005

use

sql2000: servername\sql2000
sql2005: servername\sql2005

this way you know what environment you're pointing to..

Can SQL Server 2005 and Express Edition co-exist?

I just started getting into C# programming, and downloaded the express version for work and at home. At home, I also installed SQL Server 2005 Express, but not at work, since I already have the full version installed. Unfortunately, Visual Studio Express won't recognize the full version of SQL Server, and I was wondering if there would be any problems installing both the full and express versions side by side. As this is my work computer, I don't want to risk it unless I know it's safe. Thanks for any help.

Yes, you can install all of the SQL 2005 editions side-by-side. Installing Express would be a good solution for installing VS on your machine. Let us know if you have any questions with it.

Thanks,
Sam Lester (MSFT)

Can SQL Server 2000/2005 Co-Exist On One Server?

Can I install SQL Server 2000 and SQL Server 2005 on the same physical server and be able to access them independently through their respective tools (E/M, Q/A, SSMS) and through ADO, OLEDB?

We have an upgrade issue that involves some parallel testing without buying a new server. Hey, i just work here right?

Yes this works just fine