Can total be moved to top of column rather than bottom

Standard newbie disclaimer: I have searched the archives and this is
my second week with the tool, so my apologies if this is a rather
simple question or I am not asking the question properly.
My team has received a specification for a report where the customers
would like to see column totals at the top of the column, rather than
SSRS's default of bottom. I am new to banded report writing, so I am
hoping this is fairly simple. Using BusinessObjects, I would have
inserted a row at the top of the column and then copied the formula
from the total (or subtotal) line up to the line I had just inserted
(then deleted the row at the bottom).
Is there similar functionality with SRSS?
Kind regards,
Steve HaffnerYes, it is possible.
Option-1: If you want to show the total besides the group name: Ask them to
add the group Header(if not available). besides the group name table cell ,
write a expression like =sum(field!columnname.value)
Option-2: If you want to show the total in top of the group name:
right click on table row(Group row) and click on insert row above. and write
a expression like ="Group Total : " & sum(field!columnname.value)
Regards,
Sriman.
"shaffner" wrote:
> Standard newbie disclaimer: I have searched the archives and this is
> my second week with the tool, so my apologies if this is a rather
> simple question or I am not asking the question properly.
> My team has received a specification for a report where the customers
> would like to see column totals at the top of the column, rather than
> SSRS's default of bottom. I am new to banded report writing, so I am
> hoping this is fairly simple. Using BusinessObjects, I would have
> inserted a row at the top of the column and then copied the formula
> from the total (or subtotal) line up to the line I had just inserted
> (then deleted the row at the bottom).
> Is there similar functionality with SRSS?
> Kind regards,
> Steve Haffner
>|||On Apr 5, 10:48 am, "shaffner" <steve_haff...@.hotmail.com> wrote:
> Standard newbie disclaimer: I have searched the archives and this is
> my second week with the tool, so my apologies if this is a rather
> simple question or I am not asking the question properly.
> My team has received a specification for a report where the customers
> would like to see column totals at the top of the column, rather than
> SSRS's default of bottom. I am new to banded report writing, so I am
> hoping this is fairly simple. Using BusinessObjects, I would have
> inserted a row at the top of the column and then copied the formula
> from the total (or subtotal) line up to the line I had just inserted
> (then deleted the row at the bottom).
> Is there similar functionality with SRSS?
> Kind regards,
> Steve Haffner
This can be done similarly in SSRS. You can either insert a row/group
in the top of a table control and add something like the following as
the expression:
=Sum(Fields!FieldName.Value)
Also, you can do the totaling in the stored procedure/query that is
sourcing the report and just pass it to the report and create a
textbox control at the top of the table control and include it there.
Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant

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 SQL Standard Edition with User CALs be used as the backend to a website?

I just need a straight answer. Is it allowable to use SQL Standard Edition
as the database for a website if you are using user or device CALs instead o
f per processor licensing? The plan is for a company website running IIS on
d SQL standard edition on t
he same server. The only connection to the SQL server would be the user acc
ount that accesses the databases on the ASP.NET pages. There would be no ex
ternal direct connection to the SQL server.
Every search I have done has said I should use per processor licensing for t
he backend SQL server, but it does not say that I have to. Any help would b
e appreciated. Please feel free to email me.
Thanks!Exposing data through a web server to the public when in Per Seat mode is a
violation of the Licensing agreement.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"yourpalqwerty" <yourpalqwerty@.yahoo.com> wrote in message
news:E97EDFA1-7D00-43F9-A1FF-070105B323D9@.microsoft.com...
> I just need a straight answer. Is it allowable to use SQL Standard
Edition as the database for a website if you are using user or device CALs
instead of per processor licensing? The plan is for a company website
running IIS ond SQL standard edition on the same server. The only
connection to the SQL server would be the user account that accesses the
databases on the ASP.NET pages. There would be no external direct
connection to the SQL server.
> Every search I have done has said I should use per processor licensing for
the backend SQL server, but it does not say that I have to. Any help would
be appreciated. Please feel free to email me.
> Thanks!|||Thanks for the quick response. I'm glad MSDE exists. I guess I'll stick wi
th that for people with a limited budget.

Can SQL Server 2005 Standard Edition be installed on machine with Intel Celeron processor

Can SQL Server 2005 Standard Edition be installed on machine with Intel Celeron processor ?yes, there is no constraint its a standard CPU
(with fewer cache than the other CPUs)
"S.Santorowski" <s.santorowski@.entity.com.pl> wrote in message
news:%236fd3jOuHHA.1208@.TK2MSFTNGP05.phx.gbl...
>

Can SQL Server 2005 Standard Edition be installed on machine with Intel Celeron processor

Can SQL Server 2005 Standard Edition be installed on machine with Intel Celeron processoryes, there is no constraint its a standard CPU
(with fewer cache than the other CPUs)
"S.Santorowski" <s.santorowski@.entity.com.pl> wrote in message
news:%236fd3jOuHHA.1208@.TK2MSFTNGP05.phx.gbl...
>

Can Sql Server 2005 Standard be used in a production enviroment?

I was wondering what was the limitations of Sql Server 2005 standard w/ 1 cal
This is the version that is given out at the launch events.
We are currently developing a site, that will use Sql Databases and was wondering if the version we have now will work.
Like we know for a fact that the site will recieve a decent amount of traffic. Is standard limited to certain kind of sites and so forth?
Thanks,
CedricThe answer is yes, you can see a comparison chart of features here...http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx

Can SQL Server 2005 run on Windows XP SP2

Hi
In "http://www.microsoft.com/sql/editions/standard/sysreqs.mspx" I read that
SQL Server 2005 Standard Edition can run on Windows XP SP2.
I am sure that I read some place that SQL Server 2005 Standard edition must
run on a server operating system.
Is this correct?
Regards Kjell Arne JohansenSQL Server 2005 Standard is supported on Windows XP SP2. It says so
on the box (so to speak) and it runs fine for me.
Not that I would use XP for a production server, but it is supported.
Roy Harvey
Beacon Falls, CT
On Wed, 11 Apr 2007 02:22:02 -0700, Kjell Arne Johansen
<KjellArneJohansen@.discussions.microsoft.com> wrote:

>Hi
>In "http://www.microsoft.com/sql/editions/standard/sysreqs.mspx" I read tha
t
>SQL Server 2005 Standard Edition can run on Windows XP SP2.
>I am sure that I read some place that SQL Server 2005 Standard edition must
>run on a server operating system.
>Is this correct?
>Regards Kjell Arne Johansen
>|||The confusion might be that 2000 SE needed a server OS. I was also surprised
when 2005 was released
that SE was supported on client OS. Not that I've tested it, but I haven't s
een any official text
saying anything different.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Roy Harvey" <roy_harvey@.snet.net> wrote in message
news:r91q1359bucp42mla7vmqubie557rma9nk@.
4ax.com...[vbcol=seagreen]
> SQL Server 2005 Standard is supported on Windows XP SP2. It says so
> on the box (so to speak) and it runs fine for me.
> Not that I would use XP for a production server, but it is supported.
> Roy Harvey
> Beacon Falls, CT
> On Wed, 11 Apr 2007 02:22:02 -0700, Kjell Arne Johansen
> <KjellArneJohansen@.discussions.microsoft.com> wrote:
>

Can SQL Server 2005 run on Windows XP SP2

Hi
In "http://www.microsoft.com/sql/editions/standard/sysreqs.mspx" I read that
SQL Server 2005 Standard Edition can run on Windows XP SP2.
I am sure that I read some place that SQL Server 2005 Standard edition must
run on a server operating system.
Is this correct?
Regards Kjell Arne Johansen
SQL Server 2005 Standard is supported on Windows XP SP2. It says so
on the box (so to speak) and it runs fine for me.
Not that I would use XP for a production server, but it is supported.
Roy Harvey
Beacon Falls, CT
On Wed, 11 Apr 2007 02:22:02 -0700, Kjell Arne Johansen
<KjellArneJohansen@.discussions.microsoft.com> wrote:

>Hi
>In "http://www.microsoft.com/sql/editions/standard/sysreqs.mspx" I read that
>SQL Server 2005 Standard Edition can run on Windows XP SP2.
>I am sure that I read some place that SQL Server 2005 Standard edition must
>run on a server operating system.
>Is this correct?
>Regards Kjell Arne Johansen
>
|||The confusion might be that 2000 SE needed a server OS. I was also surprised when 2005 was released
that SE was supported on client OS. Not that I've tested it, but I haven't seen any official text
saying anything different.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Roy Harvey" <roy_harvey@.snet.net> wrote in message
news:r91q1359bucp42mla7vmqubie557rma9nk@.4ax.com... [vbcol=seagreen]
> SQL Server 2005 Standard is supported on Windows XP SP2. It says so
> on the box (so to speak) and it runs fine for me.
> Not that I would use XP for a production server, but it is supported.
> Roy Harvey
> Beacon Falls, CT
> On Wed, 11 Apr 2007 02:22:02 -0700, Kjell Arne Johansen
> <KjellArneJohansen@.discussions.microsoft.com> wrote:

Can SQL Server 2005 run on Windows XP SP2

Hi
In "http://www.microsoft.com/sql/editions/standard/sysreqs.mspx" I read that
SQL Server 2005 Standard Edition can run on Windows XP SP2.
I am sure that I read some place that SQL Server 2005 Standard edition must
run on a server operating system.
Is this correct?
Regards Kjell Arne JohansenSQL Server 2005 Standard is supported on Windows XP SP2. It says so
on the box (so to speak) and it runs fine for me.
Not that I would use XP for a production server, but it is supported.
Roy Harvey
Beacon Falls, CT
On Wed, 11 Apr 2007 02:22:02 -0700, Kjell Arne Johansen
<KjellArneJohansen@.discussions.microsoft.com> wrote:
>Hi
>In "http://www.microsoft.com/sql/editions/standard/sysreqs.mspx" I read that
>SQL Server 2005 Standard Edition can run on Windows XP SP2.
>I am sure that I read some place that SQL Server 2005 Standard edition must
>run on a server operating system.
>Is this correct?
>Regards Kjell Arne Johansen
>|||The confusion might be that 2000 SE needed a server OS. I was also surprised when 2005 was released
that SE was supported on client OS. Not that I've tested it, but I haven't seen any official text
saying anything different.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Roy Harvey" <roy_harvey@.snet.net> wrote in message
news:r91q1359bucp42mla7vmqubie557rma9nk@.4ax.com...
> SQL Server 2005 Standard is supported on Windows XP SP2. It says so
> on the box (so to speak) and it runs fine for me.
> Not that I would use XP for a production server, but it is supported.
> Roy Harvey
> Beacon Falls, CT
> On Wed, 11 Apr 2007 02:22:02 -0700, Kjell Arne Johansen
> <KjellArneJohansen@.discussions.microsoft.com> wrote:
>>Hi
>>In "http://www.microsoft.com/sql/editions/standard/sysreqs.mspx" I read that
>>SQL Server 2005 Standard Edition can run on Windows XP SP2.
>>I am sure that I read some place that SQL Server 2005 Standard edition must
>>run on a server operating system.
>>Is this correct?
>>Regards Kjell Arne Johansen

Can not specify file name for new database in sql 2005

Hi,
We installed Microsoft SQL Server 2005 - 9.00.3054.00 (Intel X86) Mar 23
2007 16:28:52 Copyright (c) 1988-2005 Microsoft Corporation Standard
Edition on Windows NT 5.2 (Build 3790: Service Pack 2). In management
studio, when I created a new database, I was able to change logical name,
initial size, path, etc., but the problem is with the File Name field. I
could not enter file name for either data or log. I clicked in it, the
background color changed to light blue with no cursor.
Anybody know why?
Thanks in advance,
BingNever mind. Looks like the File Name field doesn't expect any user input.
It defaults to whatever that's entered in the Database Name field. But in
sql 2000, database name doesn't have to be the same with the physical
database disk file name. Wonder why 2005 handles that differently?
Bing
"bing" wrote:
> Hi,
> We installed Microsoft SQL Server 2005 - 9.00.3054.00 (Intel X86) Mar 23
> 2007 16:28:52 Copyright (c) 1988-2005 Microsoft Corporation Standard
> Edition on Windows NT 5.2 (Build 3790: Service Pack 2). In management
> studio, when I created a new database, I was able to change logical name,
> initial size, path, etc., but the problem is with the File Name field. I
> could not enter file name for either data or log. I clicked in it, the
> background color changed to light blue with no cursor.
> Anybody know why?
> Thanks in advance,
> Bing

Can not see Filegroups in Backup Exec

Hi, I have MSDE2000 running on SBS2003 Standard with Backup Exec 9.1. As MSDE
is a new addition I have installed the SQL Agent for BEW however I can not
see the SQL Databases or filegroups under Selections in Backup Exec. I have
searched the Veritas KB plus the forums and have not found the answer... I
have set the checkbox in BEW /options/SQL to display the filegroups to no
avail. Is this a setting in SQL that I have missed?
Any thoughts would be great...
hi Johan,
Johan Strange wrote:
> Hi, I have MSDE2000 running on SBS2003 Standard with Backup Exec 9.1.
> As MSDE is a new addition I have installed the SQL Agent for BEW
> however I can not see the SQL Databases or filegroups under
> Selections in Backup Exec. I have searched the Veritas KB plus the
> forums and have not found the answer... I have set the checkbox in
> BEW /options/SQL to display the filegroups to no avail. Is this a
> setting in SQL that I have missed?
> Any thoughts would be great...
this is something you have to work with Veritas tech support or help file..
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.15.0 - DbaMgr ver 0.60.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||Hi , I have gone through the modrated forum and am at the stage where I am
going to pay for a support case ($85)... I will have to swallow this so I
want to post this to an MSDE forum incase anyone here has seen it before and
can suggest something that Veritas can not.
What you say is right, it is a Backup Exec issue that much is obvious.
Thanks
Johan
"Andrea Montanari" wrote:

> hi Johan,
> Johan Strange wrote:
> this is something you have to work with Veritas tech support or help file..
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
> DbaMgr2k ver 0.15.0 - DbaMgr ver 0.60.0
> (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
> interface)
> -- remove DMO to reply
>
>
|||hi Johan,
Johan Strange wrote:
> Hi , I have gone through the modrated forum and am at the stage
> where I am going to pay for a support case ($85)... I will have to
> swallow this so I want to post this to an MSDE forum incase anyone
> here has seen it before and can suggest something that Veritas can
> not.
thank you...
in recent time it seems to happen very often...
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.15.0 - DbaMgr ver 0.60.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply

Can not run SQL Server 2005 Upgrade Advisor on server that does not use the standard port

I tried creating an alias to the server to get it to connect to analyze the server but it will not recognize the SQL 2000 server as a valid server to analyze. I can use the alias to connect in EM or SSMS. Any ideas? The server is not clustered and is at SP4. I've connected to several others in my environment but this one is causing me grief!

Thanks,

Linda

After trying several other things, insuing I had the correct permissions on the destination server, one issue was discovered and that was I had permissions on the instance of SQL server I wanted to look at but not the defautl. Adding me did not fix the problem.

The fix actually came using an alias for the full default instance name and not using the "detect" button on the server entry screen. The instance name also had to be manually typed in. This worked after setting up an alias to the full instance name and not just the server name for the default instance.