Mobile 5.0 app can not connect to SQL 2005 Express

I'm using VS2005 pro to develop one windows form and one Mobile5.0 app ,
they are simple apps and just connect to SQL server to get data. The SQL
servers include Win2K + SQL2K, Win2K3 + SQL2K5 std and Win2K3 + SQL2K5
Express.
All works fine until one day I updated Win2K3 patches to the sql server via
windows update.
The mobile 5.0 app can not connect the SQL 2005 express any more, it will
get error message:
"Can not find specific sql server SERVERNAME\SQLEXPRESS", I didn't change
any codes
or settings. But it still can connect to SQL2000 or SQL 2005 std.
The Windows app is able to connect to SQL2000/SQL2005 std/SQL 2005 express
without
any problem.
Any clue? thanks in advance!Apparently, that's not a supported configuration. I'd seen that some
people had tried it and gotten it to work, so maybe MS did something
active to turn it off.|||I don't know why it wouldn't be supported. I assume you are using SQLClient
to connect to SQL Express? Do you get an error message on the client? Are
there any errors in the SQL Express error log?
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
"rick" <rickkozak@.hotmail.com> wrote in message
news:1149164611.354005.100770@.y43g2000cwc.googlegroups.com...
> Apparently, that's not a supported configuration. I'd seen that some
> people had tried it and gotten it to work, so maybe MS did something
> active to turn it off.
>|||Yes, I used the System.Data.SQLClient in the Mobile 5.0 app.
The problem here is it works for SQL 2005 Express in the begining.
But it's failed after applying windows 2003 patches.
"Roger Wolter[MSFT]" <rwolter@.online.microsoft.com> glsD:OXJ020chGHA.3756@.TK2MSFTNGP02.
phx.gbl...
>I don't know why it wouldn't be supported. I assume you are using
>SQLClient to connect to SQL Express? Do you get an error message on the
>client? Are there any errors in the SQL Express error log?
> --
> 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
> "rick" <rickkozak@.hotmail.com> wrote in message
> news:1149164611.354005.100770@.y43g2000cwc.googlegroups.com...
>|||Sorry, if "failed" is all you're willing to tell us, I don't think we can be
of much help. Depending on which patches you installed, some network or
security setting may have changed.
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
"RedHair" <redhair@.ms40.url.com.tw> wrote in message
news:u5ZPZihhGHA.4388@.TK2MSFTNGP05.phx.gbl...
> Yes, I used the System.Data.SQLClient in the Mobile 5.0 app.
> The problem here is it works for SQL 2005 Express in the begining.
> But it's failed after applying windows 2003 patches.
>
> "Roger Wolter[MSFT]" <rwolter@.online.microsoft.com>
> glsD:OXJ020chGHA.3756@.TK2MSFTNGP02.phx.gbl...
>|||In my orginal post , I have mentioned the error msg is
"Specified SQL server not found: ServerName\SQLEXPRESS"
"Roger Wolter[MSFT]" <rwolter@.online.microsoft.com> wrote in message
news:OKyb8alhGHA.3584@.TK2MSFTNGP04.phx.gbl...
> Sorry, if "failed" is all you're willing to tell us, I don't think we can
> be of much help. Depending on which patches you installed, some network
> or security setting may have changed.
> --
> 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
> "RedHair" <redhair@.ms40.url.com.tw> wrote in message
> news:u5ZPZihhGHA.4388@.TK2MSFTNGP05.phx.gbl...
>

Mobile 5.0 app can not connect to SQL 2005 Express

I'm using VS2005 pro to develop one windows form and one Mobile5.0 app ,
they are simple apps and just connect to SQL server to get data. The SQL
servers include Win2K + SQL2K, Win2K3 + SQL2K5 std and Win2K3 + SQL2K5
Express.
All works fine until one day I updated Win2K3 patches to the sql server via
windows update.
The mobile 5.0 app can not connect the SQL 2005 express any more, it will
get error message:
"Can not find specific sql server SERVERNAME\SQLEXPRESS", I didn't change
any codes
or settings. But it still can connect to SQL2000 or SQL 2005 std.
The Windows app is able to connect to SQL2000/SQL2005 std/SQL 2005 express
without
any problem.
Any clue? thanks in advance!Apparently, that's not a supported configuration. I'd seen that some
people had tried it and gotten it to work, so maybe MS did something
active to turn it off.|||I don't know why it wouldn't be supported. I assume you are using SQLClient
to connect to SQL Express? Do you get an error message on the client? Are
there any errors in the SQL Express error log?
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
"rick" <rickkozak@.hotmail.com> wrote in message
news:1149164611.354005.100770@.y43g2000cwc.googlegroups.com...
> Apparently, that's not a supported configuration. I'd seen that some
> people had tried it and gotten it to work, so maybe MS did something
> active to turn it off.
>|||Yes, I used the System.Data.SQLClient in the Mobile 5.0 app.
The problem here is it works for SQL 2005 Express in the begining.
But it's failed after applying windows 2003 patches.
"Roger Wolter[MSFT]" <rwolter@.online.microsoft.com> glsD:OXJ020chGHA.3756@.TK2M
SFTNGP02.phx.gbl...
>I don't know why it wouldn't be supported. I assume you are using
>SQLClient to connect to SQL Express? Do you get an error message on the
>client? Are there any errors in the SQL Express error log?
> --
> 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
> "rick" <rickkozak@.hotmail.com> wrote in message
> news:1149164611.354005.100770@.y43g2000cwc.googlegroups.com...
>|||Sorry, if "failed" is all you're willing to tell us, I don't think we can be
of much help. Depending on which patches you installed, some network or
security setting may have changed.
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
"RedHair" <redhair@.ms40.url.com.tw> wrote in message
news:u5ZPZihhGHA.4388@.TK2MSFTNGP05.phx.gbl...
> Yes, I used the System.Data.SQLClient in the Mobile 5.0 app.
> The problem here is it works for SQL 2005 Express in the begining.
> But it's failed after applying windows 2003 patches.
>
> "Roger Wolter[MSFT]" <rwolter@.online.microsoft.com>
> glsD:OXJ020chGHA.3756@.TK2MSFTNGP02.phx.gbl...
>|||In my orginal post , I have mentioned the error msg is
"Specified SQL server not found: ServerName\SQLEXPRESS"
"Roger Wolter[MSFT]" <rwolter@.online.microsoft.com> wrote in message
news:OKyb8alhGHA.3584@.TK2MSFTNGP04.phx.gbl...
> Sorry, if "failed" is all you're willing to tell us, I don't think we can
> be of much help. Depending on which patches you installed, some network
> or security setting may have changed.
> --
> 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
> "RedHair" <redhair@.ms40.url.com.tw> wrote in message
> news:u5ZPZihhGHA.4388@.TK2MSFTNGP05.phx.gbl...
>

missing SQL Server Agent

Hi,

I'm learning SQL 2005 and installed the express ADV edition to my pc. But I miss the Agent service.

Is this included in express? Has it another name after SQL server 2000?

thanks

majid

Looking at the edition comparison page (http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx), it looks like SQL Agent Job Scheduling Service only comes with Workgroup, Standard, and Enterprise.

Thanks,
Sam Lester (MSFT)|||

oh, I see, Thanx

majid

Missing Integration Service Template - fixed now

I have installed SQL Server 180 day evaluation as well as SQL Server Express but I cannot add a new SSIS project because the template is not there (- in the non-express instance - only Reporting Services). When I try and redo the SSIS part of setup(Add/Remove programs) the report tells me that it is already installed correctly. I have searched for others having this problem to no avail...

What do I need to do to fix it?

This may be a silly question but just wanted to make sure. Did you check the bottom option in the installation wizard for Workstation components and documentation? Also, when you look at the services, do you see the SSIS service installed?

-- Brian Knight

|||

Not a silly question but I had checked already and the SSIS service was installed and running and I had checked everything to install.

I tried to install the parts of sql that I could to D: rather than the default of C: and I installed SQL Express before the SQL 2005 EVAL (which I the realized that I needed for SSIS)

Then I posted the question and the decided to un and re-install.

I have now installed just the EVAL and it now works ok :-)

(In fact I see that there is also an Analysis Service Template there as well)

So the problem may have been with the order or the location?

I will be adding the SQL Express later so if it fails I will let you know...

Thanks anyway for the reply

|||

Not a silly question but I had checked already and the SSIS service was installed and running and I had checked everything to install.

I tried to install the parts of sql that I could to D: rather than the default of C: and I installed SQL Express before the SQL 2005 EVAL (which I the realized that I needed for SSIS)

Then I posted the question and the decided to un and re-install

I have now installed just the EVAL and it now works ok :-)

(In fact I see that there is also an Analysis Service Template there as well)

So the problem may have been with the order or the location?

I will be adding the SQL Express later so if it fails I will let you know...

Thanks anyway for the reply

|||

Your configuration should work fantastically. Not sure what gremlin reaked havok in your install but glad everything is fine now! I have your exact config and everything works well.

-- Brian Knight

Missing Integration Service Template

I have installed SQL Server 180 day evaluation as well as SQL Server Express but I cannot add a new SSIS project because the template is not there (- in the non-express instance - only Reporting Services). When I try and redo the SSIS part of setup(Add/Remove programs) the report tells me that it is already installed correctly. I have searched for others having this problem to no avail...

What do I need to do to fix it?

This may be a silly question but just wanted to make sure. Did you check the bottom option in the installation wizard for Workstation components and documentation? Also, when you look at the services, do you see the SSIS service installed?

-- Brian Knight

|||

Not a silly question but I had checked already and the SSIS service was installed and running and I had checked everything to install.

I tried to install the parts of sql that I could to D: rather than the default of C: and I installed SQL Express before the SQL 2005 EVAL (which I the realized that I needed for SSIS)

Then I posted the question and the decided to un and re-install.

I have now installed just the EVAL and it now works ok :-)

(In fact I see that there is also an Analysis Service Template there as well)

So the problem may have been with the order or the location?

I will be adding the SQL Express later so if it fails I will let you know...

Thanks anyway for the reply

|||

Not a silly question but I had checked already and the SSIS service was installed and running and I had checked everything to install.

I tried to install the parts of sql that I could to D: rather than the default of C: and I installed SQL Express before the SQL 2005 EVAL (which I the realized that I needed for SSIS)

Then I posted the question and the decided to un and re-install

I have now installed just the EVAL and it now works ok :-)

(In fact I see that there is also an Analysis Service Template there as well)

So the problem may have been with the order or the location?

I will be adding the SQL Express later so if it fails I will let you know...

Thanks anyway for the reply

|||

Your configuration should work fantastically. Not sure what gremlin reaked havok in your install but glad everything is fine now! I have your exact config and everything works well.

-- Brian Knight

Missing File

I am trying hard to get my downloaded SQL server express working.
I need to have use of the reporting services.
This appears on my start menu, but clicking it gives a message that
devenv.exe is missing and can't be found anywhere.
Where does devenv.exe come from - how can I get hold of it?
Thanks for helping this newbie.The Business Intelligence Development Studio.
The readme has the information you need - you need the
Express Edition Toolkit. You can find the download link at:
http://msdn.microsoft.com/vstudio/express/sql/download/
-Sue
On Sun, 03 Sep 2006 20:49:58 GMT, "PeeJayEll"
<nospamthanks@.hotmail.com> wrote:

>I am trying hard to get my downloaded SQL server express working.
>I need to have use of the reporting services.
>This appears on my start menu, but clicking it gives a message that
>devenv.exe is missing and can't be found anywhere.
>Where does devenv.exe come from - how can I get hold of it?
>Thanks for helping this newbie.
>
>

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.