Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Can't install trial SQL Server. It is "Blocked"

Status
Not open for further replies.

stevenriz

IS-IT--Management
Joined
May 21, 2001
Messages
1,069
Originally had an issue and posted it in thread962-1254971.

Now I have uninstalled SQL Server 2005 and SQL Server Express and am trying to reinstall the Trial 2005 SQL Server so we can try it out. Mind you we still haven't even used it yet. Now we are getting a message that the components are already installed on the machine. Well, no they are not. I just uninstalled everything. Anyway I hit the details button and now see this error. What do I do about this now? It is a windows XP Pro system that meets all requirements.

Name: Microsoft SQL Server 2005 Tools Express Edition
Reason: Your upgrade is blocked. For more information about upgrade support, see the "Version and Edition Upgrades" and "Hardware and Software Requirements" topics in SQL Server 2005 Setup Help or SQL Server 2005 Books Online.

Edition check:
Your upgrade is blocked because of edition upgrade rules. For more information about edition upgrades, see the Version and Edition Upgrades topic in SQL Server 2005 Setup Help or SQL Server 2005 Books Online.
 
Just an update. I was able continue the installation. Now just before I click ok to install, I see this message

The following components that you selected will not be changed:

Client Components


But I did check to install the client components. Maybe that is why I had my original problem of not having the Management Studio installed??
 
ok it gets worse. now I am getting this error during the installation....

Setup could not connect to the database service for server configuration. The error was:
[Microsoft][SQL Native Client]Encryption not supported on the client. Refer to server error
logs and setup logs for more information. For details on how to view setup logs, see "How to
View Setup Log Files" in SQL Server Books Online.

Here is an excerp from the log file.... DO we just need to reinstall XP on this PC from scratch?

SQL_ERROR (-1) in OdbcConnection::connect
sqlstate=08001, level=-1, state=-1, native_error=21,
msg=[Microsoft][SQL Native Client]Encryption not supported on the client.
sqlstate=08001,
level=-1, state=-1, native_error=21, msg=[Microsoft][SQL Native Client]Client unable to
establish connection
sqlstate=08001, level=-1, state=-1, native_error=0, msg=[Microsoft][SQL
Native Client]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.
Error Code: 0x80070015 (21)
Windows Error Text: The device is not ready.
Source File Name: lib\odbc_connection.cpp
Compiler Timestamp: Fri Jul 29 01:13:53 2005

Function Name: OdbcConnection::connect@connect
Source Line Number: 148

---- Context -----------------------------------------------

Connecting to SQL Server
ExecuteSqlCommands
Originial error was 80070015 (21)
Do_sqlScript
SqlScriptHlpr

Error Code: 21
MSI (s) (A4:50) [15:30:39:703]: Running as a service.
MSI (s) (A4:50) [15:30:39:875]: Running as a service.
MSI (s) (A4:50) [15:30:39:875]: Generating random cookie.
MSI (s) (A4:50) [15:30:39:906]: Created Custom Action Server with PID 2808 (0xAF8).
MSI (s) (A4:68) [15:30:40:000]: Running as a service.
MSI (s) (A4:68) [15:30:40:000]: Hello, I'm your 32bit Impersonated custom action server.
MSI (s) (A4:D8) [15:30:52:093]: Server locked. Will skip uninstalled package cleanup, and
allow locking install to perform cleanup.
MSI (s) (A4:50) [15:34:37:750]: Running as a service.
MSI (s) (A4:68) [15:34:37:937]: Running as a service.
MSI (s) (A4:68) [15:34:37:937]: Generating random cookie.
MSI (s) (A4:68) [15:34:37:953]: Created Custom Action Server with PID 248 (0xF8).
MSI (s) (A4:50) [15:34:38:015]: Running as a service.
MSI (s) (A4:50) [15:34:38:015]: Hello, I'm your 32bit Impersonated custom action server.
MSI (s) (A4:50) [15:36:26:062]: Server locked. Will skip uninstalled package cleanup, and
allow locking install to perform cleanup.
MSI (s) (A4:68) [15:36:33:500]: Running as a service.
MSI (s) (A4:50) [15:36:33:656]: Running as a service.
MSI (s) (A4:68) [15:36:33:656]: Generating random cookie.
MSI (s) (A4:68) [15:36:33:671]: Created Custom Action Server with PID 164 (0xA4).
MSI (s) (A4:D8) [15:36:33:734]: Running as a service.
MSI (s) (A4:D8) [15:36:33:734]: Hello, I'm your 32bit Impersonated custom action server.
MSI (s) (A4:50) [15:36:54:203]: Server locked. Will skip uninstalled package cleanup, and
allow locking install to perform cleanup.
MSI (s) (A4!98) [15:38:52:328]: Product: Microsoft SQL Server 2005 -- Error 29515. SQL Server
Setup could not connect to the database service for server configuration. The error was:
[Microsoft][SQL Native Client]Encryption not supported on the client. Refer to server error
logs and setup logs for more information. For details on how to view setup logs, see "How to
View Setup Log Files" in SQL Server Books Online.
Error 29515. SQL Server Setup could not connect to the database service for server
configuration. The error was: [Microsoft][SQL Native Client]Encryption not supported on the
client. Refer to server error logs and setup logs for more information. For details on how to
view setup logs, see "How to View Setup Log Files" in SQL Server Books Online.
<Func Name='GetCAContext'>
<EndFunc Name='GetCAContext' Return='T' GetLastError='203'>
Doing Action: Do_sqlScript
PerfTime Start: Do_sqlScript : Mon Jul 17 15:38:52 2006
Service MSSQLSERVER with parameters '-m SqlSetup -Q -qSQL_Latin1_General_CP1_CI_AS -T4022
-T3659 -T3610 -T4010' is being started at Mon Jul 17 15:38:52 2006
Attempt to start service when it is already running
SQL service MSSQLSERVER started successfully waiting for SQL service to accept client
connections
Service MSSQLSERVER started at Mon Jul 17 15:38:52 2006
Loaded DLL:
C:\WINDOWS\system32\Odbc32.dll
Version:
3.525.1117.0

SQL_ERROR (-1) in OdbcConnection::connect
sqlstate=08001, level=-1, state=-1, native_error=21,
msg=[Microsoft][SQL Native Client]Encryption not supported on the client.
sqlstate=08001,
level=-1, state=-1, native_error=21, msg=[Microsoft][SQL Native Client]Client unable to
establish connection
sqlstate=08001, level=-1, state=-1, native_error=0, msg=[Microsoft][SQL
Native Client]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.
Error Code: 0x80070015 (21)
Windows Error Text: The device is not ready.
Source File Name: lib\odbc_connection.cpp
Compiler Timestamp: Fri Jul 29 01:13:53 2005

Function Name: OdbcConnection::connect@connect
Source Line Number: 148

---- Context -----------------------------------------------

Connecting to SQL Server
ExecuteSqlCommands
Originial error was 80070015 (21)
Do_sqlScript
SqlScriptHlpr

Error Code: 21
MSI (s) (A4!98) [15:38:53:390]: Product: Microsoft SQL Server 2005 -- Error 29515. SQL Server
Setup could not connect to the database service for server configuration. The error was:
[Microsoft][SQL Native Client]Encryption not supported on the client. Refer to server error
logs and setup logs for more information. For details on how to view setup logs, see "How to
View Setup Log Files" in SQL Server Books Online.
Error 29515. SQL Server Setup could not connect to the database service for server
configuration. The error was: [Microsoft][SQL Native Client]Encryption not supported on the
client. Refer to server error logs and setup logs for more information. For details on how to
view setup logs, see "How to View Setup Log Files" in SQL Server Books Online.
<Failure Type='Fatal' Error='21'>
<EndFunc Name='LaunchFunction' Return='21' GetLastError='203'>
MSI (s) (A4:FC) [15:38:53:468]: User policy value 'DisableRollback' is 0
MSI (s) (A4:FC) [15:38:53:468]: Machine policy value 'DisableRollback' is 0
Action ended 15:38:53: InstallFinalize. Return value 3.
MSI (s) (A4:FC) [15:38:53:640]: Executing op:
Header(Signature=1397708873,Version=301,Timestamp=888240212,LangId=1033,Platform=0,ScriptType=
2,ScriptMajorVersion=21,ScriptMinorVersion=4,ScriptAttributes=1)
MSI (s) (A4:FC) [15:38:53:640]: Executing op: DialogInfo(Type=0,Argument=1033)
MSI (s) (A4:FC) [15:38:53:640]: Executing op: DialogInfo(Type=1,Argument=Microsoft SQL Server
2005)
MSI (s) (A4:FC) [15:38:53:640]: Executing op:
RollbackInfo(,RollbackAction=Rollback,RollbackDescription=Rolling back
action:,RollbackTemplate=[1],CleanupAction=RollbackCleanup,CleanupDescription=Removing backup
files,CleanupTemplate=File: [1])
MSI (s) (A4:FC) [15:38:53:640]: Executing op:
ActionStart(Name=Do_sqlScript.D20239D7_E87C_40C9_9837_E70B8D4882C2,Description=Configuring
Microsoft SQL Server,Template=Starting SQL Service: [1])
MSI (s) (A4:FC) [15:38:53:640]: Executing op:
ProductInfo(ProductKey={28B22773-100E-4AF2-A1C9-2F2EA8A35844},ProductName=Microsoft SQL Server
2005,PackageName=SqlRun_SQL.msi,Language=1033,Version=150996343,Assignment=1,ObsoleteArg=0,Pro
ductIcon=ARPIcon.ico,PackageMediaPath=\Setup\,PackageCode={BF30555C-01A9-4F88-AE1D-7E1F38D492C
3},,,InstanceType=1,LUASetting=0,RemoteURTInstalls=0)
MSI (s) (A4:FC) [15:38:53:640]: Executing op:
ActionStart(Name=Rollback_sqlScript.D20239D7_E87C_40C9_9837_E70B8D4882C2,Description=Configuri
ng Microsoft SQL Server,Template=Stopping SQL Service: [1])
MSI (s) (A4:FC) [15:38:53:640]: Executing op:
CustomActionRollback(Action=Rollback_sqlScript.D20239D7_E87C_40C9_9837_E70B8D4882C2,ActionType
=1345,Source=BinaryData,Target=Rollback_sqlScript,CustomActionData=100Configuring Microsoft
SQL Server30330000lpc:DHC8B4B1)
MSI (s) (A4:A0) [15:38:53:656]: Invoking remote custom action. DLL:
C:\WINDOWS\Installer\MSI43A.tmp, Entrypoint: Rollback_sqlScript
<Func Name='LaunchFunction'>
Function=Rollback_sqlScript
<Func Name='GetCAContext'>
<EndFunc Name='GetCAContext' Return='T' GetLastError='203'>
Doing Action: Rollback_sqlScript
PerfTime Start: Rollback_sqlScript : Mon Jul 17 15:38:53 2006
Service MSSQLSERVER is being stopped at Mon Jul 17 15:38:53 2006
Service MSSQLSERVER stopped at Mon Jul 17 15:38:59 2006
PerfTime Stop: Rollback_sqlScript : Mon Jul 17 15:38:59 2006
<EndFunc Name='LaunchFunction' Return='0' GetLastError='234'>
MSI (s) (A4:FC) [15:38:59:687]: Executing op:
ActionStart(Name=Do_sqlFileRename.D20239D7_E87C_40C9_9837_E70B8D4882C2,Description=Renaming
Files,)
MSI (s) (A4:FC) [15:38:59:687]: Executing op:
ActionStart(Name=Rollback_sqlFileRename.D20239D7_E87C_40C9_9837_E70B8D4882C2,Description=Renam
ing Files,)
MSI (s) (A4:FC) [15:38:59:687]: Executing op:
CustomActionRollback(Action=Rollback_sqlFileRename.D20239D7_E87C_40C9_9837_E70B8D4882C2,Action
Type=1345,Source=BinaryData,Target=Rollback_sqlFileRename,CustomActionData=100Renaming
Files200C:\Program Files\Microsoft SQL Server\MSSQL.2\MSSQL\Data\distmdl1.mdfC:\Program
Files\Microsoft SQL Server\MSSQL.2\MSSQL\Data\distmdl.mdf00)
MSI (s) (A4:D4) [15:38:59:703]: Invoking remote custom action. DLL:
C:\WINDOWS\Installer\MSI43B.tmp, Entrypoint: Rollback_sqlFileRename
<Func Name='LaunchFunction'>
Function=Rollback_sqlFileRename
<Func Name='GetCAContext'>
<EndFunc Name='GetCAContext' Return='T' GetLastError='203'>
Doing Action: Rollback_sqlFileRename
PerfTime Start: Rollback_sqlFileRename : Mon Jul 17 15:38:59 2006
<Func Name='Rollback_sqlFileRename'>
<EndFunc Name='Rollback_sqlFileRename' Return='0' GetLastError='0'>
PerfTime Stop: Rollback_sqlFileRename : Mon Jul 17 15:38:59 2006
<EndFunc Name='LaunchFunction' Return='0' GetLastError='0'>
MSI (s) (A4:FC) [15:38:59:796]: Executing op:
ActionStart(Name=Do_sqlFileRename.D20239D7_E87C_40C9_9837_E70B8D4882C2,Description=Renaming
Files,)
MSI (s) (A4:FC) [15:38:59:796]: Executing op:
ActionStart(Name=Rollback_sqlFileRename.D20239D7_E87C_40C9_9837_E70B8D4882C2,Description=Renam
ing Files,)
MSI (s) (A4:FC) [15:38:59:796]: Executing op:
CustomActionRollback(Action=Rollback_sqlFileRename.D20239D7_E87C_40C9_9837_E70B8D4882C2,Action
Type=1345,Source=BinaryData,Target=Rollback_sqlFileRename,CustomActionData=100Renaming
Files200C:\Program Files\Microsoft SQL Server\MSSQL.2\MSSQL\Data\distmdl1.ldfC:\Program
Files\Microsoft SQL Server\MSSQL.2\MSSQL\Data\distmdl.ldf00)
MSI (s) (A4:E0) [15:38:59:812]: Invoking remote custom action. DLL:
C:\WINDOWS\Installer\MSI43C.tmp, Entrypoint: Rollback_sqlFileRename
<Func Name='LaunchFunction'>
Function=Rollback_sqlFileRename
<Func Name='GetCAContext'>
<EndFunc Name='GetCAContext' Return='T' GetLastError='203'>
Doing Action: Rollback_sqlFileRename
PerfTime Start: Rollback_sqlFileRename : Mon Jul 17 15:38:59 2006
<Func Name='Rollback_sqlFileRename'>
<EndFunc Name='Rollback_sqlFileRename' Return='0' GetLastError='0'>
PerfTime Stop: Rollback_sqlFileRename : Mon Jul 17 15:38:59 2006
<EndFunc Name='LaunchFunction' Return='0' GetLastError='0'>
MSI (s) (A4:FC) [15:38:59:843]: Executing op:
ActionStart(Name=Do_sqlFileRename.D20239D7_E87C_40C9_9837_E70B8D4882C2,Description=Renaming
Files,)
MSI (s) (A4:FC) [15:38:59:859]: Executing op:
ActionStart(Name=Rollback_sqlFileRename.D20239D7_E87C_40C9_9837_E70B8D4882C2,Description=Renam
ing Files,)
MSI (s) (A4:FC) [15:38:59:859]: Executing op:
CustomActionRollback(Action=Rollback_sqlFileRename.D20239D7_E87C_40C9_9837_E70B8D4882C2,Action
Type=1345,Source=BinaryData,Target=Rollback_sqlFileRename,CustomActionData=100Renaming
Files200C:\Program Files\Microsoft SQL
Server\MSSQL.2\MSSQL\Data\mssqlsystemresource1.mdfC:\Program Files\Microsoft SQL
Server\MSSQL.2\MSSQL\Data\mssqlsystemresource.mdf00)
MSI (s) (A4:3C) [15:38:59:875]: Invoking remote custom action. DLL:
C:\WINDOWS\Installer\MSI43D.tmp, Entrypoint: Rollback_sqlFileRename
<Func Name='LaunchFunction'>
Function=Rollback_sqlFileRename
<Func Name='GetCAContext'>
<EndFunc Name='GetCAContext' Return='T' GetLastError='203'>
Doing Action: Rollback_sqlFileRename
PerfTime Start: Rollback_sqlFileRename : Mon Jul 17 15:38:59 2006
<Func Name='Rollback_sqlFileRename'>
<EndFunc Name='Rollback_sqlFileRename' Return='0' GetLastError='0'>
PerfTime Stop: Rollback_sqlFileRename : Mon Jul 17 15:38:59 2006
<EndFunc Name='LaunchFunction' Return='0' GetLastError='0'>
MSI (s) (A4:FC) [15:38:59:906]: Executing op:
ActionStart(Name=Do_sqlFileRename.D20239D7_E87C_40C9_9837_E70B8D4882C2,Description=Renaming
Files,)
MSI (s) (A4:FC) [15:38:59:906]: Executing op:
ActionStart(Name=Rollback_sqlFileRename.D20239D7_E87C_40C9_9837_E70B8D4882C2,Description=Renam
ing Files,)
MSI (s) (A4:FC) [15:38:59:906]: Executing op:
CustomActionRollback(Action=Rollback_sqlFileRename.D20239D7_E87C_40C9_9837_E70B8D4882C2,Action
Type=1345,Source=BinaryData,Target=Rollback_sqlFileRename,CustomActionData=100Renaming
Files200C:\Program Files\Microsoft SQL
Server\MSSQL.2\MSSQL\Data\mssqlsystemresource1.ldfC:\Program Files\Microsoft SQL
Server\MSSQL.2\MSSQL\Data\mssqlsystemresource.ldf00)
MSI (s) (A4:18) [15:38:59:921]: Invoking remote custom action. DLL:
C:\WINDOWS\Installer\MSI43E.tmp, Entrypoint: Rollback_sqlFileRename
<Func Name='LaunchFunction'>
Function=Rollback_sqlFileRename
<Func Name='GetCAContext'>
<EndFunc Name='GetCAContext' Return='T' GetLastError='203'>
Doing Action: Rollback_sqlFileRename
PerfTime Start: Rollback_sqlFileRename : Mon Jul 17 15:38:59 2006
<Func Name='Rollback_sqlFileRename'>
<EndFunc Name='Rollback_sqlFileRename' Return='0' GetLastError='0'>
PerfTime Stop: Rollback_sqlFileRename : Mon Jul 17 15:38:59 2006
<EndFunc Name='LaunchFunction' Return='0' GetLastError='0'>
MSI (s) (A4:FC) [15:38:59:953]: Executing op:
ActionStart(Name=StartServices,Description=Starting services,Template=Service: [1])
MSI (s) (A4:FC) [15:38:59:953]: Executing op:
ActionStart(Name=CASetLaunchPermissions.68C6D15C_77E0_11D5_8528_00C04F68155C,,)
MSI (s) (A4:FC) [15:38:59:953]: Executing op:
ActionStart(Name=CAFTEInstallPerfCounters.68C6D15C_77E0_11D5_8528_00C04F68155C,,)
MSI (s) (A4:FC) [15:38:59:953]: Executing op:
ActionStart(Name=CAFTEAddCertificate.68C6D15C_77E0_11D5_8528_00C04F68155C,,)
MSI (s) (A4:FC) [15:38:59:953]: Executing op:
ActionStart(Name=Do_WMISecurity.D20239D7_E87C_40C9_9837_E70B8D4882C2,Description=Installing
WMI registration,)
MSI (s) (A4:FC) [15:38:59:968]: Executing op:
ActionStart(Name=Do_WMISecurity.D20239D7_E87C_40C9_9837_E70B8D4882C2,Description=Installing
WMI registration,)
MSI (s) (A4:FC) [15:38:59:968]: Executing op:
ActionStart(Name=Do_WMISecurity.D20239D7_E87C_40C9_9837_E70B8D4882C2,Description=Installing
WMI registration,)
MSI (s) (A4:FC) [15:38:59:968]: Executing op:
ActionStart(Name=Do_sqlMofcomp.D20239D7_E87C_40C9_9837_E70B8D4882C2,Description=Installing WMI
registration,)
MSI (s) (A4:FC) [15:38:59:968]: Executing op:
ActionStart(Name=Rollback_sqlMofcomp.D20239D7_E87C_40C9_9837_E70B8D4882C2,Description=Installi
ng WMI registration,)
MSI (s) (A4:FC) [15:38:59:968]: Executing op:
CustomActionRollback(Action=Rollback_sqlMofcomp.D20239D7_E87C_40C9_9837_E70B8D4882C2,ActionTyp
e=1281,Source=BinaryData,Target=Rollback_sqlMofcomp,CustomActionData=010Installing WMI
registration50000\\.\root\Microsoft\SqlServer\ServerEvents\MSSQLSERVERC:\Program
Files\Microsoft SQL Server\MSSQL.2\MSSQL\Binn\sqlwep-uni.mof)
MSI (s) (A4:40) [15:38:59:984]: Invoking remote custom action. DLL:
C:\WINDOWS\Installer\MSI43F.tmp, Entrypoint: Rollback_sqlMofcomp
<Func Name='LaunchFunction'>
Function=Rollback_sqlMofcomp
<Func Name='GetCAContext'>
<EndFunc Name='GetCAContext' Return='T' GetLastError='203'>
Doing Action: Rollback_sqlMofcomp
PerfTime Start: Rollback_sqlMofcomp : Mon Jul 17 15:39:00 2006
<Func Name='UninstallMOF'>
Namespace MSSQLSERVER deleted
<EndFunc Name='UninstallMOF' Return='0' GetLastError='0'>
PerfTime Stop: Rollback_sqlMofcomp : Mon Jul 17 15:39:00 2006
<EndFunc Name='LaunchFunction' Return='0' GetLastError='0'>
MSI (s) (A4:FC) [15:39:00:203]: Executing op:
ActionStart(Name=Do_sqlMofcomp.D20239D7_E87C_40C9_9837_E70B8D4882C2,Description=Installing WMI
registration,)
MSI (s) (A4:FC) [15:39:00:218]: Executing op:
ActionStart(Name=Do_sqlMofcomp.D20239D7_E87C_40C9_9837_E70B8D4882C2,Description=Installing WMI
registration,)
MSI (s) (A4:FC) [15:39:00:218]: Executing op:
ActionStart(Name=Do_sqlMofcomp.D20239D7_E87C_40C9_9837_E70B8D4882C2,Description=Installing WMI
registration,)
MSI (s) (A4:FC) [15:39:00:218]: Executing op:
ActionStart(Name=Do_sqlServiceSDDL.D20239D7_E87C_40C9_9837_E70B8D4882C2,Description=Setting
Service Security,Template=Service: [1])
MSI (s) (A4:FC) [15:39:00:218]: Executing op:
ActionStart(Name=Do_sqlRegSDDL.D20239D7_E87C_40C9_9837_E70B8D4882C2,Description=Setting
Registry Security,Template=Key: [1])
MSI (s) (A4:FC) [15:39:00:218]: Executing op:
ActionStart(Name=Do_SetServerSSNLDefaults.D20239D7_E87C_40C9_9837_E70B8D4882C2,Description=Set
ting Server Network Default Settings,)
MSI (s) (A4:FC) [15:39:00:218]: Executing op:
ActionStart(Name=Rollback_SetServerSSNLDefaults.D20239D7_E87C_40C9_9837_E70B8D4882C2,Descripti
on=Setting Client Network Default Settings,)
MSI (s) (A4:FC) [15:39:00:218]: Executing op:
CustomActionRollback(Action=Rollback_SetServerSSNLDefaults.D20239D7_E87C_40C9_9837_E70B8D4882C
2,ActionType=1345,Source=BinaryData,Target=Rollback_SetServerSSNLDefaults,CustomActionData=01
0Setting Client Network Default Settings10000MSSQLSERVERMSSQL.2MSSQL.211)
MSI (s) (A4:58) [15:39:00:234]: Invoking remote custom action. DLL:
C:\WINDOWS\Installer\MSI440.tmp, Entrypoint: Rollback_SetServerSSNLDefaults
<Func Name='LaunchFunction'>

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top