Error 70038 on install Solved!

Hi all

I packaged .Net Framework & Sql Express with my setup project. When I attempt to install it on an XP (with SP2) system .Net Framework installs fine. The Sql Express gets about 25% of the way through then fails. Here's the content of the log file:

The following properties have been set:
Property: [AdminUser] = true {boolean}
Property: [ProcessorArchitecture] = Intel {string}
Property: [VersionNT] = 5.1.2 {version}
Running checks for package '.NET Framework 2.0', phase BuildList
Running external check with command line "C:\DOCUME~1\Gary\LOCALS~1\Temp\VSDA0.tmp\dotnetfx\dotnetchk.exe"
Process exited with code 1
Setting value '1 {int}' for property 'DotNetInstalled'
Reading value 'Version' of registry key 'HKLM\Software\Microsoft\Internet Explorer'
Read string value '6.0.2900.2180'
Setting value '6.0.2900.2180 {string}' for property 'IEVersion'
The following properties have been set for package '.NET Framework 2.0':
Property: [DotNetInstalled] = 1 {int}
Property: [IEVersion] = 6.0.2900.2180 {string}
Running checks for command 'dotnetfx\instmsia.exe'
Result of running operator 'ValueExists' on property 'VersionNT': true
Result of checks for command 'dotnetfx\instmsia.exe' is 'Bypass'
Running checks for command 'dotnetfx\WindowsInstaller-KB893803-v2-x86.exe'
Result of running operator 'ValueExists' on property 'Version9x': false
Result of running operator 'VersionLessThan' on property 'VersionNT' and value '5.0.3': false
Result of running operator 'VersionGreaterThanOrEqualTo' on property 'VersionMsi' and value '3.0': true
Result of checks for command 'dotnetfx\WindowsInstaller-KB893803-v2-x86.exe' is 'Bypass'
Running checks for command 'dotnetfx\dotnetfx.exe'
Result of running operator 'ValueNotEqualTo' on property 'DotNetInstalled' and value '0': true
Result of checks for command 'dotnetfx\dotnetfx.exe' is 'Bypass'
'.NET Framework 2.0' RunCheck result: No Install Needed
Running checks for package 'SQL Server 2005 Express Edition', phase BuildList
Running external check with command line "C:\DOCUME~1\Gary\LOCALS~1\Temp\VSDA0.tmp\SqlExpress\SqlExpressChk.exe"
Process exited with code 1
Setting value '1 {int}' for property 'SQLExpressInstalled'
The following properties have been set for package 'SQL Server 2005 Express Edition':
Property: [SQLExpressInstalled] = 1 {int}
Running checks for command 'SqlExpress\sqlexpr32.exe'
Result of running operator 'ValueEqualTo' on property 'SQLExpressInstalled' and value '0': false
Result of running operator 'VersionGreaterThanOrEqualTo' on property 'VersionNT' and value '5.1': true
Result of checks for command 'SqlExpress\sqlexpr32.exe' is 'Bypass'
Running checks for command 'SqlExpress\sqlexpr32.exe'
Result of running operator 'ValueEqualTo' on property 'SQLExpressInstalled' and value '0': false
Result of running operator 'VersionLessThan' on property 'VersionNT' and value '5.1': false
Result of running operator 'ValueEqualTo' on property 'AdminUser' and value 'false': false
Result of running operator 'ValueExists' on property 'Version9x': false
Result of running operator 'VersionLessThan' on property 'VersionNT' and value '5.1.2': false
Result of running operator 'ValueNotEqualTo' on property 'ProcessorArchitecture' and value 'Intel': false
Result of checks for command 'SqlExpress\sqlexpr32.exe' is 'Install'
'SQL Server 2005 Express Edition' RunCheck result: Install Needed
EULA for components 'SQL Server 2005 Express Edition' was accepted.
Copying files to temporary directory "C:\DOCUME~1\Gary\LOCALS~1\Temp\VSDA0.tmp\"
Copying from '\\.host\Shared Folders\G-CDRW\MovieCollection Setup\Debug\SqlExpress\sqlexpr32.exe' to 'C:\DOCUME~1\Gary\LOCALS~1\Temp\VSDA0.tmp\SqlExpress\sqlexpr32.exe'
Running checks for package 'SQL Server 2005 Express Edition', phase BeforePackage
Running external check with command line "C:\DOCUME~1\Gary\LOCALS~1\Temp\VSDA0.tmp\SqlExpress\SqlExpressChk.exe"
Process exited with code 1
Setting value '1 {int}' for property 'SQLExpressInstalled'
The following properties have been set for package 'SQL Server 2005 Express Edition':
Property: [SQLExpressInstalled] = 1 {int}
Running checks for command 'SqlExpress\sqlexpr32.exe'
Result of running operator 'ValueEqualTo' on property 'SQLExpressInstalled' and value '0': false
Result of running operator 'VersionLessThan' on property 'VersionNT' and value '5.1': false
Result of running operator 'ValueEqualTo' on property 'AdminUser' and value 'false': false
Result of running operator 'ValueExists' on property 'Version9x': false
Result of running operator 'VersionLessThan' on property 'VersionNT' and value '5.1.2': false
Result of running operator 'ValueNotEqualTo' on property 'ProcessorArchitecture' and value 'Intel': false
Result of checks for command 'SqlExpress\sqlexpr32.exe' is 'Install'
'SQL Server 2005 Express Edition' RunCheck result: Install Needed
Verifying file integrity of C:\DOCUME~1\Gary\LOCALS~1\Temp\VSDA0.tmp\SqlExpress\sqlexpr32.exe
WinVerifyTrust returned 0
File trusted
Installing using command line '"C:\DOCUME~1\Gary\LOCALS~1\Temp\VSDA0.tmp\SqlExpress\sqlexpr32.exe" -q /norebootchk /qn reboot=ReallySuppress addlocal=all instancename=SQLEXPRESS SQLAUTOSTART=1'
Process exited with code 70038
Status of package 'SQL Server 2005 Express Edition' after install is 'InstallFailed'

--

Any ideas?

TIA

Gary

Hi Gary,

I got the same error today on my Win XP SP2 workstation. An update for the MSI installer to Version 3.1 helped. After that, SQLexpress could be installed correctly.

Have a nice day

Ralf.

|||Hi Ralf

Thanks for your posting. Works beautifully!

Gary|||

I also got the same error,

I see in the log

Result of running operator 'VersionGreaterThanOrEqualTo' on property 'VersionNT' and value '5.1': true
Result of checks for command 'SqlExpress\sqlexpr32.exe' is 'Bypass'
Running checks for command 'SqlExpress\sqlexpr32.exe'

In the package.xml file it states that:

<BypassIf Property="VersionNT" Compare="VersionGreaterThanOrEqualTo" Value="5.1"/>

Should this be there? Why would we bypass sql installation if VersionNT is >= 5.1?

Error 70038 on install Solved!

Hi all

I packaged .Net Framework & Sql Express with my setup project. When I attempt to install it on an XP (with SP2) system .Net Framework installs fine. The Sql Express gets about 25% of the way through then fails. Here's the content of the log file:

The following properties have been set:
Property: [AdminUser] = true {boolean}
Property: [ProcessorArchitecture] = Intel {string}
Property: [VersionNT] = 5.1.2 {version}
Running checks for package '.NET Framework 2.0', phase BuildList
Running external check with command line "C:\DOCUME~1\Gary\LOCALS~1\Temp\VSDA0.tmp\dotnetfx\dotnetchk.exe"
Process exited with code 1
Setting value '1 {int}' for property 'DotNetInstalled'
Reading value 'Version' of registry key 'HKLM\Software\Microsoft\Internet Explorer'
Read string value '6.0.2900.2180'
Setting value '6.0.2900.2180 {string}' for property 'IEVersion'
The following properties have been set for package '.NET Framework 2.0':
Property: [DotNetInstalled] = 1 {int}
Property: [IEVersion] = 6.0.2900.2180 {string}
Running checks for command 'dotnetfx\instmsia.exe'
Result of running operator 'ValueExists' on property 'VersionNT': true
Result of checks for command 'dotnetfx\instmsia.exe' is 'Bypass'
Running checks for command 'dotnetfx\WindowsInstaller-KB893803-v2-x86.exe'
Result of running operator 'ValueExists' on property 'Version9x': false
Result of running operator 'VersionLessThan' on property 'VersionNT' and value '5.0.3': false
Result of running operator 'VersionGreaterThanOrEqualTo' on property 'VersionMsi' and value '3.0': true
Result of checks for command 'dotnetfx\WindowsInstaller-KB893803-v2-x86.exe' is 'Bypass'
Running checks for command 'dotnetfx\dotnetfx.exe'
Result of running operator 'ValueNotEqualTo' on property 'DotNetInstalled' and value '0': true
Result of checks for command 'dotnetfx\dotnetfx.exe' is 'Bypass'
'.NET Framework 2.0' RunCheck result: No Install Needed
Running checks for package 'SQL Server 2005 Express Edition', phase BuildList
Running external check with command line "C:\DOCUME~1\Gary\LOCALS~1\Temp\VSDA0.tmp\SqlExpress\SqlExpressChk.exe"
Process exited with code 1
Setting value '1 {int}' for property 'SQLExpressInstalled'
The following properties have been set for package 'SQL Server 2005 Express Edition':
Property: [SQLExpressInstalled] = 1 {int}
Running checks for command 'SqlExpress\sqlexpr32.exe'
Result of running operator 'ValueEqualTo' on property 'SQLExpressInstalled' and value '0': false
Result of running operator 'VersionGreaterThanOrEqualTo' on property 'VersionNT' and value '5.1': true
Result of checks for command 'SqlExpress\sqlexpr32.exe' is 'Bypass'
Running checks for command 'SqlExpress\sqlexpr32.exe'
Result of running operator 'ValueEqualTo' on property 'SQLExpressInstalled' and value '0': false
Result of running operator 'VersionLessThan' on property 'VersionNT' and value '5.1': false
Result of running operator 'ValueEqualTo' on property 'AdminUser' and value 'false': false
Result of running operator 'ValueExists' on property 'Version9x': false
Result of running operator 'VersionLessThan' on property 'VersionNT' and value '5.1.2': false
Result of running operator 'ValueNotEqualTo' on property 'ProcessorArchitecture' and value 'Intel': false
Result of checks for command 'SqlExpress\sqlexpr32.exe' is 'Install'
'SQL Server 2005 Express Edition' RunCheck result: Install Needed
EULA for components 'SQL Server 2005 Express Edition' was accepted.
Copying files to temporary directory "C:\DOCUME~1\Gary\LOCALS~1\Temp\VSDA0.tmp\"
Copying from '\\.host\Shared Folders\G-CDRW\MovieCollection Setup\Debug\SqlExpress\sqlexpr32.exe' to 'C:\DOCUME~1\Gary\LOCALS~1\Temp\VSDA0.tmp\SqlExpress\sqlexpr32.exe'
Running checks for package 'SQL Server 2005 Express Edition', phase BeforePackage
Running external check with command line "C:\DOCUME~1\Gary\LOCALS~1\Temp\VSDA0.tmp\SqlExpress\SqlExpressChk.exe"
Process exited with code 1
Setting value '1 {int}' for property 'SQLExpressInstalled'
The following properties have been set for package 'SQL Server 2005 Express Edition':
Property: [SQLExpressInstalled] = 1 {int}
Running checks for command 'SqlExpress\sqlexpr32.exe'
Result of running operator 'ValueEqualTo' on property 'SQLExpressInstalled' and value '0': false
Result of running operator 'VersionLessThan' on property 'VersionNT' and value '5.1': false
Result of running operator 'ValueEqualTo' on property 'AdminUser' and value 'false': false
Result of running operator 'ValueExists' on property 'Version9x': false
Result of running operator 'VersionLessThan' on property 'VersionNT' and value '5.1.2': false
Result of running operator 'ValueNotEqualTo' on property 'ProcessorArchitecture' and value 'Intel': false
Result of checks for command 'SqlExpress\sqlexpr32.exe' is 'Install'
'SQL Server 2005 Express Edition' RunCheck result: Install Needed
Verifying file integrity of C:\DOCUME~1\Gary\LOCALS~1\Temp\VSDA0.tmp\SqlExpress\sqlexpr32.exe
WinVerifyTrust returned 0
File trusted
Installing using command line '"C:\DOCUME~1\Gary\LOCALS~1\Temp\VSDA0.tmp\SqlExpress\sqlexpr32.exe" -q /norebootchk /qn reboot=ReallySuppress addlocal=all instancename=SQLEXPRESS SQLAUTOSTART=1'
Process exited with code 70038
Status of package 'SQL Server 2005 Express Edition' after install is 'InstallFailed'

--

Any ideas?

TIA

Gary

Hi Gary,

I got the same error today on my Win XP SP2 workstation. An update for the MSI installer to Version 3.1 helped. After that, SQLexpress could be installed correctly.

Have a nice day

Ralf.

|||Hi Ralf

Thanks for your posting. Works beautifully!

Gary|||

I also got the same error,

I see in the log

Result of running operator 'VersionGreaterThanOrEqualTo' on property 'VersionNT' and value '5.1': true
Result of checks for command 'SqlExpress\sqlexpr32.exe' is 'Bypass'
Running checks for command 'SqlExpress\sqlexpr32.exe'

In the package.xml file it states that:

<BypassIf Property="VersionNT" Compare="VersionGreaterThanOrEqualTo" Value="5.1"/>

Should this be there? Why would we bypass sql installation if VersionNT is >= 5.1?

Error 70038 on install

Hi all

I packaged .Net Framework & Sql Express with my setup project. When I attempt to install it on an XP (with SP2) system .Net Framework installs fine. The Sql Express gets about 25% of the way through then fails. Here's the content of the log file:

The following properties have been set:
Property: [AdminUser] = true {boolean}
Property: [ProcessorArchitecture] = Intel {string}
Property: [VersionNT] = 5.1.2 {version}
Running checks for package '.NET Framework 2.0', phase BuildList
Running external check with command line "C:\DOCUME~1\Gary\LOCALS~1\Temp\VSDA0.tmp\dotnetfx\dotnetchk.exe"
Process exited with code 1
Setting value '1 {int}' for property 'DotNetInstalled'
Reading value 'Version' of registry key 'HKLM\Software\Microsoft\Internet Explorer'
Read string value '6.0.2900.2180'
Setting value '6.0.2900.2180 {string}' for property 'IEVersion'
The following properties have been set for package '.NET Framework 2.0':
Property: [DotNetInstalled] = 1 {int}
Property: [IEVersion] = 6.0.2900.2180 {string}
Running checks for command 'dotnetfx\instmsia.exe'
Result of running operator 'ValueExists' on property 'VersionNT': true
Result of checks for command 'dotnetfx\instmsia.exe' is 'Bypass'
Running checks for command 'dotnetfx\WindowsInstaller-KB893803-v2-x86.exe'
Result of running operator 'ValueExists' on property 'Version9x': false
Result of running operator 'VersionLessThan' on property 'VersionNT' and value '5.0.3': false
Result of running operator 'VersionGreaterThanOrEqualTo' on property 'VersionMsi' and value '3.0': true
Result of checks for command 'dotnetfx\WindowsInstaller-KB893803-v2-x86.exe' is 'Bypass'
Running checks for command 'dotnetfx\dotnetfx.exe'
Result of running operator 'ValueNotEqualTo' on property 'DotNetInstalled' and value '0': true
Result of checks for command 'dotnetfx\dotnetfx.exe' is 'Bypass'
'.NET Framework 2.0' RunCheck result: No Install Needed
Running checks for package 'SQL Server 2005 Express Edition', phase BuildList
Running external check with command line "C:\DOCUME~1\Gary\LOCALS~1\Temp\VSDA0.tmp\SqlExpress\SqlExpressChk.exe"
Process exited with code 1
Setting value '1 {int}' for property 'SQLExpressInstalled'
The following properties have been set for package 'SQL Server 2005 Express Edition':
Property: [SQLExpressInstalled] = 1 {int}
Running checks for command 'SqlExpress\sqlexpr32.exe'
Result of running operator 'ValueEqualTo' on property 'SQLExpressInstalled' and value '0': false
Result of running operator 'VersionGreaterThanOrEqualTo' on property 'VersionNT' and value '5.1': true
Result of checks for command 'SqlExpress\sqlexpr32.exe' is 'Bypass'
Running checks for command 'SqlExpress\sqlexpr32.exe'
Result of running operator 'ValueEqualTo' on property 'SQLExpressInstalled' and value '0': false
Result of running operator 'VersionLessThan' on property 'VersionNT' and value '5.1': false
Result of running operator 'ValueEqualTo' on property 'AdminUser' and value 'false': false
Result of running operator 'ValueExists' on property 'Version9x': false
Result of running operator 'VersionLessThan' on property 'VersionNT' and value '5.1.2': false
Result of running operator 'ValueNotEqualTo' on property 'ProcessorArchitecture' and value 'Intel': false
Result of checks for command 'SqlExpress\sqlexpr32.exe' is 'Install'
'SQL Server 2005 Express Edition' RunCheck result: Install Needed
EULA for components 'SQL Server 2005 Express Edition' was accepted.
Copying files to temporary directory "C:\DOCUME~1\Gary\LOCALS~1\Temp\VSDA0.tmp\"
Copying from '\\.host\Shared Folders\G-CDRW\MovieCollection Setup\Debug\SqlExpress\sqlexpr32.exe' to 'C:\DOCUME~1\Gary\LOCALS~1\Temp\VSDA0.tmp\SqlExpress\sqlexpr32.exe'
Running checks for package 'SQL Server 2005 Express Edition', phase BeforePackage
Running external check with command line "C:\DOCUME~1\Gary\LOCALS~1\Temp\VSDA0.tmp\SqlExpress\SqlExpressChk.exe"
Process exited with code 1
Setting value '1 {int}' for property 'SQLExpressInstalled'
The following properties have been set for package 'SQL Server 2005 Express Edition':
Property: [SQLExpressInstalled] = 1 {int}
Running checks for command 'SqlExpress\sqlexpr32.exe'
Result of running operator 'ValueEqualTo' on property 'SQLExpressInstalled' and value '0': false
Result of running operator 'VersionLessThan' on property 'VersionNT' and value '5.1': false
Result of running operator 'ValueEqualTo' on property 'AdminUser' and value 'false': false
Result of running operator 'ValueExists' on property 'Version9x': false
Result of running operator 'VersionLessThan' on property 'VersionNT' and value '5.1.2': false
Result of running operator 'ValueNotEqualTo' on property 'ProcessorArchitecture' and value 'Intel': false
Result of checks for command 'SqlExpress\sqlexpr32.exe' is 'Install'
'SQL Server 2005 Express Edition' RunCheck result: Install Needed
Verifying file integrity of C:\DOCUME~1\Gary\LOCALS~1\Temp\VSDA0.tmp\SqlExpress\sqlexpr32.exe
WinVerifyTrust returned 0
File trusted
Installing using command line '"C:\DOCUME~1\Gary\LOCALS~1\Temp\VSDA0.tmp\SqlExpress\sqlexpr32.exe" -q /norebootchk /qn reboot=ReallySuppress addlocal=all instancename=SQLEXPRESS SQLAUTOSTART=1'
Process exited with code 70038
Status of package 'SQL Server 2005 Express Edition' after install is 'InstallFailed'

--

Any ideas?

TIA

Gary

Hi Gary,

I got the same error today on my Win XP SP2 workstation. An update for the MSI installer to Version 3.1 helped. After that, SQLexpress could be installed correctly.

Have a nice day

Ralf.

|||Hi Ralf

Thanks for your posting. Works beautifully!

Gary|||

I also got the same error,

I see in the log

Result of running operator 'VersionGreaterThanOrEqualTo' on property 'VersionNT' and value '5.1': true
Result of checks for command 'SqlExpress\sqlexpr32.exe' is 'Bypass'
Running checks for command 'SqlExpress\sqlexpr32.exe'

In the package.xml file it states that:

<BypassIf Property="VersionNT" Compare="VersionGreaterThanOrEqualTo" Value="5.1"/>

Should this be there? Why would we bypass sql installation if VersionNT is >= 5.1?

Error 40: could not open a connection to Mssql server

Hi,

I'm using sql server 2005 express edition. I have created a database using sql server management studio express edition. Now I'm trying to connect it in visual studio 2005. It show following error.

An error has occurred while establishing a connection to the server. When connections to SQL 5erver 2005, this failure may be caused by the fact under the server's default settings SQL Server does not allow remote connections, (provider: Named Pipes Provider, error: 40- Could not open a connection to SQL Server)

I have enables named pipes from Sql services configuration manager.

Hi,

Named Pipes Provider, error: 40 - Could not open a connection to SQL Server

Is just a basic connectivity error meaning the client could not connect to the target SQL Server. So just follow the basic connectivity troubleshooting guidelines on our SQL Protocols blog, see:

SQL Server 2005 Connectivity Issue Troubleshoot - Part I

http://blogs.msdn.com/sql_protocols/archive/2005/10/22/483684.aspx

and

SQL Server 2005 Connectivity Issue Troubleshoot - Part II

http://blogs.msdn.com/sql_protocols/archive/2005/10/29/486861.aspx

This should help you debug the problem.

error 40

I have VS2005, SQL 2000, SQL Express and SQL 2005 installed on my laptop wit
h
XP Pro. I have no problems connecting to SQL 2000 but get the following
error when I try to connect to SQL2005.
"When connecting to SQL Server 2005, this
failure may be caused by the fact that under the default settings SQL Server
does not allow remote connections. (provider: Named Pipes Provider, error: 4
0
- Could not open a connection to SQL Server")."
My connection String is as follows:
connectionString="Data Source=sql2005;Initial Catalog=TestDB;Integrated
Security=True"
Thanks for any help in advance.Hi
From the error message, it seems the connection stage was broken and I
would like to know if you have tried basic connectivity tests between the
two mahcines you are working on. One simple way to verifty connectivity is
to use command line tools, such as sqlcmd.exe. If it connects cross-machine
successfully, please also verify that your connection string in your
scenario is correct.
You may refer the articles below for more detailed information
Troubleshoot Connectivity Issue in SQL Server 2005 - Part III
http://blogs.msdn.com/sql_protocols.../22/506607.aspx
How to: Configure Express to accept remote connections
http://blogs.msdn.com/sqlexpress/ar.../05/415084.aspx
How do I manage / connect to SQL Server Express?
http://www.aspfaq.com/sql2005/show.asp?id=3
Thank you for your patience and cooperation. If you have any questions or
concerns, don't hesitate to let me know. We are always here to be of
assistance!
Sincerely yours,
Michael Cheng
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
========================================
=============
This posting is provided "AS IS" with no warranties, and confers no rights.|||Michael,
I do not have 2 machines, VS2005, SQL2005, SQL2000 are running on the same
machine for developement purposes.
Thanks.
"Michael Cheng [MSFT]" wrote:

> Hi
> From the error message, it seems the connection stage was broken and I
> would like to know if you have tried basic connectivity tests between the
> two mahcines you are working on. One simple way to verifty connectivity is
> to use command line tools, such as sqlcmd.exe. If it connects cross-machin
e
> successfully, please also verify that your connection string in your
> scenario is correct.
> You may refer the articles below for more detailed information
> Troubleshoot Connectivity Issue in SQL Server 2005 - Part III
> http://blogs.msdn.com/sql_protocols.../22/506607.aspx
> How to: Configure Express to accept remote connections
> http://blogs.msdn.com/sqlexpress/ar.../05/415084.aspx
> How do I manage / connect to SQL Server Express?
> http://www.aspfaq.com/sql2005/show.asp?id=3
> Thank you for your patience and cooperation. If you have any questions or
> concerns, don't hesitate to let me know. We are always here to be of
> assistance!
>
> Sincerely yours,
> Michael Cheng
> Microsoft Online Partner Support
> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> ========================================
=============
> This posting is provided "AS IS" with no warranties, and confers no rights
.
>|||Hi Chico,
Thanks for the prompt update.
What's the instance name of your SQL Express?
In your connection string, I have noticed "Data Source=sql2005", does your
machine named "SQL2005" and you installed SQL Server 2005 Express as
default instance?
If you installed SQL Server 2005 Express as named instance, you will have
to connect the instance using connection string like "Data
Source=.\sql2005" (Here, I assume sql2005 is the name for default instance)
Thank you for your patience and cooperation. If you have any questions or
concerns, don't hesitate to let me know. We are always here to be of
assistance!
Sincerely yours,
Michael Cheng
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
========================================
=============
This posting is provided "AS IS" with no warranties, and confers no rights.

error 40

I have VS2005, SQL 2000, SQL Express and SQL 2005 installed on my laptop with
XP Pro. I have no problems connecting to SQL 2000 but get the following
error when I try to connect to SQL2005.
"When connecting to SQL Server 2005, this
failure may be caused by the fact that under the default settings SQL Server
does not allow remote connections. (provider: Named Pipes Provider, error: 40
- Could not open a connection to SQL Server")."
My connection String is as follows:
connectionString="Data Source=sql2005;Initial Catalog=TestDB;Integrated
Security=True"
Thanks for any help in advance.
Hi
From the error message, it seems the connection stage was broken and I
would like to know if you have tried basic connectivity tests between the
two mahcines you are working on. One simple way to verifty connectivity is
to use command line tools, such as sqlcmd.exe. If it connects cross-machine
successfully, please also verify that your connection string in your
scenario is correct.
You may refer the articles below for more detailed information
Troubleshoot Connectivity Issue in SQL Server 2005 - Part III
http://blogs.msdn.com/sql_protocols/...22/506607.aspx
How to: Configure Express to accept remote connections
http://blogs.msdn.com/sqlexpress/arc...05/415084.aspx
How do I manage / connect to SQL Server Express?
http://www.aspfaq.com/sql2005/show.asp?id=3
Thank you for your patience and cooperation. If you have any questions or
concerns, don't hesitate to let me know. We are always here to be of
assistance!
Sincerely yours,
Michael Cheng
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
================================================== ===
This posting is provided "AS IS" with no warranties, and confers no rights.
|||Michael,
I do not have 2 machines, VS2005, SQL2005, SQL2000 are running on the same
machine for developement purposes.
Thanks.
"Michael Cheng [MSFT]" wrote:

> Hi
> From the error message, it seems the connection stage was broken and I
> would like to know if you have tried basic connectivity tests between the
> two mahcines you are working on. One simple way to verifty connectivity is
> to use command line tools, such as sqlcmd.exe. If it connects cross-machine
> successfully, please also verify that your connection string in your
> scenario is correct.
> You may refer the articles below for more detailed information
> Troubleshoot Connectivity Issue in SQL Server 2005 - Part III
> http://blogs.msdn.com/sql_protocols/...22/506607.aspx
> How to: Configure Express to accept remote connections
> http://blogs.msdn.com/sqlexpress/arc...05/415084.aspx
> How do I manage / connect to SQL Server Express?
> http://www.aspfaq.com/sql2005/show.asp?id=3
> Thank you for your patience and cooperation. If you have any questions or
> concerns, don't hesitate to let me know. We are always here to be of
> assistance!
>
> Sincerely yours,
> Michael Cheng
> Microsoft Online Partner Support
> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> ================================================== ===
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
|||Hi Chico,
Thanks for the prompt update.
What's the instance name of your SQL Express?
In your connection string, I have noticed "Data Source=sql2005", does your
machine named "SQL2005" and you installed SQL Server 2005 Express as
default instance?
If you installed SQL Server 2005 Express as named instance, you will have
to connect the instance using connection string like "Data
Source=.\sql2005" (Here, I assume sql2005 is the name for default instance)
Thank you for your patience and cooperation. If you have any questions or
concerns, don't hesitate to let me know. We are always here to be of
assistance!
Sincerely yours,
Michael Cheng
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
================================================== ===
This posting is provided "AS IS" with no warranties, and confers no rights.

Error 3205 Restore SQLServer 2005 Express to MSDE

I am trying to restore a database backed up using SQL Server 2005 Express Edition to a server using MSDE. I get an error 3205 "Too many backup devices specified...64 max..."

I'm only specifying one file for the restore.

Ideas?

Once a database has been attached to a 2005 version it can not be restored to a 2000 version.

MSDE is 2000 and Express is 2005.

WesleyB

Visit my SQL Server weblog @. http://dis4ea.blogspot.com

|||

Color me sad...

I control my server completely. If I install 2005 (either express or full version) on my server, will it migrate my existing msde database(s) automatically? Is there a way to do that? I have no problem upgrading as long as I can pull my existing db's up with me.

Can you help me?

Again, thanks for your answer. It's the only definitive answer I've received.

Jim

|||

More information about upgrading MSDE to SQL Server Express can be found here: http://www.microsoft.com/sql/editions/express/upgrade.mspx.

Migrating your MSDE to the full version is also a viable option.

From 2000 to 2005 is not a problem only the other way around.

WesleyB

Visit my SQL Server weblog @. http://dis4ea.blogspot.com

Error 3205 Restore SQLServer 2005 Express to MSDE

I am trying to restore a database backed up using SQL Server 2005 Express Edition to a server using MSDE. I get an error 3205 "Too many backup devices specified...64 max..."

I'm only specifying one file for the restore.

Ideas?

Once a database has been attached to a 2005 version it can not be restored to a 2000 version.

MSDE is 2000 and Express is 2005.

WesleyB

Visit my SQL Server weblog @. http://dis4ea.blogspot.com

|||

Color me sad...

I control my server completely. If I install 2005 (either express or full version) on my server, will it migrate my existing msde database(s) automatically? Is there a way to do that? I have no problem upgrading as long as I can pull my existing db's up with me.

Can you help me?

Again, thanks for your answer. It's the only definitive answer I've received.

Jim

|||

More information about upgrading MSDE to SQL Server Express can be found here: http://www.microsoft.com/sql/editions/express/upgrade.mspx.

Migrating your MSDE to the full version is also a viable option.

From 2000 to 2005 is not a problem only the other way around.

WesleyB

Visit my SQL Server weblog @. http://dis4ea.blogspot.com

Error 28092 when upgrading from Express to Workgroup Edition

Hello,

when I try to upgrade SQL Server 2005 using this command line:

setup.exe /qb SKUUPGRADE=1 UPGRADE=SQL_Engine INSTANCENAME=Z1 SQLACCOUNT=NT-AUTORIT?T\SYSTEM SECURITYMODE=SQL SAPWD=XXXXXX

I get error 28092 (administrator rights needed).

It seems like the upgrade tries to use Windows authentification although I've told it to use SQL Server authentification. Or did I miss a parameter in my command line?

If I do the upgrade manually it works without needing Windows authentification.

can you goto %program files%\microsoft sql server\90\setup bootstrap\log folder, and search for the error code, and share out the log content near/around the error?|||

The file SQLSetup0008_Z1TESTVISTA_SQL.log contains:

Attempt to start service when it is already running
SQL service MSSQL$Z1 started successfully waiting for SQL service to accept client connections
Loaded DLL:
C:\Windows\system32\Odbc32.dll
Version:
6.0.6000.16386

SQL_SUCCESS_WITH_INFO (1) in OdbcConnection::connect
sqlstate=01000, level=-1, state=-1, native_error=5701, msg=[Microsoft][SQL Native Client][SQL Server]Der Datenbankkontext wurde auf 'master' ge?ndert.
sqlstate=01000, level=-1, state=-1, native_error=5703, msg=[Microsoft][SQL Native Client][SQL Server]Die Spracheneinstellung wurde auf Deutsch ge?ndert.

Error Code: 0x80076dbc (28092)
Windows Error Text: Source File Name: sqlca\upgradesql.cpp
Compiler Timestamp: Thu Aug 11 01:12:02 2005
Function Name: sqls::UpgradeSql::validateDatabases
Source Line Number: 187

- Context --

Setting status of unmanaged components and removing unmanaged resources

Error Code: 28092
MSI (s) (38!74) [17:34:44:691]: Produkt: Microsoft SQL Server 2005 -- Fehler 28092. Das SQL Server-Setup ben?tigt Administratorberechtigungen für die aktualisierte SQL Server-Instanz. Melden Sie sich mit einem Administratorkonto an, um den Vorgang fortzusetzen.

Fehler 28092. Das SQL Server-Setup ben?tigt Administratorberechtigungen für die aktualisierte SQL Server-Instanz. Melden Sie sich mit einem Administratorkonto an, um den Vorgang fortzusetzen.
<Func Name='SetCAContext'>
<EndFunc Name='SetCAContext' Return='T' GetLastError='203'>
Doing Action: ValidateUpgrade
PerfTime Start: ValidateUpgrade : Thu Feb 01 17:34:44 2007
<Func Name='ValidateUpgrade'>
<Func Name='updateFeatureSellection'>
Attempt to start service when it is already running
SQL service MSSQL$Z1 started successfully waiting for SQL service to accept client connections
Loaded DLL:
C:\Windows\system32\Odbc32.dll
Version:
6.0.6000.16386

SQL_SUCCESS_WITH_INFO (1) in OdbcConnection::connect
sqlstate=01000, level=-1, state=-1, native_error=5701, msg=[Microsoft][SQL Native Client][SQL Server]Der Datenbankkontext wurde auf 'master' ge?ndert.
sqlstate=01000, level=-1, state=-1, native_error=5703, msg=[Microsoft][SQL Native Client][SQL Server]Die Spracheneinstellung wurde auf Deutsch ge?ndert.

Error Code: 0x80076dbc (28092)
Windows Error Text: Source File Name: sqlca\upgradesql.cpp
Compiler Timestamp: Thu Aug 11 01:12:02 2005
Function Name: sqls::UpgradeSql::validateDatabases
Source Line Number: 187

- Context --

Setting status of unmanaged components and removing unmanaged resources

Error Code: 28092
MSI (s) (38:FC) [17:34:46:848]: I/O on thread 2504 could not be cancelled. Error: 1168
MSI (s) (38:FC) [17:34:46:848]: I/O on thread 3304 could not be cancelled. Error: 1168
MSI (s) (38:FC) [17:34:46:848]: I/O on thread 2040 could not be cancelled. Error: 1168
MSI (s) (38:FC) [17:34:46:848]: I/O on thread 3548 could not be cancelled. Error: 1168
MSI (s) (38:FC) [17:34:46:848]: I/O on thread 3172 could not be cancelled. Error: 1168
MSI (s) (38:FC) [17:34:46:848]: I/O on thread 3996 could not be cancelled. Error: 1168
MSI (s) (38:FC) [17:34:46:848]: I/O on thread 3664 could not be cancelled. Error: 1168
MSI (s) (38:FC) [17:34:46:848]: I/O on thread 1456 could not be cancelled. Error: 1168
MSI (s) (38:FC) [17:34:46:848]: I/O on thread 3848 could not be cancelled. Error: 1168
MSI (s) (38!74) [17:34:46:863]: Produkt: Microsoft SQL Server 2005 -- Fehler 28092. Das SQL Server-Setup ben?tigt Administratorberechtigungen für die aktualisierte SQL Server-Instanz. Melden Sie sich mit einem Administratorkonto an, um den Vorgang fortzusetzen.

Fehler 28092. Das SQL Server-Setup ben?tigt Administratorberechtigungen für die aktualisierte SQL Server-Instanz. Melden Sie sich mit einem Administratorkonto an, um den Vorgang fortzusetzen.
<Failure Type='Fatal' Error='28092'>
<EndFunc Name='LaunchFunction' Return='28092' GetLastError='203'>
Aktion beendet um 17:34:46: ValidateUpgrade.D20239D7_E87C_40C9_9837_E70B8D4882C2. Rückgabewert 3.
Aktion beendet um 17:34:46: INSTALL. Rückgabewert 3.

And the file SQLSetup0008_Z1TESTVISTA_Core(Patched).log:

Installing: sql on target: Z1TESTVISTA
Failed to install package
Schwerwiegender Fehler bei der Installation.
Setting package return code to: 28092
Complete: InstallSqlAction at: 2007/1/1 17:34:48, returned false
Error: Action "InstallSqlAction" failed during execution. Error information reported during run:
Target collection includes the local machine.
Invoking installPackage() on local machine.

|||

two questions:

1) were you running a admin on the box?

2) your express was ENU (English) or not? What language SKU it is? The same quesstion for the WorkGroup Edition?

|||

1) Yes, but on Vista with UAC enabled. Vista asks for admin evelation and I allow it.

May this be the problem? Shall I try under Windows XP?

2) Both are the German versions.

Maybe this is a similar problem like in

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

|||

This error means that the user who is running the setup is not sysadmin in the SQL instance. It makes sense this happens on Vista because of AUC the user is not recognize as NT administrator. You need to add yourself as sysadmin to SQL. From elevated application connect to SLQ and run:

EXEC sys.sp_grantlogin N'YourAccount'

EXEC sys.sp_addsrvrolemember N'[YourAccount]', N'sysadmin'

|||

Sorry, but this doesn't answer my question:

Why does this error not occur if I do the upgrade manually?

And how do I have to change my command line above to get the same result?

|||

So; after trying the same under Windows XP and experiencing the same problems again, I compared the log files created by the working manual upgrade with the ones from the aborting automatic upgrade.

I discovered some undocumented property names, especially "UPGRADEUSER" and "UPGRADEPWD". After changing my command line to

setup.exe /qb SKUUPGRADE=1 UPGRADE=SQL_Engine INSTANCENAME=Z1 SECURITYMODE=SQL UPGRADEUSER=sa UPGRADEPWD=XXXXXX

the automatic upgrade works now (with one exception).

THANK YOU VERY MUCH MICROSOFT FOR YOUR INCOMPLETE DOCUMENTATIONS!!!

The remaining problem now is, that the upgrade deletes Tools_Legacy even if I add

ADDLOCAL=Tools_Legacy

to the command line above. Any idea?

|||

I've found the solution for the last problem. So my (hopefully) final command line is:

setup.exe /qb SKUUPGRADE=1 UPGRADE=SQL_Engine ADDLOCAL=SQL_BC_DEP INSTANCENAME=Z1 SECURITYMODE=SQL UPGRADEUSER=sa UPGRADEPWD=XXXXXX

ERROR 26 AFTER UPGRADE OF SQL 2005 SERVER EXPRESS

I cannot make connection to database that I was using prior to the upgrade of SP1. Keep getting error 26-default settings prohibit remote access - but it's not remote.? Can anyone help - tell me how to change defaults or change properties to connect to my data after the update?

I am using Visual Web Developer Express. It can see the instance but cannot connect.

Using TCP/IP rather than named pipes is always "remote". YOu can enable the remote connections on the Computer by using the SQL Server Configuration surface. See more details and a screencast at my site in the section Screencasts >Enabling remote connections

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de|||Thank you - this did it.

Error 26 - SQL Connection Error

I was working on my office computer where I had Visual Web Developer Express Edition installed. I moved to my home office and installed Visual Web Developer and tried to run my application on my new computer and I get the following error message:

An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)

Please let me know if you need further information, any help would be appreciated.

Thanks.

Never mind, I just realized I had issues with my SQL Server....I reinstalled it and it all works fine now.

Thanks.

error 26

Hello
I'm trying to make a connection from Web developer 2005 express to a sql
database (sql server 2005 express), which has worked for me a dozen times
before but now I'm getting the error 26 message...error locating server. My
web site is file based on my computer. I'm unable to resolve this and move
forward.
My status is best describe as a Novice.
Chris
Hi Chris
On the server try using NET START or looking at the services applet under
the control panel to see if SQL Server is running.
If it is running, check that you can PING the server.
Try accessing the Server with SQLCMD or osql.
Check the Service Area Configuration Tool SQLSAC.exe to see that the
protocols are still enabled. You may also want to check SQL Server
Configuration Manager SQLServerManager.msc
If the server is responding to PINGS check that there are no firewall rules
that are blocking the SQL Server ports
http://support.microsoft.com/default...;en-us;287932, you could try
opening these ports with TELNET.
John
"ChrisCB" wrote:

> Hello
> I'm trying to make a connection from Web developer 2005 express to a sql
> database (sql server 2005 express), which has worked for me a dozen times
> before but now I'm getting the error 26 message...error locating server. My
> web site is file based on my computer. I'm unable to resolve this and move
> forward.
> My status is best describe as a Novice.
> Chris
|||Hi
You may also want to read:
http://support.microsoft.com/default...b;en-us;827422
and check out the SQL Server logs as well!
John
"ChrisCB" wrote:

> Hello
> I'm trying to make a connection from Web developer 2005 express to a sql
> database (sql server 2005 express), which has worked for me a dozen times
> before but now I'm getting the error 26 message...error locating server. My
> web site is file based on my computer. I'm unable to resolve this and move
> forward.
> My status is best describe as a Novice.
> Chris
|||John
Thanks, the SQL Server and SQL Server Browser were both stopped but are both
now running and I can access my SQL Database.
Many thanks for your directions.
Chris
"John Bell" wrote:
[vbcol=seagreen]
> Hi
> You may also want to read:
> http://support.microsoft.com/default...b;en-us;827422
> and check out the SQL Server logs as well!
> John
>
> "ChrisCB" wrote:

error 26

Hello
I'm trying to make a connection from Web developer 2005 express to a sql
database (sql server 2005 express), which has worked for me a dozen times
before but now I'm getting the error 26 message...error locating server. My
web site is file based on my computer. I'm unable to resolve this and move
forward.
My status is best describe as a Novice.
ChrisHi Chris
On the server try using NET START or looking at the services applet under
the control panel to see if SQL Server is running.
If it is running, check that you can PING the server.
Try accessing the Server with SQLCMD or osql.
Check the Service Area Configuration Tool SQLSAC.exe to see that the
protocols are still enabled. You may also want to check SQL Server
Configuration Manager SQLServerManager.msc
If the server is responding to PINGS check that there are no firewall rules
that are blocking the SQL Server ports
http://support.microsoft.com/defaul...b;en-us;287932, you could tr
y
opening these ports with TELNET.
John
"ChrisCB" wrote:

> Hello
> I'm trying to make a connection from Web developer 2005 express to a sql
> database (sql server 2005 express), which has worked for me a dozen times
> before but now I'm getting the error 26 message...error locating server.
My
> web site is file based on my computer. I'm unable to resolve this and move
> forward.
> My status is best describe as a Novice.
> Chris|||Hi
You may also want to read:
http://support.microsoft.com/defaul...kb;en-us;827422
and check out the SQL Server logs as well!
John
"ChrisCB" wrote:

> Hello
> I'm trying to make a connection from Web developer 2005 express to a sql
> database (sql server 2005 express), which has worked for me a dozen times
> before but now I'm getting the error 26 message...error locating server.
My
> web site is file based on my computer. I'm unable to resolve this and move
> forward.
> My status is best describe as a Novice.
> Chris|||John
Thanks, the SQL Server and SQL Server Browser were both stopped but are both
now running and I can access my SQL Database.
Many thanks for your directions.
Chris
"John Bell" wrote:
[vbcol=seagreen]
> Hi
> You may also want to read:
> http://support.microsoft.com/defaul...kb;en-us;827422
> and check out the SQL Server logs as well!
> John
>
> "ChrisCB" wrote:
>

error 26

Hello
I'm trying to make a connection from Web developer 2005 express to a sql
database (sql server 2005 express), which has worked for me a dozen times
before but now I'm getting the error 26 message...error locating server. My
web site is file based on my computer. I'm unable to resolve this and move
forward.
My status is best describe as a Novice.
ChrisHi Chris
On the server try using NET START or looking at the services applet under
the control panel to see if SQL Server is running.
If it is running, check that you can PING the server.
Try accessing the Server with SQLCMD or osql.
Check the Service Area Configuration Tool SQLSAC.exe to see that the
protocols are still enabled. You may also want to check SQL Server
Configuration Manager SQLServerManager.msc
If the server is responding to PINGS check that there are no firewall rules
that are blocking the SQL Server ports
http://support.microsoft.com/default.aspx?scid=kb;en-us;287932, you could try
opening these ports with TELNET.
John
"ChrisCB" wrote:
> Hello
> I'm trying to make a connection from Web developer 2005 express to a sql
> database (sql server 2005 express), which has worked for me a dozen times
> before but now I'm getting the error 26 message...error locating server. My
> web site is file based on my computer. I'm unable to resolve this and move
> forward.
> My status is best describe as a Novice.
> Chris|||Hi
You may also want to read:
http://support.microsoft.com/default.aspx?scid=kb;en-us;827422
and check out the SQL Server logs as well!
John
"ChrisCB" wrote:
> Hello
> I'm trying to make a connection from Web developer 2005 express to a sql
> database (sql server 2005 express), which has worked for me a dozen times
> before but now I'm getting the error 26 message...error locating server. My
> web site is file based on my computer. I'm unable to resolve this and move
> forward.
> My status is best describe as a Novice.
> Chris|||John
Thanks, the SQL Server and SQL Server Browser were both stopped but are both
now running and I can access my SQL Database.
Many thanks for your directions.
Chris
"John Bell" wrote:
> Hi
> You may also want to read:
> http://support.microsoft.com/default.aspx?scid=kb;en-us;827422
> and check out the SQL Server logs as well!
> John
>
> "ChrisCB" wrote:
> > Hello
> > I'm trying to make a connection from Web developer 2005 express to a sql
> > database (sql server 2005 express), which has worked for me a dozen times
> > before but now I'm getting the error 26 message...error locating server. My
> > web site is file based on my computer. I'm unable to resolve this and move
> > forward.
> > My status is best describe as a Novice.
> >
> > Chris

error 206 creating new db in express

Hi,
I get the error 206 not autorized to create db in Master ?
I tried to find the error in the msdn but nothing, any one have a suggestion
?
Thanks
Paolol
hi Paolol,
Paolol wrote:
> Hi,
> I get the error 206 not autorized to create db in Master ?
> I tried to find the error in the msdn but nothing, any one have a
> suggestion ?
does the login you are connected to SQL Server have enought permissions to
create databases?
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
|||Thx it works
Paolol
"Andrea Montanari" <andrea.sqlDMO@.virgilio.it> ha scritto nel messaggio
news:5c06b3F2u55scU1@.mid.individual.net...
> hi Paolol,
> Paolol wrote:
> does the login you are connected to SQL Server have enought permissions to
> create databases?
> --
> 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
>

error 1937 installing sql express

Please help me!

Microsoft SQL Server 2005 9.00.1399.06
==============================
OS Version : Microsoft Windows XP Home Edition Service Pack 2 (Build 2600)
Time : Sat Jul 15 12:51:21 2006
Machine : JIMMY
Product : File di supporto dell'installazione di Microsoft SQL Server (Italiano)
Product Version : 9.00.1399.06
Install : Successful
Log File : C:\programmi\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0001_JIMMY_SQLSupport_1.log
--
Machine : JIMMY
Product : Microsoft SQL Server Native Client
Product Version : 9.00.1399.06
Install : Successful
Log File : C:\programmi\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0001_JIMMY_SQLNCLI_1.log
--
Machine : JIMMY
Product : Microsoft SQL Server VSS Writer
Product Version : 9.00.1399.06
Install : Successful
Log File : C:\programmi\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0001_JIMMY_SqlWriter_1.log
--
Machine : JIMMY
Product : Parser MSXML 6.0
Product Version : 6.00.3883.15
Install : Successful
Log File : C:\programmi\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0001_JIMMY_MSXML6_1.log
--
Machine : JIMMY
Product : File di supporto dell'installazione di Microsoft SQL Server (Italiano)
Product Version : 9.00.1399.06
Install : Successful
Log File : C:\programmi\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0001_JIMMY_SQLSupport_2.log
--
Machine : JIMMY
Product : Microsoft SQL Server Native Client
Product Version : 9.00.1399.06
Install : Successful
Log File : C:\programmi\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0001_JIMMY_SQLNCLI_2.log
--
Machine : JIMMY
Product : Parser MSXML 6.0
Product Version : 6.00.3883.15
Install : Successful
Log File : C:\programmi\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0001_JIMMY_MSXML6_2.log
--
Machine : JIMMY
Product : Servizi di database SQL Server
Error : Errore durante l'installazione dell'assembly 'Microsoft.SqlServer.SmoEnum,Version="9.0.242.0",Culture="neutral",processorArchitecture="MSIL",PublicKeyToken="89845dcd8080cc91",FileVersion="9.0.1399.0"'. Firma o catalogo non verificabili o non validi. HRESULT: 0x80131045.
--
Machine : JIMMY
Product : Microsoft SQL Server 2005 Express Edition
Product Version : 9.00.1399.06
Install : Failed
Log File : C:\programmi\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0001_JIMMY_SQL.log
Last Action : InstallFinalize
Error String : Errore durante l'installazione dell'assembly 'Microsoft.SqlServer.SmoEnum,Version="9.0.242.0",Culture="neutral",processorArchitecture="MSIL",PublicKeyToken="89845dcd8080cc91",FileVersion="9.0.1399.0"'. Firma o catalogo non verificabili o non validi. HRESULT: 0x80131045. interfaccia assembly: IAssemblyCacheItem, funzione: Commit, componente: {FD5D8A34-6302-4B57-A51D-65A834A1EF6F}
Error Number : 1937
--

Hi Agostino,

Please check the file at C:\programmi\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0001_JIMMY_SQL.log to see if it offers additional information.

I'm moving this to the setup form so they can troubleshoot for you.

Mike

|||

hi Mike,

the log above (from the file you suggested me in the previous message) tells something about the error but i can't understand. Can you help me?

Bye,

Ago

MSI (s) (44:30) [12:56:11:359]: Executing op: End(Checksum=0,ProgressTotalHDWord=0,ProgressTotalLDWord=366409477)
MSI (s) (44:30) [12:56:11:453]: Assembly Error:Strong name signature verification failed for assembly '%1'. The assembly may have been tampered with, or it was delay signed but not fully signed with the correct private key.
MSI (s) (44:30) [12:56:11:468]: Note: 1: 1937 2: {FD5D8A34-6302-4B57-A51D-65A834A1EF6F} 3: 0x80131045 4: IAssemblyCacheItem 5: Commit 6: Microsoft.SqlServer.SmoEnum,Version="9.0.242.0",Culture="neutral",processorArchitecture="MSIL",PublicKeyToken="89845dcd8080cc91",FileVersion="9.0.1399.0"
MSI (s) (44:30) [12:56:32:203]: Prodotto: Microsoft SQL Server 2005 Express Edition -- Errore 1937. Errore durante l'installazione dell'assembly 'Microsoft.SqlServer.SmoEnum,Version="9.0.242.0",Culture="neutral",processorArchitecture="MSIL",PublicKeyToken="89845dcd8080cc91",FileVersion="9.0.1399.0"'. Firma o catalogo non verificabili o non validi. HRESULT: 0x80131045. interfaccia assembly: IAssemblyCacheItem, funzione: Commit, componente: {FD5D8A34-6302-4B57-A51D-65A834A1EF6F}

Errore 1937. Errore durante l'installazione dell'assembly 'Microsoft.SqlServer.SmoEnum,Version="9.0.242.0",Culture="neutral",processorArchitecture="MSIL",PublicKeyToken="89845dcd8080cc91",FileVersion="9.0.1399.0"'. Firma o catalogo non verificabili o non validi. HRESULT: 0x80131045. interfaccia assembly: IAssemblyCacheItem, funzione: Commit, componente: {FD5D8A34-6302-4B57-A51D-65A834A1EF6F}
MSI (s) (44:30) [12:56:32:281]: User policy value 'DisableRollback' is 0
MSI (s) (44:30) [12:56:32:281]: Machine policy value 'DisableRollback' is 0
Fine operazione 12.56.32: InstallFinalize. Valore restituito 3.

|||Typically, the "Strong name signature verification" error has something to do with a corrupt package (possibly during download, transfer across network, etc). Can you try to download the package one more time and try again? Also, for future debugging help, are you trying to install the Italian SQL Express on an English OS or an Italian OS?

Thanks,
Samuel Lester (MSFT)