Inserting Null Value: installing

Showing posts with label installing. Show all posts

Friday, March 30, 2012

Install Security

Reguarding best practices: when I am installing s SQL
Server Database, best practice would say that I do not use
the Domain Admin or the BUILTIN Admin account to run the
database under. If I cannot use these accounts, what do I
use? My network has Active Directory installed and we are
running on Win2000 servers."Rich" <anonymous@.discussions.microsoft.com> wrote in message
news:8b5201c3e9a2$dbf005a0$a401280a@.phx.gbl...

quote:

> Reguarding best practices: when I am installing s SQL
> Server Database, best practice would say that I do not use
> the Domain Admin or the BUILTIN Admin account to run the
> database under. If I cannot use these accounts, what do I
> use? My network has Active Directory installed and we are
> running on Win2000 servers.

For fairly high level of security you can use a domain account with user
level domain permissions, on the server grant the permissions (user rights,
registry & NTFS permissions) found in this document:
http://support.microsoft.com/defaul...1&Product=sql2k
Stevesql

Install Second Node

How would I go about installing the second node for SQL 2000 cluster? The
first node is up and running.
Think I go it. Thanks-
"Gabe Matteson" <gmatteson.rounder.com.nospam> wrote in message
news:uNZKUQMtHHA.2124@.TK2MSFTNGP02.phx.gbl...
> How would I go about installing the second node for SQL 2000 cluster? The
> first node is up and running.
>
|||Whats the answer ? You cant do this live, can you ?
"Gabe Matteson" <gmatteson.rounder.com.nospam> wrote in message
news:uAIXXWMtHHA.1208@.TK2MSFTNGP05.phx.gbl...
> Think I go it. Thanks-
> "Gabe Matteson" <gmatteson.rounder.com.nospam> wrote in message
> news:uNZKUQMtHHA.2124@.TK2MSFTNGP02.phx.gbl...
>

Wednesday, March 28, 2012

Install Problem Error 29503 & 1067 OR Error 29503 & 2146885628

I'm new with development and just wanted to get the Personal Website Sample to work. So far, I'm have am having a terrible time installing SQL Express Edition. I'm not exactly sure what to do next. I have installed, manually uninstalled, and reinstalled many times. Sometimes I get error 29503 & 1067. Other times when I reinstall I get 29503 & -2146885628 . Here's the info I got so far for my 29503&1067 since that error occurs 95% of time. I believe I got the -2146885628 error when I changed a setting from network to local services.

I feel so confused right now. Any help would be appreciative.

From the Summary Log:

Code Snippet

Machine : DELL1

Product : SQL Server Database Services
Error : The SQL Server service failed to start. For more information, see the SQL Server Books Online topics, "How to: View SQL Server 2005 Setup Log Files" and "Starting SQL Server Manually."
--
Machine : DELL1
Product : Microsoft SQL Server 2005
Product Version : 9.2.3042.00
Install : Failed
Log File : c:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0018_DELL1_SQL.log
Last Action : InstallFinalize
Error String : The SQL Server service failed to start. For more information, see the SQL Server Books Online topics, "How to: View SQL Server 2005 Setup Log Files" and "Starting SQL Server Manually."
The error is (1067) The process terminated unexpectedly.
Error Number : 29503
--

From there, I searched the error logs to find this in the SQL.log

Code Snippet

- Context --

Setting status of unmanaged components and removing unmanaged resources

Do_sqlScript

SqlScriptHlpr

Start service MSSQL$SQLEXPRESS

Error Code: 1067

MSI (s) (84!D4) [01:48:10:750]: Product: Microsoft SQL Server 2005 -- Error 29503. The SQL Server service failed to start. For more information, see the SQL Server Books Online topics, "How to: View SQL Server 2005 Setup Log Files" and "Starting SQL Server Manually."

The error is (1067) The process terminated unexpectedly.

Error 29503. The SQL Server service failed to start. For more information, see the SQL Server Books Online topics, "How to: View SQL Server 2005 Setup Log Files" and "Starting SQL Server Manually."

The error is (1067) The process terminated unexpectedly.

Doing Action: Do_sqlScript

PerfTime Start: Do_sqlScript : Tue Aug 28 01:48:10 2007

Service MSSQL$SQLEXPRESS with parameters '-m SqlSetup -Q -qJapanese_CI_AS -T4022 -T3659 -T3610 -T4010' is being started at Tue Aug 28 01:48:10 2007

Service failed unexpectedly (1067)

Error Code: 0x8007042b (1067)

Windows Error Text: The process terminated unexpectedly.

Source File Name: sqlsetuplib\service.cpp

Compiler Timestamp: Wed Jun 14 16:29:04 2006

Function Name: sqls::Service::Start

Source Line Number: 301

- Context --

Setting status of unmanaged components and removing unmanaged resources

Do_sqlScript

SqlScriptHlpr

Start service MSSQL$SQLEXPRESS

Do_sqlScript

SqlScriptHlpr

Start service MSSQL$SQLEXPRESS

Error Code: 1067

MSI (s) (84!D4) [01:48:13:968]: Product: Microsoft SQL Server 2005 -- Error 29503. The SQL Server service failed to start. For more information, see the SQL Server Books Online topics, "How to: View SQL Server 2005 Setup Log Files" and "Starting SQL Server Manually."

The error is (1067) The process terminated unexpectedly.

Error 29503. The SQL Server service failed to start. For more information, see the SQL Server Books Online topics, "How to: View SQL Server 2005 Setup Log Files" and "Starting SQL Server Manually."

The error is (1067) The process terminated unexpectedly.

MSI (s) (84:10) [01:48:14:109]: User policy value 'DisableRollback' is 0

MSI (s) (84:10) [01:48:14:109]: Machine policy value 'DisableRollback' is 0

Action ended 1:48:14: InstallFinalize. Return value 3.

MSI (s) (84:10) [01:48:14:171]: Executing op: Header(Signature=1397708873,Version=301,Timestamp=924585293,LangId=1033,Platform=0,ScriptType=2,ScriptMajorVersion=21,ScriptMinorVersion=4,ScriptAttributes=1)

MSI (s) (84:10) [01:48:14:171]: Executing op: DialogInfo(Type=0,Argument=1033)

MSI (s) (84:10) [01:48:14:171]: Executing op: DialogInfo(Type=1,Argument=Microsoft SQL Server 2005)

MSI (s) (84:10) [01:48:14:171]: Executing op: RollbackInfo(,RollbackAction=Rollback,RollbackDescription=Rolling back action:,RollbackTemplate=[1],CleanupAction=RollbackCleanup,CleanupDescription=Removing backup files,CleanupTemplate=File: [1])

MSI (s) (84:10) [01:48:14:171]: Executing op: ActionStart(Name=Do_sqlScript.D20239D7_E87C_40C9_9837_E70B8D4882C2,Description=Configuring Microsoft SQL Server,Template=Starting SQL Service: [1])

MSI (s) (84:10) [01:48:14:171]: Executing op: ProductInfo(ProductKey={B0F9497C-52B4-4686-8E73-74D866BBDF59},ProductName=Microsoft SQL Server 2005,PackageName=sqlrun_sql.msi,Language=1033,Version=151129058,Assignment=1,ObsoleteArg=0,ProductIcon=ARPIcon.ico,PackageMediaPath=\Setup\,PackageCode={08AD0897-0300-4F7D-A3CC-A0CCEDD42E0D},,,InstanceType=1,LUASetting=0,RemoteURTInstalls=0)

MSI (s) (84:10) [01:48:14:171]: Executing op: ActionStart(Name=Rollback_sqlScript.D20239D7_E87C_40C9_9837_E70B8D4882C2,Description=Configuring Microsoft SQL Server,Template=Stopping SQL Service: [1])

MSI (s) (84:10) [01:48:14:171]: Executing op: CustomActionRollback(Action=Rollback_sqlScript.D20239D7_E87C_40C9_9837_E70B8D4882C2,ActionType=1345,Source=BinaryData,Target=Rollback_sqlScript,CustomActionData=100Configuring Microsoft SQL Server81062400lpc:DELL1\SQLEXPRESS)

MSI (s) (84:B4) [01:48:14:171]: Invoking remote custom action. DLL: C:\WINDOWS\Installer\MSI571.tmp, Entrypoint: Rollback_sqlScript

Function=Rollback_sqlScript

Doing Action: Rollback_sqlScript

This log does get kind of big, so if you need more information, please feel free to ask

The first link is a cleaned up version of the Personal Starter Kit and the second link is where he can answer your questions. The third link is tutorials for many starter kits. Hope this helps.

http://www.jeremywadsworth.com/

http://forums.asp.net/1003.aspx

http://msdn2.microsoft.com/en-us/library/aa530759.aspx

|||Will I ever need to install SQL EE (right now I'm SQL less)? This error looks really big and I'm not sure exactly how to solve it.
|||

EDIT

I don't see how you plan to run an application that needs SQL Server database without running Express. Express Advanced that is almost like the full edition is free. If you plan to develop you can download the Advanced below.

http://msdn2.microsoft.com/en-us/express/bb410792.aspx

|||Still waiting around for an answer to my install errors. I did install mySQL in about 15mins vs 3 full days and counting for SQL Server EE. It's pretty nice...but besides that, still wondering if anyone knows about these SQL EE Errors?
|||

You cannot install MySQL and expect to run software created to use SQL Server Here is the thing I have installed the kit without problem a whileback and you are having problem so read those tutorials in my recent post the two for this kit and post in the forum I gave to you.

|||I am very very confused now.

I can't install SQL Server Express Edition because I get errors 29503 & -2146885628 during the install process. Thus, SQL Server Express is not installed in my computer.

The links you gave me are troubleshooting tips for the Personal WebKit. Since you gave it too me, I thought I could run it without SQL Server Express Edition but your reply to that makes it sound like I need SQL Server Express Edition which I cannot install due to the errors above. I already install, manually uninstall, etc etc etc. As far as I can tell, during my install process, SQL Server Express Edition just installs maybe 80% of what it should be installing because my summary log says this:

I am assumming because my summary log says "Failed" in the install section, that SQL Server failed to install. I may be wrong and this may be a bug in the summary log.

I am very very confused now. Do I or do I not need to install SQL Server Express Edition first?
|||SQL Server 2005 is the easiest SQL Server to install I have installed 7.0, 2000 and now 2005 on all exist operating systems except Vista, that means server included. Now if you are running XP it comes with System Restore roll your Operating System back by one month if you have restore point that far back. You cannot install this starter kit without SQL Server because I have not seen MySQL versions of it. The link I gave you is where errors for this kit are resolved and you are right your current problem is SQL Server installation so now go roll back the Operating System and try the install again. Now go do some work and post again.|||

I did a search and found a number of possible causes of this error, but the log segment you provided does not provide enough information to really tell what the issue is. For starters, check out the KB article at http://support.microsoft.com/default.aspx?scid=kb%3Ben-us%3B920114 and see if this applies to your situation.

If that doesn't work, search the log for "ue 3" to find any lines that contain 'Return Value 3' indicating a failure. The several lines above the return value should give you a more specific message about what actually failed to cause the error you're seeing. If that information doesn't point you in an obvious direction, post that snippet to the forum and we can take a look at it.

Mike

sql

Install Problem Error 29503 & 1067 OR Error 29503 & 2146885628

I feel so confused right now. Any help would be appreciative.

From the Summary Log:

Code Snippet

Machine : DELL1

From there, I searched the error logs to find this in the SQL.log

Code Snippet

- Context --

Setting status of unmanaged components and removing unmanaged resources

Do_sqlScript

SqlScriptHlpr

Start service MSSQL$SQLEXPRESS

Error Code: 1067

The error is (1067) The process terminated unexpectedly.

Error 29503. The SQL Server service failed to start. For more information, see the SQL Server Books Online topics, "How to: View SQL Server 2005 Setup Log Files" and "Starting SQL Server Manually."

The error is (1067) The process terminated unexpectedly.

Doing Action: Do_sqlScript

PerfTime Start: Do_sqlScript : Tue Aug 28 01:48:10 2007

Service MSSQL$SQLEXPRESS with parameters '-m SqlSetup -Q -qJapanese_CI_AS -T4022 -T3659 -T3610 -T4010' is being started at Tue Aug 28 01:48:10 2007

Service failed unexpectedly (1067)

Error Code: 0x8007042b (1067)

Windows Error Text: The process terminated unexpectedly.

Source File Name: sqlsetuplib\service.cpp

Compiler Timestamp: Wed Jun 14 16:29:04 2006

Function Name: sqls::Service::Start

Source Line Number: 301

- Context --

Setting status of unmanaged components and removing unmanaged resources

Do_sqlScript

SqlScriptHlpr

Start service MSSQL$SQLEXPRESS

Do_sqlScript

SqlScriptHlpr

Start service MSSQL$SQLEXPRESS

Error Code: 1067

The error is (1067) The process terminated unexpectedly.

Error 29503. The SQL Server service failed to start. For more information, see the SQL Server Books Online topics, "How to: View SQL Server 2005 Setup Log Files" and "Starting SQL Server Manually."

The error is (1067) The process terminated unexpectedly.

MSI (s) (84:10) [01:48:14:109]: User policy value 'DisableRollback' is 0

MSI (s) (84:10) [01:48:14:109]: Machine policy value 'DisableRollback' is 0

Action ended 1:48:14: InstallFinalize. Return value 3.

MSI (s) (84:10) [01:48:14:171]: Executing op: DialogInfo(Type=0,Argument=1033)

MSI (s) (84:10) [01:48:14:171]: Executing op: DialogInfo(Type=1,Argument=Microsoft SQL Server 2005)

MSI (s) (84:10) [01:48:14:171]: Executing op: ActionStart(Name=Do_sqlScript.D20239D7_E87C_40C9_9837_E70B8D4882C2,Description=Configuring Microsoft SQL Server,Template=Starting SQL Service: [1])

MSI (s) (84:10) [01:48:14:171]: Executing op: ActionStart(Name=Rollback_sqlScript.D20239D7_E87C_40C9_9837_E70B8D4882C2,Description=Configuring Microsoft SQL Server,Template=Stopping SQL Service: [1])

MSI (s) (84:B4) [01:48:14:171]: Invoking remote custom action. DLL: C:\WINDOWS\Installer\MSI571.tmp, Entrypoint: Rollback_sqlScript

Function=Rollback_sqlScript

Doing Action: Rollback_sqlScript

This log does get kind of big, so if you need more information, please feel free to ask

The first link is a cleaned up version of the Personal Starter Kit and the second link is where he can answer your questions. The third link is tutorials for many starter kits. Hope this helps.

http://www.jeremywadsworth.com/

http://forums.asp.net/1003.aspx

http://msdn2.microsoft.com/en-us/library/aa530759.aspx

|||Will I ever need to install SQL EE (right now I'm SQL less)? This error looks really big and I'm not sure exactly how to solve it.
|||

EDIT

http://msdn2.microsoft.com/en-us/express/bb410792.aspx

|||I am very very confused now.

I can't install SQL Server Express Edition because I get errors 29503 & -2146885628 during the install process. Thus, SQL Server Express is not installed in my computer.

I am assumming because my summary log says "Failed" in the install section, that SQL Server failed to install. I may be wrong and this may be a bug in the summary log.

Mike

Install problem

I am having a problem installing SQL express. I have 2.0 framework installed as well as the other express software. I also have Visual Studio 2003 installed. Do I need to uninstall other version of Visual Studio? Do I need to uninstall other versions of SQL. I get an error but it does not tell me what the problem is.

Thank you

Dee

Also can we somehow add the icons for the install to our desktop, if so how?

Dee

|||Take a look at the following file: C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Summary.txt. It should have information regarding the failure with a pointer to the full log file. When you find the full error log file you'll want to open it and search for "Value 3" (I know not very intuitive but that's the way Windows Installer logs errors). Take a look at a few lines above and below the line with "Value 3". If you don't understand what it's telling you go ahead and post the error back here.|||I'm not clear on what you're asking. Do you want to save the installation package to your desktop?|||No, the exec to start the program, but someone answered that for me. Thank you|||

I took a look at the Suumary.txt file and do not understand where there is a problem.

Microsoft SQL Server 2005 9.00.2047.00 ============================== OS Version : Microsoft Windows XP Professional Service Pack 2 (Build 2600) Time : Wed Aug 16 07:22:32 2006 MARK : SQL Server 2005 Setup has detected incompatible components from beta versions of Visual Studio, .NET Framework, or SQL Server 2005. Use Add or Remove Programs to remove these components, and then run SQL Server 2005 Setup again. For detailed instructions on uninstalling SQL Server 2005, see the SQL Server 2005 Readme. SQL Server Setup failed. For more information, review the Setup log file in %ProgramFiles%\Microsoft SQL Server\90\Setup Bootstrap\LOG\Summary.txt. Time : Wed Aug 16 07:24:02 2006 List of log files: C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0026_MARK_Core.log C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0026_MARK_Datastore.xml C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Summary.txt

|||

this is from the core file

Microsoft SQL Server 2005 Setup beginning at Wed Aug 16 18:14:14 2006 Process ID : 4668 c:\8c27e35b5d509dc8609c33e266\setup.exe Version: 2005.90.2047.0 Running: LoadResourcesAction at: 2006/7/16 18:14:13 Complete: LoadResourcesAction at: 2006/7/16 18:14:13, returned true Running: ParseBootstrapOptionsAction at: 2006/7/16 18:14:14 Loaded DLL:c:\8c27e35b5d509dc8609c33e266\xmlrw.dll Version:2.0.3609.0 Complete: ParseBootstrapOptionsAction at: 2006/7/16 18:14:14, returned true Running: ValidateWinNTAction at: 2006/7/16 18:14:14 Complete: ValidateWinNTAction at: 2006/7/16 18:14:14, returned true Running: ValidateMinOSAction at: 2006/7/16 18:14:14 Complete: ValidateMinOSAction at: 2006/7/16 18:14:14, returned true Running: PerformSCCAction at: 2006/7/16 18:14:14 Complete: PerformSCCAction at: 2006/7/16 18:14:14, returned true Running: ActivateLoggingAction at: 2006/7/16 18:14:14 Complete: ActivateLoggingAction at: 2006/7/16 18:14:14, returned true Delay load of action "DetectPatchedBootstrapAction" returned nothing. No action will occur as a result. Action "LaunchPatchedBootstrapAction" will be skipped due to the following restrictions: Condition "EventCondition: __STP_LaunchPatchedBootstrap__4668" returned false. Running: PerformSCCAction2 at: 2006/7/16 18:14:14 Loaded DLL:C:\WINDOWS\system32\msi.dll Version:3.1.4000.2435 Product "{2750B389-A2D2-4953-99CA-27C1F2A8E6FD}" versioned 9.00.0981 is not compatible with current builds of SQL Server.Expected at least version: 9.00.1399.00 The Product Name is "Microsoft SQL Server 2005 Tools Express Edition Beta 3" Loaded DLL:C:\WINDOWS\system32\msi.dll Version:3.1.4000.2435 Error: Action "PerformSCCAction2" threw an exception during execution. Return Code: 70032 Message displayed to user SQL Server 2005 Setup has detected incompatible components from beta versions of Visual Studio, .NET Framework, or SQL Server 2005. Use Add or Remove Programs to remove these components, and then run SQL Server 2005 Setup again. For detailed instructions on uninstalling SQL Server 2005, see the SQL Server 2005 Readme. Class not registered. Delay load of action "UploadDrWatsonLogAction" returned nothing. No action will occur as a result.

|||I posted a reponse to this in your other posting. See: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=643847&SiteID=1|||It is not in the add and remove programs. I did what was told and stopped all processes of SQL, I had SQL 2000 running, now I am getting: The setup has encounted an unexpected error in datastore. The action is Write_CommitFlag. The error is Unable to write property into cache: "flagCommit" XmRW Error: Failure loading xmlw.dll CheckAllProcedures[] return 2

|||

I am still having problems. No one else has answered this post and I can not install sql express because of this. I am trying to take courses and learn .net that this is holding me up.

See above posing and please help.

|||Try posting to http://forums.microsoft.com/MSDN/ShowForum.aspx?ForumID=95&SiteID=1. Fols from the setup team monitor that forum but don't always monitor the other forums.|||

Thank you Dan, I have posted there.

Dee

|||Here's the linked post for historical purposes:

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

Thanks,
Sam

Install of SQL 2005

If a server is going to be used for just SQL database access - locally on the
WAN - is there any need for IIS?
Does installing reporting services and IIS degrade the machine.
I've got a client whose DBA is debating these issues with the tech who
installed OS and SQL...
DBA wants bare-bones SQL install - thinking of installing IIS/Reporting
Services on another server later if it's ever needed.
Recommendations and opinions would be appreciated.
Best practice would usually dictate that IIS / SSRS are employed on another
machine. However, just like whether you should buy an SL55 AMG or a Toyota
Corolla, it depends...
A
"Steve Z" <SteveZ@.discussions.microsoft.com> wrote in message
news:9FF616F6-89A7-4B3C-B78E-566D976B25AF@.microsoft.com...
> If a server is going to be used for just SQL database access - locally on
> the
> WAN - is there any need for IIS?
> Does installing reporting services and IIS degrade the machine.
> I've got a client whose DBA is debating these issues with the tech who
> installed OS and SQL...
> DBA wants bare-bones SQL install - thinking of installing IIS/Reporting
> Services on another server later if it's ever needed.
> Recommendations and opinions would be appreciated.
|||I agree. I would install bare essentials now, and add IIS/RS if/when needed.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Aaron Bertrand [SQL Server MVP]" <ten.xoc@.dnartreb.noraa> wrote in message
news:eOtb68zxHHA.4352@.TK2MSFTNGP05.phx.gbl...
> Best practice would usually dictate that IIS / SSRS are employed on another machine. However,
> just like whether you should buy an SL55 AMG or a Toyota Corolla, it depends...
> A
>
>
> "Steve Z" <SteveZ@.discussions.microsoft.com> wrote in message
> news:9FF616F6-89A7-4B3C-B78E-566D976B25AF@.microsoft.com...
>
|||On Jul 15, 4:30 pm, Steve Z <Ste...@.discussions.microsoft.com> wrote:
> If a server is going to be used for just SQL database access - locally on the
> WAN - is there any need for IIS?
> Does installing reporting services and IIS degrade the machine.
> I've got a client whose DBA is debating these issues with the tech who
> installed OS and SQL...
> DBA wants bare-bones SQL install - thinking of installing IIS/Reporting
> Services on another server later if it's ever needed.
> Recommendations and opinions would be appreciated.
As already echoed in the thread, start with your minimal footprint and
add as necessary. Reporting Services is pretty easy to get up and
running when need be. Just get your specifications and go from there.
|||Is there a reason to use a named instance?
Is there a reason to not use a named instance?
This will be a large enterprise server - over 1000 users - around 20 or so
buildings across town.
Opinions?
|||No and no. A named instance isn't different from a default instance except for how you access it
from a client (like only machinename or machinename\instancename). So do what feels natural for you.
Well, the one difference I can think of is resolution from machine (or host) name to port number,
when using the IP netlib.
For the default instance, the port is well known (1433). You can change this but that requires that
you specify that port in the client app.
For a named instance, the client queries the "SQL Server browser" service which relies what port
number the desired instance is using. This is done using port 1434, UDP.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Steve Z" <SteveZ@.discussions.microsoft.com> wrote in message
news:9A6F1BE0-5819-457A-8E07-86869FDF2BE7@.microsoft.com...
> Is there a reason to use a named instance?
> Is there a reason to not use a named instance?
> This will be a large enterprise server - over 1000 users - around 20 or so
> buildings across town.
> Opinions?

Install of SQL 2005

If a server is going to be used for just SQL database access - locally on the
WAN - is there any need for IIS?
Does installing reporting services and IIS degrade the machine.
I've got a client whose DBA is debating these issues with the tech who
installed OS and SQL...
DBA wants bare-bones SQL install - thinking of installing IIS/Reporting
Services on another server later if it's ever needed.
Recommendations and opinions would be appreciated.Best practice would usually dictate that IIS / SSRS are employed on another
machine. However, just like whether you should buy an SL55 AMG or a Toyota
Corolla, it depends...
A
"Steve Z" <SteveZ@.discussions.microsoft.com> wrote in message
news:9FF616F6-89A7-4B3C-B78E-566D976B25AF@.microsoft.com...
> If a server is going to be used for just SQL database access - locally on
> the
> WAN - is there any need for IIS?
> Does installing reporting services and IIS degrade the machine.
> I've got a client whose DBA is debating these issues with the tech who
> installed OS and SQL...
> DBA wants bare-bones SQL install - thinking of installing IIS/Reporting
> Services on another server later if it's ever needed.
> Recommendations and opinions would be appreciated.|||I agree. I would install bare essentials now, and add IIS/RS if/when needed.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Aaron Bertrand [SQL Server MVP]" <ten.xoc@.dnartreb.noraa> wrote in message
news:eOtb68zxHHA.4352@.TK2MSFTNGP05.phx.gbl...
> Best practice would usually dictate that IIS / SSRS are employed on another machine. However,
> just like whether you should buy an SL55 AMG or a Toyota Corolla, it depends...
> A
>
>
> "Steve Z" <SteveZ@.discussions.microsoft.com> wrote in message
> news:9FF616F6-89A7-4B3C-B78E-566D976B25AF@.microsoft.com...
>> If a server is going to be used for just SQL database access - locally on the
>> WAN - is there any need for IIS?
>> Does installing reporting services and IIS degrade the machine.
>> I've got a client whose DBA is debating these issues with the tech who
>> installed OS and SQL...
>> DBA wants bare-bones SQL install - thinking of installing IIS/Reporting
>> Services on another server later if it's ever needed.
>> Recommendations and opinions would be appreciated.
>|||On Jul 15, 4:30 pm, Steve Z <Ste...@.discussions.microsoft.com> wrote:
> If a server is going to be used for just SQL database access - locally on the
> WAN - is there any need for IIS?
> Does installing reporting services and IIS degrade the machine.
> I've got a client whose DBA is debating these issues with the tech who
> installed OS and SQL...
> DBA wants bare-bones SQL install - thinking of installing IIS/Reporting
> Services on another server later if it's ever needed.
> Recommendations and opinions would be appreciated.
As already echoed in the thread, start with your minimal footprint and
add as necessary. Reporting Services is pretty easy to get up and
running when need be. Just get your specifications and go from there.|||Is there a reason to use a named instance?
Is there a reason to not use a named instance?
This will be a large enterprise server - over 1000 users - around 20 or so
buildings across town.
Opinions?|||No and no. A named instance isn't different from a default instance except for how you access it
from a client (like only machinename or machinename\instancename). So do what feels natural for you.
Well, the one difference I can think of is resolution from machine (or host) name to port number,
when using the IP netlib.
For the default instance, the port is well known (1433). You can change this but that requires that
you specify that port in the client app.
For a named instance, the client queries the "SQL Server browser" service which relies what port
number the desired instance is using. This is done using port 1434, UDP.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Steve Z" <SteveZ@.discussions.microsoft.com> wrote in message
news:9A6F1BE0-5819-457A-8E07-86869FDF2BE7@.microsoft.com...
> Is there a reason to use a named instance?
> Is there a reason to not use a named instance?
> This will be a large enterprise server - over 1000 users - around 20 or so
> buildings across town.
> Opinions?

Install of SQL 2005

If a server is going to be used for just SQL database access - locally on th
e
WAN - is there any need for IIS?
Does installing reporting services and IIS degrade the machine.
I've got a client whose DBA is debating these issues with the tech who
installed OS and SQL...
DBA wants bare-bones SQL install - thinking of installing IIS/Reporting
Services on another server later if it's ever needed.
Recommendations and opinions would be appreciated.Best practice would usually dictate that IIS / SSRS are employed on another
machine. However, just like whether you should buy an SL55 AMG or a Toyota
Corolla, it depends...
A
"Steve Z" <SteveZ@.discussions.microsoft.com> wrote in message
news:9FF616F6-89A7-4B3C-B78E-566D976B25AF@.microsoft.com...
> If a server is going to be used for just SQL database access - locally on
> the
> WAN - is there any need for IIS?
> Does installing reporting services and IIS degrade the machine.
> I've got a client whose DBA is debating these issues with the tech who
> installed OS and SQL...
> DBA wants bare-bones SQL install - thinking of installing IIS/Reporting
> Services on another server later if it's ever needed.
> Recommendations and opinions would be appreciated.|||I agree. I would install bare essentials now, and add IIS/RS if/when needed.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Aaron Bertrand [SQL Server MVP]" <ten.xoc@.dnartreb.noraa> wrote in mess
age
news:eOtb68zxHHA.4352@.TK2MSFTNGP05.phx.gbl...
> Best practice would usually dictate that IIS / SSRS are employed on anothe
r machine. However,
> just like whether you should buy an SL55 AMG or a Toyota Corolla, it depen
ds...
> A
>
>
> "Steve Z" <SteveZ@.discussions.microsoft.com> wrote in message
> news:9FF616F6-89A7-4B3C-B78E-566D976B25AF@.microsoft.com...
>|||On Jul 15, 4:30 pm, Steve Z <Ste...@.discussions.microsoft.com> wrote:
> If a server is going to be used for just SQL database access - locally on
the
> WAN - is there any need for IIS?
> Does installing reporting services and IIS degrade the machine.
> I've got a client whose DBA is debating these issues with the tech who
> installed OS and SQL...
> DBA wants bare-bones SQL install - thinking of installing IIS/Reporting
> Services on another server later if it's ever needed.
> Recommendations and opinions would be appreciated.
As already echoed in the thread, start with your minimal footprint and
add as necessary. Reporting Services is pretty easy to get up and
running when need be. Just get your specifications and go from there.|||Is there a reason to use a named instance?
Is there a reason to not use a named instance?
This will be a large enterprise server - over 1000 users - around 20 or so
buildings across town.
Opinions?|||No and no. A named instance isn't different from a default instance except f
or how you access it
from a client (like only machinename or machinename\instancename). So do wha
t feels natural for you.
Well, the one difference I can think of is resolution from machine (or host)
name to port number,
when using the IP netlib.
For the default instance, the port is well known (1433). You can change this
but that requires that
you specify that port in the client app.
For a named instance, the client queries the "SQL Server browser" service wh
ich relies what port
number the desired instance is using. This is done using port 1434, UDP.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Steve Z" <SteveZ@.discussions.microsoft.com> wrote in message
news:9A6F1BE0-5819-457A-8E07-86869FDF2BE7@.microsoft.com...
> Is there a reason to use a named instance?
> Is there a reason to not use a named instance?
> This will be a large enterprise server - over 1000 users - around 20 or so
> buildings across town.
> Opinions?sql

Install of MSDE on XP Pro Failed, HELP Please ANYONE!

I have for the past 1.5 weeks been trying to get MSDE installed on a Windows
XP computer. We are installing MSDE sp3 which we have installed on more
than 20+ computers. Some computers Windows 2003 Servers some Windows XP
Pro. We have NEVER had a problem. So before anyone suggest it, I don't
think going to MSDE sp4 will help with this problem. We have formatted the
computer MANY times and started over. We have updated with ALL of the
Windows update and it did not work. We formatted and install only SP2 on
Windows XP. We have taken off all other software, virus scanners, office,
etc. The computer is BLANK. It is on the network and I am remote
desktopped in when I try to install. Now I have done this MANY time remote
desktopped to a machine and no problem. We have made sure that network
items like File and Print Sharing are on. I have tried to install as the
administrator of the computer, as a user who have administrative priveleges,
etc. This computer is a Windows XP computer, not on a domain, the software
is XP Pro, and everything looks good. I am at a lost.
When I install I have it dump out the logs, here is some of the log I get,
it is
to long to post all of it. I have also added the SQL
Error logs that are left below this log. Then below that I have attached
the cnfgsvr.out
Any help is GREATLY appriecated, I can not blank out and install XP any
more.
=== Verbose logging started: 7/25/2007 17:43:02 Build type: SHIP UNICODE
3.00.3790.2180 Calling process: C:\WINDOWS\system32\msiexec.exe ===
MSI (c) (10:C0) [17:43:02:687]: Resetting cached policy values
MSI (c) (10:C0) [17:43:02:687]: Machine policy value 'Debug' is 0
MSI (c) (10:C0) [17:43:02:687]: ******* RunEngine:
******* Product: C:\ONSInstall\sql2ksp3\MSDE\Setup\SqlRun01.msi
******* Action:
******* CommandLine: **********
MSI (c) (10:C0) [17:43:02:718]: Machine policy value 'DisableUserInstalls'
is 0
MSI (c) (10:C0) [17:43:02:843]: SOFTWARE RESTRICTION POLICY: Verifying
package --> 'C:\ONSInstall\sql2ksp3\MSDE\Setup\SqlRun01.msi' against
software restriction policy
MSI (c) (10:C0) [17:43:02:843]: Note: 1: 2262 2: DigitalSignature
3: -2147287038
MSI (c) (10:C0) [17:43:02:843]: SOFTWARE RESTRICTION POLICY:
C:\ONSInstall\sql2ksp3\MSDE\Setup\SqlRun01.msi is not digitally signed
MSI (c) (10:C0) [17:43:02:843]: SOFTWARE RESTRICTION POLICY:
C:\ONSInstall\sql2ksp3\MSDE\Setup\SqlRun01.msi is permitted to run at the
'unrestricted' authorization level.
MSI (c) (10:C0) [17:43:02:968]: Cloaking enabled.
MSI (c) (10:C0) [17:43:02:968]: Attempting to enable all disabled priveleges
before calling Install on Server
MSI (c) (10:C0) [17:43:03:000]: End dialog not enabled
MSI (c) (10:C0) [17:43:03:000]: Original package ==>
C:\ONSInstall\sql2ksp3\MSDE\Setup\SqlRun01.msi
MSI (c) (10:C0) [17:43:03:000]: Package we're running from ==>
C:\DOCUME~1\ADMINI~1\LOCALS~1\Temp\2557a1.msi
MSI (c) (10:C0) [17:43:03:015]: APPCOMPAT: looking for appcompat database
entry with ProductCode '{E09B48B5-E141-427A-AB0C-D3605127224A}'.
MSI (c) (10:C0) [17:43:03:015]: APPCOMPAT: no matching ProductCode found in
database.
MSI (c) (10:C0) [17:43:03:015]: MSCOREE not loaded loading copy from
system32
MSI (c) (10:C0) [17:43:03:015]: Machine policy value 'TransformsSecure' is 0
MSI (c) (10:C0) [17:43:03:015]: User policy value 'TransformsAtSource' is 0
MSI (c) (10:C0) [17:43:03:015]: Note: 1: 2205 2: 3: MsiFileHash
MSI (c) (10:C0) [17:43:03:015]: Machine policy value 'DisablePatch' is 0
MSI (c) (10:C0) [17:43:03:015]: Machine policy value 'AllowLockdownPatch' is
0
MSI (c) (10:C0) [17:43:03:015]: Machine policy value 'DisableLUAPatching' is
0
MSI (c) (10:C0) [17:43:03:015]: Machine policy value
'DisableFlyWeightPatching' is 0
MSI (c) (10:C0) [17:43:03:015]: APPCOMPAT: looking for appcompat database
entry with ProductCode '{E09B48B5-E141-427A-AB0C-D3605127224A}'.
MSI (c) (10:C0) [17:43:03:015]: APPCOMPAT: no matching ProductCode found in
database.
MSI (c) (10:C0) [17:43:03:015]: Transforms are not secure.
MSI (c) (10:C0) [17:43:03:015]: Note: 1: 2262 2: Control 3: -2147287038
MSI (c) (10:C0) [17:43:03:015]: Command Line: instancename=ThinkHealth
SECURITYMODE=SQL SA...
MSI (c) (10:C0) [17:43:03:015]: PROPERTY CHANGE: Adding PackageCode
property. Its value is '{D29DCF7A-8199-4373-BA0D-2F3635EC940C}'.
MSI (c) (10:C0) [17:43:03:015]: Product Code passed to Engine.Initialize:
''
MSI (c) (10:C0) [17:43:03:015]: Product Code from property table before
transforms: '{E09B48B5-E141-427A-AB0C-D3605127224A}'
MSI (c) (10:C0) [17:43:03:015]: Product Code from property table after
transforms: '{E09B48B5-E141-427A-AB0C-D3605127224A}'
MSI (c) (10:C0) [17:43:03:015]: Product not registered: beginning first-time
install
MSI (c) (10:C0) [17:43:03:015]: PROPERTY CHANGE: Adding ProductState
property. Its value is '-1'.
MSI (c) (10:C0) [17:43:03:015]: Entering
CMsiConfigurationManager::SetLastUsedSource.
MSI (c) (10:C0) [17:43:03:015]: User policy value 'SearchOrder' is 'nmu'
MSI (c) (10:C0) [17:43:03:015]: Adding new sources is allowed.
MSI (c) (10:C0) [17:43:03:015]: PROPERTY CHANGE: Adding PackagecodeChanging
property. Its value is '1'.
MSI (c) (10:C0) [17:43:03:015]: Package name extracted from package path:
'SqlRun01.msi'
MSI (c) (10:C0) [17:43:03:015]: Package to be registered: 'SqlRun01.msi'
MSI (c) (10:C0) [17:43:03:031]: Note: 1: 2262 2: AdminProperties
3: -2147287038
MSI (c) (10:C0) [17:43:03:031]: Machine policy value 'DisableMsi' is 0
MSI (c) (10:C0) [17:43:03:031]: Machine policy value 'AlwaysInstallElevated'
is 0
MSI (c) (10:C0) [17:43:03:031]: User policy value 'AlwaysInstallElevated' is
0
MSI (c) (10:C0) [17:43:03:031]: Product installation will be elevated
because user is admin and product is being installed per-machine.
MSI (c) (10:C0) [17:43:03:031]: Running product
'{E09B48B5-E141-427A-AB0C-D3605127224A}' with elevated privileges: Product
is assigned.
*********************************
SOFTWARE\Microsoft\Microsoft SQL Server
Setup.{E09B48B5-E141-427A-AB0C-D3605127224A}
TempFolder is
C:\DOCUME~1\ADMINI~1\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\
Loading extended custom action library
C:\DOCUME~1\ADMINI~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 InstallPerfMon
Registering performance counters from sqlctr.ini
MSI (s) (00:4C) [17:43:38:156]: Executing op:
ActionStart(Name=InstallSQLAdHlp.2D02443E_7002_4C0 B_ABC9_EAB2C064397B,,)
MSI (s) (00:4C) [17:43:38:156]: Executing op:
CustomActionSchedule(Action=InstallSQLAdHlp.2D0244 3E_7002_4C0B_ABC9_EAB2C064397B,ActionType=1025,Sou rce=BinaryData,Target=InstallSQLAdHlp,)
MSI (s) (00:BC) [17:43:38:171]: Invoking remote custom action. DLL:
C:\WINDOWS\Installer\MSI2A.tmp, Entrypoint: InstallSQLAdHlp
SOFTWARE\Microsoft\Microsoft SQL Server
Setup.{E09B48B5-E141-427A-AB0C-D3605127224A}
TempFolder is
C:\DOCUME~1\ADMINI~1\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\
Loading extended custom action library
C:\DOCUME~1\ADMINI~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 CallSQLAdHlp
C:\Program Files\Microsoft SQL Server\80\Tools\Binn\sqladhlp.exe : 0
MSI (s) (00:4C) [17:43:38:593]: Executing op:
ActionStart(Name=RollbackAgentSecurity.2D02443E_70 02_4C0B_ABC9_EAB2C064397B,,)
MSI (s) (00:4C) [17:43:38:593]: Executing op:
CustomActionSchedule(Action=RollbackAgentSecurity. 2D02443E_7002_4C0B_ABC9_EAB2C064397B,ActionType=12 81,Source=BinaryData,Target=UnInstSQLAgentSecurity ,)
MSI (s) (00:4C) [17:43:38:593]: Executing op:
ActionStart(Name=InstallAgentSecurity.2D02443E_700 2_4C0B_ABC9_EAB2C064397B,,)
MSI (s) (00:4C) [17:43:38:593]: Executing op:
CustomActionSchedule(Action=InstallAgentSecurity.2 D02443E_7002_4C0B_ABC9_EAB2C064397B,ActionType=102 5,Source=BinaryData,Target=InstallSQLAgentSecurity ,)
MSI (s) (00:90) [17:43:38:609]: Invoking remote custom action. DLL:
C:\WINDOWS\Installer\MSI2B.tmp, Entrypoint: InstallSQLAgentSecurity
SOFTWARE\Microsoft\Microsoft SQL Server
Setup.{E09B48B5-E141-427A-AB0C-D3605127224A}
TempFolder is
C:\DOCUME~1\ADMINI~1\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\
Loading extended custom action library
C:\DOCUME~1\ADMINI~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 InstallSQLAgentSecurity
InstallSQLAgentSecurity succeeded
MSI (s) (00:4C) [17:43:38:671]: Executing op:
ActionStart(Name=SkuIt.2D02443E_7002_4C0B_ABC9_EAB 2C064397B,,)
MSI (s) (00:4C) [17:43:38:687]: Executing op:
CustomActionSchedule(Action=SkuIt.2D02443E_7002_4C 0B_ABC9_EAB2C064397B,ActionType=1025,Source=Binary Data,Target=SkuIt,)
MSI (s) (00:78) [17:43:38:687]: Invoking remote custom action. DLL:
C:\WINDOWS\Installer\MSI2C.tmp, Entrypoint: SkuIt
SOFTWARE\Microsoft\Microsoft SQL Server
Setup.{E09B48B5-E141-427A-AB0C-D3605127224A}
TempFolder is
C:\DOCUME~1\ADMINI~1\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\
Loading extended custom action library
C:\DOCUME~1\ADMINI~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 SkuIt
MSI (s) (00:4C) [17:43:38:796]: Executing op:
ActionStart(Name=ConfigServer.2D02443E_7002_4C0B_A BC9_EAB2C064397B...
MSI (s) (00:4C) [17:43:38:796]: Executing op:
CustomActionSchedule(Action=ConfigServer.2D02443E_ 7002_4C0B_ABC9_EAB2C064397B...
MSI (s) (00:10) [17:43:38:796]: Invoking remote custom action. DLL:
C:\WINDOWS\Installer\MSI2D.tmp, Entrypoint: ConfigServer
SOFTWARE\Microsoft\Microsoft SQL Server
Setup.{E09B48B5-E141-427A-AB0C-D3605127224A}
TempFolder is
C:\DOCUME~1\ADMINI~1\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\
Loading extended custom action library
C:\DOCUME~1\ADMINI~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
Executing "C:\Program Files\Microsoft SQL
Server\80\Tools\Binn\cnfgsvr.exe -V 1 -M 1 -U sa -I "THINKHEALTH" -Q
"SQL_Latin1_General_CP1_CI_AS""
MSI (c) (10:50) [17:45:59:531]: Font created. Charset: Req=0, Ret=0, Font:
Req=MS Shell Dlg, Ret=MS Shell Dlg
Setup failed to configure the server. Refer to the server error logs and
setup error logs for more information.
MSI (s) (00!F4) [17:46:12:140]: Product: Microsoft SQL Server Desktop
Engine -- Setup failed to configure the server. Refer to the server error
logs and setup error logs for more information.
Action ended 17:46:12: InstallFinalize. Return value 3.
MSI (s) (00:4C) [17:46:12:171]: User policy value 'DisableRollback' is 0
MSI (s) (00:4C) [17:46:12:171]: Machine policy value 'DisableRollback' is 0
MSI (s) (00:4C) [17:46:12:187]: Executing op:
Header(Signature=1397708873,Version=300,Timestamp= 922324328,LangId=1033,Platform=0,ScriptType=2,Scri ptMajorVersion=21,ScriptMinorVersion=4,ScriptAttri butes=1)
MSI (s) (00:4C) [17:46:12:187]: Executing op:
DialogInfo(Type=0,Argument=1033)
MSI (s) (00:4C) [17:46:12:187]: Executing op:
DialogInfo(Type=1,Argument=Microsoft SQL Server Desktop Engine)
MSI (s) (00:4C) [17:46:12:187]: Executing op:
RollbackInfo(,RollbackAction=Rollback,RollbackDesc ription=Rolling back
action:,RollbackTemplate=[1],CleanupAction=RollbackCleanup,CleanupDescription= Removing
backup files,CleanupTemplate=File: [1])
MSI (s) (00:4C) [17:46:12:203]: Executing op:
ActionStart(Name=ConfigServer.2D02443E_7002_4C0B_A BC9_EAB2C064397B...
MSI (s) (00:4C) [17:46:12:203]: Executing op:
ProductInfo(ProductKey={E09B48B5-E141-427A-AB0C-D3605127224A},ProductName=Microsoft
SQL Server Desktop
Engine,PackageName=SqlRun01.msi,Language=1033,Vers ion=134218489,Assignment=1,ObsoleteArg=0,,,Package Code={D29DCF7A-8199-4373-BA0D-2F3635EC940C},,,InstanceType=0,LUASetting=0)
MSI (s) (00:4C) [17:46:12:203]: Executing op:
ActionStart(Name=SkuIt.2D02443E_7002_4C0B_ABC9_EAB 2C064397B,,)
MSI (s) (00:4C) [17:46:12:203]: Executing op:
ActionStart(Name=InstallAgentSecurity.2D02443E_700 2_4C0B_ABC9_EAB2C064397B,,)
MSI (s) (00:4C) [17:46:12:203]: Executing op:
ActionStart(Name=RollbackAgentSecurity.2D02443E_70 02_4C0B_ABC9_EAB2C064397B,,)
MSI (s) (00:4C) [17:46:12:203]: Executing op:
CustomActionRollback(Action=RollbackAgentSecurity. 2D02443E_7002_4C0B_ABC9_EAB2C064397B,ActionType=12 81,Source=BinaryData,Target=UnInstSQLAgentSecurity ,)
MSI (s) (00:28) [17:46:12:218]: Invoking remote custom action. DLL:
C:\WINDOWS\Installer\MSI2E.tmp, Entrypoint: UnInstSQLAgentSecurity
SOFTWARE\Microsoft\Microsoft SQL Server
Setup.{E09B48B5-E141-427A-AB0C-D3605127224A}
TempFolder is
C:\DOCUME~1\ADMINI~1\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\
Loading extended custom action library
C:\DOCUME~1\ADMINI~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 UnInstSQLAgentSecurity
Starting custom action UnInstSQLAgentSecurity
************************************************** ***
Property(S): ProductState = -1
Property(S): PackagecodeChanging = 1
Property(S): INSTANCENAME = ThinkHealth
Property(S): SA...
Property(S): SECURITYMODE = SQL
Property(S): CURRENTDIRECTORY = C:\ONSInstall\sql2ksp3\MSDE
Property(S): CLIENTUILEVEL = 0
Property(S): CLIENTPROCESSID = 1808
Property(S): USERNAME = Discovery
Property(S): COMPANYNAME = Discovery-uttuwah
Property(S): ACTION = INSTALL
Property(S): VersionDatabase = 110
Property(S): VersionMsi = 3.00
Property(S): WindowsBuild = 2600
Property(S): ServicePackLevel = 2
Property(S): ServicePackLevelMinor = 0
Property(S): MsiNTProductType = 1
Property(S): WindowsFolder = C:\WINDOWS\
Property(S): WindowsVolume = C:\
Property(S): System16Folder = C:\WINDOWS\system\
Property(S): RemoteAdminTS = 1
Property(S): TempFolder = C:\DOCUME~1\ADMINI~1\LOCALS~1\Temp\
Property(S): ProgramFilesFolder = C:\Program Files\
Property(S): CommonFilesFolder = C:\Program Files\Common Files\
Property(S): AppDataFolder = C:\Documents and
Settings\Administrator\Application Data\
Property(S): FavoritesFolder = C:\Documents and
Settings\Administrator\Favorites\
Property(S): NetHoodFolder = C:\Documents and
Settings\Administrator\NetHood\
Property(S): PersonalFolder = C:\Documents and Settings\Administrator\My
Documents\
Property(S): PrintHoodFolder = C:\Documents and
Settings\Administrator\PrintHood\
Property(S): RecentFolder = C:\Documents and Settings\Administrator\Recent\
Property(S): SendToFolder = C:\Documents and Settings\Administrator\SendTo\
Property(S): TemplateFolder = C:\Documents and Settings\All Users\Templates\
Property(S): CommonAppDataFolder = C:\Documents and Settings\All
Users\Application Data\
Property(S): LocalAppDataFolder = C:\Documents and
Settings\Administrator\Local Settings\Application Data\
Property(S): MyPicturesFolder = C:\Documents and Settings\Administrator\My
Documents\My Pictures\
Property(S): AdminToolsFolder = C:\Documents and Settings\All Users\Start
Menu\Programs\Administrative Tools\
Property(S): StartupFolder = C:\Documents and Settings\All Users\Start
Menu\Programs\Startup\
Property(S): ProgramMenuFolder = C:\Documents and Settings\All Users\Start
Menu\Programs\
Property(S): StartMenuFolder = C:\Documents and Settings\All Users\Start
Menu\
Property(S): DesktopFolder = C:\Documents and Settings\All Users\Desktop\
Property(S): FontsFolder = C:\WINDOWS\Fonts\
Property(S): GPTSupport = 1
Property(S): OLEAdvtSupport = 1
Property(S): ShellAdvtSupport = 1
Property(S): Intel = 15
Property(S): PhysicalMemory = 447
Property(S): VirtualMemory = 933
Property(S): AdminUser = 1
Property(S): LogonUser = Administrator
Property(S): UserSID = S-1-5-21-1202660629-1450960922-725345543-500
Property(S): UserLanguageID = 1033
Property(S): ComputerName = DISCOVSERVER
Property(S): SystemLanguageID = 1033
Property(S): ScreenX = 1024
Property(S): ScreenY = 768
Property(S): CaptionHeight = 26
Property(S): BorderTop = 1
Property(S): BorderSide = 1
Property(S): TextHeight = 16
Property(S): ColorBits = 32
Property(S): TTCSupport = 1
Property(S): MsiWin32AssemblySupport = 5.1.2600.2180
Property(S): RedirectedDllSupport = 2
Property(S): Time = 17:46:21
Property(S): Date = 7/25/2007
Property(S): Privileged = 1
Property(S): DATABASE = C:\WINDOWS\Installer\255937.msi
Property(S): OriginalDatabase =
C:\ONSInstall\sql2ksp3\MSDE\Setup\SqlRun01.msi
Property(S): UILevel = 3
Property(S): AgentServiceName = SQLAgent$THINKHEALTH
Property(S): InstanceRegKey = Microsoft SQL Server\THINKHEALTH
Property(S): InstanceSubDir = MSSQL$THINKHEALTH
Property(S): SqlPerfMonRegKey = SQLCTR$THINKHEALTH
Property(S): SQLServiceName = MSSQL$THINKHEALTH
Property(S): SqlStates = 0
Property(S): ROOTDRIVE = C:\
Property(S): CostingComplete = 1
Property(S): OutOfDiskSpace = 0
Property(S): OutOfNoRbDiskSpace = 0
Property(S): PrimaryVolumeSpaceAvailable = 0
Property(S): PrimaryVolumeSpaceRequired = 0
Property(S): PrimaryVolumeSpaceRemaining = 0
Property(S): SqlFeature = SqlRun
Property(S): SOURCEDIR = C:\ONSInstall\sql2ksp3\MSDE\Setup\
Property(S): SourcedirProduct = {E09B48B5-E141-427A-AB0C-D3605127224A}
Property(S): ProductToBeRegistered = 1
MSI (s) (00:4C) [17:46:21:453]: MainEngineThread is returning 1603
MSI (s) (00:38) [17:46:21:453]: Destroying RemoteAPI object.
MSI (s) (00:5C) [17:46:21:453]: Custom Action Manager thread ending.
MSI (c) (10:C0) [17:46:21:484]: Back from server. Return value: 1603
MSI (c) (10:C0) [17:46:21:484]: Decrementing counter to disable shutdown. If
counter >= 0, shutdown will be denied. Counter after decrement: -1
Action ended 17:46:21: INSTALL. Return value 3.
Property(C): UpgradeCode = {421A321C-2214-4713-B3EB-253F2FBCCE49}
Property(C): VersionNT = 501
Property(C): ALLUSERS = 1
Property(C): ARPNOMODIFY = 1
Property(C): DefaultUIFont = Tahoma8
Property(C): INSTALLLEVEL = 3
Property(C): LIMITUI = 1
Property(C): Manufacturer = Microsoft Corporation
Property(C): ProductCode = {E09B48B5-E141-427A-AB0C-D3605127224A}
Property(C): ProductLanguage = 1033
Property(C): ProductName = Microsoft SQL Server Desktop Engine
Property(C): ProductVersion = 8.00.761
Property(C): MsiHiddenProperties = SqlSa...
Property(C): SQLVersion.2D02443E_7002_4C0B_ABC9_EAB2C064397B = 8.00.194
Property(C): SQLExitCode.2D02443E_7002_4C0B_ABC9_EAB2C064397B = 1603
Property(C): APPS_TEST = 1
Property(C): SQLMSDESelected = 1
Property(C): CSDVersionNumber = 768
Property(C): CSDVersion = 8.00.761
Property(C): SystemFolder = C:\WINDOWS\system32\
Property(C): PackageCode = {D29DCF7A-8199-4373-BA0D-2F3635EC940C}
Property(C): ProductState = -1
Property(C): PackagecodeChanging = 1
Property(C): INSTANCENAME = ThinkHealth
Property(C): SA...
Property(C): SECURITYMODE = SQL
Property(C): CURRENTDIRECTORY = C:\ONSInstall\sql2ksp3\MSDE
Property(C): CLIENTUILEVEL = 0
Property(C): CLIENTPROCESSID = 1808
Property(C): VersionDatabase = 110
Property(C): VersionMsi = 3.00
Property(C): WindowsBuild = 2600
Property(C): ServicePackLevel = 2
Property(C): ServicePackLevelMinor = 0
Property(C): MsiNTProductType = 1
Property(C): WindowsFolder = C:\WINDOWS\
Property(C): WindowsVolume = C:\
Property(C): System16Folder = C:\WINDOWS\system\
Property(C): RemoteAdminTS = 1
Property(C): TempFolder = C:\DOCUME~1\ADMINI~1\LOCALS~1\Temp\
Property(C): ProgramFilesFolder = C:\Program Files\
Property(C): CommonFilesFolder = C:\Program Files\Common Files\
Property(C): AppDataFolder = C:\Documents and
Settings\Administrator\Application Data\
Property(C): FavoritesFolder = C:\Documents and
Settings\Administrator\Favorites\
Property(C): NetHoodFolder = C:\Documents and
Settings\Administrator\NetHood\
Property(C): PersonalFolder = C:\Documents and Settings\Administrator\My
Documents\
Property(C): PrintHoodFolder = C:\Documents and
Settings\Administrator\PrintHood\
Property(C): RecentFolder = C:\Documents and Settings\Administrator\Recent\
Property(C): SendToFolder = C:\Documents and Settings\Administrator\SendTo\
Property(C): TemplateFolder = C:\Documents and Settings\All Users\Templates\
Property(C): CommonAppDataFolder = C:\Documents and Settings\All
Users\Application Data\
Property(C): LocalAppDataFolder = C:\Documents and
Settings\Administrator\Local Settings\Application Data\
Property(C): MyPicturesFolder = C:\Documents and Settings\Administrator\My
Documents\My Pictures\
Property(C): AdminToolsFolder = C:\Documents and Settings\All Users\Start
Menu\Programs\Administrative Tools\
Property(C): StartupFolder = C:\Documents and Settings\All Users\Start
Menu\Programs\Startup\
Property(C): ProgramMenuFolder = C:\Documents and Settings\All Users\Start
Menu\Programs\
Property(C): StartMenuFolder = C:\Documents and Settings\All Users\Start
Menu\
Property(C): DesktopFolder = C:\Documents and Settings\All Users\Desktop\
Property(C): FontsFolder = C:\WINDOWS\Fonts\
Property(C): GPTSupport = 1
Property(C): OLEAdvtSupport = 1
Property(C): ShellAdvtSupport = 1
Property(C): Intel = 15
Property(C): PhysicalMemory = 447
Property(C): VirtualMemory = 936
Property(C): AdminUser = 1
Property(C): LogonUser = Administrator
Property(C): UserSID = S-1-5-21-1202660629-1450960922-725345543-500
Property(C): UserLanguageID = 1033
Property(C): ComputerName = DISCOVSERVER
Property(C): SystemLanguageID = 1033
Property(C): ScreenX = 1280
Property(C): ScreenY = 1024
Property(C): CaptionHeight = 26
Property(C): BorderTop = 1
Property(C): BorderSide = 1
Property(C): TextHeight = 16
Property(C): ColorBits = 16
Property(C): TTCSupport = 1
Property(C): MsiWin32AssemblySupport = 5.1.2600.2180
Property(C): RedirectedDllSupport = 2
Property(C): Time = 17:46:21
Property(C): Date = 7/25/2007
Property(C): Privileged = 1
Property(C): USERNAME = Discovery
Property(C): COMPANYNAME = Discovery-uttuwah
Property(C): DATABASE = C:\DOCUME~1\ADMINI~1\LOCALS~1\Temp\2557a1.msi
Property(C): OriginalDatabase =
C:\ONSInstall\sql2ksp3\MSDE\Setup\SqlRun01.msi
Property(C): UILevel = 3
Property(C): ACTION = INSTALL
=== Logging stopped: 7/25/2007 17:46:21 ===
MSI (c) (10:C0) [17:46:21:531]: Note: 1: 1708
MSI (c) (10:C0) [17:46:21:531]: Product: Microsoft SQL Server Desktop
Engine -- Installation operation failed.
MSI (c) (10:C0) [17:46:21:531]: Grabbed execution mutex.
MSI (c) (10:C0) [17:46:21:531]: Cleaning up uninstalled install packages, if
any exist
MSI (c) (10:C0) [17:46:21:546]: MainEngineThread is returning 1603
=== Verbose logging stopped: 7/25/2007 17:46:21 ===
2007-07-25 17:43:39.59 server Microsoft SQL Server 2000 - 8.00.760
(Intel X86)
Dec 17 2002 14:22:05
Copyright (c) 1988-2003 Microsoft Corporation
Desktop Engine on Windows NT 5.1 (Build 2600: Service Pack 2)
2007-07-25 17:43:39.59 server Copyright (C) 1988-2002 Microsoft
Corporation.
2007-07-25 17:43:39.59 server All rights reserved.
2007-07-25 17:43:39.59 server Server Process ID is 1880.
2007-07-25 17:43:39.59 server Logging SQL Server messages in file
'C:\Program Files\Microsoft SQL Server\MSSQL$THINKHEALTH\LOG\ERRORLOG'.
2007-07-25 17:43:39.60 server SQL Server is starting at priority class
'normal'(1 CPU detected).
2007-07-25 17:43:39.78 server SQL Server configured for thread mode
processing.
2007-07-25 17:43:39.79 server Using dynamic lock allocation. [500] Lock
Blocks, [1000] Lock Owner Blocks.
2007-07-25 17:43:39.92 spid3 Warning ******************
2007-07-25 17:43:39.92 spid3 SQL Server started in single user mode.
Updates allowed to system catalogs.
2007-07-25 17:43:39.93 spid3 Starting up database 'master'.
2007-07-25 17:43:40.40 server Using 'SSNETLIB.DLL' version '8.0.766'.
2007-07-25 17:43:40.40 spid5 Starting up database 'model'.
2007-07-25 17:43:40.49 spid3 Server name is 'DISCOVSERVER\THINKHEALTH'.
2007-07-25 17:43:40.49 spid3 Skipping startup of clean database id 5
2007-07-25 17:43:40.49 spid3 Skipping startup of clean database id 6
2007-07-25 17:43:40.49 spid3 Starting up database 'msdb'.
2007-07-25 17:43:40.67 server SQL server listening on Shared Memory.
2007-07-25 17:43:40.67 server SQL Server is ready for client connections
2007-07-25 17:43:40.74 spid5 Clearing tempdb database.
2007-07-25 17:43:41.29 spid5 Starting up database 'tempdb'.
2007-07-25 17:43:41.40 spid3 Recovery complete.
2007-07-25 17:43:41.40 spid3 SQL global counter collection task is
created.
2007-07-25 17:43:41.43 spid3 Warning: override, autoexec procedures
skipped.
2007-07-25 17:45:44.74 spid3 SQL Server is terminating due to 'stop'
request from Service Control Manager.
################################################## #############################
Starting Service ...
SQL_Latin1_General_CP1_CI_AS
-m -Q -T4022 -T3659
An error occurred while attempting to start the service (1460)
SQL Server configuration failed.
################################################## #############################
hi,
Microsoft News wrote:
> I have for the past 1.5 weeks been trying to get MSDE installed on a
> Windows XP computer. We are installing MSDE sp3 which we have
> installed on more than 20+ computers. Some computers Windows 2003
> Servers some Windows XP Pro. We have NEVER had a problem. So before
> anyone suggest it, I don't think going to MSDE sp4 will help with
> this problem. We have formatted the computer MANY times and started
> over. We have updated with ALL of the Windows update and it did not
> work. We formatted and install only SP2 on Windows XP. We have
> taken off all other software, virus scanners, office, etc. The
> computer is BLANK. It is on the network and I am remote desktopped
> in when I try to install. Now I have done this MANY time remote
> desktopped to a machine and no problem. We have made sure that
> network items like File and Print Sharing are on. I have tried to
> install as the administrator of the computer, as a user who have
> administrative priveleges, etc. This computer is a Windows XP
> computer, not on a domain, the software is XP Pro, and everything
> looks good. I am at a lost.
> When I install I have it dump out the logs, here is some of the log I
> get, it is
> to long to post all of it. I have also added the SQL
> Error logs that are left below this log. Then below that I have
> attached the cnfgsvr.out
> Any help is GREATLY appriecated, I can not blank out and install XP
> any more.
<-->
Setup failed to configure the server. Refer to the server error logs and
setup error logs for more information.
MSI (s) (00!F4) [17:46:12:140]: Product: Microsoft SQL Server Desktop
Engine -- Setup failed to configure the server. Refer to the server error
logs and setup error logs for more information.
Action ended 17:46:12: InstallFinalize. Return value 3.
<-->
this exception is usually related to
http://support.microsoft.com/default.aspx?scid=kb;en-us;816499&Product=sql
is the "Server" service up and running as well?
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz http://italy.mvps.org
DbaMgr2k ver 0.21.0 - DbaMgr ver 0.65.0 and further SQL Tools
-- remove DMO to reply
|||Andrea
Thank you for your response, as I said in my email this is a BLANK computer,
never had anything installed on it so the link does not help me with this
but I will try to install it in another directory just to see if there is
something wrong with trying to install it in the default location.
What do you mean by:
> is the "Server" service up and running as well?
Thank you
Clyde
"Andrea Montanari" <andrea.sqlDMO@.virgilio.it> wrote in message
news:5graglF37hkkqU1@.mid.individual.net...
> hi,
> Microsoft News wrote:
>
> <-->
> Setup failed to configure the server. Refer to the server error logs and
> setup error logs for more information.
> MSI (s) (00!F4) [17:46:12:140]: Product: Microsoft SQL Server Desktop
> Engine -- Setup failed to configure the server. Refer to the server error
> logs and setup error logs for more information.
> Action ended 17:46:12: InstallFinalize. Return value 3.
> <-->
> this exception is usually related to
> http://support.microsoft.com/default.aspx?scid=kb;en-us;816499&Product=sql
> is the "Server" service up and running as well?
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz http://italy.mvps.org
> DbaMgr2k ver 0.21.0 - DbaMgr ver 0.65.0 and further SQL Tools
> -- remove DMO to reply
>
|||hi,
> What do you mean by:
>
go in the Administrative Tools and select the Services Applet... scroll down
till you find a service called "Server" (Supports file, print, and
named-pipe sharing over the network for this computer. If this service is
stopped, these functions will be unavailable. If this service is disabled,
any services that explicitly depend on it will fail to start.)
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz http://italy.mvps.org
DbaMgr2k ver 0.21.0 - DbaMgr ver 0.65.0 and further SQL Tools
-- remove DMO to reply
|||Andrea
You are a great help but that was not it. The service is up and running. I
even stopped it and started it, then checked the event log to make sure no
error occured. But everything worked fine. The server service is working
file.
"Andrea Montanari" <andrea.sqlDMO@.virgilio.it> wrote in message
news:5gsig1F3i3s7nU1@.mid.individual.net...
> hi,
> go in the Administrative Tools and select the Services Applet... scroll
> down till you find a service called "Server" (Supports file, print, and
> named-pipe sharing over the network for this computer. If this service is
> stopped, these functions will be unavailable. If this service is disabled,
> any services that explicitly depend on it will fail to start.)
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz http://italy.mvps.org
> DbaMgr2k ver 0.21.0 - DbaMgr ver 0.65.0 and further SQL Tools
> -- remove DMO to reply
>
|||hi,
Microsoft News wrote:
> Andrea
> You are a great help but that was not it. The service is up and
> running. I even stopped it and started it, then checked the event
> log to make sure no error occured. But everything worked fine. The
> server service is working file.
Sometimes you may need to delete this key:
HKLM\Software\Microsoft\Windows\CurrentVersion\Set up\ExceptionComponents,
then reinstall the SQL Server again.
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz http://italy.mvps.org
DbaMgr2k ver 0.21.0 - DbaMgr ver 0.65.0 and further SQL Tools
-- remove DMO to reply
|||Andrea,
I tried removing the key after wiping out any registry settings and the
folder from the computer after the last install. I also tried installing in
a different folder since I read some where that might help. But getting rid
of the registry key you meantioned below along with changing the path did
not fix the problem. I still get the same error.
Thank you
"Andrea Montanari" <andrea.sqlDMO@.virgilio.it> wrote in message
news:5gtuueF3hi7apU1@.mid.individual.net...
> hi,
> Microsoft News wrote:
> Sometimes you may need to delete this key:
> HKLM\Software\Microsoft\Windows\CurrentVersion\Set up\ExceptionComponents,
> then reinstall the SQL Server again.
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz http://italy.mvps.org
> DbaMgr2k ver 0.21.0 - DbaMgr ver 0.65.0 and further SQL Tools
> -- remove DMO to reply
>
|||This is a long shot but you aren't trying to install this through a Terminal
Server connection are you? This will fail with a 1460 error similar to what
you're seeing. The log indicates SQL Server service installed and started
successfully and then shut down. You might try installing with different
options to see if that makes a difference. Since you messed around with the
registry, you may now get different failures related to the registry key
being partially there. SQL Server uses several thousand registry key so I'm
reasonably certain you didn't remove them all.
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
"Microsoft News" <Name@.coxinet.net> wrote in message
news:el2nANG0HHA.3768@.TK2MSFTNGP06.phx.gbl...
> Andrea,
> I tried removing the key after wiping out any registry settings and the
> folder from the computer after the last install. I also tried installing
> in a different folder since I read some where that might help. But
> getting rid of the registry key you meantioned below along with changing
> the path did not fix the problem. I still get the same error.
> Thank you
> "Andrea Montanari" <andrea.sqlDMO@.virgilio.it> wrote in message
> news:5gtuueF3hi7apU1@.mid.individual.net...
>
|||Roger,
Yes I am installing through a terminal server connection. I had read
another post were people pointed to that as a POSSIBLE problem but it was
not clear as to why. We have installed over 20+ MSDE systems through
Terminal Server connection and NEVER a problem. But tomorrow I will try to
install on a BLANK machine but this time I will have a local user run the
MSDE install.

> successfully and then shut down. You might try installing with different
> options to see if that makes a difference. Since you messed around with
> the
What different options are you referring to? I am installing with the
following command line:
setup instancename=<OurInstance> SECURITYMODE=SQL SAPWD=<SomePassword> /L*V
C:\msde.log

> options to see if that makes a difference. Since you messed around with
> the registry, you may now get different failures related to the registry
> key being partially there. SQL Server uses several thousand registry key
> so I'm reasonably certain you didn't remove them all.
Some time we try to install again after the install fails, what I do is go
into the registry and strip out everything that has SQL or MSSQL in the key,
that does not relate to ODBC. I figured that was cleaning up everything
because if you could look at the log file what you would see is that MSDE
rollback the install and remove all those thousands of registry keys. But
even if we do not get them all, as I said before we have tried MANY time to
format and re-install on a blank computer. I get the same error whether I
strip out keys or format. So your assumption of a different failures
related to registry key being partially there is incorrect.
Thanks for you help and advice, I will try to install locally and not
remoted, on a blank computer and see what happens. Any more suggestions
would be VERY helpful.
Clyde
"Roger Wolter[MSFT]" <rwolter@.online.microsoft.com> wrote in message
news:48A8AC3E-F262-4875-BCCF-315DB9BDC51A@.microsoft.com...
> This is a long shot but you aren't trying to install this through a
> Terminal Server connection are you? This will fail with a 1460 error
> similar to what you're seeing. The log indicates SQL Server service
> installed and started successfully and then shut down. You might try
> installing with different options to see if that makes a difference.
> Since you messed around with the registry, you may now get different
> failures related to the registry key being partially there. SQL Server
> uses several thousand registry key so I'm reasonably certain you didn't
> remove them all.
> --
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
> Use of included script samples are subject to the terms specified at
> http://www.microsoft.com/info/cpyright.htm
> "Microsoft News" <Name@.coxinet.net> wrote in message
> news:el2nANG0HHA.3768@.TK2MSFTNGP06.phx.gbl...
>
|||Roger,
Ok, we were able to install on a BLANK xp computer, we did nothing but
install XP, service pack 2, we did not install any hardware drivers (network
card or video card drivers, etc) we took all the windows defaults.
Plus, we did not remote in and try the installation, we just did the install
locally. The last thing we did was use MSDE sp4 not MSDE sp3 which I do not
think made a difference but I wanted to make sure anyone reading this would
know.
It all installed fine. I think the issue might have either been some other
driver or not installing remotely but we have installed remotely on a lot of
computers so I don't see the reason that would not work. The drivers are
the only other thing I can think of which might be the issue.
But thank to you and Andrea for all your help and I am glad this has been
solved.
Clyde W.
"Microsoft News" <Name@.coxinet.net> wrote in message
news:OzZdD2w0HHA.5380@.TK2MSFTNGP04.phx.gbl...
> Roger,
> Yes I am installing through a terminal server connection. I had read
> another post were people pointed to that as a POSSIBLE problem but it was
> not clear as to why. We have installed over 20+ MSDE systems through
> Terminal Server connection and NEVER a problem. But tomorrow I will try
> to install on a BLANK machine but this time I will have a local user run
> the MSDE install.
>
> What different options are you referring to? I am installing with the
> following command line:
> setup instancename=<OurInstance> SECURITYMODE=SQL SAPWD=<SomePassword>
> /L*V C:\msde.log
>
> Some time we try to install again after the install fails, what I do is go
> into the registry and strip out everything that has SQL or MSSQL in the
> key, that does not relate to ODBC. I figured that was cleaning up
> everything because if you could look at the log file what you would see is
> that MSDE rollback the install and remove all those thousands of registry
> keys. But even if we do not get them all, as I said before we have tried
> MANY time to format and re-install on a blank computer. I get the same
> error whether I strip out keys or format. So your assumption of a
> different failures related to registry key being partially there is
> incorrect.
> Thanks for you help and advice, I will try to install locally and not
> remoted, on a blank computer and see what happens. Any more suggestions
> would be VERY helpful.
> Clyde
> "Roger Wolter[MSFT]" <rwolter@.online.microsoft.com> wrote in message
> news:48A8AC3E-F262-4875-BCCF-315DB9BDC51A@.microsoft.com...
>

Monday, March 26, 2012

Install MSDE need XP disc

I have been installing MSDE2000 on several XP machines. Couple of them asked
for XP installation disc during the installation of MSDE. Others didn't.
Does anyone know why sometimes the installation of MSDE need the XP disc?
Thanks in advance.
Regards,
Otto
There might be requirements for things that weren't set up initially, like
TCP/IP/network support, MDAC, etc. I'm not sure of all the system
requirements for MSDE but if these installations are not all identical there
will likely be some required items missing...
http://www.aspfaq.com/
(Reverse address to reply.)
"Otto" <Otto@.discussions.microsoft.com> wrote in message
news:E7E21430-74ED-425B-B2CB-787D7DC6C66C@.microsoft.com...
> I have been installing MSDE2000 on several XP machines. Couple of them
asked
> for XP installation disc during the installation of MSDE. Others didn't.
> Does anyone know why sometimes the installation of MSDE need the XP disc?
> Thanks in advance.
> --
> Regards,
> Otto

Install MSDE need XP disc

I have been installing MSDE2000 on several XP machines. Couple of them asked
for XP installation disc during the installation of MSDE. Others didn't.
Does anyone know why sometimes the installation of MSDE need the XP disc?
Thanks in advance.
--
Regards,
OttoThere might be requirements for things that weren't set up initially, like
TCP/IP/network support, MDAC, etc. I'm not sure of all the system
requirements for MSDE but if these installations are not all identical there
will likely be some required items missing...
--
http://www.aspfaq.com/
(Reverse address to reply.)
"Otto" <Otto@.discussions.microsoft.com> wrote in message
news:E7E21430-74ED-425B-B2CB-787D7DC6C66C@.microsoft.com...
> I have been installing MSDE2000 on several XP machines. Couple of them
asked
> for XP installation disc during the installation of MSDE. Others didn't.
> Does anyone know why sometimes the installation of MSDE need the XP disc?
> Thanks in advance.
> --
> Regards,
> Otto

Install MSDE need XP disc

I have been installing MSDE2000 on several XP machines. Couple of them asked
for XP installation disc during the installation of MSDE. Others didn't.
Does anyone know why sometimes the installation of MSDE need the XP disc?
Thanks in advance.
Regards,
OttoThere might be requirements for things that weren't set up initially, like
TCP/IP/network support, MDAC, etc. I'm not sure of all the system
requirements for MSDE but if these installations are not all identical there
will likely be some required items missing...
http://www.aspfaq.com/
(Reverse address to reply.)
"Otto" <Otto@.discussions.microsoft.com> wrote in message
news:E7E21430-74ED-425B-B2CB-787D7DC6C66C@.microsoft.com...
> I have been installing MSDE2000 on several XP machines. Couple of them
asked
> for XP installation disc during the installation of MSDE. Others didn't.
> Does anyone know why sometimes the installation of MSDE need the XP disc?
> Thanks in advance.
> --
> Regards,
> Ottosql

Install issue with SQL Server 2005 Enterprise

I am having a really hard time installing SQL Server 2005 Enterprise
Edition. My server definitely meets the hardware requirements of the
server. The server OS is Windows 2003 Enterprise R2. The problem
occurs during setup. After checking my system configuration, it goes
to the window that generates a list of items it is going to install (I
believe). Here, as soon as it starts generating the list, it freezes
the whole server and then shuts down. It does this every single time.
Any thoughts or suggestions?First thing, check the setup log files in C:\Program Files\Microsoft SQL
Server\90\Setup Bootstrap\LOG\Files for where the setup failed and for any
error info.
Linchi
"CarlosSanchezJr@.gmail.com" wrote:
> I am having a really hard time installing SQL Server 2005 Enterprise
> Edition. My server definitely meets the hardware requirements of the
> server. The server OS is Windows 2003 Enterprise R2. The problem
> occurs during setup. After checking my system configuration, it goes
> to the window that generates a list of items it is going to install (I
> believe). Here, as soon as it starts generating the list, it freezes
> the whole server and then shuts down. It does this every single time.
> Any thoughts or suggestions?
>|||In addition , if your computer is connected to the network , try unplug
the cable and start an installation
"Linchi Shea" <LinchiShea@.discussions.microsoft.com> wrote in message
news:0A94A25C-0C87-4777-92FF-4F76A5420387@.microsoft.com...
> First thing, check the setup log files in C:\Program Files\Microsoft SQL
> Server\90\Setup Bootstrap\LOG\Files for where the setup failed and for any
> error info.
> Linchi
> "CarlosSanchezJr@.gmail.com" wrote:
>> I am having a really hard time installing SQL Server 2005 Enterprise
>> Edition. My server definitely meets the hardware requirements of the
>> server. The server OS is Windows 2003 Enterprise R2. The problem
>> occurs during setup. After checking my system configuration, it goes
>> to the window that generates a list of items it is going to install (I
>> believe). Here, as soon as it starts generating the list, it freezes
>> the whole server and then shuts down. It does this every single time.
>> Any thoughts or suggestions?
>>|||I have checked the log files and did not see anything there that caused
an issue. I also tried the disabling of my network connection and that
also did not work.
I am at a complete loss here. Everything is great until it does the
System Configuration Check. Then it just suddenly freezes the whole
server and I have to do a hard reboot.
Uri Dimant wrote:
> In addition , if your computer is connected to the network , try unplug
> the cable and start an installation
>
> "Linchi Shea" <LinchiShea@.discussions.microsoft.com> wrote in message
> news:0A94A25C-0C87-4777-92FF-4F76A5420387@.microsoft.com...
> > First thing, check the setup log files in C:\Program Files\Microsoft SQL
> > Server\90\Setup Bootstrap\LOG\Files for where the setup failed and for any
> > error info.
> >
> > Linchi
> >
> > "CarlosSanchezJr@.gmail.com" wrote:
> >
> >> I am having a really hard time installing SQL Server 2005 Enterprise
> >> Edition. My server definitely meets the hardware requirements of the
> >> server. The server OS is Windows 2003 Enterprise R2. The problem
> >> occurs during setup. After checking my system configuration, it goes
> >> to the window that generates a list of items it is going to install (I
> >> believe). Here, as soon as it starts generating the list, it freezes
> >> the whole server and then shuts down. It does this every single time.
> >>
> >> Any thoughts or suggestions?
> >>
> >>|||Never did get this working on 2003 Enterprise R2, however, I tried it
on 2003 Standard R2 and it installed without any problems. Very odd.
CarlosSanchezJr@.gmail.com wrote:
> I have checked the log files and did not see anything there that caused
> an issue. I also tried the disabling of my network connection and that
> also did not work.
> I am at a complete loss here. Everything is great until it does the
> System Configuration Check. Then it just suddenly freezes the whole
> server and I have to do a hard reboot.
> Uri Dimant wrote:
> > In addition , if your computer is connected to the network , try unplug
> > the cable and start an installation
> >
> >
> > "Linchi Shea" <LinchiShea@.discussions.microsoft.com> wrote in message
> > news:0A94A25C-0C87-4777-92FF-4F76A5420387@.microsoft.com...
> > > First thing, check the setup log files in C:\Program Files\Microsoft SQL
> > > Server\90\Setup Bootstrap\LOG\Files for where the setup failed and for any
> > > error info.
> > >
> > > Linchi
> > >
> > > "CarlosSanchezJr@.gmail.com" wrote:
> > >
> > >> I am having a really hard time installing SQL Server 2005 Enterprise
> > >> Edition. My server definitely meets the hardware requirements of the
> > >> server. The server OS is Windows 2003 Enterprise R2. The problem
> > >> occurs during setup. After checking my system configuration, it goes
> > >> to the window that generates a list of items it is going to install (I
> > >> believe). Here, as soon as it starts generating the list, it freezes
> > >> the whole server and then shuts down. It does this every single time.
> > >>
> > >> Any thoughts or suggestions?
> > >>
> > >>

Install issue with SQL Server 2005 Enterprise

Friday, March 23, 2012

install Express Manager without installing Express

The Express Manager will not install until after installing Express. One reason is because of a dependency on the SMO dll. Can Express Manager be installed without Express if SMO is installed into the GAC first? Is there a way to avoid installing Express?

Things have changed since originally asking the question over a year ago.

A new install of SQL Server Management Studio Express Setup on XP Pro SP 2 resulted in the following dialog box:

Microsoft SQL Server Management Studio Express Setup

Setup is missing prerequisites:
-MSXML6

Go to http://go.microsoft.com/fwlink/?linkid=54583

After downloading and installing MSXML6, SSMS Express installed without any further problems. SQL Server 2005 Express does not have to be installed before or after installing SSMS Express.

|||hello, I never encountered this problem before.

but ever since I started installing the latest package of msxml6 (msxml6-KB925673-enu-x86.exe) at T-13 of Windows XP installation via SVCPACK.INI, along with other hotfixes, I can no longer install SSMSExpress. I received the same error message as above. SQL Server 2005 Express was able to to detect MSXML6 properly. I only have problem with SSMSE. of course, a workaround would be to use original MSXML6 instead, then install KB925673 after SSMSE. but will MS update SSMSE installer?
|||

I removed the MSXML 6.0 with KB925673 from my computer, downloaded the MSXML 6.0 from http://www.microsoft.com/downloads/details.aspx?FamilyID=993c0bcf-3bcf-4009-be21-27e85e1857b1&DisplayLang=en but the SSMSEE still throws the same error "Setup is missing pre-requisites MSXML6".

The dowloaded MSXML 6.0 version doesn't say KB925673.

Please help.

Friday, March 30, 2012

Install Security

Install Second Node

Wednesday, March 28, 2012

Install Problem Error 29503 & 1067 OR Error 29503 & 2146885628

Install Problem Error 29503 & 1067 OR Error 29503 & 2146885628

Install problem

Install of SQL 2005

Install of SQL 2005

Install of SQL 2005

Install of MSDE on XP Pro Failed, HELP Please ANYONE!

Monday, March 26, 2012

Install MSDE need XP disc

Install MSDE need XP disc

Install MSDE need XP disc

Install issue with SQL Server 2005 Enterprise

Install issue with SQL Server 2005 Enterprise

Install issue with SQL Server 2005 Enterprise

Friday, March 23, 2012

install Express Manager without installing Express

Inserting Null Value

Blog Archive

About Me