Hi
I have been using SQL server with the web matrix project whilst I learn
ASP.net. (I am new to both). At some point this week the SQL server stopped
working (It may be linked to my computer crashing whilst another program was
running). It now will not run from the web matrix or the SQL service
manager. I have found the error logs and the last four lines read :-
2005-09-10 08:54:02.92 spid3 Starting up database 'master'.
2005-09-10 08:54:03.35 spid3 Error: 9003, Servrity: 20, State: 1.
2005-09-10 08:54:03.35 spid3 Cannot recover the master database.
Exiting.
I have found a description of error 9003
"The LSN %S_LSN passed to log scan in database '%.*Is' is invalid."
but this means nothing to me.
My guess is I have an inconsistancy because of the crash but to be honest I
am out of my depth.
Has anyone got some simple advice or do I just start again.
Thanks in advance
Mike
Hi,
Have a look into the below URL to correct the master database corruption.
This will work out provide you have the master database backup.
http://geekswithblogs.net/travis/arc.../27/48400.aspx
Thanks
Hari
SQL Server MVP
"Mike" <Mike@.discussions.microsoft.com> wrote in message
news:93CFAEEF-9171-4CD7-B712-58870BE12715@.microsoft.com...
> Hi
> I have been using SQL server with the web matrix project whilst I learn
> ASP.net. (I am new to both). At some point this week the SQL server
> stopped
> working (It may be linked to my computer crashing whilst another program
> was
> running). It now will not run from the web matrix or the SQL service
> manager. I have found the error logs and the last four lines read :-
> 2005-09-10 08:54:02.92 spid3 Starting up database 'master'.
> 2005-09-10 08:54:03.35 spid3 Error: 9003, Servrity: 20, State: 1.
> 2005-09-10 08:54:03.35 spid3 Cannot recover the master database.
> Exiting.
> I have found a description of error 9003
> "The LSN %S_LSN passed to log scan in database '%.*Is' is invalid."
> but this means nothing to me.
> My guess is I have an inconsistancy because of the crash but to be honest
> I
> am out of my depth.
> Has anyone got some simple advice or do I just start again.
> Thanks in advance
> Mike
|||Hi Prasad
Thanks for the advice. In fact I have been looking around the internet over
the last few hours and tried a few things including SP4. I also realised
that I had nothing backed up in the SQL Server (as I did not know how to).
Anyway, I installed a new Instance of the server on my computer and have
spent hours building the tables and stored procedures again. I have almost
finished! It's a little messy as I still have the old instance of the SQL
Server on the computer and cannot open it or remove it.
Anyway, I will back up my database this time!!
I will also have a look at your link just for interest sake - and I have
certainly learnt some important info about SQL Server today.
Thanks again
Mike
"Hari Prasad" wrote:
> Hi,
> Have a look into the below URL to correct the master database corruption.
> This will work out provide you have the master database backup.
> http://geekswithblogs.net/travis/arc.../27/48400.aspx
> Thanks
> Hari
> SQL Server MVP
> "Mike" <Mike@.discussions.microsoft.com> wrote in message
> news:93CFAEEF-9171-4CD7-B712-58870BE12715@.microsoft.com...
>
>
sql
Showing posts with label net. Show all posts
Showing posts with label net. Show all posts
Tuesday, March 27, 2012
Error 9003
Hi
I have been using SQL server with the web matrix project whilst I learn
ASP.net. (I am new to both). At some point this week the SQL server stopped
working (It may be linked to my computer crashing whilst another program was
running). It now will not run from the web matrix or the SQL service
manager. I have found the error logs and the last four lines read :-
2005-09-10 08:54:02.92 spid3 Starting up database 'master'.
2005-09-10 08:54:03.35 spid3 Error: 9003, Servrity: 20, State: 1.
2005-09-10 08:54:03.35 spid3 Cannot recover the master database.
Exiting.
I have found a description of error 9003
"The LSN %S_LSN passed to log scan in database '%.*Is' is invalid."
but this means nothing to me.
My guess is I have an inconsistancy because of the crash but to be honest I
am out of my depth.
Has anyone got some simple advice or do I just start again.
Thanks in advance
MikeHi,
Have a look into the below URL to correct the master database corruption.
This will work out provide you have the master database backup.
http://geekswithblogs.net/travis/ar...7/27/48400.aspx
Thanks
Hari
SQL Server MVP
"Mike" <Mike@.discussions.microsoft.com> wrote in message
news:93CFAEEF-9171-4CD7-B712-58870BE12715@.microsoft.com...
> Hi
> I have been using SQL server with the web matrix project whilst I learn
> ASP.net. (I am new to both). At some point this week the SQL server
> stopped
> working (It may be linked to my computer crashing whilst another program
> was
> running). It now will not run from the web matrix or the SQL service
> manager. I have found the error logs and the last four lines read :-
> 2005-09-10 08:54:02.92 spid3 Starting up database 'master'.
> 2005-09-10 08:54:03.35 spid3 Error: 9003, Servrity: 20, State: 1.
> 2005-09-10 08:54:03.35 spid3 Cannot recover the master database.
> Exiting.
> I have found a description of error 9003
> "The LSN %S_LSN passed to log scan in database '%.*Is' is invalid."
> but this means nothing to me.
> My guess is I have an inconsistancy because of the crash but to be honest
> I
> am out of my depth.
> Has anyone got some simple advice or do I just start again.
> Thanks in advance
> Mike|||Hi Prasad
Thanks for the advice. In fact I have been looking around the internet over
the last few hours and tried a few things including SP4. I also realised
that I had nothing backed up in the SQL Server (as I did not know how to).
Anyway, I installed a new Instance of the server on my computer and have
spent hours building the tables and stored procedures again. I have almost
finished! It's a little messy as I still have the old instance of the SQL
Server on the computer and cannot open it or remove it.
Anyway, I will back up my database this time!!
I will also have a look at your link just for interest sake - and I have
certainly learnt some important info about SQL Server today.
Thanks again
Mike
"Hari Prasad" wrote:
> Hi,
> Have a look into the below URL to correct the master database corruption.
> This will work out provide you have the master database backup.
> http://geekswithblogs.net/travis/ar...7/27/48400.aspx
> Thanks
> Hari
> SQL Server MVP
> "Mike" <Mike@.discussions.microsoft.com> wrote in message
> news:93CFAEEF-9171-4CD7-B712-58870BE12715@.microsoft.com...
>
>
I have been using SQL server with the web matrix project whilst I learn
ASP.net. (I am new to both). At some point this week the SQL server stopped
working (It may be linked to my computer crashing whilst another program was
running). It now will not run from the web matrix or the SQL service
manager. I have found the error logs and the last four lines read :-
2005-09-10 08:54:02.92 spid3 Starting up database 'master'.
2005-09-10 08:54:03.35 spid3 Error: 9003, Servrity: 20, State: 1.
2005-09-10 08:54:03.35 spid3 Cannot recover the master database.
Exiting.
I have found a description of error 9003
"The LSN %S_LSN passed to log scan in database '%.*Is' is invalid."
but this means nothing to me.
My guess is I have an inconsistancy because of the crash but to be honest I
am out of my depth.
Has anyone got some simple advice or do I just start again.
Thanks in advance
MikeHi,
Have a look into the below URL to correct the master database corruption.
This will work out provide you have the master database backup.
http://geekswithblogs.net/travis/ar...7/27/48400.aspx
Thanks
Hari
SQL Server MVP
"Mike" <Mike@.discussions.microsoft.com> wrote in message
news:93CFAEEF-9171-4CD7-B712-58870BE12715@.microsoft.com...
> Hi
> I have been using SQL server with the web matrix project whilst I learn
> ASP.net. (I am new to both). At some point this week the SQL server
> stopped
> working (It may be linked to my computer crashing whilst another program
> was
> running). It now will not run from the web matrix or the SQL service
> manager. I have found the error logs and the last four lines read :-
> 2005-09-10 08:54:02.92 spid3 Starting up database 'master'.
> 2005-09-10 08:54:03.35 spid3 Error: 9003, Servrity: 20, State: 1.
> 2005-09-10 08:54:03.35 spid3 Cannot recover the master database.
> Exiting.
> I have found a description of error 9003
> "The LSN %S_LSN passed to log scan in database '%.*Is' is invalid."
> but this means nothing to me.
> My guess is I have an inconsistancy because of the crash but to be honest
> I
> am out of my depth.
> Has anyone got some simple advice or do I just start again.
> Thanks in advance
> Mike|||Hi Prasad
Thanks for the advice. In fact I have been looking around the internet over
the last few hours and tried a few things including SP4. I also realised
that I had nothing backed up in the SQL Server (as I did not know how to).
Anyway, I installed a new Instance of the server on my computer and have
spent hours building the tables and stored procedures again. I have almost
finished! It's a little messy as I still have the old instance of the SQL
Server on the computer and cannot open it or remove it.
Anyway, I will back up my database this time!!
I will also have a look at your link just for interest sake - and I have
certainly learnt some important info about SQL Server today.
Thanks again
Mike
"Hari Prasad" wrote:
> Hi,
> Have a look into the below URL to correct the master database corruption.
> This will work out provide you have the master database backup.
> http://geekswithblogs.net/travis/ar...7/27/48400.aspx
> Thanks
> Hari
> SQL Server MVP
> "Mike" <Mike@.discussions.microsoft.com> wrote in message
> news:93CFAEEF-9171-4CD7-B712-58870BE12715@.microsoft.com...
>
>
Monday, March 19, 2012
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 RalfThanks 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 RalfThanks 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 RalfThanks 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?
Wednesday, March 7, 2012
error 3926 , server failed to resume transaction
In a high load asp.net environment, I am getting an error.
The transation active in this session has been committed or aborted by another session.
Here is the code , I am getting error.
1object returnObject =null;2 SqlTransaction sqlTrans =null;3try4 {5//Getting new SqlConnection6 comm.Connection = GetConnection();7//Opening connection8 OpenConn(comm.Connection);9//beginning transaction10 sqlTrans = comm.Connection.BeginTransaction( IsolationLevel.ReadCommitted );11//setting transaction to SqlCommand object12 comm.Transaction = sqlTrans;13//executing operation14 returnObject = comm.ExecuteScalar();15//trying to commit.16 sqlTrans.Commit();171819 }20catch (SqlException sex)21 {22if (sqlTrans !=null)23 {24 sqlTrans.Rollback();25 }26 }27finally28 {29 comm.Connection.Close();30 } Could you please explain , am I doing smthg wrong ?Check out this link: http://forums.microsoft.com/TechNet/ShowPost.aspx?PostID=2041937&SiteID=17
Good luck.
|||Hi CS4Ever ,
Thanks for the reply, but as far as I understood , Thona just submitted the situation , not a solution and the 3rd reply belongs to me :)
What could I possibly do ? Submit a bug to Microsoft ?
Thanks in advance.
|||Still no answers ?
Friday, February 24, 2012
ERROR 28000 Invalid authorization specification
a customer is getting on mS SQL 2000
ERROR ODBC 28000 Invalid authorization specification
I dont understand because all the rigth are OK
ASP NET USER, IISS user and so on !
i am trying to connect the to SQL from ASPX pages (it works for me and a few customers but not that one)
what can be the problem ?
thank youODBC state 28000 usually means a bad password or login. You can confirm this by running a trace of the login failed event on sql server.|||maybe he has entered a password or login somewhere and even dont remember it !
normally we have asked no login no password and no trusted connection
how do you run a trace on SQL 2000 ?
thanks again for helping|||Run Profiler from the SQL Server programs group.|||i try it ! thank you|||but the trace run and run how long ?
i get no result|||Provoke the error in your application, and you should see something.
ERROR ODBC 28000 Invalid authorization specification
I dont understand because all the rigth are OK
ASP NET USER, IISS user and so on !
i am trying to connect the to SQL from ASPX pages (it works for me and a few customers but not that one)
what can be the problem ?
thank youODBC state 28000 usually means a bad password or login. You can confirm this by running a trace of the login failed event on sql server.|||maybe he has entered a password or login somewhere and even dont remember it !
normally we have asked no login no password and no trusted connection
how do you run a trace on SQL 2000 ?
thanks again for helping|||Run Profiler from the SQL Server programs group.|||i try it ! thank you|||but the trace run and run how long ?
i get no result|||Provoke the error in your application, and you should see something.
Wednesday, February 15, 2012
error 193 installing .net framework 2.0
Hi,
I'm trying to install SQL Server 2005 and I receive the "error 193 installing .net framework 2.0"
I got the same error when try to install the 32 bits SQL Server 2005 SE which I downloaded from MSDN. I got the same error even after I tried to install .Net Framework separately.
I tried the Developer Edition and there is no such error.
I'm trying to install SQL Server 2005 and I receive the "error 193 installing .net framework 2.0"
I got the same error when try to install the 32 bits SQL Server 2005 SE which I downloaded from MSDN. I got the same error even after I tried to install .Net Framework separately.
I tried the Developer Edition and there is no such error.
Is there something special with the SE CD?|||Hi,
what I did:
1.) Disabled the extended IE security on the Win2K3 server (saw that on another post)
2.) Installed .net Framework 2.0 from Windows Update
3.) Reboot
After that everything worked fine... No idea which of the 3 did the trick...|||Update:
No, it didn't work... I got the error message that IIS wasn't completely configured... I forgot to do so... After adding ASP.net to IIS the setup wants to install .net 2.0 again. No idea why. Even repairing the .net installation didn't help.
What I noticed is that all the graphics in the pre-setup screens are missing... Perhaps this has something to do with that...|||Are you using virtual machines? I am using VMware and found that my problem is an corrupted iso file. MY problem was resolved after I recreate the iso file.
So the error may be due to a bad installation media.|||How to disable the extended IE security on the Win2k3 server|||I thought disabling Extended IE Security would help (see my earlier post) but it didn't. It was a Virtual PC, I finally got it running not by using Developer Edition but Enterprise Edition... I also did a new download of the software (from MSDN) because I wasn't able to read the complete disk from the image. But that didn't help... My guess is a problem with VirtualPC... But I'm not sure...|||
I was trying to install SQL 2005 Developer edition to winXP sp2 on a virtual machine and got the same error. THen I downloaded framework 2 from win update and got the same error. Now I setup a virtual pc with Server 2003 enterprise sp1 disabled IE extended security and got the same error. So it might not be the problem (it is logical as ie on XP doesn;t have extended security).Right now I am updating that Virtual PC (server 2003 enterprise) with framework 2 . I'll reboot it and if that doesn't work I;ll change profession!!
It doesn't work still! I also get the problem where the graphics are not displayed like if an ActiveX control is missing.
|||Hi everybody, too many boys now angry with this problem.. and too many versions of this problemthis is mine:
1. i have.net framework 2.0 and i haveMs visual studio 2005 .
2. i tried to installMs SQL server 2005 Developer edition.
in first step [Server components, tools, Books Online, and samples] the installation sayas that net FRM 2.0 and support files required.
3. i click the install button and wow!! "error 193 installation Net Framework 2.0."
i cant understand, i havenet framework 2.0 and it cant install it. :S
i uninstalled all visual studio 2005 and net framework 2.0 and all other sql services.
and the same problem appears again.
Note: i run the installation program from full DVD [includes x86 x64 and itanium]
and no servers are running while installations.
i closed antivirus and firewall programmes while installation.
but the same error - that damned "error 193"
and please help me, and feel good to help a good boy :)
|||
If the install media is not a problem. How about trying to clean up the registry settings created by SQL2005.
Uninstall .net framwork 2.0 and also makie sure that your settings for the tmp folder is correct, clean up the temp and tmp folders
|||Map the DVD to a mapped drive in the virtual machine, ie the DVD is in the host OS, not in the VM. Run the setup.exe from the mapped drive. All is well after that.|||ya boys.... thanks everybody.. and Yo123 thaks..
it is fine now.
let me say what i did:
1. i copy the full DVD to my local computer. like this --> c:\sql_detup_files
2. then i uninstalled the sql server and all components
3. and... try again to install sql server -- correct the instance names bla bla
4. then everything ok.
|||I believe your installation file was corrupted:
Please check if the file is corrupted in SQL2005\redist\2.0\dotnetfx.exe
|||I also had the same issue and running a repair on .net 2.0 fixed it.error 193 installing .net framework 2.0
Hi,
I'm trying to install SQL Server 2005 and I receive the "error 193 installing .net framework 2.0"
I got the same error when try to install the 32 bits SQL Server 2005 SE which I downloaded from MSDN. I got the same error even after I tried to install .Net Framework separately.
I tried the Developer Edition and there is no such error.
I'm trying to install SQL Server 2005 and I receive the "error 193 installing .net framework 2.0"
I got the same error when try to install the 32 bits SQL Server 2005 SE which I downloaded from MSDN. I got the same error even after I tried to install .Net Framework separately.
I tried the Developer Edition and there is no such error.
Is there something special with the SE CD?|||Hi,
what I did:
1.) Disabled the extended IE security on the Win2K3 server (saw that on another post)
2.) Installed .net Framework 2.0 from Windows Update
3.) Reboot
After that everything worked fine... No idea which of the 3 did the trick...|||Update:
No, it didn't work... I got the error message that IIS wasn't completely configured... I forgot to do so... After adding ASP.net to IIS the setup wants to install .net 2.0 again. No idea why. Even repairing the .net installation didn't help.
What I noticed is that all the graphics in the pre-setup screens are missing... Perhaps this has something to do with that...|||Are you using virtual machines? I am using VMware and found that my problem is an corrupted iso file. MY problem was resolved after I recreate the iso file.
So the error may be due to a bad installation media.|||How to disable the extended IE security on the Win2k3 server|||I thought disabling Extended IE Security would help (see my earlier post) but it didn't. It was a Virtual PC, I finally got it running not by using Developer Edition but Enterprise Edition... I also did a new download of the software (from MSDN) because I wasn't able to read the complete disk from the image. But that didn't help... My guess is a problem with VirtualPC... But I'm not sure...|||
I was trying to install SQL 2005 Developer edition to winXP sp2 on a virtual machine and got the same error. THen I downloaded framework 2 from win update and got the same error. Now I setup a virtual pc with Server 2003 enterprise sp1 disabled IE extended security and got the same error. So it might not be the problem (it is logical as ie on XP doesn;t have extended security).Right now I am updating that Virtual PC (server 2003 enterprise) with framework 2 . I'll reboot it and if that doesn't work I;ll change profession!!
It doesn't work still! I also get the problem where the graphics are not displayed like if an ActiveX control is missing.
|||Hi everybody, too many boys now angry with this problem.. and too many versions of this problemthis is mine:
1. i have .net framework 2.0 and i have Ms visual studio 2005 .
2. i tried to install Ms SQL server 2005 Developer edition.
in
first step [Server components, tools, Books Online, and samples] the
installation sayas that net FRM 2.0 and support files required.
3. i click the install button and wow!! "error 193 installation Net Framework 2.0."
i cant understand, i have net framework 2.0 and it cant install it. :S
i uninstalled all visual studio 2005 and net framework 2.0 and all other sql services.
and the same problem appears again.
Note: i run the installation program from full DVD [includes x86 x64 and itanium]
and no servers are running while installations.
i closed antivirus and firewall programmes while installation.
but the same error - that damned "error 193"
and please help me, and feel good to help a good boy :)
|||
If the install media is not a problem. How about trying to clean up the registry settings created by SQL2005.
Uninstall .net framwork 2.0 and also makie sure that your settings for the tmp folder is correct, clean up the temp and tmp folders
|||Map the DVD to a mapped drive in the virtual machine, ie the DVD is in the host OS, not in the VM. Run the setup.exe from the mapped drive. All is well after that.|||ya boys.... thanks everybody.. and Yo123 thaks..
it is fine now.
let me say what i did:
1. i copy the full DVD to my local computer. like this --> c:\sql_detup_files
2. then i uninstalled the sql server and all components
3. and... try again to install sql server -- correct the instance names bla bla
4. then everything ok.
|||
I believe your installation file was corrupted:
Please check if the file is corrupted in SQL2005\redist\2.0\dotnetfx.exe
error 193 installing .net framework 2.0
Hi,
I'm trying to install SQL Server 2005 and I receive the "error 193 installing .net framework 2.0"
I got the same error when try to install the 32 bits SQL Server 2005 SE which I downloaded from MSDN. I got the same error even after I tried to install .Net Framework separately.
I tried the Developer Edition and there is no such error.
I'm trying to install SQL Server 2005 and I receive the "error 193 installing .net framework 2.0"
I got the same error when try to install the 32 bits SQL Server 2005 SE which I downloaded from MSDN. I got the same error even after I tried to install .Net Framework separately.
I tried the Developer Edition and there is no such error.
Is there something special with the SE CD?|||Hi,
what I did:
1.) Disabled the extended IE security on the Win2K3 server (saw that on another post)
2.) Installed .net Framework 2.0 from Windows Update
3.) Reboot
After that everything worked fine... No idea which of the 3 did the trick...|||Update:
No, it didn't work... I got the error message that IIS wasn't completely configured... I forgot to do so... After adding ASP.net to IIS the setup wants to install .net 2.0 again. No idea why. Even repairing the .net installation didn't help.
What I noticed is that all the graphics in the pre-setup screens are missing... Perhaps this has something to do with that...|||Are you using virtual machines? I am using VMware and found that my problem is an corrupted iso file. MY problem was resolved after I recreate the iso file.
So the error may be due to a bad installation media.|||How to disable the extended IE security on the Win2k3 server|||I thought disabling Extended IE Security would help (see my earlier post) but it didn't. It was a Virtual PC, I finally got it running not by using Developer Edition but Enterprise Edition... I also did a new download of the software (from MSDN) because I wasn't able to read the complete disk from the image. But that didn't help... My guess is a problem with VirtualPC... But I'm not sure...|||
I was trying to install SQL 2005 Developer edition to winXP sp2 on a virtual machine and got the same error. THen I downloaded framework 2 from win update and got the same error. Now I setup a virtual pc with Server 2003 enterprise sp1 disabled IE extended security and got the same error. So it might not be the problem (it is logical as ie on XP doesn;t have extended security).Right now I am updating that Virtual PC (server 2003 enterprise) with framework 2 . I'll reboot it and if that doesn't work I;ll change profession!!
It doesn't work still! I also get the problem where the graphics are not displayed like if an ActiveX control is missing.
|||Hi everybody, too many boys now angry with this problem.. and too many versions of this problemthis is mine:
1. i have.net framework 2.0 and i haveMs visual studio 2005 .
2. i tried to installMs SQL server 2005 Developer edition.
in first step [Server components, tools, Books Online, and samples] the installation sayas that net FRM 2.0 and support files required.
3. i click the install button and wow!! "error 193 installation Net Framework 2.0."
i cant understand, i havenet framework 2.0 and it cant install it. :S
i uninstalled all visual studio 2005 and net framework 2.0 and all other sql services.
and the same problem appears again.
Note: i run the installation program from full DVD [includes x86 x64 and itanium]
and no servers are running while installations.
i closed antivirus and firewall programmes while installation.
but the same error - that damned "error 193"
and please help me, and feel good to help a good boy :)
|||
If the install media is not a problem. How about trying to clean up the registry settings created by SQL2005.
Uninstall .net framwork 2.0 and also makie sure that your settings for the tmp folder is correct, clean up the temp and tmp folders
|||Map the DVD to a mapped drive in the virtual machine, ie the DVD is in the host OS, not in the VM. Run the setup.exe from the mapped drive. All is well after that.|||ya boys.... thanks everybody.. and Yo123 thaks..
it is fine now.
let me say what i did:
1. i copy the full DVD to my local computer. like this --> c:\sql_detup_files
2. then i uninstalled the sql server and all components
3. and... try again to install sql server -- correct the instance names bla bla
4. then everything ok.
|||I believe your installation file was corrupted:
Please check if the file is corrupted in SQL2005\redist\2.0\dotnetfx.exe
|||I also had the same issue and running a repair on .net 2.0 fixed it.
Subscribe to:
Posts (Atom)