Instance Uniunstall problem with "Uninst.isu" file

I am attempting to uninstall an instance of SQL Server 2000. When I run the SS2000 "change/uninstall" process in "Add/Remove Programs" (Control Panel), I get an error message stating that ...

"Unable to locate the installation log file 'C:\Program Files\Microsoft SQL Server\....\Uninst.isu Uninstallation will not continue."

I have looked in the directory and the file is not there.How do I uninstall SS2000?

Hi,

I am facing the same problem in fact I have manually removed all traces of sql server 2000 in program files. It is still exisiting in add/remove programs. How to remove it from there.

Thanks,

Bharath

|||

Even I am facing the same problem.

Can anyone help us., Please...

sql

Instance Uniunstall problem with "Uninst.isu" file

I am attempting to uninstall an instance of SQL Server 2000. When I run the SS2000 "change/uninstall" process in "Add/Remove Programs" (Control Panel), I get an error message stating that ...

"Unable to locate the installation log file 'C:\Program Files\Microsoft SQL Server\....\Uninst.isu Uninstallation will not continue."

I have looked in the directory and the file is not there.How do I uninstall SS2000?

Hi,

I am facing the same problem in fact I have manually removed all traces of sql server 2000 in program files. It is still exisiting in add/remove programs. How to remove it from there.

Thanks,

Bharath

Instance Uniunstall problem with "Uninst.isu" file

I am attempting to uninstall an instance of SQL Server 2000. When I run the SS2000 "change/uninstall" process in "Add/Remove Programs" (Control Panel), I get an error message stating that ...

"Unable to locate the installation log file 'C:\Program Files\Microsoft SQL Server\....\Uninst.isu Uninstallation will not continue."

I have looked in the directory and the file is not there.How do I uninstall SS2000?

Hi,

I am facing the same problem in fact I have manually removed all traces of sql server 2000 in program files. It is still exisiting in add/remove programs. How to remove it from there.

Thanks,

Bharath

|||

Even I am facing the same problem.

Can anyone help us., Please...

Instance specified not valid

Hi,

I'm trying to install MSDE SP3 which I downloaded from MS at http://www.asp.net/msde/.
Following the instructions as best I can I unzipped the file into a Folder now called MSDE located on C: I then went to a command prompt and typed in the command given to start the install:

setup SAPWD=testsite SecurityMode=SQL

Hit enter and the installer started up and ran for a few secs and then came back with

The Instance named specified is invalid

There was no mention of including an instance name or the format for it.

Suggestions please?

Also, if I want to completly uninstall MSDE if I need to how would I do it?

Thanks,
BobWell, I had this message come up if I tried to run setup for the instance that was already on the system.

I used this setup to install msde on my machine.

setup instancename="netsdk" sapwd="your password for sa" securitymode=sql

Reason for using instance name netsdk was that it seems that SDK kit needs this instance to install pubs and nwind database.

After executing this i did not get any error messages but when I started service manager I could not see any servers listed. It took me solid two hours to come up with idea to look into error log and there it was.

2004-03-09 11:57:44.50 server Microsoft SQL Server 2000 - 8.00.760 (Intel X86)
Dec 17 2002 14:22:05
Copyright (c) 1988-2003 Microsoft Corporation
Desktop Engine on Windows NT 5.1 (Build 2600: Service Pack 1)

2004-03-09 11:57:44.50 server Copyright (C) 1988-2002 Microsoft Corporation.
2004-03-09 11:57:44.50 server All rights reserved.
2004-03-09 11:57:44.50 server Server Process ID is 3456.
2004-03-09 11:57:44.50 server Logging SQL Server messages in file 'C:\Program Files\Microsoft SQL Server\MSSQL$NETSDK\LOG\ERRORLOG'.
2004-03-09 11:57:44.52 server SQL Server is starting at priority class 'normal'(2 CPUs detected).
2004-03-09 11:57:44.63 server SQL Server configured for thread mode processing.
2004-03-09 11:57:44.63 server Using dynamic lock allocation. [500] Lock Blocks, [1000] Lock Owner Blocks.
2004-03-09 11:57:44.63 spid2 Warning ******************
2004-03-09 11:57:44.63 spid2 SQL Server started in single user mode. Updates allowed to system catalogs.
2004-03-09 11:57:44.63 spid2 Starting up database 'master'.
2004-03-09 11:57:44.98 spid5 Starting up database 'model'.
2004-03-09 11:57:44.98 server Using 'SSNETLIB.DLL' version '8.0.766'.
2004-03-09 11:57:45.03 spid2 Server name is 'PC0491-EPITKA\NETSDK'.
2004-03-09 11:57:45.03 spid2 Skipping startup of clean database id 5
2004-03-09 11:57:45.03 spid2 Skipping startup of clean database id 6
2004-03-09 11:57:45.03 spid2 Starting up database 'msdb'.
2004-03-09 11:57:45.17 server SQL server listening on Shared Memory.
2004-03-09 11:57:45.17 server SQL Server is ready for client connections
2004-03-09 11:57:45.38 spid5 Clearing tempdb database.
2004-03-09 11:57:46.12 spid5 Starting up database 'tempdb'.
2004-03-09 11:57:46.20 spid2 Recovery complete.
2004-03-09 11:57:46.20 spid2 SQL global counter collection task is created.
2004-03-09 11:57:46.22 spid2 Warning: override, autoexec procedures skipped.
2004-03-09 11:57:56.94 spid51 Error: 15457, Severity: 0, State: 1
2004-03-09 11:57:56.94 spid51 Configuration option 'allow updates' changed from 0 to 1. Run the RECONFIGURE statement to install..
2004-03-09 11:57:57.08 spid51 Error: 15457, Severity: 0, State: 1
2004-03-09 11:57:57.08 spid51 Configuration option 'allow updates' changed from 1 to 0. Run the RECONFIGURE statement to install..
2004-03-09 11:57:57.34 spid2 SQL Server is terminating due to 'stop' request from Service Control Manager.

There is a line that says servername, I typed it in and I was able to start service. Log should be under c:\program files\microsoft sql server\mssql${your instance name}\log.

I am very new to windows world since I worked on Unix platform for past six years, so for you gurus out there this migth be something that does not need to be explained. Anyway I hope this helps.sql

installtion file for SQL CE 2.0 to install in Real PocketPC

HI,

i have one instalation file of SQL CE 2.0 named setup.exe ,i installed that in my desktop it works well.i could not install the same file inside the pocketPC.Can any one give me some information about how to get the installation file of SQL CE 2.0 and how to install that in real pocketPC.Thanks in advance.

Best Regards

Ihsan

Not having worked with SQL CE 2.0 (available here) for a while I would assume that it follows the same pattern as the current verion which is that the installer is to be run on the desktop NOT the device. After running the installer either the runtime dlls or a mobile installer will be available - you should also read the ReadMe and consider installing the books online (available locally after installing the main SQL CE 2.0 installer)

Hope this helps.

InstallSQLAgentSecurity

Trying to install MSDE2000 on a clean Win2000Pro laptop. Installing from the SqlRun01.Msi file. According to the log it fails at.....
>>
Loading extended custom action library sqlcax.dll
Starting custom action InstallSQLAgentSecurity
InstallSQLAgentSecurity failed (TEST_0001,LocalSystem,87). <<

I can find where MS says there is an error, and it is Error# 60005, but nothing else.

I need to know what the problem is and how to fix it...

HELP! Deadline approaches.Applies to Windows 2000 OS.
MSDE 2000

Error: MSDE2000 fails to install correctly.

To Verify: Press Start|Run. Type "msiexec /i" <the fully qualified name and location of the sqlrun01.msi file> "/L* c:\msi.log" Press OK. This will run the install and place a log file called msi.log on the c:\. Check the log file for the word "Fail". Log should indicate that InstallSQLAgentSecurity failed.

Problem: File and Print Sharing are not enabled.* You will know this is not enabled if you are missing the "Service" service in the Services applet in Administrative Tools or
Control Panel.

Solution: Install File and printer sharing.|||AIkerd - THANK YOU for posting the solution to this. I spent 3 frustrating hours today fighting with this. Whoda thunk? Turing on File and Print sharing solved it immediately.

Mike G|||I have already done the logging but I have print and file sharing enabled anything else that might cause this problem?

your help is much appreciated

...already over my deadline

shiloh|||An MSDE Installation requires the Server service to be started.

Originally posted by shiloh69
I have already done the logging but I have print and file sharing enabled anything else that might cause this problem?

your help is much appreciated

...already over my deadline

shiloh

installing the Northwind database

Hi I have just started using the SQL Server 2005 Express Edition and wondering how to install the InstNwnd.sql from the sql file. I can't find any way to insert the database

Any help would be very appreciated

Thanks

I did figure it out|||

Hi howlinhuskie,

I'm so glad you have figured it out. To close this post, I add the scrpt below:

osql -E -S computerName/SqlExpress -i instnwnd.sql

Thanks.

|||Was there somthing I should have done to end the post?|||

Hi howlinhuskie,

No problem, I only post the solution in this thread so that the others can get the solution.

installing sql2005 standard problems.

I have an issue with trying to install SQL 2005 standard on my XP machine.
I get an .hta file that is not readable and when I btpass that I get a
pop-up message:
please go to the control panel to install and configure system components.
WTF?
PLease assist...
Gene
Geno (genegodsey@.hotmail.com) writes:
> I have an issue with trying to install SQL 2005 standard on my XP machine.
> I get an .hta file that is not readable and when I btpass that I get a
> pop-up message:
> please go to the control panel to install and configure system components.
From where did you get the media? Was it a download? Did you buy a
CD/DVD?
If Autorun does not set in, splash.hta is indeed the file to click to
get it going.
Note that you need IE6 SP1 to install SQL 2005. (And SP2 of Windows XP.)
I know I once tried to run the install on a machine with only IE5 - the
splash.hta produced a bunch of cryptc error messages instead of telling
me just to keep out.
If the file is entirely unreadable, it appears that you have bad
media, and you should get a replacement.
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx
|||On Wed, 5 Apr 2006 12:19:12 -0400, "Geno" <genegodsey@.hotmail.com>
wrote:

>I have an issue with trying to install SQL 2005 standard on my XP machine.
>I get an .hta file that is not readable and when I btpass that I get a
>pop-up message:
>please go to the control panel to install and configure system components.
>WTF?
>PLease assist...
>Gene
In addition to the points that Erland made, assuming your disk
structure is the same as I have seen, navigate to the Servers and/or
Tools folders and run Setup.exe. Gets round the .hta problem, as far
as I am aware.
Andrew Watt [MVP]

Installing SQL server 2005 evaluation

After unzipping the download I have run the splash.hta file. I then chose run the sql native client installation wizard. I then receive the installation package is not supported by this processor type. Contact your product vendor. I am installing this for a class I am taking on a test station. It is a PIII 863 with 512 MB or Ram, running windows 2003 enterprise server SP1. I have looked at the hardware guidelines and it seems this is enough to run it. Any ideas?Are you sure you did not download any 64bit images ? What does the Splash Screen tell you ?

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de

|||Across the top of the splash screen is says SQL Server 2005 (Disk 1 of 2). Then the start options, prepare, install, other information. At the bottom it has Microsoft SQL Server 2005 Evaluation edition. No where does it mention 64bit.|||I was able to find a link to the SQL Server 2000 evaluation edition, and may opt to install that if I cannot corrent the other issue. Does anyone have any other ideas?|||That really does sound like the message displayed when you run a 64-bit application on a 32-bit operating system. Can you try to double click on setup.exe and see if it displays a similar message? If so, it would be displayed even before you see the license dialog.|||Just one quick thing to add. When I downloaded the evaluation edition, I only saw one download. I assumed that when did you the install you chose whether to install the 64bit version or the 32bit version. Are there two seperate downloads for this, one for each version?|||

After reviewing all 3 downloadable links, it appears the X86 download is the non 64 bit download. After looking at the one I downloaded and installed, it appears it is the 64 bit version. Why the 32 bit version is named X86, I am not sure.

|||

That is the correct behavior that you are seeing. The three packages are:

x86 - for all 32-bit machines
x64 - for x64 (AMD-64) 64-bit machines
ia64 - for ia64 (Itanium) 64-bit machines

Thanks,
Sam Lester (MSFT)

Installing Sql Mobile via CAB file

Hi guys,

wonder if someone can help? I have written an app the runs on PocketPC 2003 and uses CF 2 and Sql Mobile 2005. I need to be able to install my application and Sql Mobile from within a desktop app. This is what I am doing, but I have a few questions:

Using RAPI I copy over to the device; myApp.CAB and sqlce30.ppc.wce4.armv4.CAB.
Using RAPI I then run wceload on these two CAB files.

This works a treat, both application install properly and work!!

But, in the same directory as the sqlce30.ppc.wce4.armv4.CAB (in C:\Program Files\Microsoft Visual Studio 8\SmartDevices\SDK\SQL Server\Mobile\v3.0\wce400\armv4) there are two other CAB files:

sqlce30.dev.ENU.ppc.wce4.armv4.CAB
sqlce30.repl.ppc.wce4.armv4.CAB

My application doesn't use replication so I didn't copy over the second file. But what is the first one, and do I need it installed on the device?

Thanks for your help
Graham

Hi

I installed

sqlce30.dev.ENU.ppc.wce4.armv4.CAB

from C:\Program Files\Microsoft Visual Studio 8\SmartDevices\SDK\SQL Server\Mobile\v3.0\wce400\armv4

and

sql.dev.ENU.ppc.wce4.armv4.CAB

from C:\Program Files\Microsoft Visual Studio 8\SmartDevices\SDK\SQL Server\Client\v2.0\wce400\armv4

and

Installing Sql Mobile via CAB file

Hi guys,

wonder if someone can help? I have written an app the runs on PocketPC 2003 and uses CF 2 and Sql Mobile 2005. I need to be able to install my application and Sql Mobile from within a desktop app. This is what I am doing, but I have a few questions:

Using RAPI I copy over to the device; myApp.CAB and sqlce30.ppc.wce4.armv4.CAB.
Using RAPI I then run wceload on these two CAB files.

This works a treat, both application install properly and work!!

But, in the same directory as the sqlce30.ppc.wce4.armv4.CAB (in C:\Program Files\Microsoft Visual Studio 8\SmartDevices\SDK\SQL Server\Mobile\v3.0\wce400\armv4) there are two other CAB files:

sqlce30.dev.ENU.ppc.wce4.armv4.CAB
sqlce30.repl.ppc.wce4.armv4.CAB

My application doesn't use replication so I didn't copy over the second file. But what is the first one, and do I need it installed on the device?

Thanks for your help
Graham

Hi

I installed

sqlce30.dev.ENU.ppc.wce4.armv4.CAB

from C:\Program Files\Microsoft Visual Studio 8\SmartDevices\SDK\SQL Server\Mobile\v3.0\wce400\armv4

and

sql.dev.ENU.ppc.wce4.armv4.CAB

from C:\Program Files\Microsoft Visual Studio 8\SmartDevices\SDK\SQL Server\Client\v2.0\wce400\armv4

and

Installing SQL Mobile 2005

It is possible to install the .NET Compact Framework from the desktop with a .msi file.

However, SQL Mobile 2005 seems to require you to know the processor which your mobile device uses - there are only CAB files available to do the install.

Have Microsoft made an MSI file available to make this process easier?

matt.
All Windows Mobile (5 and 6) devices use the same processor architecture - ARM, so the problem is minimal.

Installing SQL Express : File is corrupt !!!

Hello,

On my computer, XP SP2, VB 2005 Express and VisualWeb 2005 Express are installed.

SQL 2005 Server express was also automatically installed in the same time.

I want to complete this SQL SERVER EXPRESS Installation, by downloading complements;

No problem to install SQL Server Management Studio

but problem occurs :

I downloaded SQLEXPR_ADV_FRN.EXE (Version : 0.0.0.0)

When I want to install it, I have a first box Extracting Files with :

Extracting Files :setup\sqlrun_rs.msi

To Directory ;i:\8eefbf891116a71dbc7190cceb05b9

(I don’t know why it wants to install in this partition !!!!)

Then an error box :

Extraction Failed

File is corrupt

I had same issue when I tried to install SQLEXPR_TOOLKIT_FRN.EXE

Can anyone explain me how to resolve these issues ?

Regards

Mouspi

try to disable your AV software when running the setup and see what happens.

Are you able to download the ISO image and burning it to CD for example, or mounting it to a virtual CD, and installing it from that?

|||

I disabled my AV, but I got the same messages.

I didn't find the right place where i can download the ISO images for these two files.

If you know the way to reach them, it would be fine.

Regards

Mouspi

Installing SQL Errors - Anyone please read my log file

Microsoft SQL Server 2005 Setup beginning at Sat Jan 14 20:31:52 2006
Process ID : 896
c:\ef878dcc6c3c3c0766424d939e4b7c78\setup.exe Version: 2005.90.1399.0
Running: LoadResourcesAction at: 2006/0/14 20:31:51
Complete: LoadResourcesAction at: 2006/0/14 20:31:51, returned true
Running: ParseBootstrapOptionsAction at: 2006/0/14 20:31:51
Loaded DLL:c:\ef878dcc6c3c3c0766424d939e4b7c78\xmlrw.dll Version:2.0.3604.0
Complete: ParseBootstrapOptionsAction at: 2006/0/14 20:31:52, returned true
Running: ValidateWinNTAction at: 2006/0/14 20:31:52
Complete: ValidateWinNTAction at: 2006/0/14 20:31:52, returned true
Running: ValidateMinOSAction at: 2006/0/14 20:31:52
Complete: ValidateMinOSAction at: 2006/0/14 20:31:52, returned true
Running: PerformSCCAction at: 2006/0/14 20:31:52
Complete: PerformSCCAction at: 2006/0/14 20:31:52, returned true
Running: ActivateLoggingAction at: 2006/0/14 20:31:52
Complete: ActivateLoggingAction at: 2006/0/14 20:31:52, returned true
Delay load of action "DetectPatchedBootstrapAction" returned nothing. No action will occur as a result.
Action "LaunchPatchedBootstrapAction" will be skipped due to the following restrictions:
Condition "EventCondition: __STP_LaunchPatchedBootstrap__896" returned false.
Running: PerformSCCAction2 at: 2006/0/14 20:31:52
Loaded DLL:C:\WINDOWS\system32\msi.dll Version:3.1.4000.2435
Product "{2750B389-A2D2-4953-99CA-27C1F2A8E6FD}" versioned 9.00.1116 is not compatible with current builds of SQL Server.Expected at least version: 9.00.1399.06
The Product Name is "Microsoft SQL Server 2005 Tools Express Edition CTP"
Loaded DLL:C:\WINDOWS\system32\msi.dll Version:3.1.4000.2435
Error: Action "PerformSCCAction2" threw an exception during execution.
Return Code: 70032
Message displayed to user
SQL Server 2005 Setup has detected incompatible components from beta versions of Visual Studio, .NET Framework, or SQL Server 2005. Use Add or Remove Programs to remove these components, and then run SQL Server 2005 Setup again. For detailed instructions on uninstalling SQL Server 2005, see the SQL Server 2005 Readme.

Class not registered.
Delay load of action "UploadDrWatsonLogAction" returned nothing. No action will occur as a result.
Message pump returning: 70032

I have scraped this maching clean and still get the residue beta version exception. Got any clues to find this stuff that exist on my machine- XP home addtion

In the note log it says Watson failed.

Try the following.

1. Uninstall all visible Beta components in Add/Remove Programes.
2. Detect the Beta components infromation in the the log file located in %Program Files%\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup_%machinename%_Core(Local).log.
3. Search the whole registry keys, remove those registy keys related to those Beta components. This is time-consuming.
4. Kill all Beta SQL Services (including SQL, OLAP, RS, SQLBROWSER, SQLAGENT, etc.) if they are existing with command sc.
5. Reboot the machine.
6. Start Setup again.

Or you can send me email so I can send a script for you to clean beta components.

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.

installing SQL 2005 Management Studio

Hello:
When I try to install SQL Server 2005 Management Studio from the
SQLRun_Tools.exe file on the CD, I get a message saying the following:
"A component that you have specificed in the ADD_LOCAL propety is already
installed. To upgrade the existing component, refer to the template ini and
set the UPGRADE property to the name of the component."
How do I get past this and get the Studio installed?
Thanks!
childofthe1980sHi
To install the client tools from the command line check out
http://msdn2.microsoft.com/en-us/library/ms144259.aspx#installationscripts
and the ADDLOCAL option with the value SQL_Tools90
John
"childofthe1980s" wrote:
> Hello:
> When I try to install SQL Server 2005 Management Studio from the
> SQLRun_Tools.exe file on the CD, I get a message saying the following:
> "A component that you have specificed in the ADD_LOCAL propety is already
> installed. To upgrade the existing component, refer to the template ini and
> set the UPGRADE property to the name of the component."
> How do I get past this and get the Studio installed?
> Thanks!
> childofthe1980s

Installing SQL 2005 Express and attaching database from CD

Hi there,

I have created an .iss file which when compiled creates a setup.exe file on a cd rom. Within the .iss I have extracted the sqlexpress files out so that it will install straight from disk to the users machine rather than from the .msi file. All this has been successful so far....

My problem is:- I want to attach a database to the an instance of sqlexpress on the users machine. I have detached it from SQL Server 2000 and copied it over to the cd. The setup file copies these over the users hard drive. I have looked through many forums etc and the words that keep popping up are:-

sqlcmd.exe

template.ini

type into the command prompt.

Sorry if I'm a little ignorant but I am not sure how to go about these. How do I open the command prompt on the users machine from CD? Do I have to create something to do this?

Any information would be appreciated, any guidance or scripts would be great.

Regards

Sam

That depends how you do your copy job to copy the database to the folder. If you just copy it over you can just append another line with using the SQLCMD -Q"sp_attachdb ..... using the path to you already copied the file of the database to.

Jens K. Suessmeyer.

http://www.sqlserver2005.de
|||

Thank you for your reply.

I'm still a little unsure of what you mean. Do you mean to add a new line of code within my .iss file.

I have detached my database from my machine using SQL Server 2000 and I want to attach it to the users machine from CD.

Here is a sample of the code within my .iss file.

[Files]
Source: "D:\dotnetfx.exe"; Flags: dontcopy
Source: "D:\WEB\WCU\SSE\SQLEXPR.EXE"; Flags: dontcopy
Source: "D:\UltiDevCassiniWebServer2.exe"; Flags: dontcopy
Source: "D:\CA\*"; DestDir: "C:\CA\"; Flags: ignoreversion recursesubdirs createallsubdirs ' aspx files

Source: "D:\CA.mdf"; DestDir: "C:\CA\"; Flags: ignoreversion recursesubdirs createallsubdirs ' detached database
Source: "D:\c_icons.ico"; DestDir: "C:\CA\"; Flags: ignoreversion
Source: "D:\CA.url"; DestDir: "{userdesktop}"; Flags: ignoreversion

; NOTE: Don't use "Flags: ignoreversion" on any shared system files

[Run]
Filename: "D:\WEB\WCU\SSE\SQLEXPR.EXE"; StatusMsg: "Installing SQL Server 2005 Express Edition..."; Flags: skipifdoesntexist;
Filename: "D:\UltiDevCassiniWebServer2.exe"; StatusMsg: "Installing UltiDev Cassini Web Server 2.0..."; Flags: skipifdoesntexist;

thanks

Sam