New SQL2005 SP2

Hi,
Bink is saying there is a new version of SP2 http://bink.nu/Article9653.bink
The download site now shows version 9.00.3042.01 dated 3/5/2007. It sounds
like this version fixes the fact that maintenance plan cleanup tasks now
change from days to hours. This change has been talked about here before.
Any one having any newer information on the change?
Thanks
ChrisMicrosoft SQL Server 2005 Service Pack 2 issue: Cleanup tasks run at
different intervals than intended
http://support.microsoft.com/kb/933508
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Chris Wood" <anonymous@.discussions.microsoft.com> wrote in message
news:O6Nhfw$XHHA.1220@.TK2MSFTNGP03.phx.gbl...
> Hi,
> Bink is saying there is a new version of SP2
> http://bink.nu/Article9653.bink The download site now shows version
> 9.00.3042.01 dated 3/5/2007. It sounds like this version fixes the fact
> that maintenance plan cleanup tasks now change from days to hours. This
> change has been talked about here before.
> Any one having any newer information on the change?
> Thanks
> Chris
>

New SQL2005 SP2

Hi,
Bink is saying there is a new version of SP2 http://bink.nu/Article9653.bink
The download site now shows version 9.00.3042.01 dated 3/5/2007. It sounds
like this version fixes the fact that maintenance plan cleanup tasks now
change from days to hours. This change has been talked about here before.
Any one having any newer information on the change?
Thanks
Chris
Microsoft SQL Server 2005 Service Pack 2 issue: Cleanup tasks run at
different intervals than intended
http://support.microsoft.com/kb/933508
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Chris Wood" <anonymous@.discussions.microsoft.com> wrote in message
news:O6Nhfw$XHHA.1220@.TK2MSFTNGP03.phx.gbl...
> Hi,
> Bink is saying there is a new version of SP2
> http://bink.nu/Article9653.bink The download site now shows version
> 9.00.3042.01 dated 3/5/2007. It sounds like this version fixes the fact
> that maintenance plan cleanup tasks now change from days to hours. This
> change has been talked about here before.
> Any one having any newer information on the change?
> Thanks
> Chris
>

New SQL2005 SP2

Hi,
Bink is saying there is a new version of SP2 http://bink.nu/Article9653.bink
The download site now shows version 9.00.3042.01 dated 3/5/2007. It sounds
like this version fixes the fact that maintenance plan cleanup tasks now
change from days to hours. This change has been talked about here before.
Any one having any newer information on the change?
Thanks
ChrisMicrosoft SQL Server 2005 Service Pack 2 issue: Cleanup tasks run at
different intervals than intended
http://support.microsoft.com/kb/933508
--
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Chris Wood" <anonymous@.discussions.microsoft.com> wrote in message
news:O6Nhfw$XHHA.1220@.TK2MSFTNGP03.phx.gbl...
> Hi,
> Bink is saying there is a new version of SP2
> http://bink.nu/Article9653.bink The download site now shows version
> 9.00.3042.01 dated 3/5/2007. It sounds like this version fixes the fact
> that maintenance plan cleanup tasks now change from days to hours. This
> change has been talked about here before.
> Any one having any newer information on the change?
> Thanks
> Chris
>sql

New Sql Server Cluster Install

Everyone,
I'm installing SQL Server 2000 SP2 virtual server onto a Windows 2003
Cluster. The install process seems to install sql server fine on both
machines, however when the installer gets to creating the virtual resources
the install fails after about 5 to 10 minutes. I've looked at the sql logs
that are generated by the install and the only error code I see that is not 0
is an error trying to load a dll. After the install fails the installer
proceeds to uninstall all files and shortcuts from both nodes. I'm thinking
this has something to do with Windows 2003 not allowing anything less than
sp3 to start. Can anyone help clarify this for me. I've searched google and
have found many articles and kb about other issues but none so far that look
like this one. If this is caused by the sp3 issues is there a workaround or
is there a way to get an install CD of SQL Server 2000 with SP3.
Thanks!
ST
Hi
Installing sp2 is no problem unless you don't patch it to sp3a after the
install completes.
Make sure you have gone through the check lists on
http://www.microsoft.com/technet/pro.../failclus.mspx
Regards
Mike
"Shannon T." wrote:

> Everyone,
> I'm installing SQL Server 2000 SP2 virtual server onto a Windows 2003
> Cluster. The install process seems to install sql server fine on both
> machines, however when the installer gets to creating the virtual resources
> the install fails after about 5 to 10 minutes. I've looked at the sql logs
> that are generated by the install and the only error code I see that is not 0
> is an error trying to load a dll. After the install fails the installer
> proceeds to uninstall all files and shortcuts from both nodes. I'm thinking
> this has something to do with Windows 2003 not allowing anything less than
> sp3 to start. Can anyone help clarify this for me. I've searched google and
> have found many articles and kb about other issues but none so far that look
> like this one. If this is caused by the sp3 issues is there a workaround or
> is there a way to get an install CD of SQL Server 2000 with SP3.
> --
> Thanks!
> ST
|||The error I'm receiving I looks like it is during the self registration phase.
The error is as follows:
09:13:43 C:\PROGRA~1\MICROS~1\80\Tools\Binn\dcomscm.exe /RegServer
09:13:43 Process Exit Code: (0)
09:13:43 C:\PROGRA~1\COMMON~1\MICROS~1\SQLDEB~1\sqldbreg.ex e -RegServer
09:13:43 Process Exit Code: (-2147312566) Error loading type library/DLL.
|||this seems to be the tsql debugger. Please refer to
http://support.microsoft.com/default...b;en-us;280101 for some
information on this.
Unless you are running tsql debugger in your clustered (production?)
environment, I doubt you would need this.
What components are you selecting in your install? Are you installing the
developers resources and code samples? It seems to me that this component is
probably installed with them as opposed to the default installation set.
"Shannon T." <ShannonT@.discussions.microsoft.com> wrote in message
news:E753DEF8-46B7-408E-BBCB-E6FE3A6A14D1@.microsoft.com...
> The error I'm receiving I looks like it is during the self registration
> phase.
> The error is as follows:
> 09:13:43 C:\PROGRA~1\MICROS~1\80\Tools\Binn\dcomscm.exe /RegServer
> 09:13:43 Process Exit Code: (0)
> 09:13:43 C:\PROGRA~1\COMMON~1\MICROS~1\SQLDEB~1\sqldbreg.ex e -RegServer
> 09:13:43 Process Exit Code: (-2147312566) Error loading type library/DLL.
>
>
|||I choose the default installation radio button on the Select Type window
during the setup. Should I use the custom install type for a virtual server?
"Hilary Cotter" wrote:

> this seems to be the tsql debugger. Please refer to
> http://support.microsoft.com/default...b;en-us;280101 for some
> information on this.
> Unless you are running tsql debugger in your clustered (production?)
> environment, I doubt you would need this.
> What components are you selecting in your install? Are you installing the
> developers resources and code samples? It seems to me that this component is
> probably installed with them as opposed to the default installation set.
> "Shannon T." <ShannonT@.discussions.microsoft.com> wrote in message
> news:E753DEF8-46B7-408E-BBCB-E6FE3A6A14D1@.microsoft.com...
>
>
|||I have removed the sql debug tools from the install. The error that was
showing up is no longer occuring. However, I still receive a message that the
installation has failed and the install rolls back.
I'm totally confused. Here is the log if anyone sees anything wrong please
let me know.
14:40:20 Begin Setup
14:40:20 8.00.194
14:40:20 Mode = Silent
14:40:20 ModeType = CLUSTER
14:40:20 Cluster node.
14:40:20 g_szIssPath=C:\WINDOWS\setup~0.iss
14:40:20 GetDefinitionEx returned: 0, Extended: 0x0
14:40:20 ValueFTS returned: 1
14:40:20 ValuePID returned: 1
14:40:20 ValueLic returned: 1
14:40:20 System: Windows NT Enterprise Server
14:40:20 SQL Server ProductType: Enterprise Edition [0x3]
14:40:20 IsNTCluster returned: 1
14:40:20 Begin Action: SetupInitialize
14:40:20 End Action SetupInitialize
14:40:20 Begin Action: SetupInstall
14:40:20 Reading Software\Microsoft\Windows\CurrentVersion\CommonFi lesDir ...
14:40:20 CommonFilesDir=C:\Program Files\Common Files
14:40:20 Windows Directory=C:\WINDOWS\
14:40:20 Program Files=C:\Program Files\
14:40:20 TEMPDIR=C:\DOCUME~1\username\LOCALS~1\Temp\
14:40:20 Begin Action: SetupInstall
14:40:20 digpid size : 256
14:40:20 digpid size : 164
14:40:20 Begin Action: CheckFixedRequirements
14:40:20 Platform ID: 0xf00000
14:40:20 Version: 5.2.3790
14:40:20 File Version - C:\WINDOWS\system32\shdocvw.dll: 6.0.3790.186
14:40:20 End Action: CheckFixedRequirements
14:40:20 Begin Action: ShowDialogs
14:40:20 Initial Dialog Mask: 0x183000f7, Disable Back=0x1
14:40:20 Begin Action ShowDialogsHlpr: 0x1
14:40:20 Begin Action: DialogShowSdWelcome
14:40:20 End Action DialogShowSdWelcome
14:40:20 Dialog 0x1 returned: 1
14:40:20 End Action ShowDialogsHlpr
14:40:20 ShowDialogsGetDialog returned: nCurrent=0x2,index=1
14:40:20 Begin Action ShowDialogsHlpr: 0x2
14:40:20 Begin Action: DialogShowSdMachineName
14:40:20 [DlgMachine]
14:40:20 Result = 1
14:40:20 Type = 268435466
14:40:20 Name = virtualserver1
14:40:20 ShowDlgMachine returned: 1
14:40:20 Name = virtualserver1, Type = 0x1000000a
14:40:20 Begin Action: CheckRequirements
14:40:20 Processor Architecture: x86 (Pentium)
14:40:20 ComputerName: virtualserver1
14:40:20 User Name: username
14:40:20 IsAllAccessAllowed returned: 1
14:40:20 OS Language: 0x409
14:40:20 End Action CheckRequirements
14:40:20 This combination of Package and Operating System allows a full
product install.
14:40:20 End Action DialogShowSdMachineName
14:40:20 begin ShowDialogsUpdateMask
14:40:20 nFullMask = 0x183000f7, nCurrent = 0x2, nDirection = 0
14:40:20 Updated Dialog Mask: 0xbf3c037, Disable Back = 0x1
14:40:20 Dialog 0x2 returned: 0
14:40:20 End Action ShowDialogsHlpr
14:40:20 ShowDialogsGetDialog returned: nCurrent=0x4,index=2
14:40:20 Begin Action ShowDialogsHlpr: 0x4
14:40:20 Begin Action: DialogShowSdInstallMode
14:40:20 [DlgInstallMode]
14:40:20 Result = 1
14:40:20 Type = 1
14:40:20 InstallMode : 0x1
14:40:20 End Action DialogShowSdInstallMode
14:40:20 begin ShowDialogsUpdateMask
14:40:20 nFullMask = 0xbf3c037, nCurrent = 0x4, nDirection = 1
14:40:20 Updated Dialog Mask: 0x1bf7c037, Disable Back = 0x1
14:40:20 Dialog 0x4 returned: 1
14:40:20 End Action ShowDialogsHlpr
14:40:20 ShowDialogsGetDialog returned: nCurrent=0x10,index=4
14:40:20 Begin Action ShowDialogsHlpr: 0x10
14:40:20 Begin Action: DialogShowSdRegisterUserEx
14:40:20 End Action DialogShowSdRegisterUserEx
14:40:20 begin ShowDialogsUpdateMask
14:40:20 nFullMask = 0x1bf7c037, nCurrent = 0x10, nDirection = 1
14:40:20 Updated Dialog Mask: 0x1bf7c037, Disable Back = 0x1
14:40:20 Dialog 0x10 returned: 1
14:40:20 End Action ShowDialogsHlpr
14:40:20 ShowDialogsGetDialog returned: nCurrent=0x20,index=5
14:40:20 Begin Action ShowDialogsHlpr: 0x20
14:40:20 Begin Action: DialogShowSdLicense
14:40:20 End Action DialogShowSdLicense
14:40:20 Dialog 0x20 returned: 1
14:40:20 End Action ShowDialogsHlpr
14:40:20 ShowDialogsGetDialog returned: nCurrent=0x4000,index=14
14:40:20 Begin Action ShowDialogsHlpr: 0x4000
14:40:20 Begin Action: DialogShowSdVirtualServer
14:40:20 [DlgVirtServer]
14:40:20 Result = 1
14:40:20 VirtServerName = virtualserver
14:40:20 IpAddresses = 10.130.19.135,255.255.252.0,Public
14:40:24 ShowDlgVirtualServer returned: 0
14:40:24 Ipaddress = 10.130.19.135,255.255.252.0,Public
14:40:24 szNewList = 10.130.19.135,255.255.252.0,Public
14:40:24 szModifiedList =
14:40:24 szRemovedList =
14:40:24 End Action DialogShowSdVirtualServer
14:40:24 begin ShowDialogsUpdateMask
14:40:24 nFullMask = 0x1bf7c037, nCurrent = 0x4000, nDirection = 1
14:40:24 Updated Dialog Mask: 0x1bf7c037, Disable Back = 0x1
14:40:24 Dialog 0x4000 returned: 1
14:40:24 End Action ShowDialogsHlpr
14:40:24 ShowDialogsGetDialog returned: nCurrent=0x8000,index=15
14:40:24 Begin Action ShowDialogsHlpr: 0x8000
14:40:24 Begin Action : DialogShowSdDiskGroups
14:40:24 [DlgDiskGroups]
14:40:24 Result = 1
14:40:24 DiskGroupsName = SQLGroup
14:40:24 ShowDlgDiskGroups returned: 1
14:40:24 Disk Group = SQLGroup
14:40:24 End Action : DialogShowSdDiskGroups
14:40:24 begin ShowDialogsUpdateMask
14:40:24 nFullMask = 0x1bf7c037, nCurrent = 0x8000, nDirection = 1
14:40:24 Updated Dialog Mask: 0x1bf7c037, Disable Back = 0x1
14:40:24 Dialog 0x8000 returned: 1
14:40:24 End Action ShowDialogsHlpr
14:40:24 ShowDialogsGetDialog returned: nCurrent=0x10000,index=16
14:40:24 Begin Action ShowDialogsHlpr: 0x10000
14:40:24 Begin Action: DialogShowSdClusterDef
14:40:24 [DlgClusterDef]
14:40:24 Result = 1
14:40:24 nNumNodes = 2
14:40:24 VirtServerName = virtualserver
14:40:24 szPrefowners = virtualserver1,virtualserver2
14:40:24 ShowDlgClusterDef returned: 1
14:40:24 PrefOwners = virtualserver1,virtualserver2, NumIp = 0
14:40:24 End Action DialogShowSdClusterDef
14:40:24 begin ShowDialogsUpdateMask
14:40:24 nFullMask = 0x1bf7c037, nCurrent = 0x10000, nDirection = 1
14:40:24 Updated Dialog Mask: 0x1bf7c037, Disable Back = 0x1
14:40:24 Dialog 0x10000 returned: 1
14:40:24 End Action ShowDialogsHlpr
14:40:24 ShowDialogsGetDialog returned: nCurrent=0x20000,index=17
14:40:24 Begin Action ShowDialogsHlpr: 0x20000
14:40:24 Begin Action : Cluster Security - DlgAcct
14:40:24 [DlgAccount]
14:40:24 Result = 1
14:40:24 Domain = TMC
14:40:24 DomainAcct = username
14:40:24 DomainPwd
14:40:24 ValidateUser returned: 1, 0, 0x17c
14:40:24 IsAcctValidForCluster returned: 1, 0
14:40:24 End Action : Cluster Security - DlgAcct
14:40:24 begin ShowDialogsUpdateMask
14:40:24 nFullMask = 0x1bf7c037, nCurrent = 0x20000, nDirection = 1
14:40:24 Updated Dialog Mask: 0x1bf7c037, Disable Back = 0x1
14:40:24 Dialog 0x20000 returned: 1
14:40:24 End Action ShowDialogsHlpr
14:40:24 ShowDialogsGetDialog returned: nCurrent=0x40000,index=18
14:40:24 Begin Action ShowDialogsHlpr: 0x40000
14:40:24 Begin Action: DialogShowSdCliSvr
14:40:24 DisplaySystemPreReq
14:40:24 [DlgClientServer]
14:40:24 Result = 1
14:40:24 Type = 2
14:40:24 ShowDlgClientServerSelect returned: 1
14:40:24 Type : 0x2
14:40:24 End Action DialogShowSdCliSvr
14:40:24 begin ShowDialogsUpdateMask
14:40:24 nFullMask = 0x1bf7c037, nCurrent = 0x40000, nDirection = 1
14:40:24 Updated Dialog Mask: 0x1bffc037, Disable Back = 0x1
14:40:24 Dialog 0x40000 returned: 1
14:40:24 End Action ShowDialogsHlpr
14:40:24 ShowDialogsGetDialog returned: nCurrent=0x80000,index=19
14:40:24 Begin Action ShowDialogsHlpr: 0x80000
14:40:24 Begin Action: DialogShowSdInstanceName
14:40:24 [DlgInstanceName]
14:40:24 Result = 1
14:40:24 InstanceName = MSSQLSERVER
14:40:24 Begin Action: ShowDlgInstanceName
14:40:24 End Action: ShowDlgInstanceName
14:40:24 ShowDlgInstanceName returned : 1
14:40:24 InstanceName : MSSQLSERVER
14:40:24 CreateSetupTopology(virtualserver1), Handle : 0x1453f00, returned : 0
14:40:24 CreateSetupTopology returned : 0, Handle : 0x1453f00
14:40:24 Topology Type : 1, Return Value : 0
14:40:24 ST_GetPhysicalNode returned : 0, PNHandle : 0x1453f50
14:40:24 PN_EnumerateEx returned : 0
14:40:24 PN_GetSQLStates returned : 0, SqlStates : 0x0
14:40:24 PN_StartScan [0x1453f50] returned : 0
14:40:24 PN_GetNext [0x1453f50] returned : 18, Handle: [0x0]
14:40:24 No more items in enumeration.
14:40:24 ReleaseSetupTopology
14:40:24 End Action DialogShowSdInstanceName
14:40:24 begin ShowDialogsUpdateMask
14:40:24 nFullMask = 0x1bffc037, nCurrent = 0x80000, nDirection = 1
14:40:24 Updated Dialog Mask: 0x1bffc037, Disable Back = 0x1
14:40:24 Dialog 0x80000 returned: 1
14:40:24 End Action ShowDialogsHlpr
14:40:24 ShowDialogsGetDialog returned: nCurrent=0x100000,index=20
14:40:24 Begin Action ShowDialogsHlpr: 0x100000
14:40:24 Begin Action: DialogShowSdSetupType
14:40:24 Begin Action: Setup Type
14:40:24 [SetupTypeSQL]
14:40:24 Result = 303
14:40:24 szDir = C:\Program Files\Microsoft SQL Server
14:40:24 final szDir = C:\Program Files\Microsoft SQL Server
14:40:24 szDataDir = g:\dbfiles
14:40:25 final szDataDir = g:\dbfiles
14:40:25 End Action: Setup Type
14:40:25 Setup Type: Custom (303)
14:40:25 End Action DialogShowSdSetupType
14:40:25 begin ShowDialogsUpdateMask
14:40:25 nFullMask = 0x1bffc037, nCurrent = 0x100000, nDirection = 303
14:40:25 Updated Dialog Mask: 0x1bffc037, Disable Back = 0x1
14:40:25 Dialog 0x100000 returned: 303
14:40:25 End Action ShowDialogsHlpr
14:40:25 ShowDialogsGetDialog returned: nCurrent=0x200000,index=21
14:40:25 Begin Action ShowDialogsHlpr: 0x200000
14:40:25 Begin Action: DialogShowSdComponentMult
14:40:25 basesys = 0, baseinst = 0, basedata = 0
14:40:25 Begin Action: Component Handler
14:40:25 ***** Silent Mode in Multi comps
14:40:25 [SQLComponentMult]
14:40:25 Result = 1
14:40:25 ComponentSelectItem(MgtTool\Wzcnflct): -103
14:40:25 End Action: Component Handler
14:40:25 End Action DialogShowSdComponentMult
14:40:25 begin ShowDialogsUpdateMask
14:40:25 nFullMask = 0x1bffc037, nCurrent = 0x200000, nDirection = 1
14:40:25 Updated Dialog Mask: 0x1bffc037, Disable Back = 0x1
14:40:25 Dialog 0x200000 returned: 1
14:40:25 End Action ShowDialogsHlpr
14:40:25 ShowDialogsGetDialog returned: nCurrent=0x400000,index=22
14:40:25 Begin Action ShowDialogsHlpr: 0x400000
14:40:25 Begin Action: DlgServices
14:40:25 [DlgServices]
14:40:25 Result = 1
14:40:25 Local-Domain = 61680
14:40:25 AutoStart = 0
14:40:25 SQLDomain= TMC
14:40:25 SQLDomainAcct = bob
14:40:25 SQLDomainPwd
14:40:25 ValidateUser returned: 1, 0, 0x17c
14:40:25 GrantRightAsService returned : 1, 0
14:40:25 AgtDomain= TMC
14:40:25 AgtDomainAcct= bob
14:40:25 AgtDomainPwd
14:40:25 ValidateUser returned: 1, 0, 0x180
14:40:25 GrantRightAsService returned : 1, 0
14:40:25 End Action DlgServices
14:40:25 begin ShowDialogsUpdateMask
14:40:25 nFullMask = 0x1bffc037, nCurrent = 0x400000, nDirection = 1
14:40:25 Updated Dialog Mask: 0x1bffc037, Disable Back = 0x1
14:40:25 Dialog 0x400000 returned: 1
14:40:25 End Action ShowDialogsHlpr
14:40:25 ShowDialogsGetDialog returned: nCurrent=0x800000,index=23
14:40:25 Begin Action ShowDialogsHlpr: 0x800000
14:40:25 Begin Action: DlgSQLSecurity
14:40:25 [DlgSQLSecurity]
14:40:25 Result = 1
14:40:25 szPwd
14:40:25 ShowDlgSQLSecurity returned: 1
14:40:25 LoginMode = 2,szPwd
14:40:25 End Action DlgSQLSecurity
14:40:25 begin ShowDialogsUpdateMask
14:40:25 nFullMask = 0x1bffc037, nCurrent = 0x800000, nDirection = 1
14:40:25 Updated Dialog Mask: 0x1bffc037, Disable Back = 0x1
14:40:25 Dialog 0x800000 returned: 1
14:40:25 End Action ShowDialogsHlpr
14:40:25 ShowDialogsGetDialog returned: nCurrent=0x1000000,index=24
14:40:25 Begin Action ShowDialogsHlpr: 0x1000000
14:40:25 Begin Action: DlgCollation
14:40:25 [DlgCollation]
14:40:25 Result = 1
14:40:25 collation_name = SQL_Latin1_General_CP1_CI_AS
14:40:25 ShowDlgCollation returned: 1
14:40:25 collation_name = SQL_Latin1_General_CP1_CI_AS,locale_name = ,lcid =
0x0,SortId = 0,dwCompFlags = 0x0
14:40:25 End Action DlgCollation
14:40:25 begin ShowDialogsUpdateMask
14:40:25 nFullMask = 0x1bffc037, nCurrent = 0x1000000, nDirection = 1
14:40:25 Updated Dialog Mask: 0x1bffc037, Disable Back = 0x1
14:40:25 Dialog 0x1000000 returned: 1
14:40:25 End Action ShowDialogsHlpr
14:40:25 ShowDialogsGetDialog returned: nCurrent=0x2000000,index=25
14:40:25 Begin Action ShowDialogsHlpr: 0x2000000
14:40:25 Begin Action: DlgNetwork
14:40:25 Result = 1
14:40:25 [DlgServerNetwork]
14:40:25 NetworkLibs = 255
14:40:25 TCPPort =1433
14:40:25 TCPPrxy =
14:40:25 NMPPipeName =\\.\pipe\sql\query
14:40:25 ShowDlgNetwork returned: 1
14:40:25 [DlgServerNetwork]
14:40:25 NetworkLibs = 255
14:40:25 TCPPort = 1433
14:40:25 TCPPrxy = Default
14:40:25 NMPPipeName = \\.\pipe\sql\query
14:40:25 Result = 1
14:40:25 End Action DlgNetwork
14:40:25 begin ShowDialogsUpdateMask
14:40:25 nFullMask = 0x1bffc037, nCurrent = 0x2000000, nDirection = 1
14:40:25 Updated Dialog Mask: 0x1bffc037, Disable Back = 0x1
14:40:25 Dialog 0x2000000 returned: 1
14:40:25 End Action ShowDialogsHlpr
14:40:25 ShowDialogsGetDialog returned: nCurrent=0x8000000,index=27
14:40:25 Begin Action ShowDialogsHlpr: 0x8000000
14:40:25 Begin Action: DialogShowSdStartCopy
14:40:25 End Action DialogShowSdStartCopy
14:40:25 begin ShowDialogsUpdateMask
14:40:25 nFullMask = 0x1bffc037, nCurrent = 0x8000000, nDirection = 1
14:40:25 Updated Dialog Mask: 0x1bffc037, Disable Back = 0x1
14:40:25 Dialog 0x8000000 returned: 1
14:40:25 End Action ShowDialogsHlpr
14:40:25 ShowDialogsGetDialog returned: nCurrent=0x10000000,index=28
14:40:25 Begin Action ShowDialogsHlpr: 0x10000000
14:40:25 Begin Action: DialogShowSdLicenseMode
14:40:25 LicenseMode as read from ISS file : PERDEVICE
14:40:25 LicenseLimit as read from ISS file : 2
14:40:25 ShowDlgLicense returned: 1
14:40:25 ShowDlgLicense returned: LicenseMode = 0, LicenseLimit = 2
14:40:25 End Action DialogShowSdLicenseMode
14:40:25 Dialog 0x10000000 returned: 1
14:40:25 End Action ShowDialogsHlpr
14:40:25 ShowDialogsGetDialog returned: nCurrent=0x0,index=0
14:40:25 End Action ShowDialogs
14:40:25 Begin Action ProcessBeforeDataMove:
14:40:25 DeinstallStart returned (C:\Program Files\Microsoft SQL
Server\MSSQL): 0
14:40:25 End Action ProcessBeforeDataMove:
14:40:25 Begin Action SetToolsComponentSelection:
14:40:25 CreateSetupTopology(virtualserver1), Handle : 0x1453f00, returned : 0
14:40:25 CreateSetupTopology returned : 0, Handle : 0x1453f00
14:40:25 Topology Type : 1, Return Value : 0
14:40:25 ST_GetPhysicalNode returned : 0, PNHandle : 0x1453f50
14:40:25 PN_EnumerateEx returned : 0
14:40:25 PN_GetSQLStates returned : 0, SqlStates : 0x0
14:40:25 PN_StartScan [0x1453f50] returned : 0
14:40:25 PN_GetNext [0x1453f50] returned : 18, Handle: [0x0]
14:40:25 No more items in enumeration.
14:40:25 ReleaseSetupTopology
14:40:25 End Action SetToolsComponentSelection:
14:40:25 Begin Action ProcessComponentSelection:
14:40:25 End Action ProcessComponentSelection
14:40:25 Begin Action LogSelectedComponents:
...
14:40:25 {E07FDDBE-5A21-11d2-9DAD-00C04F79D434}
14:40:25 End Action LogSelectedComponents
14:40:25 SQL program folder: C:\Program Files\Microsoft SQL Server\MSSQL
14:40:25 SQL data folder: g:\dbfiles\MSSQL
14:40:25 Windows system folder: C:\WINDOWS\system32\
14:40:25 Prog req: 21962, Data req: 31360, Sys req: 60946
14:40:25 Prog avail: 5778608, Data avail: 560472816, Sys avail: 5778608
14:40:25 Prog req vs. avail, 82908, 5778608
14:40:25 Data req vs. avail, 31360, 560472816
14:40:25 Sys req vs. avail, 60946, 5778608
14:40:25 DisplaySystemPreReq
14:40:25 Begin Action InstallPkgs:
14:40:25 Begin Action: Locked Connectivity Files Check
14:40:26 ConnectivityLocked returned: 0
14:40:26 The operation completed successfully.
14:40:26 End Action: Locked Connectivity Files Check
14:40:26 Setup is installing Microsoft Data Access Components (MDAC) ...
14:40:26 C:\SQL2000_Ent\x86\Other\sqlredis.exe /q:a
14:40:33 ExitCode: 0
14:40:33 InstallMSSearch instance: MSSQLSERVER
14:40:33 Software\Microsoft\Search\Install:Version not present
14:40:33 MSSearch 2.0 or greater version check returned -1
14:40:33 Setup is installing the Microsoft Full-Text Search Engine ...
14:40:33 "C:\SQL2000_Ent\x86\FullText\MSSearch\Search\Searc hStp.exe" /s
/a:SQLServer
14:40:42 Process Exit Code: (0)
14:41:03 End Action InstallPkgs
14:41:03 Begin Action MoveFileData:
14:41:03 Enabled SELFREGISTERBATCH
14:41:03 Enabled CORECOMPONENTHANDLING
14:41:25 Begin Action: MoveFileDataSpecial
14:41:25 End Action: MoveFileDataSpecial
14:41:25 End Action MoveFileData
14:41:25 Begin Action ProcessAfterDataMove:
14:41:25 End Action ProcessAfterDataMove
14:41:25 Begin Action BuildServer:
14:41:25 C:\DOCUME~1\Username\LOCALS~1\Temp\SqlSetup\Bin\sc m.exe -Silent 1
-Action 5 -ExePath "C:\Program Files\Microsoft SQL
Server\MSSQL\binn\sqlservr.exe" -Service "MSSQLSERVER"
14:41:25 Process Exit Code: (0)
14:41:25 Begin Action: CreateRegistrySetSQL
14:41:25 End Action: CreateRegistrySetSQL
14:41:25 Begin Action: RegWriteSetupEntry
14:41:25 End Action: RegWriteSetupEntry
14:41:25 Begin Action: CreateSer
14:41:25 End Action: CreateSer
14:41:25 Begin Action: SkuIt
14:41:25 End Action: SkuIt
14:41:25 SetFileSecuritySQLAndAdmin for g:\dbfiles\MSSQL returned: 0, 0
14:41:26 SetFileSecuritySQLAndAdmin for C:\Program Files\Microsoft SQL
Server\MSSQL returned: 0, 0
14:41:26 SetRegSecuritySQLAndAdmin for
Software\Microsoft\MSSQLServer\MSSQLServer returned: 0, 0
14:41:26 Begin Action: UpdateSystemPath
14:41:26 Path successfully updated.
14:41:26 C:\Program
Files\EMC\PowerPath\;%SystemRoot%\system32;%System Root%;%SystemRoot%\System32\Wbem;C:\Program
Files\Dell\OpenManage\Array Manager;C:\Program Files\Microsoft SQL
Server\80\Tools\BINN
14:41:26 End Action: UpdateSystemPath
14:41:26 Grant Right for TMC\bob returned : 1, 0
14:41:26 Grant Right for TMC\bob returned : 1, 0
14:41:26 Grant Right for TMC\bob returned : 1, 0
14:41:26 Grant Right for TMC\bob returned : 1, 0
14:41:26 Grant Right for TMC\bob returned : 1, 0
14:41:27 C:\Program Files\Microsoft SQL Server\80\Tools\Binn\cnfgsvr.exe -F
"C:\WINDOWS\sqlstp9.log" -I MSSQLSERVER -V 1 -M 0 -Q
"SQL_Latin1_General_CP1_CI_AS" -H 524590 -U sa -P
#####################
Starting Service ...
SQL_Latin1_General_CP1_CI_AS
-m -Q -T4022 -T3659
Connecting to Server ...
driver={sql server};server=virtualserver1;UID=sa;PWD=;database =master
Configuring Server ...
EXEC sp_grantlogin N'BUILTIN\Administrators'
[Microsoft][ODBC SQL Server Driver][SQL Server]Granted login access to
'BUILTIN\Administrators'.
EXEC sp_addsrvrolemember N'BUILTIN\Administrators', 'sysadmin'
[Microsoft][ODBC SQL Server Driver][SQL Server]'BUILTIN\Administrators'
added to role 'sysadmin'.
update master.dbo.spt_server_info set attribute_value = @.@.version where
attribute_id = 2
EXEC sp_grantlogin N'TMC\bob'
[Microsoft][ODBC SQL Server Driver][SQL Server]Granted login access to
'TMC\bob'.
EXEC sp_addsrvrolemember N'TMC\bob', 'sysadmin'
[Microsoft][ODBC SQL Server Driver][SQL Server]'TMC\bob' added to role
'sysadmin'.
EXEC sp_addserver N'virtualserver1', local
[Microsoft][ODBC SQL Server Driver][SQL Server]Password changed.
EXEC sp_configure 'allow updates', 1
[Microsoft][ODBC SQL Server Driver][SQL Server]DBCC execution completed. If
DBCC printed error messages, contact your system administrator.
[Microsoft][ODBC SQL Server Driver][SQL Server]Configuration option 'allow
updates' changed from 0 to 1. Run the RECONFIGURE statement to install.
reconfigure with override
update master.dbo.sysaltfiles set size=1024 where name=N'tempdev'
EXEC sp_configure 'allow updates', 0
[Microsoft][ODBC SQL Server Driver][SQL Server]DBCC execution completed. If
DBCC printed error messages, contact your system administrator.
[Microsoft][ODBC SQL Server Driver][SQL Server]Configuration option 'allow
updates' changed from 1 to 0. Run the RECONFIGURE statement to install.
reconfigure with override
Disconnecting from Server ...
Stopping Service ...
SQL Server has been successfully configured!
################
14:42:22 Process Exit Code: (0)
14:42:22 End Action BuildServer
14:42:22 Begin Action SelfRegiser
14:42:22 DLLRegisterServer atl.dll: 0, 0x0
14:42:27 Manual DLLRegisterServer C:\Program Files\Common Files\Microsoft
Shared\Database Replication\Conflict Viewer\wzcnf.dll: 0, 0x0
14:42:27 Begin Action SelfRegisterOnCluster
14:42:27 End Action SelfRegisterOnCluster
14:42:27 Begin Action RegisterSvrReplFiles
14:42:27 End Action RegisterSvrReplFiles
14:42:27 Begin Action SelfRegisterCOMShared
14:42:27 End Action SelfRegisterCOMShared
14:42:27 End Action SelfRegister
14:42:27 Begin Action SetupRegistry:
14:42:27 SNMP service has been detected.
14:42:27 Begin Action RegWriteInstalledInstances:
14:42:27 End Action RegWriteInstalledInstances
14:42:27 Register this installation of SQL Server with MDAC
14:42:27 Completed registering this installation of SQL Server with MDAC
14:42:27 SetRegSecuritySQLAndAdmin for
Software\Microsoft\MSSQLServer\SQLServerAgent returned: 0, 0
14:42:27 SetRegSecuritySQLAndAdmin for
Software\Microsoft\MSSQLServer\Replication returned: 0, 0
14:42:27 SetRegSecuritySQLAndAdmin for
Software\Microsoft\MSSQLServer\Providers returned: 0, 0
14:42:27 SetRegSecuritySQLAndAdmin for Software\Microsoft\MSSQLServer\Setup
returned: 0, 0
14:42:27 SetRegSecuritySQLAndAdmin for
Software\Microsoft\MSSQLServer\Tracking returned: 0, 0
14:42:27 Updating SQL Licensing Control Panel information
14:42:27 Done updating SQL Licensing Control Panel information
14:42:27 SetRegSecuritySQLAndAdmin for
System\CurrentControlset\Services\MSSQLSERVER returned: 0, 0
14:42:27 SetRegSecuritySQLAndAdmin for Software\Microsoft\Windows
NT\CurrentVersion\Perflib returned: 0, 0
14:42:27 SetRegSecuritySQLAndAdmin for SOFTWARE\Clients\Mail returned: 0, 0
14:42:27 End Action SetupRegistry
14:42:27 Begin Action PostSetupRegistry:
14:42:27 C:\DOCUME~1\Username\LOCALS~1\Temp\SqlSetup\Bin\sc m.exe -Silent 1
-Action 7 -Service MSSQLSERVER -SvcStartType 1 -SvcAccount "TMC\bob" -SvcEPwd
14:42:27 Process Exit Code: (0)
14:42:27 C:\DOCUME~1\Username\LOCALS~1\Temp\SqlSetup\Bin\sc m.exe -Silent 1
-Action 5 -Service "SQLSERVERAGENT" -Dependencies MSSQLSERVER -ExePath
"C:\Program Files\Microsoft SQL Server\MSSQL\binn\sqlagent.exe" -SvcAccount
"TMC\bob" -SvcEPwd
14:42:33 Process Exit Code: (0)
14:42:33 SetupSQLExecSecurity returned: 0
14:42:33 PerfmonLoad returned: 0
14:42:33 C:\PROGRA~1\MICROS~1\80\Tools\Binn\dcomscm.exe /RegServer
14:42:33 Process Exit Code: (0)
14:42:33 MSSearch ApplicationName: SQLServer
14:42:33 C:\SQL2000_Ent\x86\FullText\ftsetup.exe SQLServer TMC\bob 1 0 1 0
14:42:33 C:\SQL2000_Ent\x86\FullText\ftsetup.exe SQLServer TMC\bob 1 0 1 0
14:42:33 Process Exit Code: (0)
14:42:33 FulltextSetup returned: 0
14:42:33 C:\Program Files\Microsoft SQL Server\80\Tools\Binn\sqladhlp.exe
-i -lcid 1033
14:42:33 Process Exit Code: (0)
14:42:33 End Action PostSetupRegistry
14:42:33 Begin Action SetupFolders:
14:42:33 C:\Documents and Settings\All Users\Start Menu\Programs\Microsoft
SQL Server\Enterprise Manager
14:42:33 Software\Microsoft\MSSQLServer\Tracking\Shortcuts\ Enterprise Manager
14:42:33 Tracking\Shortcuts\Enterprise Manager
14:42:33 C:\Documents and Settings\All Users\Start Menu\Programs\Microsoft
SQL Server\Query Analyzer
14:42:33 Software\Microsoft\MSSQLServer\Tracking\Shortcuts\ Query Analyzer
14:42:33 Tracking\Shortcuts\Query Analyzer
14:42:33 C:\Documents and Settings\All Users\Start Menu\Programs\Microsoft
SQL Server\Profiler
14:42:33 Software\Microsoft\MSSQLServer\Tracking\Shortcuts\ Profiler
14:42:33 Tracking\Shortcuts\Profiler
14:42:33 C:\Documents and Settings\All Users\Start Menu\Programs\Microsoft
SQL Server\Client Network Utility
14:42:33 Software\Microsoft\MSSQLServer\Tracking\Shortcuts\ Client Network
Utility
14:42:33 Tracking\Shortcuts\Client Network Utility
14:42:33 C:\Documents and Settings\All Users\Start Menu\Programs\Microsoft
SQL Server\Configure SQL XML Support in IIS
14:42:33 Software\Microsoft\MSSQLServer\Tracking\Shortcuts\ Configure SQL XML
Support in IIS
14:42:33 Tracking\Shortcuts\Configure SQL XML Support in IIS
14:42:33 C:\Documents and Settings\All Users\Start Menu\Programs\Microsoft
SQL Server\Import and Export Data
14:42:33 Software\Microsoft\MSSQLServer\Tracking\Shortcuts\ Import and Export
Data
14:42:33 Tracking\Shortcuts\Import and Export Data
14:42:33 C:\Documents and Settings\All Users\Start Menu\Programs\Microsoft
SQL Server\Service Manager
14:42:33 Software\Microsoft\MSSQLServer\Tracking\Shortcuts\ Service Manager
14:42:33 Tracking\Shortcuts\Service Manager
14:42:33 C:\Documents and Settings\All Users\Start Menu\Programs\Microsoft
SQL Server\Server Network Utility
14:42:33 Software\Microsoft\MSSQLServer\Tracking\Shortcuts\ Server Network
Utility
14:42:33 Tracking\Shortcuts\Server Network Utility
14:42:33 Microsoft SQL Server Folder refreshed.
14:42:33 End Action SetupFolders
14:42:33 Action CleanUpInstall:
14:42:33 Uninstall command: C:\WINDOWS\IsUninst.exe -f"C:\Program
Files\Microsoft SQL Server\MSSQL\Uninst.isu" -c"C:\Program Files\Microsoft
SQL Server\MSSQL\sqlsun.dll" -msql.mif i=MSSQLSERVER
14:42:33
Software\Microsoft\MSSQLServer\Tracking\{E07FDDA4-5A21-11d2-9DAD-00C04F79D434}
14:42:33
Software\Microsoft\MSSQLServer\Tracking\{E07FDDA7-5A21-11d2-9DAD-00C04F79D434}
14:42:33
Software\Microsoft\MSSQLServer\Tracking\{6DC86044-0C71-11d3-9E18-00C04F79D434}
14:42:33 Software\Microsoft\Microsoft SQL
Server\80\Tools\Tracking\{E07FDDA8-5A21-11d2-9DAD-00C04F79D434} (1)
14:42:33
Software\Microsoft\MSSQLServer\Tracking\{E07FDDA8-5A21-11d2-9DAD-00C04F79D434}
14:42:33 Software\Microsoft\Microsoft SQL
Server\80\Tools\Tracking\{E07FDDA9-5A21-11d2-9DAD-00C04F79D434} (1)
14:42:33
Software\Microsoft\MSSQLServer\Tracking\{E07FDDA9-5A21-11d2-9DAD-00C04F79D434}
14:42:33 Software\Microsoft\Microsoft SQL
Server\80\Tools\Tracking\{E07FDDAA-5A21-11d2-9DAD-00C04F79D434} (1)
14:42:33
Software\Microsoft\MSSQLServer\Tracking\{E07FDDAA-5A21-11d2-9DAD-00C04F79D434}
14:42:33 Software\Microsoft\Microsoft SQL
Server\80\Tools\Tracking\{E07FDDAB-5A21-11d2-9DAD-00C04F79D434} (1)
14:42:33
Software\Microsoft\MSSQLServer\Tracking\{E07FDDAB-5A21-11d2-9DAD-00C04F79D434}
14:42:33 Software\Microsoft\Microsoft SQL
Server\80\Tools\Tracking\{E07FDDAC-5A21-11d2-9DAD-00C04F79D434} (1)
14:42:33
Software\Microsoft\MSSQLServer\Tracking\{E07FDDAC-5A21-11d2-9DAD-00C04F79D434}
14:42:33 Software\Microsoft\Microsoft SQL
Server\80\Tools\Tracking\{E07FDDAD-5A21-11d2-9DAD-00C04F79D434} (1)
14:42:33
Software\Microsoft\MSSQLServer\Tracking\{E07FDDAD-5A21-11d2-9DAD-00C04F79D434}
14:42:33 Software\Microsoft\Microsoft SQL
Server\80\Tools\Tracking\{E07FDDBE-5A21-11d2-9DAD-00C04F79D434} (1)
14:42:33
Software\Microsoft\MSSQLServer\Tracking\{E07FDDBE-5A21-11d2-9DAD-00C04F79D434}
14:42:33 StatsGenerate returned: 2
14:42:33 StatsGenerate (0x0,0x1,0xf00000,0x0,1033,303,0x0,0x1000000a,0,0, 0
14:42:33 StatsGenerate -1,username)
14:42:33 Installation Succeeded
|||Figured out the problem. I had taken the MSDTC offline per a step-by-step
provided by a sql server website. This was incorrect in my situation. Once I
brought the MSDTC online the install was successful. Additionally to apply
SP3 I had to manually bring the sql virtual server online before running the
sp3 setup.
Thanks to everyone that helped!

New SQL Express

I am working with Microsoft Office Access 2003 on MSWXP Professional SP2. In attempting to open one of the sample database projects that come with Access 2003, NorthwindCS.adp, I get the following message: "Microsoft Access could not find either Microsoft SQL Server 2000 Desktop Engine or Microsoft SQL Server installed on your computer. Click OK to display the Data Link Properties dialog box and log on to a remote server. If you want to install SQL Server 2000 Desktop Engine on this computer first, click Cancel, install it from the MSDE2000 folder on the Office CD-ROM, and then reopen this Access project". Instead of downloading & installing the Microsoft SQL Server 2000 Desktop Engine, I downloaded & installed the SQL Server 2005 Express Edition SP1 instead. After having restarted the computer and relaunching Access 2003 & opening the NorthwindCS.adp I still get the same message as mentioned previously above. My question is can the SQL Server 2005 Express Edition SP1 be used or must the SQL Server 2000 Desktop Engine be used instead. I understand that running Microsoft Windows Vista must use the SQL Server 2005 Express Edition SP1 but I am running MSWXP Professional SP2 instead. Advise?

Hi,

AFAIC remember 2003 ADP projects are not fully supported / working in conjunction with SQL Server Express even with t the compt. settings changed.

HTH; Jens K. Suessmeyer.

http://www.sqlserver2005.de

New SP2?

Today, Microsoft published a new SQL Server 2005 SP2 Build (9.0.3042.1) but with no Information, what has changed since the Original Build 9.0.3042.0. Do you have more Information? Thanks in advance.

Please see Ed's post listed here:

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1312501&SiteID=1

Thanks,
Sam Lester (MSFT)

New SP2 Excel Render Bug (Excel Formulas)

Hi,
I have a report that converts expression to Excel formulas. The Excel
formulas in a table are incorrectly rendered in a way that the references
are all off by 6 or so cells. When I set the "Omit Formulas" device setting
to true the values are correct, though there are no formulas. I don't
remember this failure in SP1.
Thanks,
Bryan
PS. Is there a way to make "OmitFormulas=true" static when the request is
made from the report manager?BTW, This bug only happens when requesting the render from the report
server. It doesn't happen in VS.NET.
"BDB" <reply@.to.group.com> wrote in message
news:eK%234l6nSFHA.3336@.TK2MSFTNGP10.phx.gbl...
> Hi,
> I have a report that converts expression to Excel formulas. The Excel
> formulas in a table are incorrectly rendered in a way that the references
> are all off by 6 or so cells. When I set the "Omit Formulas" device
> setting to true the values are correct, though there are no formulas. I
> don't remember this failure in SP1.
> Thanks,
> Bryan
> PS. Is there a way to make "OmitFormulas=true" static when the request is
> made from the report manager?
>|||Setting the DeviceInfo defaults has been added in SQL 2005 RS but is not
available with SQL 2000. As for the bug, nothing has changed in this area so
I would imagine it happened with SP1 as well.
--
Brian Welcker
Group Program Manager
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"BDB" <reply@.to.group.com> wrote in message
news:eoGuJAoSFHA.3720@.TK2MSFTNGP10.phx.gbl...
> BTW, This bug only happens when requesting the render from the report
> server. It doesn't happen in VS.NET.
> "BDB" <reply@.to.group.com> wrote in message
> news:eK%234l6nSFHA.3336@.TK2MSFTNGP10.phx.gbl...
>> Hi,
>> I have a report that converts expression to Excel formulas. The Excel
>> formulas in a table are incorrectly rendered in a way that the references
>> are all off by 6 or so cells. When I set the "Omit Formulas" device
>> setting to true the values are correct, though there are no formulas. I
>> don't remember this failure in SP1.
>> Thanks,
>> Bryan
>> PS. Is there a way to make "OmitFormulas=true" static when the request
>> is made from the report manager?
>|||No, I've tested both ways. This bug was introduced in SP2.
"Brian Welcker [MSFT]" <bwelcker@.online.microsoft.com> wrote in message
news:ePzjhGpSFHA.2324@.TK2MSFTNGP10.phx.gbl...
> Setting the DeviceInfo defaults has been added in SQL 2005 RS but is not
> available with SQL 2000. As for the bug, nothing has changed in this area
> so I would imagine it happened with SP1 as well.
> --
> Brian Welcker
> Group Program Manager
> Microsoft SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
> "BDB" <reply@.to.group.com> wrote in message
> news:eoGuJAoSFHA.3720@.TK2MSFTNGP10.phx.gbl...
>> BTW, This bug only happens when requesting the render from the report
>> server. It doesn't happen in VS.NET.
>> "BDB" <reply@.to.group.com> wrote in message
>> news:eK%234l6nSFHA.3336@.TK2MSFTNGP10.phx.gbl...
>> Hi,
>> I have a report that converts expression to Excel formulas. The Excel
>> formulas in a table are incorrectly rendered in a way that the
>> references are all off by 6 or so cells. When I set the "Omit Formulas"
>> device setting to true the values are correct, though there are no
>> formulas. I don't remember this failure in SP1.
>> Thanks,
>> Bryan
>> PS. Is there a way to make "OmitFormulas=true" static when the request
>> is made from the report manager?
>>
>|||Can you post or send me your RDL (remove the online. part in my e-mail
address)?
--
Brian Welcker
Group Program Manager
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"BDB" <reply@.to.group.com> wrote in message
news:uFBYKQqSFHA.3552@.TK2MSFTNGP10.phx.gbl...
> No, I've tested both ways. This bug was introduced in SP2.
>
> "Brian Welcker [MSFT]" <bwelcker@.online.microsoft.com> wrote in message
> news:ePzjhGpSFHA.2324@.TK2MSFTNGP10.phx.gbl...
>> Setting the DeviceInfo defaults has been added in SQL 2005 RS but is not
>> available with SQL 2000. As for the bug, nothing has changed in this area
>> so I would imagine it happened with SP1 as well.
>> --
>> Brian Welcker
>> Group Program Manager
>> Microsoft SQL Server Reporting Services
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>> "BDB" <reply@.to.group.com> wrote in message
>> news:eoGuJAoSFHA.3720@.TK2MSFTNGP10.phx.gbl...
>> BTW, This bug only happens when requesting the render from the report
>> server. It doesn't happen in VS.NET.
>> "BDB" <reply@.to.group.com> wrote in message
>> news:eK%234l6nSFHA.3336@.TK2MSFTNGP10.phx.gbl...
>> Hi,
>> I have a report that converts expression to Excel formulas. The Excel
>> formulas in a table are incorrectly rendered in a way that the
>> references are all off by 6 or so cells. When I set the "Omit
>> Formulas" device setting to true the values are correct, though there
>> are no formulas. I don't remember this failure in SP1.
>> Thanks,
>> Bryan
>> PS. Is there a way to make "OmitFormulas=true" static when the request
>> is made from the report manager?
>>
>>
>|||Sure. Thank you.
"Brian Welcker [MSFT]" <bwelcker@.online.microsoft.com> wrote in message
news:%2376cRJrSFHA.3300@.TK2MSFTNGP10.phx.gbl...
> Can you post or send me your RDL (remove the online. part in my e-mail
> address)?
> --
> Brian Welcker
> Group Program Manager
> Microsoft SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
> "BDB" <reply@.to.group.com> wrote in message
> news:uFBYKQqSFHA.3552@.TK2MSFTNGP10.phx.gbl...
>> No, I've tested both ways. This bug was introduced in SP2.
>>
>> "Brian Welcker [MSFT]" <bwelcker@.online.microsoft.com> wrote in message
>> news:ePzjhGpSFHA.2324@.TK2MSFTNGP10.phx.gbl...
>> Setting the DeviceInfo defaults has been added in SQL 2005 RS but is not
>> available with SQL 2000. As for the bug, nothing has changed in this
>> area so I would imagine it happened with SP1 as well.
>> --
>> Brian Welcker
>> Group Program Manager
>> Microsoft SQL Server Reporting Services
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>> "BDB" <reply@.to.group.com> wrote in message
>> news:eoGuJAoSFHA.3720@.TK2MSFTNGP10.phx.gbl...
>> BTW, This bug only happens when requesting the render from the report
>> server. It doesn't happen in VS.NET.
>> "BDB" <reply@.to.group.com> wrote in message
>> news:eK%234l6nSFHA.3336@.TK2MSFTNGP10.phx.gbl...
>> Hi,
>> I have a report that converts expression to Excel formulas. The Excel
>> formulas in a table are incorrectly rendered in a way that the
>> references are all off by 6 or so cells. When I set the "Omit
>> Formulas" device setting to true the values are correct, though there
>> are no formulas. I don't remember this failure in SP1.
>> Thanks,
>> Bryan
>> PS. Is there a way to make "OmitFormulas=true" static when the
>> request is made from the report manager?
>>
>>
>>
>|||This issue was resolved by rebuilding and redeploying the RDL.
Much thinks to Brian Welcker for his help.
Bryan
"BDB" <reply@.to.group.com> wrote in message
news:OZrPaFzSFHA.3308@.TK2MSFTNGP14.phx.gbl...
> Sure. Thank you.
> "Brian Welcker [MSFT]" <bwelcker@.online.microsoft.com> wrote in message
> news:%2376cRJrSFHA.3300@.TK2MSFTNGP10.phx.gbl...
>> Can you post or send me your RDL (remove the online. part in my e-mail
>> address)?
>> --
>> Brian Welcker
>> Group Program Manager
>> Microsoft SQL Server Reporting Services
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>> "BDB" <reply@.to.group.com> wrote in message
>> news:uFBYKQqSFHA.3552@.TK2MSFTNGP10.phx.gbl...
>> No, I've tested both ways. This bug was introduced in SP2.
>>
>> "Brian Welcker [MSFT]" <bwelcker@.online.microsoft.com> wrote in message
>> news:ePzjhGpSFHA.2324@.TK2MSFTNGP10.phx.gbl...
>> Setting the DeviceInfo defaults has been added in SQL 2005 RS but is
>> not available with SQL 2000. As for the bug, nothing has changed in
>> this area so I would imagine it happened with SP1 as well.
>> --
>> Brian Welcker
>> Group Program Manager
>> Microsoft SQL Server Reporting Services
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>> "BDB" <reply@.to.group.com> wrote in message
>> news:eoGuJAoSFHA.3720@.TK2MSFTNGP10.phx.gbl...
>> BTW, This bug only happens when requesting the render from the report
>> server. It doesn't happen in VS.NET.
>> "BDB" <reply@.to.group.com> wrote in message
>> news:eK%234l6nSFHA.3336@.TK2MSFTNGP10.phx.gbl...
>> Hi,
>> I have a report that converts expression to Excel formulas. The
>> Excel formulas in a table are incorrectly rendered in a way that the
>> references are all off by 6 or so cells. When I set the "Omit
>> Formulas" device setting to true the values are correct, though there
>> are no formulas. I don't remember this failure in SP1.
>> Thanks,
>> Bryan
>> PS. Is there a way to make "OmitFormulas=true" static when the
>> request is made from the report manager?
>>
>>
>>
>>
>

New SP2 Client Install Failure

Hi,
I have successfully upgraded a server with both the new SP2 and the 3050
hotfix. I am now trying to do this to my client workstation. It selected the
following components on my SQL2005 SP1 client to upgrade.
Setup Support Files
SQL Server Native Client
Client Components
MSXML 6.0 Parser
SQLXML4
Backward Compatibility
The client component upgrade failed on
Microsoft.sqlserver.notificationservices.dll. I had an error code 1603 and
this in the hotfix.log
MSP Error: 29549 Failed to install and configure assemblies c:\Program
Files\Microsoft SQL
Server\90\NotificationServices\9.0.242\Bin\microso ft.sqlserver.notificationservices.dll
in the COM+ catalog. Error: -2146233087
Error message: Unknown error 0x80131501
Error description: The Transaction Manager is not available. (Exception from
HRESULT: 0x8004D01B)
Any ideas?
Thanks
Chris
I found the answer on Connect. You need to have DTC running for the update
to finish.
Chris
"Chris Wood" <anonymous@.discussions.microsoft.com> wrote in message
news:evoMCLaYHHA.2556@.TK2MSFTNGP02.phx.gbl...
> Hi,
> I have successfully upgraded a server with both the new SP2 and the 3050
> hotfix. I am now trying to do this to my client workstation. It selected
> the following components on my SQL2005 SP1 client to upgrade.
> Setup Support Files
> SQL Server Native Client
> Client Components
> MSXML 6.0 Parser
> SQLXML4
> Backward Compatibility
> The client component upgrade failed on
> Microsoft.sqlserver.notificationservices.dll. I had an error code 1603 and
> this in the hotfix.log
> MSP Error: 29549 Failed to install and configure assemblies c:\Program
> Files\Microsoft SQL
> Server\90\NotificationServices\9.0.242\Bin\microso ft.sqlserver.notificationservices.dll
> in the COM+ catalog. Error: -2146233087
> Error message: Unknown error 0x80131501
> Error description: The Transaction Manager is not available. (Exception
> from HRESULT: 0x8004D01B)
> Any ideas?
> Thanks
> Chris
>
|||Try starting MSDTC if it's not already started and double check your event
logs for any COM+ errors.
HTH,
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
"Chris Wood" <anonymous@.discussions.microsoft.com> wrote in message
news:evoMCLaYHHA.2556@.TK2MSFTNGP02.phx.gbl...
> Hi,
> I have successfully upgraded a server with both the new SP2 and the 3050
> hotfix. I am now trying to do this to my client workstation. It selected
> the following components on my SQL2005 SP1 client to upgrade.
> Setup Support Files
> SQL Server Native Client
> Client Components
> MSXML 6.0 Parser
> SQLXML4
> Backward Compatibility
> The client component upgrade failed on
> Microsoft.sqlserver.notificationservices.dll. I had an error code 1603 and
> this in the hotfix.log
> MSP Error: 29549 Failed to install and configure assemblies c:\Program
> Files\Microsoft SQL
> Server\90\NotificationServices\9.0.242\Bin\microso ft.sqlserver.notificationservices.dll
> in the COM+ catalog. Error: -2146233087
> Error message: Unknown error 0x80131501
> Error description: The Transaction Manager is not available. (Exception
> from HRESULT: 0x8004D01B)
> Any ideas?
> Thanks
> Chris
>

New SP2 Client Install Failure

Hi,
I have successfully upgraded a server with both the new SP2 and the 3050
hotfix. I am now trying to do this to my client workstation. It selected the
following components on my SQL2005 SP1 client to upgrade.
Setup Support Files
SQL Server Native Client
Client Components
MSXML 6.0 Parser
SQLXML4
Backward Compatibility
The client component upgrade failed on
Microsoft.sqlserver.notificationservices.dll. I had an error code 1603 and
this in the hotfix.log
MSP Error: 29549 Failed to install and configure assemblies c:\Program
Files\Microsoft SQL
Server\90\NotificationServices\9.0.242\Bin\microsoft.sqlserver.notificationservices.dll
in the COM+ catalog. Error: -2146233087
Error message: Unknown error 0x80131501
Error description: The Transaction Manager is not available. (Exception from
HRESULT: 0x8004D01B)
Any ideas?
Thanks
ChrisI found the answer on Connect. You need to have DTC running for the update
to finish.
Chris
"Chris Wood" <anonymous@.discussions.microsoft.com> wrote in message
news:evoMCLaYHHA.2556@.TK2MSFTNGP02.phx.gbl...
> Hi,
> I have successfully upgraded a server with both the new SP2 and the 3050
> hotfix. I am now trying to do this to my client workstation. It selected
> the following components on my SQL2005 SP1 client to upgrade.
> Setup Support Files
> SQL Server Native Client
> Client Components
> MSXML 6.0 Parser
> SQLXML4
> Backward Compatibility
> The client component upgrade failed on
> Microsoft.sqlserver.notificationservices.dll. I had an error code 1603 and
> this in the hotfix.log
> MSP Error: 29549 Failed to install and configure assemblies c:\Program
> Files\Microsoft SQL
> Server\90\NotificationServices\9.0.242\Bin\microsoft.sqlserver.notificationservices.dll
> in the COM+ catalog. Error: -2146233087
> Error message: Unknown error 0x80131501
> Error description: The Transaction Manager is not available. (Exception
> from HRESULT: 0x8004D01B)
> Any ideas?
> Thanks
> Chris
>|||Try starting MSDTC if it's not already started and double check your event
logs for any COM+ errors.
--
HTH,
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
"Chris Wood" <anonymous@.discussions.microsoft.com> wrote in message
news:evoMCLaYHHA.2556@.TK2MSFTNGP02.phx.gbl...
> Hi,
> I have successfully upgraded a server with both the new SP2 and the 3050
> hotfix. I am now trying to do this to my client workstation. It selected
> the following components on my SQL2005 SP1 client to upgrade.
> Setup Support Files
> SQL Server Native Client
> Client Components
> MSXML 6.0 Parser
> SQLXML4
> Backward Compatibility
> The client component upgrade failed on
> Microsoft.sqlserver.notificationservices.dll. I had an error code 1603 and
> this in the hotfix.log
> MSP Error: 29549 Failed to install and configure assemblies c:\Program
> Files\Microsoft SQL
> Server\90\NotificationServices\9.0.242\Bin\microsoft.sqlserver.notificationservices.dll
> in the COM+ catalog. Error: -2146233087
> Error message: Unknown error 0x80131501
> Error description: The Transaction Manager is not available. (Exception
> from HRESULT: 0x8004D01B)
> Any ideas?
> Thanks
> Chris
>

New SP2 Client Install Failure

Hi,
I have successfully upgraded a server with both the new SP2 and the 3050
hotfix. I am now trying to do this to my client workstation. It selected the
following components on my SQL2005 SP1 client to upgrade.
Setup Support Files
SQL Server Native Client
Client Components
MSXML 6.0 Parser
SQLXML4
Backward Compatibility
The client component upgrade failed on
Microsoft.sqlserver.notificationservices.dll. I had an error code 1603 and
this in the hotfix.log
MSP Error: 29549 Failed to install and configure assemblies c:\Program
Files\Microsoft SQL
Server\90\NotificationServices\9.0.242\Bin\microsoft.sqlserver.notifications
ervices.dll
in the COM+ catalog. Error: -2146233087
Error message: Unknown error 0x80131501
Error description: The Transaction Manager is not available. (Exception from
HRESULT: 0x8004D01B)
Any ideas?
Thanks
ChrisI found the answer on Connect. You need to have DTC running for the update
to finish.
Chris
"Chris Wood" <anonymous@.discussions.microsoft.com> wrote in message
news:evoMCLaYHHA.2556@.TK2MSFTNGP02.phx.gbl...
> Hi,
> I have successfully upgraded a server with both the new SP2 and the 3050
> hotfix. I am now trying to do this to my client workstation. It selected
> the following components on my SQL2005 SP1 client to upgrade.
> Setup Support Files
> SQL Server Native Client
> Client Components
> MSXML 6.0 Parser
> SQLXML4
> Backward Compatibility
> The client component upgrade failed on
> Microsoft.sqlserver.notificationservices.dll. I had an error code 1603 and
> this in the hotfix.log
> MSP Error: 29549 Failed to install and configure assemblies c:\Program
> Files\Microsoft SQL
> Server\90\NotificationServices\9.0.242\Bin\microsoft.sqlserver.notificatio
nservices.dll
> in the COM+ catalog. Error: -2146233087
> Error message: Unknown error 0x80131501
> Error description: The Transaction Manager is not available. (Exception
> from HRESULT: 0x8004D01B)
> Any ideas?
> Thanks
> Chris
>|||Try starting MSDTC if it's not already started and double check your event
logs for any COM+ errors.
HTH,
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
"Chris Wood" <anonymous@.discussions.microsoft.com> wrote in message
news:evoMCLaYHHA.2556@.TK2MSFTNGP02.phx.gbl...
> Hi,
> I have successfully upgraded a server with both the new SP2 and the 3050
> hotfix. I am now trying to do this to my client workstation. It selected
> the following components on my SQL2005 SP1 client to upgrade.
> Setup Support Files
> SQL Server Native Client
> Client Components
> MSXML 6.0 Parser
> SQLXML4
> Backward Compatibility
> The client component upgrade failed on
> Microsoft.sqlserver.notificationservices.dll. I had an error code 1603 and
> this in the hotfix.log
> MSP Error: 29549 Failed to install and configure assemblies c:\Program
> Files\Microsoft SQL
> Server\90\NotificationServices\9.0.242\Bin\microsoft.sqlserver.notificatio
nservices.dll
> in the COM+ catalog. Error: -2146233087
> Error message: Unknown error 0x80131501
> Error description: The Transaction Manager is not available. (Exception
> from HRESULT: 0x8004D01B)
> Any ideas?
> Thanks
> Chris
>sql

New Production Server - Orphaned Users

Hi,
I have to move 5 databases from an old production server to a new production
server.
Old Production Server: Win 2K Server, SQL 2000 SP2
New Production Server:Win 2K3 Server, SQL 2000 SP4
I am creating the new server from scratch. Since I can't run SQL Server SP2
on Win 2K3 OS, I have a Staging Server running Win 2K and SQL 2000 SP2.
I backed up system databases on Old Production server and restored them on
Staging and applied SP4 to the Staging server. Then I backed up system
databases on Staging and restored them on New Production Server since both of
them are now at the same Service Pack Level. I have to do it this way to
avoid applying SP4 directly to the old Production server.
Then I detached and attached the User databases on the New Production server
from Old Production server. My question is - would I still have orphaned
users? Thanks in advance.If I followed your chain correctly, you basically took your system databases from a to b to c. Then
you take your user databases from a to c. This should mean that the logins exists with correct SID -
i.e., no orphaned users.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"sharman" <sharman@.discussions.microsoft.com> wrote in message
news:CDCD1A18-7031-4BA4-A08D-4363E296CD77@.microsoft.com...
> Hi,
> I have to move 5 databases from an old production server to a new production
> server.
> Old Production Server: Win 2K Server, SQL 2000 SP2
> New Production Server:Win 2K3 Server, SQL 2000 SP4
> I am creating the new server from scratch. Since I can't run SQL Server SP2
> on Win 2K3 OS, I have a Staging Server running Win 2K and SQL 2000 SP2.
> I backed up system databases on Old Production server and restored them on
> Staging and applied SP4 to the Staging server. Then I backed up system
> databases on Staging and restored them on New Production Server since both of
> them are now at the same Service Pack Level. I have to do it this way to
> avoid applying SP4 directly to the old Production server.
> Then I detached and attached the User databases on the New Production server
> from Old Production server. My question is - would I still have orphaned
> users? Thanks in advance.|||Hi
http://dimantdatabasesolutions.blogspot.com/2007/04/sql-or-windows-authentication.html
"sharman" <sharman@.discussions.microsoft.com> wrote in message
news:CDCD1A18-7031-4BA4-A08D-4363E296CD77@.microsoft.com...
> Hi,
> I have to move 5 databases from an old production server to a new
> production
> server.
> Old Production Server: Win 2K Server, SQL 2000 SP2
> New Production Server:Win 2K3 Server, SQL 2000 SP4
> I am creating the new server from scratch. Since I can't run SQL Server
> SP2
> on Win 2K3 OS, I have a Staging Server running Win 2K and SQL 2000 SP2.
> I backed up system databases on Old Production server and restored them on
> Staging and applied SP4 to the Staging server. Then I backed up system
> databases on Staging and restored them on New Production Server since both
> of
> them are now at the same Service Pack Level. I have to do it this way to
> avoid applying SP4 directly to the old Production server.
> Then I detached and attached the User databases on the New Production
> server
> from Old Production server. My question is - would I still have orphaned
> users? Thanks in advance.

new local printing with "error on page"

Hallo
I have a problem with local printing with SP2. As administrator I can
press the new button and receive the question about Security and then
the ActiveX Control RSClientPrint is installed.
As an ordinary user I receive an error on page. "Object doesn't support
this property or method" and the ActiveX Control isn't installed.
Has anybody a good idea how I can install the Control on a computer as
user and not as administrator?
Thanks!This is not a RS issue, but one to do with the permissions granted to
oridnary users, possibly through your Group profile. You could have a look
in IE at the Custom Level Security Settings under "Internet Options" but if
you are in a work environment you need to speak to the network admins. If
you are the network admin, try posting in their group. If this has only
happened since installing SP2 go back to the Security Settings for ActiveX
controls and have a look at the settings.
--
Mary Bray [SQL Server MVP]
Please reply only to newsgroups
<linus@.dplanet.ch> wrote in message
news:1116705736.745994.168630@.f14g2000cwb.googlegroups.com...
> Hallo
> I have a problem with local printing with SP2. As administrator I can
> press the new button and receive the question about Security and then
> the ActiveX Control RSClientPrint is installed.
> As an ordinary user I receive an error on page. "Object doesn't support
> this property or method" and the ActiveX Control isn't installed.
> Has anybody a good idea how I can install the Control on a computer as
> user and not as administrator?
> Thanks!
>

New Instances created after an SP2 install

Do I need to reinstall SP2 everytime I add an SQL Instance?Yes you will need to reinstall SP2 for each instance installed.

New Installation of SQL Server 2000

Hi,
I installed sql server 2000 sp2 standard edition on Windows 2003, when
installing, it said "This version is not support on this os", but I was told
to continue installing the software and that I could install the latest
security patches to bring it up to date. Will that work? Do I need to do
anything else? SQL Server 2000 is up and running on the box. When running
the statement " select @.@.version" it informed me that I was at 8.00.194
patch level. How can I tell if SQL Server 2000 is 32 or 64 bit? I was
trying to download the lasted patch and it asked for that info. Thanks.--
New SQL Server DBA
Newbie wrote:
> Hi,
> I installed sql server 2000 sp2 standard edition on Windows 2003, when
> installing, it said "This version is not support on this os", but I
> was told to continue installing the software and that I could install
> the latest security patches to bring it up to date. Will that work?
> Do I need to do anything else? SQL Server 2000 is up and running on
> the box. When running the statement " select @.@.version" it informed
> me that I was at 8.00.194 patch level. How can I tell if SQL Server
> 2000 is 32 or 64 bit? I was trying to download the lasted patch and
> it asked for that info. Thanks.-- New SQL Server DBA
You didn't install SQL 2000 SP2. You installed SQL 2000 RTM (v194). The
installation program at the point SQL 2000 RTM was released didn't know
about Win2K3 and is giving you the error.
Install SP3a on the server and you should be ready to go.
David Gugick
Imceda Software
www.imceda.com

New Installation of SQL Server 2000

Hi,
I installed sql server 2000 sp2 standard edition on Windows 2003, when
installing, it said "This version is not support on this os", but I was told
to continue installing the software and that I could install the latest
security patches to bring it up to date. Will that work? Do I need to do
anything else? SQL Server 2000 is up and running on the box. When running
the statement " select @.@.version" it informed me that I was at 8.00.194
patch level. How can I tell if SQL Server 2000 is 32 or 64 bit? I was
trying to download the lasted patch and it asked for that info. Thanks.--
New SQL Server DBANewbie wrote:
> Hi,
> I installed sql server 2000 sp2 standard edition on Windows 2003, when
> installing, it said "This version is not support on this os", but I
> was told to continue installing the software and that I could install
> the latest security patches to bring it up to date. Will that work?
> Do I need to do anything else? SQL Server 2000 is up and running on
> the box. When running the statement " select @.@.version" it informed
> me that I was at 8.00.194 patch level. How can I tell if SQL Server
> 2000 is 32 or 64 bit? I was trying to download the lasted patch and
> it asked for that info. Thanks.-- New SQL Server DBA
You didn't install SQL 2000 SP2. You installed SQL 2000 RTM (v194). The
installation program at the point SQL 2000 RTM was released didn't know
about Win2K3 and is giving you the error.
Install SP3a on the server and you should be ready to go.
David Gugick
Imceda Software
www.imceda.com

New Installation of Sql Server 2000

Hello Guru's, I need your help!

I installed sql server 2000 sp2 standard edition on Windows 2003, when
installing, it said "This version is not supported on this os", but I was told
to continue installing the software and that I could install the latest
security patches to bring it up to date. Will that work? Do I need to do
anything else? SQL Server 2000 is up and running on the box. When running
the statement " select @.@.version" it informed me that I was at 8.00.194
patch level. How can I tell if SQL Server 2000 is 32 or 64 bit? I was
trying to download the lasted patch and it asked for that info. Thanks.--
New to SQL ServerUnless you paid over $20,000 for SQL Server, it is probably 32 bit. I think the 64 bit version of SQL server states in @.@.version that it is 64 bit, so if you do not see anything, you very likely have 32 bit.

You need SQL Server SP3 to run on Windows 2003 with no problems. Just download the patch, run it, and you should be all set.|||Thank You Very Much!!! :)

New Installation of SQL Server 2000

Hi,
I installed sql server 2000 sp2 standard edition on Windows 2003, when
installing, it said "This version is not support on this os", but I was told
to continue installing the software and that I could install the latest
security patches to bring it up to date. Will that work? Do I need to do
anything else? SQL Server 2000 is up and running on the box. When running
the statement " select @.@.version" it informed me that I was at 8.00.194
patch level. How can I tell if SQL Server 2000 is 32 or 64 bit? I was
trying to download the lasted patch and it asked for that info. Thanks.--
New SQL Server DBANewbie wrote:
> Hi,
> I installed sql server 2000 sp2 standard edition on Windows 2003, when
> installing, it said "This version is not support on this os", but I
> was told to continue installing the software and that I could install
> the latest security patches to bring it up to date. Will that work?
> Do I need to do anything else? SQL Server 2000 is up and running on
> the box. When running the statement " select @.@.version" it informed
> me that I was at 8.00.194 patch level. How can I tell if SQL Server
> 2000 is 32 or 64 bit? I was trying to download the lasted patch and
> it asked for that info. Thanks.-- New SQL Server DBA
You didn't install SQL 2000 SP2. You installed SQL 2000 RTM (v194). The
installation program at the point SQL 2000 RTM was released didn't know
about Win2K3 and is giving you the error.
Install SP3a on the server and you should be ready to go.
David Gugick
Imceda Software
www.imceda.com