Showing posts with label latest. Show all posts
Showing posts with label latest. Show all posts

Wednesday, March 28, 2012

Installing the cumulative hotfix onto Express

So today I decided I may as well put the latest hotfix package for Sql 2005 onto my laptop.

Unlike SP1 the hotfix actually seemed to know about SQL Express and attempt to install itself only to collapse in a big heap. The log file indicates it can't find a bunch of files it wants to patch.

So how do I apply the hotfixes to Express?

If the upgrade or hotfix fails, it makes a bunch of entries in the System and Application event logs, and also has a log of it's own. The hotfix tells you where the log file is located when it starts.

Buck Woody

Monday, March 26, 2012

Installing the cumulative hotfix onto Express

So today I decided I may as well put the latest hotfix package for Sql 2005 onto my laptop.

Unlike SP1 the hotfix actually seemed to know about SQL Express and attempt to install itself only to collapse in a big heap. The log file indicates it can't find a bunch of files it wants to patch.

So how do I apply the hotfixes to Express?

If the upgrade or hotfix fails, it makes a bunch of entries in the System and Application event logs, and also has a log of it's own. The hotfix tells you where the log file is located when it starts.

Buck Woody

Monday, March 19, 2012

Installing SQL Server 2005 Express edition

I'm trying to install the latest SQL Server Express downloaded from Microsoft. I've followed all instructions on the download page but get the message concerning Incompatible Components being found on my machine. To my knowledge I have never installed any previous components from any betas or other previous versions. Nor have I had a previous version of .Net Framework 2.0 on my machine. Just in case, I've checked Add/Remove Programs and run the removal tool as recommended on the Microsoft site. The tool reports that it can't find any components! If I knew what to look for I'd go through the Registry to manually uninstall any problem keys. The trouble is that I can't get through to Microsoft to find out what might be causing the trouble. It appears that I'm not alone. Can anyone help please.Search for a file with a name that ends with Core.log. It can be found under C:\Program Files\Microsoft SQL Server, if you installed SQL Server in C: drive.

Please find the latest version of the file. This file will list any incompatible component(s), that was found during installation.

I hope this helps.

-- JB|||Many thanks John. That was very helpful and I am grateful for your suggestion. On looking into the core.log file I've extracted the following piece of information:
"Product "{44568A1C-53F6-49A5-A163-CD9ADC0F76D5}" versioned 2.0.50727 is not compatible with current builds of SQL Server. Expected at least version: 2.0.50727.42 The Product Name is "Microsoft .NET Framework 2.0". Unfortunately, the most recent version that I can find from the Microsoft site is version 2.0.50727!!!!!!!!!!! Can anyone help me find the 2.0.50727.42 version?|||This is one area where things are confusing... I believe there were a few builds of the .NET Framework that were released that were versioned 2.0.50727.xx prior to the final release. The 2.0.50727.42 version is the FINAL RTM version of the 2.0 framework. If the very last number in the version is < 42, you do not have the final released version installed.

You can download the final release of the 2.0 framework from here:

http://www.microsoft.com/downloads/details.aspx?FamilyID=0856eacb-4362-4b0d-8edd-aab15c5e04f5&DisplayLang=en

jeff.|||Thanks Jeff. You're right this is VERY confusing. I believe that the link you've given me is the one that I downloaded and tried to install. Unfortunately without success. Since experimenting a bit I've actually found a download that works. Unfortunately, I've had to pull down the full SDK version. This is a BIG download with lots and lots of stuff. I have now got a working version of SQL Server 2005 Express but with a massive overhead of other peripheral material. Since installing it all (I wasn't given any choice as to what to install) my notebook has become very sluggish! You just can't win can you! It's all or nothing with this lot!!!!
Thanks to everyone for their help.

Monday, March 12, 2012

Integrated Security

Hi,

I tried to access sql server through windows authentication with the latest 6/26 JDBC driver. My url is "jdbc:sqlserver://<hostname>:1433;integratedSecurity=true;". I was getting error "Invalid integratedSecurity property value:true". Can someone know how to resolve it?

Thanks.

run sql profiler trace. have a look of whats happening at the server perspective. verify if there is really an activity in the server|||

Thanks.

I ran sql profiler trace, and there are activity on that server and instance. Any other suggestions.

|||

JDBC driver does not support integrated authentication yet. There is effort to ship it in next release. Stay tuned.

Thanks,

Friday, February 24, 2012

Installing SQL 2005 on a failover cluster

Hi,
I am trying to install SQL2005 onto a failover cluster. the latest install
produced the following log file extract
-
Property(S): HeadText_ReadyInstall = Ready to Install the Program
Property(S): HeadText_ReadyRepair = Ready to Repair the Program
Property(S): HeadText_ReadyModify = Ready to Modify the Program
Property(S): HeadText_RemoveProgram = Remove the Program
Property(S): HeadText_OutOfDiskSpace = Out of Disk Space
Property(S): DescText_FilesInUse = Some files that need to be updated are
currently in use.
Property(S): DescText_RegistrationInformation = The following information
will personalize your installation.
Property(S): DescText_ServerImage = Setup will create a server image of
Property(S): DescText_ServerImage2 = at a specified network location. To
continue, click Next.
Property(S): DescText_InstallModifyRemove = Setup helps you install, modify
or remove
Property(S): DescText_InstallModifyRemove2 = . To continue, click Next.
Property(S): DescText_PatchInstall = The Install Wizard will install the
Patch for
Property(S): DescText_PatchInstall2 = on your computer. To continue, click
Update.
Property(S): DescText_WizardComplete = The Install Wizard will complete the
installation of
Property(S): DescText_WizardComplete2 = on your computer. To continue,
click Next.
Property(S): DescText_CompleteSuspended = The Install Wizard will complete
the suspended installation of
Property(S): DescText_CompleteSuspended2 = on your computer. To continue,
click Next.
Property(S): DescText_SuccessfulInstallation = Setup has installed
Property(S): DescText_SuccessfulInstallation2 = successfully. Click Finish
to exit.
Property(S): DescText_SuccessfulRemove = Setup has removed
Property(S): DescText_SuccessfulRemove2 = successfully. Click Finish to exit.
Property(S): DescText_SuccessfulRepair = Setup has repaired
Property(S): DescText_SuccessfulRepair2 = successfully. Click Finish to exit.
Property(S): DescText_SuccessfulModify = Setup has modified
Property(S): DescText_SuccessfulModify2 = successfully. Click Finish to exit.
Property(S): DescText_SetupInterrupted = Setup was interrupted before
Property(S): DescText_SetupInterrupted2 = could be completely installed.
Property(S): DescText_PreparingSetup = Setup is preparing the Install
Wizard which will guide you through the program setup process. Please wait.
Property(S): DescText_FeatureSelection = Select the program features you
want installed.
Property(S): DescText_ProgramFeaturesInstall = The program features you
selected are being installed.
Property(S): DescText_ProgramFeaturesUninstall = The program features you
selected are being uninstalled.
Property(S): DescText_ReadLicense = Please read the following license
agreement carefully.
Property(S): DescText_SpecifyNetworkLocation = Specify a network location
for the server image of the product.
Property(S): DescText_BrowseDestination = Browse to the destination folder.
Property(S): DescText_ModifyRepairRemove = Repair or remove the program.
Property(S): DescText_ReadyInstallation = Setup is ready to begin
installation.
Property(S): DescText_ChosenRemove = You have chosen to remove the program
from your system.
Property(S): DescText_DiskSpaceRequirements = The disk space required for
the installation of the selected features.
Property(S): DescText_DiskExceedsAvailable = Disk space required for the
installation exceeds available disk space.
Property(S): Text_ReRunSetup = Your system has not been modified. To
complete installation at another time, please run setup again.
Property(S): Text_FinishExit = Click Finish to exit Setup.
Property(S): Text_RestoreState = You can either keep any existing installed
elements on your system to continue this installation at a later time or you
can restore your system to its original state prior to the installation.
Property(S): Text_RestoreClick = Click Restore or Continue Later to exit
Setup.
Property(S): Text_InstallWait = Please wait while the Install Wizard installs
Property(S): Text_InstallWait2 = . This may take several minutes.
Property(S): Text_UninstallWaitText = Please wait while the Install Wizard
uninstalls
Property(S): Text_UninstallWaitText2 = . This may take several minutes.
Property(S): Text_UninstallWait = Please wait while the Install Wizard
uninstalls
Property(S): Text_UninstallWait2 = . This may take several minutes.
Property(S): Text_ProgressDone = Progress done
Property(S): Text_Copyright = WARNING: This program is protected by
copyright law and international treaties.
Property(S): Text_BeginInstallation = Click Install to begin the installation.
Property(S): Text_ReviewChange = If you want to review or change any of your
installation settings, click Back. Click Cancel to exit Setup.
Property(S): Text_AlterFeatureInstall = Click an icon in the following list
to change how a feature is installed.
Property(S): Text_ConfirmExit = The installation is not yet complete. Are
you sure you want to exit?
Property(S): Text_FeatureSelectionDescription = This feature requires 4 MB
on your hard drive.
Property(S): Text_EnterNetworkLocation = Enter the network location or click
Change to browse to a location. Click Install to create a server image of
Property(S): Text_EnterNetworkLocation2 = at the specified network location
or click Cancel to exit Setup.
Property(S): Text_SelectDifferentDrive = The highlighted volumes do not have
enough disk space available for the currently selected features. You can
remove files from the highlighted volumes, choose to install less features
onto local drives, or select different destination drives.
Property(S): Text_RepairInstallationErrors = Repair installation errors in
the program. This option fixes missing or corrupt files, shortcuts, and
registry entries.
Property(S): Text_RemoveFromComputer = Remove
Property(S): Text_RemoveFromComputer2 = from your computer.
Property(S): Text_UsingFilesRetry = The following applications are using
files that need to be updated by this setup. Close these applications and
click Retry to continue.
Property(S): Text_ClickRemove = Click Remove to remove
Property(S): Text_ClickRemove2 = from your computer. After removal, this
program will no longer be available for use.
Property(S): Text_ReviewChangeBack = If you want to review or change any
settings, click Back.
Property(S): Text_AllUsers = &Anyone who uses this computer (all users)
Property(S): Text_OnlyMe = Only for &me ([USERNAME])
Property(S): Text_NotAcceptTerms = I &do not accept the terms in the license
agreement
Property(S): Text_AcceptTerms = I &accept the terms in the license agreement
Property(S): Text_RegInfoNameAndOrg = Enter your name and the name of your
organization in the fields below.
Property(S): Text_RegInfoOrg = Enter the name of your organization in the
field below.
Property(S): Upgrade_Confirmation = A lower version of this product has been
detected on your system. Would you like to upgrade your existing installation?
Property(S): AdminMessage = Setup requires user to be in the administrator
group in order to continue the installation process. Setup is aborting as the
current user is not in the administrator group.
Property(S): SupportedOSMessage = Installation of this product failed
because it is not supported on this operating system. For information on
supported configurations, see the product documentation.
Property(S): ShortCutText = Microsoft SQL Server Native Client
Property(S): DialogTitle = Microsoft SQL Server Native Client Setup
Property(S): ProductName = Microsoft SQL Server Native Client
Property(S): ShortName = Microsoft SQL Server Native Client
Property(S): SupportedProcTypeMessage = This Microsoft SQL Server Native
Client package is not supported on the current processor type.
Property(S): DialogPatchTitle = Microsoft SQL Server Native Client Patch
Property(S): EnableFeatureDlg = 1
Property(S): EnableBrowseButton = 0
Property(S): CustomPath = SNAC
Property(S): AdminUser = 1
Property(S): ARPHELPLINK = http://go.microsoft.com/fwlink/?LinkId=52153
Property(S): ProgramFilesFolder = C:\Program Files\
Property(S): SqlShared = C:\Program Files\Microsoft SQL Server\
Property(S): SqlVer = C:\Program Files\Microsoft SQL Server\90\
Property(S): SqlTools = C:\Program Files\Microsoft SQL Server\90\Tools\
Property(S): SqlToolsBin = C:\Program Files\Microsoft SQL
Server\90\Tools\Binn\
Property(S): VSRetarget = C:\Program Files\Microsoft SQL Server\90\Tools\Binn\
Property(S): Ver90.84118FFB_F307_45F3_B5BC_3A4F8261108D = C:\Program
Files\Microsoft SQL Server\90\
Property(S): EULA.84118FFB_F307_45F3_B5BC_3A4F8261108D = C:\Program
Files\Microsoft SQL Server\90\EULA\
Property(S): SystemFolder = C:\WINDOWS\system32\
Property(S): SNACMainModId.335C9CFA_7DD6_41E0_8E4F_44D6ED5B1A54 =
9B634CFE_9A39_4508_9CA8_D8DE65A7B8AD
Property(S): WinSxsDirectory.98CB24AD_52FB_DB5F_FF1F_C8B3B9A1E1 8E =
C:\WINDOWS\winsxs\
Property(S): payload_ul.98CB24AD_52FB_DB5F_FF1F_C8B3B9A1E18E =
C:\WINDOWS\winsxs\x86_microsoft.vc80.crt_1fc8b3b9a 1e18e3b_8.0.50727.42_none_db5f52fb98cb24ad\
Property(S): payload.98CB24AD_52FB_DB5F_FF1F_C8B3B9A1E18E =
C:\WINDOWS\winsxs\x86_Microsoft.VC80.CRT_1fc8b3b9a 1e18e3b_8.0.50727.42_x-ww_0de06acd\
Property(S): WindowsFolder.98CB24AD_52FB_DB5F_FF1F_C8B3B9A1E18E = C:\WINDOWS\
Property(S): SystemFolder.98CB24AD_52FB_DB5F_FF1F_C8B3B9A1E18E =
C:\WINDOWS\system32\
Property(S): WinSxsManifests.98CB24AD_52FB_DB5F_FF1F_C8B3B9A1E1 8E =
C:\WINDOWS\winsxs\Manifests\
Property(S): WinSxsPolicies.98CB24AD_52FB_DB5F_FF1F_C8B3B9A1E18 E =
C:\WINDOWS\winsxs\Policies\
Property(S): policydir.98CB24AD_52FB_DB5F_FF1F_C8B3B9A1E18E =
C:\WINDOWS\winsxs\Policies\x86_Microsoft.VC80.CRT_ 1fc8b3b9a1e18e3b_x-ww_4428b63a\
Property(S): policydir_ul.98CB24AD_52FB_DB5F_FF1F_C8B3B9A1E18E =
C:\WINDOWS\winsxs\x86_Microsoft.VC80.CRT_1fc8b3b9a 1e18e3b_8.0.50727.42_x-ww_0de06acd\
Property(S): WinSxsDirectory.63E949F6_03BC_5C40_FF1F_C8B3B9A1E1 8E =
C:\WINDOWS\winsxs\
Property(S): payload_ul.63E949F6_03BC_5C40_FF1F_C8B3B9A1E18E =
C:\WINDOWS\winsxs\x86_policy.8.0.microsoft.vc80.cr t_1fc8b3b9a1e18e3b_8.0.50727.42_none_5c4003bc63e94 9f6\
Property(S): WinSxsPolicies.63E949F6_03BC_5C40_FF1F_C8B3B9A1E18 E =
C:\WINDOWS\winsxs\Policies\
Property(S): policydir.63E949F6_03BC_5C40_FF1F_C8B3B9A1E18E =
C:\WINDOWS\winsxs\Policies\x86_policy.8.0.Microsof t.VC80.CRT_1fc8b3b9a1e18e3b_x-ww_77c24773\
Property(S): WindowsFolder.63E949F6_03BC_5C40_FF1F_C8B3B9A1E18E = C:\WINDOWS\
Property(S): SystemFolder.63E949F6_03BC_5C40_FF1F_C8B3B9A1E18E =
C:\WINDOWS\system32\
Property(S): WinSxsManifests.63E949F6_03BC_5C40_FF1F_C8B3B9A1E1 8E =
C:\WINDOWS\winsxs\Manifests\
Property(S): payload.63E949F6_03BC_5C40_FF1F_C8B3B9A1E18E =
C:\WINDOWS\winsxs\x86_policy.8.0.Microsoft.VC80.CR T_1fc8b3b9a1e18e3b_8.0.50727.42_x-ww_51e427d4\
Property(S): policydir_ul.63E949F6_03BC_5C40_FF1F_C8B3B9A1E18E =
C:\WINDOWS\winsxs\x86_policy.8.0.Microsoft.VC80.CR T_1fc8b3b9a1e18e3b_8.0.50727.42_x-ww_51e427d4\
Property(S): Ver.06870705_8636_410E_B591_FEE8962A550E = C:\Program
Files\Microsoft SQL Server\90\
Property(S): SqlSDK.06870705_8636_410E_B591_FEE8962A550E = C:\Program
Files\Microsoft SQL Server\90\SDK\
Property(S): SqlInclude.06870705_8636_410E_B591_FEE8962A550E = C:\Program
Files\Microsoft SQL Server\90\SDK\Include\
Property(S): SqlSDKLib.06870705_8636_410E_B591_FEE8962A550E = C:\Program
Files\Microsoft SQL Server\90\SDK\Lib\
Property(S): SqlSDKLibPlatformTarget.06870705_8636_410E_B591_FE E8962A550E =
C:\Program Files\Microsoft SQL Server\90\SDK\Lib\x86\
Property(S): PackagecodeChanging = 1
Property(S): REBOOT = ReallySuppress
Property(S): SKIPPENDINGREBOOTCHECK = 1
Property(S): CURRENTDIRECTORY = D:\SQLServer2005\Servers
Property(S): CLIENTUILEVEL = 3
Property(S): CLIENTPROCESSID = 5252
Property(S): VersionDatabase = 301
Property(S): VersionMsi = 3.01
Property(S): WindowsBuild = 3790
Property(S): ServicePackLevel = 1
Property(S): ServicePackLevelMinor = 0
Property(S): MsiNTProductType = 3
Property(S): MsiNTSuiteEnterprise = 1
Property(S): WindowsFolder = C:\WINDOWS\
Property(S): WindowsVolume = C:\
Property(S): System16Folder = C:\WINDOWS\system\
Property(S): RemoteAdminTS = 1
Property(S): TempFolder = c:\documentsandsettings\LocalSettings\Temp\
Property(S): CommonFilesFolder = C:\Program Files\Common Files\
Property(S): AppDataFolder = C:\Documents and
Settings\#meg.neeson\Application Data\
Property(S): FavoritesFolder = C:\Documents and
Settings\#meg.neeson\Favorites\
Property(S): NetHoodFolder = C:\Documents and Settings\#meg.neeson\NetHood\
Property(S): PersonalFolder = C:\Documents and Settings\#meg.neeson\My
Documents\
Property(S): PrintHoodFolder = C:\Documents and
Settings\#meg.neeson\PrintHood\
Property(S): RecentFolder = C:\Documents and Settings\#meg.neeson\Recent\
Property(S): SendToFolder = C:\Documents and Settings\#meg.neeson\SendTo\
Property(S): TemplateFolder = C:\Documents and Settings\All Users\Templates\
Property(S): CommonAppDataFolder = C:\Documents and Settings\All
Users\Application Data\
Property(S): LocalAppDataFolder = C:\Documents and
Settings\#meg.neeson\Local Settings\Application Data\
Property(S): MyPicturesFolder = C:\Documents and Settings\#meg.neeson\My
Documents\My Pictures\
Property(S): AdminToolsFolder = C:\Documents and Settings\All Users\Start
Menu\Programs\Administrative Tools\
Property(S): StartupFolder = C:\Documents and Settings\All Users\Start
Menu\Programs\Startup\
Property(S): ProgramMenuFolder = C:\Documents and Settings\All Users\Start
Menu\Programs\
Property(S): StartMenuFolder = C:\Documents and Settings\All Users\Start Menu\
Property(S): DesktopFolder = C:\Documents and Settings\All Users\Desktop\
Property(S): FontsFolder = C:\WINDOWS\Fonts\
Property(S): GPTSupport = 1
Property(S): OLEAdvtSupport = 1
Property(S): ShellAdvtSupport = 1
Property(S): Intel = 15
Property(S): PhysicalMemory = 4094
Property(S): VirtualMemory = 5949
Property(S): LogonUser = #meg.neeson
Property(S): UserSID = S-1-5-21-1614895754-507921405-1801674531-799107
Property(S): UserLanguageID = 2057
Property(S): ComputerName = LNMHCAP002
Property(S): SystemLanguageID = 2057
Property(S): ScreenX = 1024
Property(S): ScreenY = 768
Property(S): CaptionHeight = 19
Property(S): BorderTop = 1
Property(S): BorderSide = 1
Property(S): TextHeight = 16
Property(S): ColorBits = 32
Property(S): TTCSupport = 1
Property(S): Time = 08:24:15
Property(S): Date = 24/04/2007
Property(S): MsiNetAssemblySupport = 2.0.50727.42
Property(S): MsiWin32AssemblySupport = 5.2.3790.1830
Property(S): RedirectedDllSupport = 2
Property(S): DATABASE = C:\WINDOWS\Installer\38e40cd.msi
Property(S): OriginalDatabase = D:\SQLServer2005\Servers\setup\sqlncli.msi
Property(S): UILevel = 2
Property(S): ACTION = INSTALL
Property(S): DOTNETCOREPATH = 1
Property(S): ROOTDRIVE = E:\
Property(S): CostingComplete = 1
Property(S): OutOfDiskSpace = 0
Property(S): OutOfNoRbDiskSpace = 0
Property(S): PrimaryVolumeSpaceAvailable = 0
Property(S): PrimaryVolumeSpaceRequired = 0
Property(S): PrimaryVolumeSpaceRemaining = 0
MSI (s) (D4:6C) [08:24:15:046]: Cleaning up uninstalled install packages, if
any exist
MSI (s) (D4:6C) [08:24:15:046]: MainEngineThread is returning 1603
MSI (s) (D4:F4) [08:24:15:156]: Destroying RemoteAPI object.
MSI (s) (D4:F4) [08:24:15:156]: Custom Action Manager thread ending.
=== Logging stopped: 24/04/2007 08:24:15 ===
MSI (c) (84:00) [08:24:15:156]: Decrementing counter to disable shutdown. If
counter >= 0, shutdown will be denied. Counter after decrement: -1
MSI (c) (84:00) [08:24:15:156]: MainEngineThread is returning 1603
=== Verbose logging stopped: 24/04/2007 08:24:15 ===
Has anyone seen this error before - I can't seem to find anything that fits
online?
cheers
Meg
hi Meg,
On what OS are you installing and are you using credentials with
administrative access to both cluster nodes?
see log:
Property(S): Upgrade_Confirmation = A lower version of this product has been
detected on your system. Would you like to upgrade your existing installation?
Property(S): AdminMessage = Setup requires user to be in the administrator
group in order to continue the installation process. Setup is aborting as the
current user is not in the administrator group.
Property(S): SupportedOSMessage = Installation of this product failed
because it is not supported on this operating system. For information on
supported configurations, see the product documentation.