Showing posts with label sql2005. Show all posts
Showing posts with label sql2005. Show all posts

Wednesday, March 28, 2012

installing the sample databases and documentation

There are two instances: SQL2005 and SQL2005Express on two different units. While there is Visual Studio 2005 Team Edition also installed on the units have not attempted these component installs through either yet. Have spent the better part of two days, following all the directions having searched help locally, online, technet,and applied their advice respectively. While I've taken out the old instances, downloaded updated ones in both my SQL Server instances they do not show as installed under Programs->SQL Server (whichever instance)->Tutorials ...However they do show installed in Control Panel and they can be found via Explorer (AdWorks DBCI+AdWorks BICI and Express instance on the other unit. Have also download SP2 and installed it, but this has proved of no help. @. My wits' end, any help will be appreciated.

Documentation and sample databases are an option during installation.

Books Online appears as an installed program in Add/Remove Programs but the sample databases do not.

If AdventureWorks was installed with 2005 but did not appear in Object Explorer you can attach it. Attach is on the right-click menu of Databases in Object Explorer.

|||

You can also find the SQL Server 2005 documentation available online at:

http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx

It has many great tutorials to get started.

Thanks,
Sam Lester (MSFT)

|||Thank you for your suggestion Lester, however before my initial post had already consulted books online, and downloaded the latest version to stay in sync with the software. Part of my frustration comes from following their directions but failing to achieve similar outcomes. Adventure Works databases are definitely resident on my computer, though not in the same directories in the Explorer file hierarchy indicated by the manuals/instructions. The directions have been exhaustively followed a number of times, replete with uninstalls then reinstalls - all to no avail. This is the case in both units, each with a different operating system and different version of SQL. Am still stymied.

Monday, March 26, 2012

Installing SQL205 in a cluster with mount points

I am struggling with an installation of SQL2005 on Windows Server 2003 SP1. I
am trying to set up a 2 node cluster with a single instance of sql2005. I
need to use mount points so I create a shared disk for the mount points and 2
disks which are mounted in there. The shared disk is called M: and the other
disks have names (DB and Logs). There will be more in due course but I
thought I would start with 2.
The install proceeds okay until it gets to the point where I have to choose
a cluster group to put it in. I have created one with M: in it plus the two
mounted disks. However, when I select that one it insists in making M: the
destination for the data files and, of course there is not enough space there
for them. It seems to be completed incapable of using the mount points. In
fact ir doesn't see them at all.
Does anyone know how to fix this or is it just not possible to use mount
points with SQL2005 in a cluster despite what the documentation says
Hi Colin,
This link has information about special mount point considerations
http://msdn2.microsoft.com/en-us/library/ms189910.aspx.
Regards
Antonio Soto
Solid Quality Leaning
http://www.solidqualitylearning.com
DISCLAIMER:
Anything written in this message represents solely the point of view of the
sender. This message does not imply endorsement from Solid Quality Learning,
and it does not represent the point of view of Solid Quality Learning or any
other person, company or institution mentioned in this message
"Colin Bruce" <ColinBruce@.discussions.microsoft.com> escribi en el mensaje
news:2DA833EE-D6B1-4D53-8E2B-4374B73F7F03@.microsoft.com...
>I am struggling with an installation of SQL2005 on Windows Server 2003 SP1.
>I
> am trying to set up a 2 node cluster with a single instance of sql2005. I
> need to use mount points so I create a shared disk for the mount points
> and 2
> disks which are mounted in there. The shared disk is called M: and the
> other
> disks have names (DB and Logs). There will be more in due course but I
> thought I would start with 2.
> The install proceeds okay until it gets to the point where I have to
> choose
> a cluster group to put it in. I have created one with M: in it plus the
> two
> mounted disks. However, when I select that one it insists in making M: the
> destination for the data files and, of course there is not enough space
> there
> for them. It seems to be completed incapable of using the mount points. In
> fact ir doesn't see them at all.
> Does anyone know how to fix this or is it just not possible to use mount
> points with SQL2005 in a cluster despite what the documentation says
|||Dear Antonio,
Thanks for the info. The bit that is mssing from that document - at least I
cannot find it is how big the base drive has to be. As far as I can see what
is not mentioned is that the SQL 2005 installation will put some files in the
base drive. Most of the installation goes somewhere such as C:\Program
Files\... but some files are put in the shared drive which is acting as the
base drive. I have tried creating the base drive with about 50 GB and SQL
2005 then installs. I don't know how much will go in there for different
installation choices but I am now trying a 30GB base drive to see if that is
big enough.
Anyway, to summarise, the base drive isn't just for mount points as the
document suggests but also holds quite a few installation files which I guess
need to be shared between the cluster nodes.
Best wishes...
Colin
"Antonio Soto" wrote:

> Hi Colin,
> This link has information about special mount point considerations
> http://msdn2.microsoft.com/en-us/library/ms189910.aspx.
> Regards
> Antonio Soto
> Solid Quality Leaning
> http://www.solidqualitylearning.com
> DISCLAIMER:
> Anything written in this message represents solely the point of view of the
> sender. This message does not imply endorsement from Solid Quality Learning,
> and it does not represent the point of view of Solid Quality Learning or any
> other person, company or institution mentioned in this message
>
> "Colin Bruce" <ColinBruce@.discussions.microsoft.com> escribió en el mensaje
> news:2DA833EE-D6B1-4D53-8E2B-4374B73F7F03@.microsoft.com...
>
>

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 sql2005 Express

I have this report while installing this product.
Something about ASP.NET. O yes, it is Vista Business.
System Configuration Check
- WMI Service Requirement (Success)
Messages
* WMI Service Requirement
* Check Passed
- MSXML Requirement (Success)
Messages
* MSXML Requirement
* Check Passed
- Operating System Minimum Level Requirement (Success)
Messages
* Operating System Minimum Level Requirement
* Check Passed
- Operating System Service Pack Level Requirement. (Success)
Messages
* Operating System Service Pack Level Requirement.
* Check Passed
- SQL Server Edition Operating System Compatibility (Success)
Messages
* SQL Server Edition Operating System Compatibility
* Check Passed
- Minimum Hardware Requirement (Success)
Messages
* Minimum Hardware Requirement
* Check Passed
- IIS Feature Requirement (Success)
Messages
* IIS Feature Requirement
* Check Passed
- Pending Reboot Requirement (Success)
Messages
* Pending Reboot Requirement
* Check Passed
- Performance Monitor Counter Requirement (Success)
Messages
* Performance Monitor Counter Requirement
* Check Passed
- Default Installation Path Permission Requirement (Success)
Messages
* Default Installation Path Permission Requirement
* Check Passed
- Internet Explorer Requirement (Success)
Messages
* Internet Explorer Requirement
* Check Passed
- COM Plus Catalog Requirement (Success)
Messages
* COM Plus Catalog Requirement
* Check Passed
- ASP.Net Version Registration Requirement (Warning)
Messages
* ASP.Net Version Registration Requirement
* Failed to find the ASP.Net Version Registration with Microsoft Internet
Information Services (IIS).
- Minimum MDAC Version Requirement (Success)
Messages
* Minimum MDAC Version Requirement
* Check Passed
- Edition Change Check (Success)
Messages
* Edition Change Check
* Check Passed
ThanksMark,
You will either need to enable ASP on II6 (Disabled by default) or register
it so you can then enable it, to register refer
http://msdn2.microsoft.com/en-us/library/k6h9cz8h(VS.80).aspx
to enable,
Open IIS Manager > Select Web Service Extensions, select the appropiate
service and "Allow" it..
Cheers
Matt
"Markgoldin" wrote:
> I have this report while installing this product.
> Something about ASP.NET. O yes, it is Vista Business.
> System Configuration Check
> - WMI Service Requirement (Success)
> Messages
> * WMI Service Requirement
> * Check Passed
>
> - MSXML Requirement (Success)
> Messages
> * MSXML Requirement
> * Check Passed
>
> - Operating System Minimum Level Requirement (Success)
> Messages
> * Operating System Minimum Level Requirement
> * Check Passed
>
> - Operating System Service Pack Level Requirement. (Success)
> Messages
> * Operating System Service Pack Level Requirement.
> * Check Passed
>
> - SQL Server Edition Operating System Compatibility (Success)
> Messages
> * SQL Server Edition Operating System Compatibility
> * Check Passed
>
> - Minimum Hardware Requirement (Success)
> Messages
> * Minimum Hardware Requirement
> * Check Passed
>
> - IIS Feature Requirement (Success)
> Messages
> * IIS Feature Requirement
> * Check Passed
>
> - Pending Reboot Requirement (Success)
> Messages
> * Pending Reboot Requirement
> * Check Passed
>
> - Performance Monitor Counter Requirement (Success)
> Messages
> * Performance Monitor Counter Requirement
> * Check Passed
>
> - Default Installation Path Permission Requirement (Success)
> Messages
> * Default Installation Path Permission Requirement
> * Check Passed
>
> - Internet Explorer Requirement (Success)
> Messages
> * Internet Explorer Requirement
> * Check Passed
>
> - COM Plus Catalog Requirement (Success)
> Messages
> * COM Plus Catalog Requirement
> * Check Passed
>
> - ASP.Net Version Registration Requirement (Warning)
> Messages
> * ASP.Net Version Registration Requirement
> * Failed to find the ASP.Net Version Registration with Microsoft Internet
> Information Services (IIS).
>
> - Minimum MDAC Version Requirement (Success)
> Messages
> * Minimum MDAC Version Requirement
> * Check Passed
>
> - Edition Change Check (Success)
> Messages
> * Edition Change Check
> * Check Passed
>
> Thanks
>|||While I am using Vista that I dont have right now but I am opening I IS
Manager on my XP box
and I dont see Web Service Extensions. Can you please give me more details?
"Aussie Matt" <AussieMatt@.discussions.microsoft.com> wrote in message
news:0EDEC0DE-B6FE-4F75-9C77-1BC63068D9D7@.microsoft.com...
> Mark,
> You will either need to enable ASP on II6 (Disabled by default) or
> register
> it so you can then enable it, to register refer
> http://msdn2.microsoft.com/en-us/library/k6h9cz8h(VS.80).aspx
> to enable,
> Open IIS Manager > Select Web Service Extensions, select the appropiate
> service and "Allow" it..
> Cheers
> Matt
>
>
> "Markgoldin" wrote:
>> I have this report while installing this product.
>> Something about ASP.NET. O yes, it is Vista Business.
>> System Configuration Check
>> - WMI Service Requirement (Success)
>> Messages
>> * WMI Service Requirement
>> * Check Passed
>>
>> - MSXML Requirement (Success)
>> Messages
>> * MSXML Requirement
>> * Check Passed
>>
>> - Operating System Minimum Level Requirement (Success)
>> Messages
>> * Operating System Minimum Level Requirement
>> * Check Passed
>>
>> - Operating System Service Pack Level Requirement. (Success)
>> Messages
>> * Operating System Service Pack Level Requirement.
>> * Check Passed
>>
>> - SQL Server Edition Operating System Compatibility (Success)
>> Messages
>> * SQL Server Edition Operating System Compatibility
>> * Check Passed
>>
>> - Minimum Hardware Requirement (Success)
>> Messages
>> * Minimum Hardware Requirement
>> * Check Passed
>>
>> - IIS Feature Requirement (Success)
>> Messages
>> * IIS Feature Requirement
>> * Check Passed
>>
>> - Pending Reboot Requirement (Success)
>> Messages
>> * Pending Reboot Requirement
>> * Check Passed
>>
>> - Performance Monitor Counter Requirement (Success)
>> Messages
>> * Performance Monitor Counter Requirement
>> * Check Passed
>>
>> - Default Installation Path Permission Requirement (Success)
>> Messages
>> * Default Installation Path Permission Requirement
>> * Check Passed
>>
>> - Internet Explorer Requirement (Success)
>> Messages
>> * Internet Explorer Requirement
>> * Check Passed
>>
>> - COM Plus Catalog Requirement (Success)
>> Messages
>> * COM Plus Catalog Requirement
>> * Check Passed
>>
>> - ASP.Net Version Registration Requirement (Warning)
>> Messages
>> * ASP.Net Version Registration Requirement
>> * Failed to find the ASP.Net Version Registration with Microsoft
>> Internet
>> Information Services (IIS).
>>
>> - Minimum MDAC Version Requirement (Success)
>> Messages
>> * Minimum MDAC Version Requirement
>> * Check Passed
>>
>> - Edition Change Check (Success)
>> Messages
>> * Edition Change Check
>> * Check Passed
>>
>> Thanks|||Hi Mark,
What version of IIS are you running ?
...Matt
"Mark Goldin" wrote:
> While I am using Vista that I dont have right now but I am opening I IS
> Manager on my XP box
> and I dont see Web Service Extensions. Can you please give me more details?
> "Aussie Matt" <AussieMatt@.discussions.microsoft.com> wrote in message
> news:0EDEC0DE-B6FE-4F75-9C77-1BC63068D9D7@.microsoft.com...
> > Mark,
> > You will either need to enable ASP on II6 (Disabled by default) or
> > register
> > it so you can then enable it, to register refer
> >
> > http://msdn2.microsoft.com/en-us/library/k6h9cz8h(VS.80).aspx
> >
> > to enable,
> > Open IIS Manager > Select Web Service Extensions, select the appropiate
> > service and "Allow" it..
> >
> > Cheers
> >
> > Matt
> >
> >
> >
> >
> >
> > "Markgoldin" wrote:
> >
> >> I have this report while installing this product.
> >> Something about ASP.NET. O yes, it is Vista Business.
> >>
> >> System Configuration Check
> >>
> >> - WMI Service Requirement (Success)
> >> Messages
> >> * WMI Service Requirement
> >>
> >> * Check Passed
> >>
> >>
> >> - MSXML Requirement (Success)
> >> Messages
> >> * MSXML Requirement
> >>
> >> * Check Passed
> >>
> >>
> >> - Operating System Minimum Level Requirement (Success)
> >> Messages
> >> * Operating System Minimum Level Requirement
> >>
> >> * Check Passed
> >>
> >>
> >> - Operating System Service Pack Level Requirement. (Success)
> >> Messages
> >> * Operating System Service Pack Level Requirement.
> >>
> >> * Check Passed
> >>
> >>
> >> - SQL Server Edition Operating System Compatibility (Success)
> >> Messages
> >> * SQL Server Edition Operating System Compatibility
> >>
> >> * Check Passed
> >>
> >>
> >> - Minimum Hardware Requirement (Success)
> >> Messages
> >> * Minimum Hardware Requirement
> >>
> >> * Check Passed
> >>
> >>
> >> - IIS Feature Requirement (Success)
> >> Messages
> >> * IIS Feature Requirement
> >>
> >> * Check Passed
> >>
> >>
> >> - Pending Reboot Requirement (Success)
> >> Messages
> >> * Pending Reboot Requirement
> >>
> >> * Check Passed
> >>
> >>
> >> - Performance Monitor Counter Requirement (Success)
> >> Messages
> >> * Performance Monitor Counter Requirement
> >>
> >> * Check Passed
> >>
> >>
> >> - Default Installation Path Permission Requirement (Success)
> >> Messages
> >> * Default Installation Path Permission Requirement
> >>
> >> * Check Passed
> >>
> >>
> >> - Internet Explorer Requirement (Success)
> >> Messages
> >> * Internet Explorer Requirement
> >>
> >> * Check Passed
> >>
> >>
> >> - COM Plus Catalog Requirement (Success)
> >> Messages
> >> * COM Plus Catalog Requirement
> >>
> >> * Check Passed
> >>
> >>
> >> - ASP.Net Version Registration Requirement (Warning)
> >> Messages
> >> * ASP.Net Version Registration Requirement
> >>
> >> * Failed to find the ASP.Net Version Registration with Microsoft
> >> Internet
> >> Information Services (IIS).
> >>
> >>
> >> - Minimum MDAC Version Requirement (Success)
> >> Messages
> >> * Minimum MDAC Version Requirement
> >>
> >> * Check Passed
> >>
> >>
> >> - Edition Change Check (Success)
> >> Messages
> >> * Edition Change Check
> >>
> >> * Check Passed
> >>
> >>
> >>
> >> Thanks
> >>
>
>|||Well, on Vista it is 7. On Xp whatever comes with it.
"Aussie Matt" <AussieMatt@.discussions.microsoft.com> wrote in message
news:2F90EE6E-9D66-4671-8A94-9D39280B0F86@.microsoft.com...
> Hi Mark,
> What version of IIS are you running ?
> ...Matt
> "Mark Goldin" wrote:
>> While I am using Vista that I dont have right now but I am opening I IS
>> Manager on my XP box
>> and I dont see Web Service Extensions. Can you please give me more
>> details?
>> "Aussie Matt" <AussieMatt@.discussions.microsoft.com> wrote in message
>> news:0EDEC0DE-B6FE-4F75-9C77-1BC63068D9D7@.microsoft.com...
>> > Mark,
>> > You will either need to enable ASP on II6 (Disabled by default) or
>> > register
>> > it so you can then enable it, to register refer
>> >
>> > http://msdn2.microsoft.com/en-us/library/k6h9cz8h(VS.80).aspx
>> >
>> > to enable,
>> > Open IIS Manager > Select Web Service Extensions, select the appropiate
>> > service and "Allow" it..
>> >
>> > Cheers
>> >
>> > Matt
>> >
>> >
>> >
>> >
>> >
>> > "Markgoldin" wrote:
>> >
>> >> I have this report while installing this product.
>> >> Something about ASP.NET. O yes, it is Vista Business.
>> >>
>> >> System Configuration Check
>> >>
>> >> - WMI Service Requirement (Success)
>> >> Messages
>> >> * WMI Service Requirement
>> >>
>> >> * Check Passed
>> >>
>> >>
>> >> - MSXML Requirement (Success)
>> >> Messages
>> >> * MSXML Requirement
>> >>
>> >> * Check Passed
>> >>
>> >>
>> >> - Operating System Minimum Level Requirement (Success)
>> >> Messages
>> >> * Operating System Minimum Level Requirement
>> >>
>> >> * Check Passed
>> >>
>> >>
>> >> - Operating System Service Pack Level Requirement. (Success)
>> >> Messages
>> >> * Operating System Service Pack Level Requirement.
>> >>
>> >> * Check Passed
>> >>
>> >>
>> >> - SQL Server Edition Operating System Compatibility (Success)
>> >> Messages
>> >> * SQL Server Edition Operating System Compatibility
>> >>
>> >> * Check Passed
>> >>
>> >>
>> >> - Minimum Hardware Requirement (Success)
>> >> Messages
>> >> * Minimum Hardware Requirement
>> >>
>> >> * Check Passed
>> >>
>> >>
>> >> - IIS Feature Requirement (Success)
>> >> Messages
>> >> * IIS Feature Requirement
>> >>
>> >> * Check Passed
>> >>
>> >>
>> >> - Pending Reboot Requirement (Success)
>> >> Messages
>> >> * Pending Reboot Requirement
>> >>
>> >> * Check Passed
>> >>
>> >>
>> >> - Performance Monitor Counter Requirement (Success)
>> >> Messages
>> >> * Performance Monitor Counter Requirement
>> >>
>> >> * Check Passed
>> >>
>> >>
>> >> - Default Installation Path Permission Requirement (Success)
>> >> Messages
>> >> * Default Installation Path Permission Requirement
>> >>
>> >> * Check Passed
>> >>
>> >>
>> >> - Internet Explorer Requirement (Success)
>> >> Messages
>> >> * Internet Explorer Requirement
>> >>
>> >> * Check Passed
>> >>
>> >>
>> >> - COM Plus Catalog Requirement (Success)
>> >> Messages
>> >> * COM Plus Catalog Requirement
>> >>
>> >> * Check Passed
>> >>
>> >>
>> >> - ASP.Net Version Registration Requirement (Warning)
>> >> Messages
>> >> * ASP.Net Version Registration Requirement
>> >>
>> >> * Failed to find the ASP.Net Version Registration with Microsoft
>> >> Internet
>> >> Information Services (IIS).
>> >>
>> >>
>> >> - Minimum MDAC Version Requirement (Success)
>> >> Messages
>> >> * Minimum MDAC Version Requirement
>> >>
>> >> * Check Passed
>> >>
>> >>
>> >> - Edition Change Check (Success)
>> >> Messages
>> >> * Edition Change Check
>> >>
>> >> * Check Passed
>> >>
>> >>
>> >>
>> >> Thanks
>> >>
>>|||I have no clue what do I need to do on my Vista to make RS running, not even
running, at least get installed.
I think it's time for a modern OS to have "Format hard drive" as addition to
Ok, Cancel.
"Aussie Matt" <AussieMatt@.discussions.microsoft.com> wrote in message
news:0EDEC0DE-B6FE-4F75-9C77-1BC63068D9D7@.microsoft.com...
> Mark,
> You will either need to enable ASP on II6 (Disabled by default) or
> register
> it so you can then enable it, to register refer
> http://msdn2.microsoft.com/en-us/library/k6h9cz8h(VS.80).aspx
> to enable,
> Open IIS Manager > Select Web Service Extensions, select the appropiate
> service and "Allow" it..
> Cheers
> Matt
>
>
> "Markgoldin" wrote:
>> I have this report while installing this product.
>> Something about ASP.NET. O yes, it is Vista Business.
>> System Configuration Check
>> - WMI Service Requirement (Success)
>> Messages
>> * WMI Service Requirement
>> * Check Passed
>>
>> - MSXML Requirement (Success)
>> Messages
>> * MSXML Requirement
>> * Check Passed
>>
>> - Operating System Minimum Level Requirement (Success)
>> Messages
>> * Operating System Minimum Level Requirement
>> * Check Passed
>>
>> - Operating System Service Pack Level Requirement. (Success)
>> Messages
>> * Operating System Service Pack Level Requirement.
>> * Check Passed
>>
>> - SQL Server Edition Operating System Compatibility (Success)
>> Messages
>> * SQL Server Edition Operating System Compatibility
>> * Check Passed
>>
>> - Minimum Hardware Requirement (Success)
>> Messages
>> * Minimum Hardware Requirement
>> * Check Passed
>>
>> - IIS Feature Requirement (Success)
>> Messages
>> * IIS Feature Requirement
>> * Check Passed
>>
>> - Pending Reboot Requirement (Success)
>> Messages
>> * Pending Reboot Requirement
>> * Check Passed
>>
>> - Performance Monitor Counter Requirement (Success)
>> Messages
>> * Performance Monitor Counter Requirement
>> * Check Passed
>>
>> - Default Installation Path Permission Requirement (Success)
>> Messages
>> * Default Installation Path Permission Requirement
>> * Check Passed
>>
>> - Internet Explorer Requirement (Success)
>> Messages
>> * Internet Explorer Requirement
>> * Check Passed
>>
>> - COM Plus Catalog Requirement (Success)
>> Messages
>> * COM Plus Catalog Requirement
>> * Check Passed
>>
>> - ASP.Net Version Registration Requirement (Warning)
>> Messages
>> * ASP.Net Version Registration Requirement
>> * Failed to find the ASP.Net Version Registration with Microsoft
>> Internet
>> Information Services (IIS).
>>
>> - Minimum MDAC Version Requirement (Success)
>> Messages
>> * Minimum MDAC Version Requirement
>> * Check Passed
>>
>> - Edition Change Check (Success)
>> Messages
>> * Edition Change Check
>> * Check Passed
>>
>> 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.

Installing SQL 2005 Express via InstallShield

Is it possible to install SQL2005 Express via InstallShield?

Has anyone had any experience doing this?

Any suggestions or recommendations?

Thanks

have a look at the following MSDN Article it might help..

Embedding SQL Server Express into Custom Applications

|||

Hi,

Is this article actually accurate in terms of the statement that says that if you don't provide a value for the property SqlServiceAccountName then it defaults to LocalSystem? I'm finding that it defaults to Network Service.

Mind you, I'm using a command line, and either using SQLACCOUNT="" or not providing the SQLACCOUNT option at all.

It would be nice to work out how to run the service by default as LocalSystem. Any help would be appreciated.

Thanks

Sam

|||

The default for SqlServiceAccountName is:

Network Service on Windows XP/2003

Local Service on Windows 2000

I assume that you should be able to set it to Local System using the command line, but you should be careful about account selection. Remember that SQL Express has all the permissions of the account that it runs as. What ever the Local System account can do, SQL Express will be able to do if instructed to do so via stored procedure or CLR function, etc.

The reason we chose to use Network Service (where available) in SQL 2005 is to reduce the "surface area" of risk when running SQL Express. By using a low permission account by default, we limit the ways that SQL Express can be exploited by "bad people."

If you want to give SQL Express higher level permissions, that is you're choice, but we expect you to understand the risks before you do so.

Regards,

Mike Wachal
SQL Express team

-
Mark the best posts as Answers!

|||

Hi, Mike.

When I tried to install SQL Express 2005 from command line in Win VISTA, and not specify any SQLAccount value, the installation fails, saying that it must be specified.

How would you go about making sure that the installation would work and set SQLAccount to the default value in Windows Vista?

Thanks.

Cliff.

Installing SQL 2005 Express via InstallShield

Is it possible to install SQL2005 Express via InstallShield?

Has anyone had any experience doing this?

Any suggestions or recommendations?

Thanks

have a look at the following MSDN Article it might help..

Embedding SQL Server Express into Custom Applications

|||

Hi,

Is this article actually accurate in terms of the statement that says that if you don't provide a value for the property SqlServiceAccountName then it defaults to LocalSystem? I'm finding that it defaults to Network Service.

Mind you, I'm using a command line, and either using SQLACCOUNT="" or not providing the SQLACCOUNT option at all.

It would be nice to work out how to run the service by default as LocalSystem. Any help would be appreciated.

Thanks

Sam

|||

The default for SqlServiceAccountName is:

Network Service on Windows XP/2003

Local Service on Windows 2000

I assume that you should be able to set it to Local System using the command line, but you should be careful about account selection. Remember that SQL Express has all the permissions of the account that it runs as. What ever the Local System account can do, SQL Express will be able to do if instructed to do so via stored procedure or CLR function, etc.

The reason we chose to use Network Service (where available) in SQL 2005 is to reduce the "surface area" of risk when running SQL Express. By using a low permission account by default, we limit the ways that SQL Express can be exploited by "bad people."

If you want to give SQL Express higher level permissions, that is you're choice, but we expect you to understand the risks before you do so.

Regards,

Mike Wachal
SQL Express team

-
Mark the best posts as Answers!

|||

Hi, Mike.

When I tried to install SQL Express 2005 from command line in Win VISTA, and not specify any SQLAccount value, the installation fails, saying that it must be specified.

How would you go about making sure that the installation would work and set SQLAccount to the default value in Windows Vista?

Thanks.

Cliff.