Installing issue (Log included)

When I try to install MSDE it just stops, the progress bar rolls back.
I've looked through the log file, but I guess I dont know what I am looking
for.
http://www.bercell.com/logfiles.htm (get the log file here)
I am using Windows 2003 Standard edition, with all updates installed. If
someone can take a look at the log I would really appriciate it. Also if you
see something wrong, past the part of the log so I can check it out also.
For some reason clicking on the link doesnt work, it seems to add a space
after the .htm. Just remove the space in the browser and the page should
come up.
"Dan" wrote:

> When I try to install MSDE it just stops, the progress bar rolls back.
> I've looked through the log file, but I guess I dont know what I am looking
> for.
> http://www.bercell.com/logfiles.htm (get the log file here)
> I am using Windows 2003 Standard edition, with all updates installed. If
> someone can take a look at the log I would really appriciate it. Also if you
> see something wrong, past the part of the log so I can check it out also.
|||hi Dan,
Dan wrote:
> When I try to install MSDE it just stops, the progress bar rolls back.
> I've looked through the log file, but I guess I dont know what I am
> looking for.
> http://www.bercell.com/logfiles.htm (get the log file here)
> I am using Windows 2003 Standard edition, with all updates installed.
> If someone can take a look at the log I would really appriciate it.
> Also if you see something wrong, past the part of the log so I can
> check it out also.
did you check http://seer.support.veritas.com/docs/265613.htm ?
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

Installing Inventor10

Hello,
I have a problem installing Autodesk Inventor 10 on my
WK SP4 OS system on XP SP2 system it works fine.
Event log during setup Inventor 10 Pro.
Source Loadperf
Category (none)
Event ID 2000
No object list was found in the installation file.
Adding an object list to the installation file will improve
performance of the system when measuring performance counters.
Source Loadperf
Category (none)
Event ID 1000
Performance counters for the MSSQL$INVENTORCONTENT service were loaded
successfully.
The Record Data contains the new index values assigned to this service.
Source MSSQL$INVENTORCONTENT
Category (8)
Event ID 19011
The description for Event ID ( 19011 ) in Source ( MSSQL$INVENTORCONTENT
) cannot be found.
The local computer may not have the necessary registry information or
message DLL files to display messages from a remote computer.
The following information is part of the event: (SpnRegister) : Error 1355.
Source MsiInstaller
Category (none)
Event ID 1013
Product: Microsoft SQL Server Desktop Engine --
An error has occurred registering this installation of SQL Server
Desktop Engine with MDAC.
Source MsiInstaller
Category (none)
Event ID 11708
Product: Microsoft SQL Server Desktop Engine --
Installation operation failed.
Source MsiInstaller
Category (none)
Event ID 11722
Product: Autodesk Inventor Professional 10 -- Error 1722.
There is a problem with this Windows Installer package.
A program run as part of the setup did not finish as expected.
Contact your support personnel or package vendor.
Action InstallMSDE, location:
F:\inv1_pro10\bin\acadfeui\support\msde\setup.exe, command:
SAPWD="AutodeskVault" INSTANCENAME="INVENTORCONTENT" SECURITYMODE=SQL
DISABLENETWORKPROTOCOLS=1 /L*v
C:\DOCUME~1\FRANCK~1\LOCALS~1\Temp\MSDE_CC_setup.l og /qb
REBOOT=ReallySuppress
Kind Regards
hi,
Smeusje wrote:
> Hello,
> I have a problem installing Autodesk Inventor 10 on my
> WK SP4 OS system on XP SP2 system it works fine.
> Event log during setup Inventor 10 Pro.
try inspecting C:\DOCUME~1\FRANCK~1\LOCALS~1\Temp\MSDE_CC_setup.l og
for
RETURN VALUE 3
entries..
about 10 lines before each entry some (sometime cryptic) description of the
problem will be reported..
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.18.0 - DbaMgr ver 0.62.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||I have two of them
************************************************** ************************************************** ********************
Starting custom action SkuIt
MSI (s) (30:D4) [13:57:35:890]: Executing op:
CustomActionSchedule(Action=ConfigServer.2D02443E_ 7002_4C0B_ABC9_EAB2C064397B...
MSI (s) (30:18) [13:57:35:921]: Invoking remote custom action. DLL:
C:\WINNT\Installer\MSI47.tmp, Entrypoint: ConfigServer
SOFTWARE\Microsoft\Microsoft SQL Server
Setup.{E09B48B5-E141-427A-AB0C-D3605127224A}
TempFolder is
C:\DOCUME~1\FRANCK~1\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\
Loading extended custom action library
C:\DOCUME~1\FRANCK~1\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\sqlcax.dll
SOFTWARE\Microsoft\Microsoft SQL Server
Setup.{E09B48B5-E141-427A-AB0C-D3605127224A}
Starting custom action ConfigServer
MSI (s) (30:D4) [13:58:06:968]: Executing op:
ActionStart(Name=RegSQLWithMDAC.2D02443E_7002_4C0B _ABC9_EAB2C064397B,,)
Executing "C:\Program Files\Microsoft SQL
Server\80\Tools\Binn\cnfgsvr.exe -V 1 -M 1 -U sa -I "INVENTORCONTENT" -Q
"SQL_Latin1_General_CP1_CI_AS""
MSI (s) (30:D4) [13:58:06:968]: Executing op:
CustomActionSchedule(Action=RegSQLWithMDAC.2D02443 E_7002_4C0B_ABC9_EAB2C064397B,ActionType=1025,Sour ce=BinaryData,Target=RegSQLWithMDAC,)
MSI (s) (30:18) [13:58:06:984]: Invoking remote custom action. DLL:
C:\WINNT\Installer\MSI48.tmp, Entrypoint: RegSQLWithMDAC
SOFTWARE\Microsoft\Microsoft SQL Server
Setup.{E09B48B5-E141-427A-AB0C-D3605127224A}
TempFolder is
C:\DOCUME~1\FRANCK~1\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\
Loading extended custom action library
C:\DOCUME~1\FRANCK~1\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\sqlcax.dll
SOFTWARE\Microsoft\Microsoft SQL Server
Setup.{E09B48B5-E141-427A-AB0C-D3605127224A}
Starting custom action RegSqlWithMdac
MSI (s) (30!00) [13:58:12:796]: Product: Microsoft SQL Server Desktop
Engine -- An error has occurred registering this installation of SQL
Server Desktop Engine with MDAC.
MSI (c) (60:90) [13:58:07:109]: Font created. Charset: Req=0, Ret=0,
Font: Req=MS Shell Dlg, Ret=MS Shell Dlg
An error has occurred registering this installation of SQL Server
Desktop Engine with MDAC.
MSI (s) (30:D4) [13:58:12:812]: User policy value 'DisableRollback' is 0
MSI (s) (30:D4) [13:58:12:812]: Machine policy value 'DisableRollback' is 0
Action ended 13:58:12: InstallFinalize. Return value 3.
************************************************** ************************************************** *******************
MSI (s) (30:D4) [13:58:19:078]: Executing op:
ActionStart(Name=RollbackStreamSupportFiles.2D0244 3E_7002_4C0B_ABC9_EAB2C064397B,,)
MSI (s) (30:D4) [13:58:19:078]: Executing op:
CustomActionRollback(Action=RollbackStreamSupportF iles.2D02443E_7002_4C0B_ABC9_EAB2C064397B,ActionTy pe=1281,Source=BinaryData,Target=RemoveSupportFile s,)
MSI (s) (30:94) [13:58:19:078]: Invoking remote custom action. DLL:
C:\WINNT\Installer\MSI4B.tmp, Entrypoint: RemoveSupportFiles
SOFTWARE\Microsoft\Microsoft SQL Server
Setup.{E09B48B5-E141-427A-AB0C-D3605127224A}
Deleted Support file :
C:\DOCUME~1\FRANCK~1\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\setupex.dll
Deleted Support file :
C:\DOCUME~1\FRANCK~1\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\sqdedev.dll
Deleted Support file :
C:\DOCUME~1\FRANCK~1\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\sqlsut.dll
Deleted Support file :
C:\DOCUME~1\FRANCK~1\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\sqlunirl.dll
Deleted Support file :
C:\DOCUME~1\FRANCK~1\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\sqlresld.dll
Deleted Support file :
C:\DOCUME~1\FRANCK~1\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\sqlcax.rll
Deleted Support file :
C:\DOCUME~1\FRANCK~1\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\sqlstp.dll
Deleted Support file :
C:\DOCUME~1\FRANCK~1\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\sqlstp.rll
Deleted Support file :
C:\DOCUME~1\FRANCK~1\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\sqlcax.dll
MSI (s) (30:D4) [13:58:19:203]: Executing op:
ActionStart(Name=RollbackDeferProperties.2D02443E_ 7002_4C0B_ABC9_EAB2C064397B,,)
MSI (s) (30:D4) [13:58:19:203]: Executing op:
CustomActionRollback(Action=RollbackDeferPropertie s.2D02443E_7002_4C0B_ABC9_EAB2C064397B,ActionType= 1281,Source=BinaryData,Target=DeferProperties,)
MSI (s) (30:94) [13:58:19:203]: Invoking remote custom action. DLL:
C:\WINNT\Installer\MSI4C.tmp, Entrypoint: DeferProperties
SOFTWARE\Microsoft\Microsoft SQL Server
Setup.{E09B48B5-E141-427A-AB0C-D3605127224A}
Start custom action DeferProperties
MSI (s) (30:D4) [13:58:19:421]: Executing op:
End(Checksum=0,ProgressTotalHDWord=0,ProgressTotal LDWord=0)
MSI (s) (30:D4) [13:58:19:421]: Error in rollback skipped. Return: 5
Defer Properties returns: 0
MSI (s) (30:D4) [13:58:19:437]: Unlocking Server
MSI (s) (30:D4) [13:58:19:437]: PROPERTY CHANGE: Deleting UpdateStarted
property. Its current value is '1'.
Action ended 13:58:19: INSTALL. Return value 3.
************************************************** ************************************************** **********************
I already changed from "Not difined" to "silently succeed" as
mentionned in the MSDE 2000 Release A guide
Unsigned driver installation behavior.
Unsigned non-driver installation behavior
Extract guide
A MSDE 2000 Release A installation will fail if either of the following
security policies has been set to Do not allow installation:
* The Devices: Unsigned driver installation behavior local security
policy for Windows XP.
* The Unsigned non-driver installation behavior local security
policy for Windows 2000.
If you use the Do not allow installation setting, you must change it to
Silently succeed before installing MSDE 2000 Release A. If necessary,
you can return the policy to its previous setting after the installation
is complete.
Note Do not allow installation is not the default setting for these
security policies.
To set these policies:
1. In Control Panel, double-click Administrative Tools.
2. Double-click Local Security Policy.
3. Expand Local Policies.
4. Select Security Options.
5. Ensure that the following option in the right pane is set to
Silently Succeed before installing MSDE 2000 Release A:
* On Windows XP and Windows 2003: Devices: Unsigned driver
installation behavior.
* On Windows 2000: Unsigned non-driver installation behavior.
Still doesn't work
Kind regards
Andrea Montanari wrote:

>hi,
>Smeusje wrote:
>
>try inspecting C:\DOCUME~1\FRANCK~1\LOCALS~1\Temp\MSDE_CC_setup.l og
>for
>RETURN VALUE 3
>entries..
>about 10 lines before each entry some (sometime cryptic) description of the
>problem will be reported..
>
|||hi,
Smeusje wrote:
> I have two of them
> ************************************************** ************************************************** ********************
> MSI (s) (30!00) [13:58:12:796]: Product: Microsoft SQL Server Desktop
> Engine -- An error has occurred registering this installation of SQL
> Server Desktop Engine with MDAC.
> MSI (c) (60:90) [13:58:07:109]: Font created. Charset: Req=0, Ret=0,
> Font: Req=MS Shell Dlg, Ret=MS Shell Dlg
> An error has occurred registering this installation of SQL Server
> Desktop Engine with MDAC.
> MSI (s) (30:D4) [13:58:12:812]: User policy value 'DisableRollback'
> is 0 MSI (s) (30:D4) [13:58:12:812]: Machine policy value
> 'DisableRollback' is 0 Action ended 13:58:12: InstallFinalize. Return
> value 3.
> ************************************************** ************************************************** *******************
>...
> MSI (s) (30:D4) [13:58:19:421]: Error in rollback skipped. Return:
> 5 Defer Properties returns: 0
> MSI (s) (30:D4) [13:58:19:437]: Unlocking Server
> MSI (s) (30:D4) [13:58:19:437]: PROPERTY CHANGE: Deleting
> UpdateStarted property. Its current value is '1'.
> Action ended 13:58:19: INSTALL. Return value 3.
> ************************************************** ************************************************** **********************
the first one indicates a problem "installing" MDAC... actually it should
not as it only has to check for the correct MDAC stack... on WinXP sp2 and
Win2003 MDAC 2.8 of the service pack 4 will not be installed becouse of the
"superior" level of the installed component, perfomed only via Windows
Update...
for the 2nd one I really have no clues...
I do think all this is dependent of a embedded installation of MSDE... can
you please try downloading and executing the original setup.exe boostrapper
installer of MSDE?
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.18.0 - DbaMgr ver 0.62.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply

Installed OK but cannot logon

I just installed MSDE (got successful install msg in Log) but now cannot logon.
I get 'Connection failed SQL State 08001 Error 17
I'm using the SA userid and password I entered upon installing
I'm attempting this via Visual Studio 2003
What could the problem be?
-David
hi David,
mscertified wrote:
> I just installed MSDE (got successful install msg in Log) but now
> cannot logon. I get 'Connection failed SQL State 08001 Error 17
> I'm using the SA userid and password I entered upon installing
> I'm attempting this via Visual Studio 2003
> What could the problem be?
is this a local or remote connection?
try connecting via oSql.exe and verify the full exception you are prompted
with
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.16.0 - DbaMgr ver 0.61.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply

Installation standards

I would like to know if Microsoft publishes SQL Server standards which direct or mandate that the database Transaction Log be created on a Mirrored set. Some no-technical management people where I work are stating that placing Transaction Logs on a Mirro
red set is a Microsoft standard. I am a DBA and have worked with SQL Server since version 4.2 and all versions since and this is news to me. I understand the performance benefits of placing the Trans. Log on the Mirror BUT in our environment, the operat
ing system is also on the Mirror and we have junior level engineers managing the systems who know nothing about SQL Server. Therefore, I feel placing the Transaction Log on the Mirror in our environment would create unneccessary risks; especially since w
e are having no performance problems.
PLEASE!!! I would appreciate the response of anyone who can tell me if placing the Trans. Log on a Mirror is a Microsoft Standard or not. I have always understood Microsoft's statements regarding Mirroring the Trans. Log to be merely suggestions or reco
mmendations not a directive. I do not want upper management sold on accepting what I see as a risk by non-technical people who are stating that placing the database Transaction Log on a Mirrored set is a standard that we have to follow.
Sorry for being so lengthy but I am take my job and protecting data very seriously and this issue is making me lose sleep.
It seems like you understand the implications for this, so the short answer is: "No, this is not a
directive, only a recommendation".
One thing, though: If the part where the data is crashes in any way, you definitely want to get to
your tlog files, as it allow you to backup the log using NO_TRUNCATE. Placing the log with the data
is increased risk exposure in this regard.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"SQLDBA_723" <SQLDBA_723@.discussions.microsoft.com> wrote in message
news:7C2CD527-1514-4F9B-90E9-0E118EB2C017@.microsoft.com...
> I would like to know if Microsoft publishes SQL Server standards which direct or mandate that the
database Transaction Log be created on a Mirrored set. Some no-technical management people where I
work are stating that placing Transaction Logs on a Mirrored set is a Microsoft standard. I am a
DBA and have worked with SQL Server since version 4.2 and all versions since and this is news to me.
I understand the performance benefits of placing the Trans. Log on the Mirror BUT in our
environment, the operating system is also on the Mirror and we have junior level engineers managing
the systems who know nothing about SQL Server. Therefore, I feel placing the Transaction Log on the
Mirror in our environment would create unneccessary risks; especially since we are having no
performance problems.
> PLEASE!!! I would appreciate the response of anyone who can tell me if placing the Trans. Log on
a Mirror is a Microsoft Standard or not. I have always understood Microsoft's statements regarding
Mirroring the Trans. Log to be merely suggestions or recommendations not a directive. I do not want
upper management sold on accepting what I see as a risk by non-technical people who are stating that
placing the database Transaction Log on a Mirrored set is a standard that we have to follow.
> Sorry for being so lengthy but I am take my job and protecting data very seriously and this issue
is making me lose sleep.
|||Hi,
[vbcol=seagreen]
Iam not speaking for Microsoft here but just letting you know what
information I have with respect to your concern.Iam not aware about any such
"standard" that Microsoft, has w.r.t SQL2000 setup.All the important things
that you have to take care before SQL2000 setup like required space, MDAC
level,IE level etc are mentioned in the readme.txt file or "help" topics
that accompany the setup CD.Any performance enhancement other than those are
solely left as an exercise to the person who is installing, based on his/her
experience with the same.The PSS team reports to the SQLServer team the
various issues that customers face regularly which often result in poor
server performance, disaster recovery etc.Based on those, Microsoft
occassionally publishes whitepapers for the benefit of SQLServer admins and
users.Here are some:
'SQL Server 2000 Operations Guide'
http://www.microsoft.com/technet/pro...n/sqlops0.mspx
'High Availability Resources'
http://www.microsoft.com/sql/techinf...ailability.asp
[vbcol=seagreen]
making me lose sleep.
Not that it's any of my business, but I couldn't help asking it.What is your
role at this workplace? Based on the above statement, it seems you are a
DBA.If so, why should you let those 'junior level engineers' manage the
SQLServer systems?
Dinesh
SQL Server MVP
--
SQL Server FAQ at
http://www.tkdinesh.com
"SQLDBA_723" <SQLDBA_723@.discussions.microsoft.com> wrote in message
news:7C2CD527-1514-4F9B-90E9-0E118EB2C017@.microsoft.com...
> I would like to know if Microsoft publishes SQL Server standards which
direct or mandate that the database Transaction Log be created on a Mirrored
set. Some no-technical management people where I work are stating that
placing Transaction Logs on a Mirrored set is a Microsoft standard. I am a
DBA and have worked with SQL Server since version 4.2 and all versions since
and this is news to me. I understand the performance benefits of placing
the Trans. Log on the Mirror BUT in our environment, the operating system is
also on the Mirror and we have junior level engineers managing the systems
who know nothing about SQL Server. Therefore, I feel placing the
Transaction Log on the Mirror in our environment would create unneccessary
risks; especially since we are having no performance problems.
> PLEASE!!! I would appreciate the response of anyone who can tell me if
placing the Trans. Log on a Mirror is a Microsoft Standard or not. I have
always understood Microsoft's statements regarding Mirroring the Trans. Log
to be merely suggestions or recommendations not a directive. I do not want
upper management sold on accepting what I see as a risk by non-technical
people who are stating that placing the database Transaction Log on a
Mirrored set is a standard that we have to follow.
> Sorry for being so lengthy but I am take my job and protecting data very
seriously and this issue is making me lose sleep.
|||If I may add my 2 cents...
Microsoft does not generally give ANY directives, the world is so varied the
answer to almost any question is 'depends'...
You do not have to do any design on the database structure - There is no MS
directive, but to normalize the database is 1. A Best Practice 2. Highly
recommended
as is mirroring the transaction logs IF you need up to the minute recovery
without loss of data.
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"SQLDBA_723" <SQLDBA_723@.discussions.microsoft.com> wrote in message
news:7C2CD527-1514-4F9B-90E9-0E118EB2C017@.microsoft.com...
> I would like to know if Microsoft publishes SQL Server standards which
direct or mandate that the database Transaction Log be created on a Mirrored
set. Some no-technical management people where I work are stating that
placing Transaction Logs on a Mirrored set is a Microsoft standard. I am a
DBA and have worked with SQL Server since version 4.2 and all versions since
and this is news to me. I understand the performance benefits of placing
the Trans. Log on the Mirror BUT in our environment, the operating system is
also on the Mirror and we have junior level engineers managing the systems
who know nothing about SQL Server. Therefore, I feel placing the
Transaction Log on the Mirror in our environment would create unneccessary
risks; especially since we are having no performance problems.
> PLEASE!!! I would appreciate the response of anyone who can tell me if
placing the Trans. Log on a Mirror is a Microsoft Standard or not. I have
always understood Microsoft's statements regarding Mirroring the Trans. Log
to be merely suggestions or recommendations not a directive. I do not want
upper management sold on accepting what I see as a risk by non-technical
people who are stating that placing the database Transaction Log on a
Mirrored set is a standard that we have to follow.
> Sorry for being so lengthy but I am take my job and protecting data very
seriously and this issue is making me lose sleep.

Installation standards

I would like to know if Microsoft publishes SQL Server standards which direct or mandate that the database Transaction Log be created on a Mirrored set. Some no-technical management people where I work are stating that placing Transaction Logs on a Mirrored set is a Microsoft standard. I am a DBA and have worked with SQL Server since version 4.2 and all versions since and this is news to me. I understand the performance benefits of placing the Trans. Log on the Mirror BUT in our environment, the operating system is also on the Mirror and we have junior level engineers managing the systems who know nothing about SQL Server. Therefore, I feel placing the Transaction Log on the Mirror in our environment would create unneccessary risks; especially since we are having no performance problems.
PLEASE!!! I would appreciate the response of anyone who can tell me if placing the Trans. Log on a Mirror is a Microsoft Standard or not. I have always understood Microsoft's statements regarding Mirroring the Trans. Log to be merely suggestions or recommendations not a directive. I do not want upper management sold on accepting what I see as a risk by non-technical people who are stating that placing the database Transaction Log on a Mirrored set is a standard that we have to follow.
Sorry for being so lengthy but I am take my job and protecting data very seriously and this issue is making me lose sleep.It seems like you understand the implications for this, so the short answer is: "No, this is not a
directive, only a recommendation".
One thing, though: If the part where the data is crashes in any way, you definitely want to get to
your tlog files, as it allow you to backup the log using NO_TRUNCATE. Placing the log with the data
is increased risk exposure in this regard.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"SQLDBA_723" <SQLDBA_723@.discussions.microsoft.com> wrote in message
news:7C2CD527-1514-4F9B-90E9-0E118EB2C017@.microsoft.com...
> I would like to know if Microsoft publishes SQL Server standards which direct or mandate that the
database Transaction Log be created on a Mirrored set. Some no-technical management people where I
work are stating that placing Transaction Logs on a Mirrored set is a Microsoft standard. I am a
DBA and have worked with SQL Server since version 4.2 and all versions since and this is news to me.
I understand the performance benefits of placing the Trans. Log on the Mirror BUT in our
environment, the operating system is also on the Mirror and we have junior level engineers managing
the systems who know nothing about SQL Server. Therefore, I feel placing the Transaction Log on the
Mirror in our environment would create unneccessary risks; especially since we are having no
performance problems.
> PLEASE!!! I would appreciate the response of anyone who can tell me if placing the Trans. Log on
a Mirror is a Microsoft Standard or not. I have always understood Microsoft's statements regarding
Mirroring the Trans. Log to be merely suggestions or recommendations not a directive. I do not want
upper management sold on accepting what I see as a risk by non-technical people who are stating that
placing the database Transaction Log on a Mirrored set is a standard that we have to follow.
> Sorry for being so lengthy but I am take my job and protecting data very seriously and this issue
is making me lose sleep.|||Hi,
>>that placing Transaction Logs on a Mirrored set is a Microsoft standard.
Iam not speaking for Microsoft here but just letting you know what
information I have with respect to your concern.Iam not aware about any such
"standard" that Microsoft, has w.r.t SQL2000 setup.All the important things
that you have to take care before SQL2000 setup like required space, MDAC
level,IE level etc are mentioned in the readme.txt file or "help" topics
that accompany the setup CD.Any performance enhancement other than those are
solely left as an exercise to the person who is installing, based on his/her
experience with the same.The PSS team reports to the SQLServer team the
various issues that customers face regularly which often result in poor
server performance, disaster recovery etc.Based on those, Microsoft
occassionally publishes whitepapers for the benefit of SQLServer admins and
users.Here are some:
'SQL Server 2000 Operations Guide'
http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/sqlops0.mspx
'High Availability Resources'
http://www.microsoft.com/sql/techinfo/administration/2000/availability.asp
>> I am take my job and protecting data very seriously and this issue is
making me lose sleep.
Not that it's any of my business, but I couldn't help asking it.What is your
role at this workplace? Based on the above statement, it seems you are a
DBA.If so, why should you let those 'junior level engineers' manage the
SQLServer systems?
--
Dinesh
SQL Server MVP
--
--
SQL Server FAQ at
http://www.tkdinesh.com
"SQLDBA_723" <SQLDBA_723@.discussions.microsoft.com> wrote in message
news:7C2CD527-1514-4F9B-90E9-0E118EB2C017@.microsoft.com...
> I would like to know if Microsoft publishes SQL Server standards which
direct or mandate that the database Transaction Log be created on a Mirrored
set. Some no-technical management people where I work are stating that
placing Transaction Logs on a Mirrored set is a Microsoft standard. I am a
DBA and have worked with SQL Server since version 4.2 and all versions since
and this is news to me. I understand the performance benefits of placing
the Trans. Log on the Mirror BUT in our environment, the operating system is
also on the Mirror and we have junior level engineers managing the systems
who know nothing about SQL Server. Therefore, I feel placing the
Transaction Log on the Mirror in our environment would create unneccessary
risks; especially since we are having no performance problems.
> PLEASE!!! I would appreciate the response of anyone who can tell me if
placing the Trans. Log on a Mirror is a Microsoft Standard or not. I have
always understood Microsoft's statements regarding Mirroring the Trans. Log
to be merely suggestions or recommendations not a directive. I do not want
upper management sold on accepting what I see as a risk by non-technical
people who are stating that placing the database Transaction Log on a
Mirrored set is a standard that we have to follow.
> Sorry for being so lengthy but I am take my job and protecting data very
seriously and this issue is making me lose sleep.|||If I may add my 2 cents...
Microsoft does not generally give ANY directives, the world is so varied the
answer to almost any question is 'depends'...
You do not have to do any design on the database structure - There is no MS
directive, but to normalize the database is 1. A Best Practice 2. Highly
recommended
as is mirroring the transaction logs IF you need up to the minute recovery
without loss of data.
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"SQLDBA_723" <SQLDBA_723@.discussions.microsoft.com> wrote in message
news:7C2CD527-1514-4F9B-90E9-0E118EB2C017@.microsoft.com...
> I would like to know if Microsoft publishes SQL Server standards which
direct or mandate that the database Transaction Log be created on a Mirrored
set. Some no-technical management people where I work are stating that
placing Transaction Logs on a Mirrored set is a Microsoft standard. I am a
DBA and have worked with SQL Server since version 4.2 and all versions since
and this is news to me. I understand the performance benefits of placing
the Trans. Log on the Mirror BUT in our environment, the operating system is
also on the Mirror and we have junior level engineers managing the systems
who know nothing about SQL Server. Therefore, I feel placing the
Transaction Log on the Mirror in our environment would create unneccessary
risks; especially since we are having no performance problems.
> PLEASE!!! I would appreciate the response of anyone who can tell me if
placing the Trans. Log on a Mirror is a Microsoft Standard or not. I have
always understood Microsoft's statements regarding Mirroring the Trans. Log
to be merely suggestions or recommendations not a directive. I do not want
upper management sold on accepting what I see as a risk by non-technical
people who are stating that placing the database Transaction Log on a
Mirrored set is a standard that we have to follow.
> Sorry for being so lengthy but I am take my job and protecting data very
seriously and this issue is making me lose sleep.

Installation standards

I would like to know if Microsoft publishes SQL Server standards which direc
t or mandate that the database Transaction Log be created on a Mirrored set.
Some no-technical management people where I work are stating that placing
Transaction Logs on a Mirro
red set is a Microsoft standard. I am a DBA and have worked with SQL Server
since version 4.2 and all versions since and this is news to me. I underst
and the performance benefits of placing the Trans. Log on the Mirror BUT in
our environment, the operat
ing system is also on the Mirror and we have junior level engineers managing
the systems who know nothing about SQL Server. Therefore, I feel placing t
he Transaction Log on the Mirror in our environment would create unneccessar
y risks; especially since w
e are having no performance problems.
PLEASE!!! I would appreciate the response of anyone who can tell me if plac
ing the Trans. Log on a Mirror is a Microsoft Standard or not. I have alway
s understood Microsoft's statements regarding Mirroring the Trans. Log to be
merely suggestions or reco
mmendations not a directive. I do not want upper management sold on accepti
ng what I see as a risk by non-technical people who are stating that placing
the database Transaction Log on a Mirrored set is a standard that we have t
o follow.
Sorry for being so lengthy but I am take my job and protecting data very ser
iously and this issue is making me lose sleep.It seems like you understand the implications for this, so the short answer
is: "No, this is not a
directive, only a recommendation".
One thing, though: If the part where the data is crashes in any way, you def
initely want to get to
your tlog files, as it allow you to backup the log using NO_TRUNCATE. Placin
g the log with the data
is increased risk exposure in this regard.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"SQLDBA_723" <SQLDBA_723@.discussions.microsoft.com> wrote in message
news:7C2CD527-1514-4F9B-90E9-0E118EB2C017@.microsoft.com...
> I would like to know if Microsoft publishes SQL Server standards which direct or m
andate that the
database Transaction Log be created on a Mirrored set. Some no-technical ma
nagement people where I
work are stating that placing Transaction Logs on a Mirrored set is a Micros
oft standard. I am a
DBA and have worked with SQL Server since version 4.2 and all versions since
and this is news to me.
I understand the performance benefits of placing the Trans. Log on the Mirro
r BUT in our
environment, the operating system is also on the Mirror and we have junior l
evel engineers managing
the systems who know nothing about SQL Server. Therefore, I feel placing th
e Transaction Log on the
Mirror in our environment would create unneccessary risks; especially since
we are having no
performance problems.
> PLEASE!!! I would appreciate the response of anyone who can tell me if placing th
e Trans. Log on
a Mirror is a Microsoft Standard or not. I have always understood Microsoft
's statements regarding
Mirroring the Trans. Log to be merely suggestions or recommendations not a d
irective. I do not want
upper management sold on accepting what I see as a risk by non-technical peo
ple who are stating that
placing the database Transaction Log on a Mirrored set is a standard that we have to follow.

> Sorry for being so lengthy but I am take my job and protecting data very seriously
and this issue
is making me lose sleep.|||Hi,

Iam not speaking for Microsoft here but just letting you know what
information I have with respect to your concern.Iam not aware about any such
"standard" that Microsoft, has w.r.t SQL2000 setup.All the important things
that you have to take care before SQL2000 setup like required space, MDAC
level,IE level etc are mentioned in the readme.txt file or "help" topics
that accompany the setup CD.Any performance enhancement other than those are
solely left as an exercise to the person who is installing, based on his/her
experience with the same.The PSS team reports to the SQLServer team the
various issues that customers face regularly which often result in poor
server performance, disaster recovery etc.Based on those, Microsoft
occassionally publishes whitepapers for the benefit of SQLServer admins and
users.Here are some:
'SQL Server 2000 Operations Guide'
http://www.microsoft.com/technet/pr...in/sqlops0.mspx
'High Availability Resources'
http://www.microsoft.com/sql/techin...vailability.asp
[vbcol=seagreen]
making me lose sleep.
Not that it's any of my business, but I couldn't help asking it.What is your
role at this workplace? Based on the above statement, it seems you are a
DBA.If so, why should you let those 'junior level engineers' manage the
SQLServer systems?
Dinesh
SQL Server MVP
--
--
SQL Server FAQ at
http://www.tkdinesh.com
"SQLDBA_723" <SQLDBA_723@.discussions.microsoft.com> wrote in message
news:7C2CD527-1514-4F9B-90E9-0E118EB2C017@.microsoft.com...[vbcol=seagreen]
> I would like to know if Microsoft publishes SQL Server standards which
direct or mandate that the database Transaction Log be created on a Mirrored
set. Some no-technical management people where I work are stating that
placing Transaction Logs on a Mirrored set is a Microsoft standard. I am a
DBA and have worked with SQL Server since version 4.2 and all versions since
and this is news to me. I understand the performance benefits of placing
the Trans. Log on the Mirror BUT in our environment, the operating system is
also on the Mirror and we have junior level engineers managing the systems
who know nothing about SQL Server. Therefore, I feel placing the
Transaction Log on the Mirror in our environment would create unneccessary
risks; especially since we are having no performance problems.
> PLEASE!!! I would appreciate the response of anyone who can tell me if
placing the Trans. Log on a Mirror is a Microsoft Standard or not. I have
always understood Microsoft's statements regarding Mirroring the Trans. Log
to be merely suggestions or recommendations not a directive. I do not want
upper management sold on accepting what I see as a risk by non-technical
people who are stating that placing the database Transaction Log on a
Mirrored set is a standard that we have to follow.
> Sorry for being so lengthy but I am take my job and protecting data very
seriously and this issue is making me lose sleep.|||If I may add my 2 cents...
Microsoft does not generally give ANY directives, the world is so varied the
answer to almost any question is 'depends'...
You do not have to do any design on the database structure - There is no MS
directive, but to normalize the database is 1. A Best Practice 2. Highly
recommended
as is mirroring the transaction logs IF you need up to the minute recovery
without loss of data.
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"SQLDBA_723" <SQLDBA_723@.discussions.microsoft.com> wrote in message
news:7C2CD527-1514-4F9B-90E9-0E118EB2C017@.microsoft.com...
> I would like to know if Microsoft publishes SQL Server standards which
direct or mandate that the database Transaction Log be created on a Mirrored
set. Some no-technical management people where I work are stating that
placing Transaction Logs on a Mirrored set is a Microsoft standard. I am a
DBA and have worked with SQL Server since version 4.2 and all versions since
and this is news to me. I understand the performance benefits of placing
the Trans. Log on the Mirror BUT in our environment, the operating system is
also on the Mirror and we have junior level engineers managing the systems
who know nothing about SQL Server. Therefore, I feel placing the
Transaction Log on the Mirror in our environment would create unneccessary
risks; especially since we are having no performance problems.
> PLEASE!!! I would appreciate the response of anyone who can tell me if
placing the Trans. Log on a Mirror is a Microsoft Standard or not. I have
always understood Microsoft's statements regarding Mirroring the Trans. Log
to be merely suggestions or recommendations not a directive. I do not want
upper management sold on accepting what I see as a risk by non-technical
people who are stating that placing the database Transaction Log on a
Mirrored set is a standard that we have to follow.
> Sorry for being so lengthy but I am take my job and protecting data very
seriously and this issue is making me lose sleep.

Installation SQL-Cluster failed

Hi,
we are trying to install "SQL-Server Version 8.00.780 SP3" on a Win2003
2-node Cluster. The Installation breaks, and in the sqlstp.log we find the
Message "remsetup.exe not find". In the Knowledge Base we find problems with
Terminal Service (no TS installed) and with special character in connection
names (the names are public and private). We have log in as a domain admin
and the sql engine and the agent are started with a domain admin.
1.copyexe=cnvsvc1.exe
08:28:41 Setup is performing required operations on cluster nodes. This may
take a few minutes...
08:28:41 C:\WINDOWS\TEMP\SqlSetup\Bin\remsetup.exe C:\WINDOWS\remsetup.ini
08:30:14 Process Exit Code: (2) The system cannot find the file specified.
08:30:14 Begin Action : GetRemsetupRetCode
08:30:14 Installation return status on OBELIX : 2
08:30:14 End Action : GetRemsetupRetCode
#### SQL Server Remote Setup - Start Time 05/14/04 08:28:41 ####
CThreadPool::RunUntilCompleteHlpr create thread, index=0
CThread::Run thread [0x74] created for execution.
CThread::Process [0x74]
CThreadPool::RunUntilCompleteHlpr start thread [0x74],index=0
Script file copied to '\\OBELIX\ADMIN$\OBELIX_MSSQLSERVER.iss' successfully.
Installing remote service (OBELIX)...
Running '\\ASTERIX\Z$\x86\setup\setupsql.exe k=ClSec k=Rm k=Cl -SMS -s -f
"\\ASTERIX\Z$\x86\setup\setup.ins" -f1
\\OBELIX\ADMIN$\OBELIX_MSSQLSERVER.iss -f2 "\\OBELIX\admin$\setup.log" -e
"stpsilnt._ex" -x "C:\"' (OBELIX) ...
CRemoteProcess::RunUntilComplete [0x74] exit code: 2
Remote process exit code was '2' (OBELIX).
CThreadPool::RunUntilCompleteHlpr WaitForMultipleObjects returned: 0
CThreadPool::RunUntilCompleteHlpr signaled thread [0x74]
Thread [0x74] exit code: [0x2]
CThreadPool::RunUntilComplete returned 2
CThreadPool::RunUntilComplete execution level=1, need execution: 0
One or more errors occurred while running the remote/unattended setups.
Disconnecting from remote machine (OBELIX)...
Service removed successfully.
Remote files removed successfully.
#### SQL Server Remote Setup - Stop Time 05/14/04 08:30:14 ####
08:30:14 End Action : Run setup on cluster nodes
08:30:14 One or more errors occurred while running remote setup on the
clustered machines.
08:30:28 Setup failed to perform required operations on the cluster nodes.
08:30:28 Begin Action : ClusterErrorCleanup
08:30:28 End Action : ClusterErrorCleanup
08:30:28 End Action : ClusterSetupHelper
Thank you for help.
Sound to me like your MS cluster isn't installed correctly.
Have you carried out the tests suggested in the Cluster checklist?
If you are happy with the installation try copying the remsetup.ini file from the user dir as mentioned in KB301520.
|||Try these steps to see if you can resolve the problem:
1) Check and see if the machine is configured to disallow 8.3 name creation
by
checking the following registry key:
HKLM\SYSTEM\CURRENTCONTROLSET\CONTROL\FileSystem\N tfsDisable8dot3NameCreatio
n
A value of 1 means this is disabled and hence change it back to 0. This
requires a
reboot for it to take effect
OR
2) Change the TEMP and TMP User Environment Variables to a path that does
not have
spaces in them. For example: c:\temp. Use the SET command to verify the new
TEMP
location is in effect. This does not require a reboot
Rand
This posting is provided "as is" with no warranties and confers no rights.

installation of msde

while i am trying to install msde i am getting error that server setup can not completed for more information check server log

how should i solve this problem

please help me

While installing Sql server if the setup fails to complete, you need to first view the setup log for any errors and post it........it will be available somewhere in C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG for sql 2005 but for msde it should be there in C:\Program Files\Microsoft SQL Server\80\Setup Bootstrap\LOG i guess .......just search it you'll get as i am not sure about the path

|||

Hello ! Mr. Deepak thanks for this help sir

installation of msde

while i am trying to install msde i am getting error that server setup can not completed for more information check server log

how should i solve this problem

please help me

While installing Sql server if the setup fails to complete, you need to first view the setup log for any errors and post it........it will be available somewhere in C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG for sql 2005 but for msde it should be there in C:\Program Files\Microsoft SQL Server\80\Setup Bootstrap\LOG i guess .......just search it you'll get as i am not sure about the path

|||

Hello ! Mr. Deepak thanks for this help sir

Installation Error

Hello. I'm trying to install SQL Server but it keeps failing. The following is from the error log. Is this the right forum? Any ideas if it is?

Microsoft SQL Server 2005 Setup beginning at Sun Dec 17 18:05:22 2006
Process ID : 3660
x:\706d62209a9eb39c63\setup.exe Version: 2005.90.1399.0
Running: LoadResourcesAction at: 2006/11/17 18:5:22
Complete: LoadResourcesAction at: 2006/11/17 18:5:22, returned true
Running: ParseBootstrapOptionsAction at: 2006/11/17 18:5:22
Loaded DLL:x:\706d62209a9eb39c63\xmlrw.dll Version:2.0.3604.0
Complete: ParseBootstrapOptionsAction at: 2006/11/17 18:5:22, returned false
Error: Action "ParseBootstrapOptionsAction" failed during execution. Error information reported during run:
Could not parse command line due to datastore exception.
Source File Name: utillib\persisthelpers.cpp
Compiler Timestamp: Fri Jul 29 01:13:55 2005
Function Name: writeEncryptedString
Source Line Number: 124
-
writeEncryptedString() failed
Source File Name: utillib\persisthelpers.cpp
Compiler Timestamp: Fri Jul 29 01:13:55 2005
Function Name: writeEncryptedString
Source Line Number: 123
-
Error Code: 0x80070002 (2)
Windows Error Text: The system cannot find the file specified.

Source File Name: cryptohelper\cryptsameusersamemachine.cpp
Compiler Timestamp: Mon Jun 13 14:30:00 2005
Function Name: sqls::CryptSameUserSameMachine::ProtectData
Source Line Number: 50

2
Could not skip Component update due to datastore exception.
Source File Name: datastore\cachedpropertycollection.cpp
Compiler Timestamp: Fri Jul 29 01:13:49 2005
Function Name: CachedPropertyCollection::findProperty
Source Line Number: 130
-
Failed to find property "InstallMediaPath" {"SetupBootstrapOptionsScope", "", "3660"} in cache
Source File Name: datastore\propertycollection.cpp
Compiler Timestamp: Fri Jul 29 01:13:50 2005
Function Name: SetupBootstrapOptionsScope.InstallMediaPath
Source Line Number: 44
-
No collector registered for scope: "SetupBootstrapOptionsScope"
Running: ValidateWinNTAction at: 2006/11/17 18:5:22
Complete: ValidateWinNTAction at: 2006/11/17 18:5:22, returned true
Running: ValidateMinOSAction at: 2006/11/17 18:5:22
Complete: ValidateMinOSAction at: 2006/11/17 18:5:22, returned true
Running: PerformSCCAction at: 2006/11/17 18:5:22
Complete: PerformSCCAction at: 2006/11/17 18:5:22, returned true
Running: ActivateLoggingAction at: 2006/11/17 18:5:22
Error: Action "ActivateLoggingAction" threw an exception during execution. Error information reported during run:
Datastore exception while trying to write logging properties.
Source File Name: datastore\cachedpropertycollection.cpp
Compiler Timestamp: Fri Jul 29 01:13:49 2005
Function Name: CachedPropertyCollection::findProperty
Source Line Number: 130
-
Failed to find property "primaryLogFiles" {"SetupStateScope", "", ""} in cache
Source File Name: datastore\propertycollection.cpp
Compiler Timestamp: Fri Jul 29 01:13:50 2005
Function Name: SetupStateScope.primaryLogFiles
Source Line Number: 44
-
No collector registered for scope: "SetupStateScope"
00DBCFC4Unable to proceed with setup, there was a command line parsing error. : 2
Error Code: 0x80070002 (2)
Windows Error Text: The system cannot find the file specified.

Source File Name: datastore\propertycollection.cpp
Compiler Timestamp: Fri Jul 29 01:13:50 2005
Function Name: SetupBootstrapOptionsScope.InstallMediaPath
Source Line Number: 44

Class not registered.
Failed to create CAB file due to datastore exception
Source File Name: datastore\cachedpropertycollection.cpp
Compiler Timestamp: Fri Jul 29 01:13:49 2005
Function Name: CachedPropertyCollection::findProperty
Source Line Number: 130
-
Failed to find property "HostSetup" {"SetupBootstrapOptionsScope", "", "3660"} in cache
Source File Name: datastore\propertycollection.cpp
Compiler Timestamp: Fri Jul 29 01:13:50 2005
Function Name: SetupBootstrapOptionsScope.HostSetup
Source Line Number: 44
-
No collector registered for scope: "SetupBootstrapOptionsScope"
Message pump returning: 2This thread appeared to have the same results and was fixed with the registry suggestion. Can you take a look at this post to see if your box is in the same state?

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

Thanks,
Sam Lester (MSFT)