Missing RAM

My server has Windows 2000 Advanced Server as the operating system with 4GB
of RAM and SQL Server 2000 as the database server. In perfmon the SQL Server
target server memory and SQL Server total server memory list at 1.68 GB.
What could be reducing the memory to 1.68 GB. How can I resolve this issue.
Thank You,
What edition of SQL Server?
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Joe K." <Joe K.@.discussions.microsoft.com> wrote in message
news:693A66FC-45B1-482E-B59D-FC068E4B6218@.microsoft.com...
> My server has Windows 2000 Advanced Server as the operating system with 4GB
> of RAM and SQL Server 2000 as the database server. In perfmon the SQL Server
> target server memory and SQL Server total server memory list at 1.68 GB.
> What could be reducing the memory to 1.68 GB. How can I resolve this issue.
> Thank You,
|||Joe,
Check the memory setting (esp the max memory) for the SQL Server. In EM
right click the SQL Server -->Properties--> Memory.
HTH
Jerry
"Joe K." <Joe K.@.discussions.microsoft.com> wrote in message
news:693A66FC-45B1-482E-B59D-FC068E4B6218@.microsoft.com...
> My server has Windows 2000 Advanced Server as the operating system with
> 4GB
> of RAM and SQL Server 2000 as the database server. In perfmon the SQL
> Server
> target server memory and SQL Server total server memory list at 1.68 GB.
> What could be reducing the memory to 1.68 GB. How can I resolve this
> issue.
> Thank You,

Missing RAM

My server has Windows 2000 Advanced Server as the operating system with 4GB
of RAM and SQL Server 2000 as the database server. In perfmon the SQL Server
target server memory and SQL Server total server memory list at 1.68 GB.
What could be reducing the memory to 1.68 GB. How can I resolve this issue.
Thank You,What edition of SQL Server?
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Joe K." <Joe K.@.discussions.microsoft.com> wrote in message
news:693A66FC-45B1-482E-B59D-FC068E4B6218@.microsoft.com...
> My server has Windows 2000 Advanced Server as the operating system with 4GB
> of RAM and SQL Server 2000 as the database server. In perfmon the SQL Server
> target server memory and SQL Server total server memory list at 1.68 GB.
> What could be reducing the memory to 1.68 GB. How can I resolve this issue.
> Thank You,|||Joe,
Check the memory setting (esp the max memory) for the SQL Server. In EM
right click the SQL Server -->Properties--> Memory.
HTH
Jerry
"Joe K." <Joe K.@.discussions.microsoft.com> wrote in message
news:693A66FC-45B1-482E-B59D-FC068E4B6218@.microsoft.com...
> My server has Windows 2000 Advanced Server as the operating system with
> 4GB
> of RAM and SQL Server 2000 as the database server. In perfmon the SQL
> Server
> target server memory and SQL Server total server memory list at 1.68 GB.
> What could be reducing the memory to 1.68 GB. How can I resolve this
> issue.
> Thank You,

Missing RAM

My server has Windows 2000 Advanced Server as the operating system with 4GB
of RAM and SQL Server 2000 as the database server. In perfmon the SQL Serve
r
target server memory and SQL Server total server memory list at 1.68 GB.
What could be reducing the memory to 1.68 GB. How can I resolve this issue.
Thank You,What edition of SQL Server?
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Joe K." <Joe K.@.discussions.microsoft.com> wrote in message
news:693A66FC-45B1-482E-B59D-FC068E4B6218@.microsoft.com...
> My server has Windows 2000 Advanced Server as the operating system with 4G
B
> of RAM and SQL Server 2000 as the database server. In perfmon the SQL Ser
ver
> target server memory and SQL Server total server memory list at 1.68 GB.
> What could be reducing the memory to 1.68 GB. How can I resolve this issu
e.
> Thank You,|||Joe,
Check the memory setting (esp the max memory) for the SQL Server. In EM
right click the SQL Server -->Properties--> Memory.
HTH
Jerry
"Joe K." <Joe K.@.discussions.microsoft.com> wrote in message
news:693A66FC-45B1-482E-B59D-FC068E4B6218@.microsoft.com...
> My server has Windows 2000 Advanced Server as the operating system with
> 4GB
> of RAM and SQL Server 2000 as the database server. In perfmon the SQL
> Server
> target server memory and SQL Server total server memory list at 1.68 GB.
> What could be reducing the memory to 1.68 GB. How can I resolve this
> issue.
> Thank You,

Missing pubs in Replication Monitor

I have set up Replication in SQL2K on a Windows 2K Advanced Server. Up until last week the Replication Monitor showed my publications and the agents. I was able to monitor and troubleshoot by selecting one of the agents. Now the Replication Monitor is there, and the publisher group is there, but the publications are not visible. The agents are running and functioning normally, yet I can not monitor them in the Replication Monitor.

Any ideas?Howdy

Well EM is a pile of cr*p so nothing would surprise me....

Try re-registering the server to EM & see how it goes.

Cheers

SG|||I have reregistered the server, I have opened a Monitor group and registered it, I have registered the server from other SQL servers. All the same.|||Howdy

How are you logging onto the SQL SErver? Are you sa? If you arent sa you probably wont be able to see the jobs.

Post back if probs.........

Cheers

SG

Missing History for Jobs (msdb.dbo.sysjobhistory)

New server running our SQL... upgrade from Advanced 2000 to Enterprise
2003... our SQL Instance normally records all history (View History from Job
s
in SQL Agent). For some reason, currently unknown, history disappears every
so often. In this case, all history from 11/24 going backward is gone. All
history from 11/25 through today is here. This happened previously. Is
there any logical explanation for this? I'd settle for a server reboot, but
to my knowledge, this did not happen either.
Also there is a disk space problem on one of the drives. The msdb does not
touch that drive so, in my way of thinking the drive space issue cannot be
connected to the missing history (sysjobhistory). Is this logical to assume
?
An additional thought comes to mind. The jobs were imported from one server
to another. The owner was either the service account (with plenty of
permission) or the sa account, but the jobs were recreated from script using
the sa login. Could this have an effect on the job history?
--
Regards,
JamieAlso I believe this is happenning each week. Saturday night or Sunday
morning to be sure.
--
Regards,
Jamie
"thejamie" wrote:

> New server running our SQL... upgrade from Advanced 2000 to Enterprise
> 2003... our SQL Instance normally records all history (View History from J
obs
> in SQL Agent). For some reason, currently unknown, history disappears eve
ry
> so often. In this case, all history from 11/24 going backward is gone. A
ll
> history from 11/25 through today is here. This happened previously. Is
> there any logical explanation for this? I'd settle for a server reboot, b
ut
> to my knowledge, this did not happen either.
> Also there is a disk space problem on one of the drives. The msdb does no
t
> touch that drive so, in my way of thinking the drive space issue cannot be
> connected to the missing history (sysjobhistory). Is this logical to assu
me?
> An additional thought comes to mind. The jobs were imported from one serv
er
> to another. The owner was either the service account (with plenty of
> permission) or the sa account, but the jobs were recreated from script usi
ng
> the sa login. Could this have an effect on the job history?
> --
> Regards,
> Jamie|||thejamie,
Recreating the jobs would cause them to have a new job_id, so any history
records that might still exist in sysjobhistory will no longer join to
existing jobs. (If you still have your previous server and can figure out
the old job_id to new job_id mapping, you could update rowsn in your
sysjobhistory and all would be well.)
Also, make sure that your SQL Agent Properties - History settings are the
same on you new server as your old, or you will find SQL Agent (by default)
deleting history fairly frequently.
RLF
"thejamie" <thejamie@.discussions.microsoft.com> wrote in message
news:C078BDDA-ED20-4F42-AD0E-2FF1AED4EE7F@.microsoft.com...
> New server running our SQL... upgrade from Advanced 2000 to Enterprise
> 2003... our SQL Instance normally records all history (View History from
> Jobs
> in SQL Agent). For some reason, currently unknown, history disappears
> every
> so often. In this case, all history from 11/24 going backward is gone.
> All
> history from 11/25 through today is here. This happened previously. Is
> there any logical explanation for this? I'd settle for a server reboot,
> but
> to my knowledge, this did not happen either.
> Also there is a disk space problem on one of the drives. The msdb does
> not
> touch that drive so, in my way of thinking the drive space issue cannot be
> connected to the missing history (sysjobhistory). Is this logical to
> assume?
> An additional thought comes to mind. The jobs were imported from one
> server
> to another. The owner was either the service account (with plenty of
> permission) or the sa account, but the jobs were recreated from script
> using
> the sa login. Could this have an effect on the job history?
> --
> Regards,
> Jamie|||Thanks for the reply Russell. Actually, I moved the data over on 11/4. I
didn't expect any history to go back before the move. What bothers me is
that on Saturday I had history going back to 11/4. On Sunday, it extended
only from 11/25. Everything prior to 11/24 is wiped. It still exists in
sysjobhistory. I am not the sole DBA so it is possible that someone other
than myself wiped it, but I have to presume that is not the case. It isn't
vital. I can filter the log for a given job to get the history. The histor
y
was set to 1000 - I have lots of disk space at the moment so I moved it to
10000 and from 100 to 1000 on the rows. Still a mystery. I suspect that
the disk space on the one drive being low may have something to do with the
history disappearing.
--
Regards,
Jamie
"Russell Fields" wrote:

> thejamie,
> Recreating the jobs would cause them to have a new job_id, so any history
> records that might still exist in sysjobhistory will no longer join to
> existing jobs. (If you still have your previous server and can figure out
> the old job_id to new job_id mapping, you could update rowsn in your
> sysjobhistory and all would be well.)
> Also, make sure that your SQL Agent Properties - History settings are the
> same on you new server as your old, or you will find SQL Agent (by default
)
> deleting history fairly frequently.
> RLF
> "thejamie" <thejamie@.discussions.microsoft.com> wrote in message
> news:C078BDDA-ED20-4F42-AD0E-2FF1AED4EE7F@.microsoft.com...
>
>|||Jamie,
If the rows are still in sysjobhistory then they should connect to the jobs.
If the jobs will not show history further back than 11/24, then did someone
redeploy the jobs again, such that they got new job_ids?
RLF
"thejamie" <thejamie@.discussions.microsoft.com> wrote in message
news:A8C507C7-D1B6-46FF-AD2F-9E9EBCF829F5@.microsoft.com...[vbcol=seagreen]
> Thanks for the reply Russell. Actually, I moved the data over on 11/4. I
> didn't expect any history to go back before the move. What bothers me is
> that on Saturday I had history going back to 11/4. On Sunday, it extended
> only from 11/25. Everything prior to 11/24 is wiped. It still exists in
> sysjobhistory. I am not the sole DBA so it is possible that someone other
> than myself wiped it, but I have to presume that is not the case. It
> isn't
> vital. I can filter the log for a given job to get the history. The
> history
> was set to 1000 - I have lots of disk space at the moment so I moved it to
> 10000 and from 100 to 1000 on the rows. Still a mystery. I suspect that
> the disk space on the one drive being low may have something to do with
> the
> history disappearing.
> --
> Regards,
> Jamie
>
> "Russell Fields" wrote:
>|||Sounds very possible. Thanks.
--
Regards,
Jamie
"Russell Fields" wrote:

> Jamie,
> If the rows are still in sysjobhistory then they should connect to the job
s.
> If the jobs will not show history further back than 11/24, then did someon
e
> redeploy the jobs again, such that they got new job_ids?
> RLF
>
> "thejamie" <thejamie@.discussions.microsoft.com> wrote in message
> news:A8C507C7-D1B6-46FF-AD2F-9E9EBCF829F5@.microsoft.com...
>
>

Missing DLL during installation - reposted from SQL Express forum

XP PRO SP2

I downloaded and installed SQL Server 2005 Express with Advanced Services (9.0.3042.0). The installation appeared to complete successfully and I looked at various options of Management Studio. After exiting, rebooting, and restarting Management Studio, I got the message, (paraphrased) Management Studio failed to initiate - terminating. After using Add/Remove to remove all installed components, I reran the installation. I got two error messages indicating that xpstar90.dll is missing. Did not see these messages during the first install.

Log SQL0003_mycomputername_SQL contains these errors:

Error Code: 17750
MSI (s) (94!58) [18:24:53:031]: Product: Microsoft SQL Server 2005 -- Error 29521. SQL Server Setup failed to execute a command for server configuration. The error was [Microsoft][SQL Native Client][SQL Server]Could not load the DLL xpstar90.dll, or one of the DLLs it references. Reason: 2(The system cannot find the file specified.).. Refer to the server error logs and Setup logs for detailed error information.

Error 29521. SQL Server Setup failed to execute a command for server configuration. The error was [Microsoft][SQL Native Client][SQL Server]Could not load the DLL xpstar90.dll, or one of the DLLs it references. Reason: 2(The system cannot find the file specified.).. Refer to the server error logs and Setup logs for detailed error information.

SQL_ERROR (-1) in OdbcStatement::execute_batch
sqlstate=42000, level=16, state=1, native_error=17750, msg=[Microsoft][SQL Native Client][SQL Server]Could not load the DLL xpstar90.dll, or one of the DLLs it references. Reason: 2(The system cannot find the file specified.).
sqlstate=42000, level=16, state=1, native_error=14658, msg=[Microsoft][SQL Native Client][SQL Server]Failed to retrieve SQLPath for syssubsystems population.

Error Code: 0x80074556 (17750)
Windows Error Text: Source File Name: lib\odbc_statement.h
Compiler Timestamp: Wed Jun 14 16:28:15 2006
Function Name: OdbcStatement::execute_batch@.sysdbupg.sql@.113
Source Line Number: 91

Log SQL0003_mycomputername_Core reported:

Error: Action "LaunchLocalBootstrapAction" threw an exception during execution. Error information reported during run:
"c:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\setup.exe" finished and returned: 17750
Aborting queue processing as nested installer has completed
Message pump returning: 17750

Log SQL003_mycomputername_Core(Local) reported:

Action: "UninstallForMSDE2000Action" will be marked as failed due to the following condition:
Condition "sql was successfully upgraded." returned false. Condition context:
sql failed to upgrade and so the uninstall of the upgraded product will not occur.
Installation of package: "patchMSDE2000" failed due to a precondition.
Error: Action "UninstallForSQLAction" failed during execution. Error information reported during run:
Action: "UninstallForSQLAction" will be marked as failed due to the following condition:
Condition "sql was successfully upgraded." returned false. Condition context:
sql failed to upgrade and so the uninstall of the upgraded product will not occur.
Installation of package: "patchLibertySql" failed due to a precondition.
Skipped: UninstallForRS2000Action
Skipped: Action "UninstallForRS2000Action" was not run. Information reported during analysis:
Action: "UninstallForRS2000Action" will be skipped due to the following condition:
Condition "Action: InstallRSAction was skipped." returned true.
Error: Action "ExposeVistaClusteredResources" failed during execution. Error information reported during run:
Action: "ExposeVistaClusteredResources" will be marked as failed due to the following condition:
Condition "The Clustered SQL Server instance that hosts is installed." returned false.
Running: ReportChainingResults at: 2007/8/11 18:27:5
Error: Action "ReportChainingResults" threw an exception during execution.
One or more packages failed to install. Refer to logs for error details. : 17750
Error Code: 0x80074556 (17750)
Windows Error Text: Source File Name: sqlchaining\sqlchainingactions.cpp
Compiler Timestamp: Thu Nov 16 20:31:57 2006
Function Name: sqls::ReportChainingResults:erform
Source Line Number: 3521

- Context --
sqls::HostSetupPackageInstallerSynchstCommit
sqls::HighlyAvailablePackage:reInstall
led due to cancel code received from cancel source: 29539

Error: Failed to add file :"C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0003_DCHJL761_.NET Framework 2.0.log" to cab file : "C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\SqlSetup0003.cab" Error Code : 2
Running: UploadDrWatsonLogAction at: 2007/8/11 18:29:5
Message pump returning: 17750

No other log contained a related error message.

A third attempt to install resulted in a Failure to create database files.

Hi,

Sql Server 205 Express SP2 will NOT Install, the datbase services section fails -> Can not start service. I believe a previous botched installation and registry settings are preventing a sucessfull re-install. I have not found a solution yet. The machine is WIndows XP SP2.

I am getting almost the same error in the logs.

Running: ReportChainingResults at: 2007/8/13 19:25:44
Error: Action "ReportChainingResults" threw an exception during execution.
One or more packages failed to install. Refer to logs for error details. : 3
Error Code: 0x80070003 (3)
Windows Error Text: The system cannot find the path specified.

Source File Name: sqlchaining\sqlchainingactions.cpp
Compiler Timestamp: Thu Nov 16 20:31:57 2006
Function Name: sqls::ReportChainingResults:erform
Source Line Number: 3521

- Context --
sqls::HostSetupPackageInstallerSynch:ostCommit
sqls::HighlyAvailablePackage:reInstall
led due to cancel code received from cancel source: 29539

Error: Failed to add file :"C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0002_IBM-D5CDBD4C907_.NET Framework 2.0.log" to cab file : "C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\SqlSetup0002.cab" Error Code : 2
Running: UploadDrWatsonLogAction at: 2007/8/13 19:28:42
Message pump returning: 3

|||

Actually, there was a error message box that flashed at some point. After finally trapping it so the message could be read, It said something about the .NET 2.0 components being corrupt ot not installed.

Removing the .NET 2.0 Framework and all SqlServer components, rebooting and then re-installing fixed the issue!

Missing DLL during installation - reposted from SQL Express forum

XP PRO SP2

I downloaded and installed SQL Server 2005 Express with Advanced Services (9.0.3042.0). The installation appeared to complete successfully and I looked at various options of Management Studio. After exiting, rebooting, and restarting Management Studio, I got the message, (paraphrased) Management Studio failed to initiate - terminating. After using Add/Remove to remove all installed components, I reran the installation. I got two error messages indicating that xpstar90.dll is missing. Did not see these messages during the first install.

Log SQL0003_mycomputername_SQL contains these errors:

Error Code: 17750
MSI (s) (94!58) [18:24:53:031]: Product: Microsoft SQL Server 2005 -- Error 29521. SQL Server Setup failed to execute a command for server configuration. The error was [Microsoft][SQL Native Client][SQL Server]Could not load the DLL xpstar90.dll, or one of the DLLs it references. Reason: 2(The system cannot find the file specified.).. Refer to the server error logs and Setup logs for detailed error information.

Error 29521. SQL Server Setup failed to execute a command for server configuration. The error was [Microsoft][SQL Native Client][SQL Server]Could not load the DLL xpstar90.dll, or one of the DLLs it references. Reason: 2(The system cannot find the file specified.).. Refer to the server error logs and Setup logs for detailed error information.

SQL_ERROR (-1) in OdbcStatement::execute_batch
sqlstate=42000, level=16, state=1, native_error=17750, msg=[Microsoft][SQL Native Client][SQL Server]Could not load the DLL xpstar90.dll, or one of the DLLs it references. Reason: 2(The system cannot find the file specified.).
sqlstate=42000, level=16, state=1, native_error=14658, msg=[Microsoft][SQL Native Client][SQL Server]Failed to retrieve SQLPath for syssubsystems population.

Error Code: 0x80074556 (17750)
Windows Error Text: Source File Name: lib\odbc_statement.h
Compiler Timestamp: Wed Jun 14 16:28:15 2006
Function Name: OdbcStatement::execute_batch@.sysdbupg.sql@.113
Source Line Number: 91

Log SQL0003_mycomputername_Core reported:

Error: Action "LaunchLocalBootstrapAction" threw an exception during execution. Error information reported during run:
"c:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\setup.exe" finished and returned: 17750
Aborting queue processing as nested installer has completed
Message pump returning: 17750

Log SQL003_mycomputername_Core(Local) reported:

Action: "UninstallForMSDE2000Action" will be marked as failed due to the following condition:
Condition "sql was successfully upgraded." returned false. Condition context:
sql failed to upgrade and so the uninstall of the upgraded product will not occur.
Installation of package: "patchMSDE2000" failed due to a precondition.
Error: Action "UninstallForSQLAction" failed during execution. Error information reported during run:
Action: "UninstallForSQLAction" will be marked as failed due to the following condition:
Condition "sql was successfully upgraded." returned false. Condition context:
sql failed to upgrade and so the uninstall of the upgraded product will not occur.
Installation of package: "patchLibertySql" failed due to a precondition.
Skipped: UninstallForRS2000Action
Skipped: Action "UninstallForRS2000Action" was not run. Information reported during analysis:
Action: "UninstallForRS2000Action" will be skipped due to the following condition:
Condition "Action: InstallRSAction was skipped." returned true.
Error: Action "ExposeVistaClusteredResources" failed during execution. Error information reported during run:
Action: "ExposeVistaClusteredResources" will be marked as failed due to the following condition:
Condition "The Clustered SQL Server instance that hosts is installed." returned false.
Running: ReportChainingResults at: 2007/8/11 18:27:5
Error: Action "ReportChainingResults" threw an exception during execution.
One or more packages failed to install. Refer to logs for error details. : 17750
Error Code: 0x80074556 (17750)
Windows Error Text: Source File Name: sqlchaining\sqlchainingactions.cpp
Compiler Timestamp: Thu Nov 16 20:31:57 2006
Function Name: sqls::ReportChainingResults:erform
Source Line Number: 3521

- Context --
sqls::HostSetupPackageInstallerSynchstCommit
sqls::HighlyAvailablePackage:reInstall
led due to cancel code received from cancel source: 29539

Error: Failed to add file :"C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0003_DCHJL761_.NET Framework 2.0.log" to cab file : "C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\SqlSetup0003.cab" Error Code : 2
Running: UploadDrWatsonLogAction at: 2007/8/11 18:29:5
Message pump returning: 17750

No other log contained a related error message.

A third attempt to install resulted in a Failure to create database files.

Hi,

Sql Server 205 Express SP2 will NOT Install, the datbase services section fails -> Can not start service. I believe a previous botched installation and registry settings are preventing a sucessfull re-install. I have not found a solution yet. The machine is WIndows XP SP2.

I am getting almost the same error in the logs.

Running: ReportChainingResults at: 2007/8/13 19:25:44
Error: Action "ReportChainingResults" threw an exception during execution.
One or more packages failed to install. Refer to logs for error details. : 3
Error Code: 0x80070003 (3)
Windows Error Text: The system cannot find the path specified.

Source File Name: sqlchaining\sqlchainingactions.cpp
Compiler Timestamp: Thu Nov 16 20:31:57 2006
Function Name: sqls::ReportChainingResults:erform
Source Line Number: 3521

- Context --
sqls::HostSetupPackageInstallerSynch:ostCommit
sqls::HighlyAvailablePackage:reInstall
led due to cancel code received from cancel source: 29539

Error: Failed to add file :"C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0002_IBM-D5CDBD4C907_.NET Framework 2.0.log" to cab file : "C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\SqlSetup0002.cab" Error Code : 2
Running: UploadDrWatsonLogAction at: 2007/8/13 19:28:42
Message pump returning: 3

|||

Actually, there was a error message box that flashed at some point. After finally trapping it so the message could be read, It said something about the .NET 2.0 components being corrupt ot not installed.

Removing the .NET 2.0 Framework and all SqlServer components, rebooting and then re-installing fixed the issue!

Missing DLL during installation - reposted from SQL Express forum

XP PRO SP2

I downloaded and installed SQL Server 2005 Express with Advanced Services (9.0.3042.0). The installation appeared to complete successfully and I looked at various options of Management Studio. After exiting, rebooting, and restarting Management Studio, I got the message, (paraphrased) Management Studio failed to initiate - terminating. After using Add/Remove to remove all installed components, I reran the installation. I got two error messages indicating that xpstar90.dll is missing. Did not see these messages during the first install.

Log SQL0003_mycomputername_SQL contains these errors:

Error Code: 17750
MSI (s) (94!58) [18:24:53:031]: Product: Microsoft SQL Server 2005 -- Error 29521. SQL Server Setup failed to execute a command for server configuration. The error was [Microsoft][SQL Native Client][SQL Server]Could not load the DLL xpstar90.dll, or one of the DLLs it references. Reason: 2(The system cannot find the file specified.).. Refer to the server error logs and Setup logs for detailed error information.

Error 29521. SQL Server Setup failed to execute a command for server configuration. The error was [Microsoft][SQL Native Client][SQL Server]Could not load the DLL xpstar90.dll, or one of the DLLs it references. Reason: 2(The system cannot find the file specified.).. Refer to the server error logs and Setup logs for detailed error information.

SQL_ERROR (-1) in OdbcStatement::execute_batch
sqlstate=42000, level=16, state=1, native_error=17750, msg=[Microsoft][SQL Native Client][SQL Server]Could not load the DLL xpstar90.dll, or one of the DLLs it references. Reason: 2(The system cannot find the file specified.).
sqlstate=42000, level=16, state=1, native_error=14658, msg=[Microsoft][SQL Native Client][SQL Server]Failed to retrieve SQLPath for syssubsystems population.

Error Code: 0x80074556 (17750)
Windows Error Text: Source File Name: lib\odbc_statement.h
Compiler Timestamp: Wed Jun 14 16:28:15 2006
Function Name: OdbcStatement::execute_batch@.sysdbupg.sql@.113
Source Line Number: 91

Log SQL0003_mycomputername_Core reported:

Error: Action "LaunchLocalBootstrapAction" threw an exception during execution. Error information reported during run:
"c:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\setup.exe" finished and returned: 17750
Aborting queue processing as nested installer has completed
Message pump returning: 17750

Log SQL003_mycomputername_Core(Local) reported:

Action: "UninstallForMSDE2000Action" will be marked as failed due to the following condition:
Condition "sql was successfully upgraded." returned false. Condition context:
sql failed to upgrade and so the uninstall of the upgraded product will not occur.
Installation of package: "patchMSDE2000" failed due to a precondition.
Error: Action "UninstallForSQLAction" failed during execution. Error information reported during run:
Action: "UninstallForSQLAction" will be marked as failed due to the following condition:
Condition "sql was successfully upgraded." returned false. Condition context:
sql failed to upgrade and so the uninstall of the upgraded product will not occur.
Installation of package: "patchLibertySql" failed due to a precondition.
Skipped: UninstallForRS2000Action
Skipped: Action "UninstallForRS2000Action" was not run. Information reported during analysis:
Action: "UninstallForRS2000Action" will be skipped due to the following condition:
Condition "Action: InstallRSAction was skipped." returned true.
Error: Action "ExposeVistaClusteredResources" failed during execution. Error information reported during run:
Action: "ExposeVistaClusteredResources" will be marked as failed due to the following condition:
Condition "The Clustered SQL Server instance that hosts is installed." returned false.
Running: ReportChainingResults at: 2007/8/11 18:27:5
Error: Action "ReportChainingResults" threw an exception during execution.
One or more packages failed to install. Refer to logs for error details. : 17750
Error Code: 0x80074556 (17750)
Windows Error Text: Source File Name: sqlchaining\sqlchainingactions.cpp
Compiler Timestamp: Thu Nov 16 20:31:57 2006
Function Name: sqls::ReportChainingResults:erform
Source Line Number: 3521

- Context --
sqls::HostSetupPackageInstallerSynchstCommit
sqls::HighlyAvailablePackage:reInstall
led due to cancel code received from cancel source: 29539

Error: Failed to add file :"C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0003_DCHJL761_.NET Framework 2.0.log" to cab file : "C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\SqlSetup0003.cab" Error Code : 2
Running: UploadDrWatsonLogAction at: 2007/8/11 18:29:5
Message pump returning: 17750

No other log contained a related error message.

A third attempt to install resulted in a Failure to create database files.

Hi,

Sql Server 205 Express SP2 will NOT Install, the datbase services section fails -> Can not start service. I believe a previous botched installation and registry settings are preventing a sucessfull re-install. I have not found a solution yet. The machine is WIndows XP SP2.

I am getting almost the same error in the logs.

Running: ReportChainingResults at: 2007/8/13 19:25:44
Error: Action "ReportChainingResults" threw an exception during execution.
One or more packages failed to install. Refer to logs for error details. : 3
Error Code: 0x80070003 (3)
Windows Error Text: The system cannot find the path specified.

Source File Name: sqlchaining\sqlchainingactions.cpp
Compiler Timestamp: Thu Nov 16 20:31:57 2006
Function Name: sqls::ReportChainingResults:erform
Source Line Number: 3521

- Context --
sqls::HostSetupPackageInstallerSynch:ostCommit
sqls::HighlyAvailablePackage:reInstall
led due to cancel code received from cancel source: 29539

Error: Failed to add file :"C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0002_IBM-D5CDBD4C907_.NET Framework 2.0.log" to cab file : "C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\SqlSetup0002.cab" Error Code : 2
Running: UploadDrWatsonLogAction at: 2007/8/13 19:28:42
Message pump returning: 3

|||

Actually, there was a error message box that flashed at some point. After finally trapping it so the message could be read, It said something about the .NET 2.0 components being corrupt ot not installed.

Removing the .NET 2.0 Framework and all SqlServer components, rebooting and then re-installing fixed the issue!

Missing DLL during installation

XP PRO SP2

I downloaded and installed SQL Server 2005 Express with Advanced Services (9.0.3042.0). The installation appeared to complete successfully and I looked at various options of Management Studio. After exiting, rebooting, and restarting Management Studio, I got the message, (paraphrased) Management Studio failed to initiate - terminating. After using Add/Remove to remove all installed components, I reran the installation. I got two error messages indicating that xpstar90.dll is missing. Did not see these messages during the first install.

Log SQL0003_mycomputername_SQL contains these errors:

Error Code: 17750
MSI (s) (94!58) [18:24:53:031]: Product: Microsoft SQL Server 2005 -- Error 29521. SQL Server Setup failed to execute a command for server configuration. The error was [Microsoft][SQL Native Client][SQL Server]Could not load the DLL xpstar90.dll, or one of the DLLs it references. Reason: 2(The system cannot find the file specified.).. Refer to the server error logs and Setup logs for detailed error information.

Error 29521. SQL Server Setup failed to execute a command for server configuration. The error was [Microsoft][SQL Native Client][SQL Server]Could not load the DLL xpstar90.dll, or one of the DLLs it references. Reason: 2(The system cannot find the file specified.).. Refer to the server error logs and Setup logs for detailed error information.

SQL_ERROR (-1) in OdbcStatement::execute_batch
sqlstate=42000, level=16, state=1, native_error=17750, msg=[Microsoft][SQL Native Client][SQL Server]Could not load the DLL xpstar90.dll, or one of the DLLs it references. Reason: 2(The system cannot find the file specified.).
sqlstate=42000, level=16, state=1, native_error=14658, msg=[Microsoft][SQL Native Client][SQL Server]Failed to retrieve SQLPath for syssubsystems population.

Error Code: 0x80074556 (17750)
Windows Error Text: Source File Name: lib\odbc_statement.h
Compiler Timestamp: Wed Jun 14 16:28:15 2006
Function Name: OdbcStatement::execute_batch@.sysdbupg.sql@.113
Source Line Number: 91

Log SQL0003_mycomputername_Core reported:

Error: Action "LaunchLocalBootstrapAction" threw an exception during execution. Error information reported during run:
"c:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\setup.exe" finished and returned: 17750
Aborting queue processing as nested installer has completed
Message pump returning: 17750

Log SQL003_mycomputername_Core(Local) reported:

Action: "UninstallForMSDE2000Action" will be marked as failed due to the following condition:
Condition "sql was successfully upgraded." returned false. Condition context:
sql failed to upgrade and so the uninstall of the upgraded product will not occur.
Installation of package: "patchMSDE2000" failed due to a precondition.
Error: Action "UninstallForSQLAction" failed during execution. Error information reported during run:
Action: "UninstallForSQLAction" will be marked as failed due to the following condition:
Condition "sql was successfully upgraded." returned false. Condition context:
sql failed to upgrade and so the uninstall of the upgraded product will not occur.
Installation of package: "patchLibertySql" failed due to a precondition.
Skipped: UninstallForRS2000Action
Skipped: Action "UninstallForRS2000Action" was not run. Information reported during analysis:
Action: "UninstallForRS2000Action" will be skipped due to the following condition:
Condition "Action: InstallRSAction was skipped." returned true.
Error: Action "ExposeVistaClusteredResources" failed during execution. Error information reported during run:
Action: "ExposeVistaClusteredResources" will be marked as failed due to the following condition:
Condition "The Clustered SQL Server instance that hosts is installed." returned false.
Running: ReportChainingResults at: 2007/8/11 18:27:5
Error: Action "ReportChainingResults" threw an exception during execution.
One or more packages failed to install. Refer to logs for error details. : 17750
Error Code: 0x80074556 (17750)
Windows Error Text: Source File Name: sqlchaining\sqlchainingactions.cpp
Compiler Timestamp: Thu Nov 16 20:31:57 2006
Function Name: sqls::ReportChainingResults:erform
Source Line Number: 3521

- Context --
sqls::HostSetupPackageInstallerSynch:ostCommit
sqls::HighlyAvailablePackage:reInstall
led due to cancel code received from cancel source: 29539

Error: Failed to add file :"C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0003_DCHJL761_.NET Framework 2.0.log" to cab file : "C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\SqlSetup0003.cab" Error Code : 2
Running: UploadDrWatsonLogAction at: 2007/8/11 18:29:5
Message pump returning: 17750

No other log contained a related error message.

A third attempt to install resulted in a Failure to create database files.

I see that I should have posted this in the SQL Express Setup and Upgrade forum. I've reposted there.