Can I install a Enterprise version analysis service on a Standard version of SQL 2005 server?

Hi all,

Since some analysis services features are only available in Enterprise version , I have to upgrade my SQL 2005 server from standard edition to enterpise edition.

So I uninstall originial standard version of analysis service and install a Enterprise version. However, the analysis service is still a standard version after installation.

Is it possible to keep data engine as standard version and install a enterprise version of analysis service?

Thank you very much

Tony

Yes. This is supported as in SQL Server 2005, Standardard SKU and Enterprise SKU can be installed side by side successfully. Of course, their instancenames must be distinct.

Can I install a Enterprise version analysis service on a Standard version of SQL 2005 server

Hi all,

Since some analysis services features are only available in Enterprise version , I have to upgrade my SQL 2005 server from standard edition to enterpise edition.

So I uninstall originial standard version of analysis service and install a Enterprise version. However, the analysis service is still a standard version after installation.

Is it possible to keep data engine as standard version and install a enterprise version of analysis service?

Thank you very much

Tony

Yes. This is supported as in SQL Server 2005, Standardard SKU and Enterprise SKU can be installed side by side successfully. Of course, their instancenames must be distinct.

Can I do rolling upgrade of active-active SQL cluster

Hi,
We have an active-active cluster where SQL server instances are created on
node 1 and Analysis services are installed on node 2. We need to upgrade the
H/W for both nodes? Can I do a rolling upgrade i.e. replacing one node at
time in above configuration?
If not then what are my options & if yes then can you give me some links to
documentation on how to do this?
Thanks,
Sushil
Sushil
Yes you can. I have done exactly this type of project. The more you plan
and test, the better your chance of success. I don't have any publicly
available documentation on a rolling upgrade.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Sushil" <Sushil@.discussions.microsoft.com> wrote in message
news:EA4D680F-4548-4536-8BD2-88ECE1004CF8@.microsoft.com...
> Hi,
> We have an active-active cluster where SQL server instances are created on
> node 1 and Analysis services are installed on node 2. We need to upgrade
> the
> H/W for both nodes? Can I do a rolling upgrade i.e. replacing one node at
> time in above configuration?
> If not then what are my options & if yes then can you give me some links
> to
> documentation on how to do this?
> Thanks,
> --
> Sushil
> --
> Sushil
|||Geoff,
Thanks for response. Can you please list if you had any challenges while
doing this?
I have been told that, When we replace node 2 by new node (Just with OS)
and install SQL server on this new node and try to cluster this new node
with OLD node 1 then that clustering will not work.
Can you point me any Microsoft documentation or books where I can get some
clues?
Thanks,
Sushil
Sushil
"Geoff N. Hiten" wrote:

> Yes you can. I have done exactly this type of project. The more you plan
> and test, the better your chance of success. I don't have any publicly
> available documentation on a rolling upgrade.
> --
> Geoff N. Hiten
> Senior Database Administrator
> Microsoft SQL Server MVP
>
>
> "Sushil" <Sushil@.discussions.microsoft.com> wrote in message
> news:EA4D680F-4548-4536-8BD2-88ECE1004CF8@.microsoft.com...
>
>
|||Here is the quick version.
Starting with SQL 2000 2-node (4-Proc DELL) connected to DELL | EMC CX-600.
Windows 2000 OS. 2 SQL Instances.
Ended with SQL 2000 4-node (8-proc Unisys) still connected to the same SAN
(expanded the storage capacity, though). Windows 2003 OS. 3 SQL Instances.
Started with in-place upgrade of OS (one node at a time). Obtaining the
correct drivers for the HBAs was a challenge. This was Q4 '03, so that
shouldn't be a problem, but it is a critical step.
Added the two new nodes. When stable, removed original two nodes. Finally
added the remaining new nodes.
Note that if you have a SCSI based cluster, you cannot have more than two
nodes even with Windows 2003.
Again, planning and testing was essential. Each step had numerous tests and
bailout plans to avoid downtime.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Sushil" <Sushil@.discussions.microsoft.com> wrote in message
news:97D3A989-1C04-450C-B3C4-20F674299E09@.microsoft.com...[vbcol=seagreen]
> Geoff,
> Thanks for response. Can you please list if you had any challenges while
> doing this?
> I have been told that, When we replace node 2 by new node (Just with OS)
> and install SQL server on this new node and try to cluster this new node
> with OLD node 1 then that clustering will not work.
> Can you point me any Microsoft documentation or books where I can get some
> clues?
> Thanks,
> Sushil
>
> --
> Sushil
>
> "Geoff N. Hiten" wrote:
|||I have a thought rolling around in my brain about limitations of the number
of nodes being different between WIn2K and Win2K3...but I can't remember the
specifics. Geoff, can you recall or am I off-base (anymore than usual?)
Kevin Hill
3NF Consulting
www.3nf-inc.com/NewsGroups.htm
www.expertsrt.com - not your average tech Q&A site
"Geoff N. Hiten" <SQLCraftsman@.gmail.com> wrote in message
news:OF3pKh0MGHA.4052@.TK2MSFTNGP15.phx.gbl...
> Here is the quick version.
> Starting with SQL 2000 2-node (4-Proc DELL) connected to DELL | EMC
> CX-600. Windows 2000 OS. 2 SQL Instances.
> Ended with SQL 2000 4-node (8-proc Unisys) still connected to the same SAN
> (expanded the storage capacity, though). Windows 2003 OS. 3 SQL
> Instances.
> Started with in-place upgrade of OS (one node at a time). Obtaining the
> correct drivers for the HBAs was a challenge. This was Q4 '03, so that
> shouldn't be a problem, but it is a critical step.
> Added the two new nodes. When stable, removed original two nodes.
> Finally added the remaining new nodes.
> Note that if you have a SCSI based cluster, you cannot have more than two
> nodes even with Windows 2003.
> Again, planning and testing was essential. Each step had numerous tests
> and bailout plans to avoid downtime.
> --
> Geoff N. Hiten
> Senior Database Administrator
> Microsoft SQL Server MVP
>
> "Sushil" <Sushil@.discussions.microsoft.com> wrote in message
> news:97D3A989-1C04-450C-B3C4-20F674299E09@.microsoft.com...
>
|||Windows 2000 Enterprise Edition supports 2 nodes. Windows 2003 supports up
to 8 nodes, but SQL 2000 Enterprise Edition only supports a maximum of 4
nodes so that is the limit. That is why I had to do an in-place OS upgrade
as a beginning step for this process. I normally don't like in-place
upgrades, but this was only for a short time during a transition.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Kevin3NF" <Kevin@.DontNeedNoSpam3NF-inc.com> wrote in message
news:eP$dgeWNGHA.1192@.TK2MSFTNGP11.phx.gbl...
>I have a thought rolling around in my brain about limitations of the number
>of nodes being different between WIn2K and Win2K3...but I can't remember
>the specifics. Geoff, can you recall or am I off-base (anymore than
>usual?)
> --
> Kevin Hill
> 3NF Consulting
> www.3nf-inc.com/NewsGroups.htm
> www.expertsrt.com - not your average tech Q&A site
>
> "Geoff N. Hiten" <SQLCraftsman@.gmail.com> wrote in message
> news:OF3pKh0MGHA.4052@.TK2MSFTNGP15.phx.gbl...
>

Can *datastore.xml be used to populate template.ini as a substitute for setup.iss?

Objective

Do a manual installation of SQL Server 2005 (which could be an upgrade from SQL Server 2000) and record the steps. Replay the steps for an unattended installation of SQL Server 2005.

Problem

There isn't a setup.ini file for SQL Server 2005. There is a template.ini for unattended installations of SQL Server 2005, but it doesn't obviously map to selections on manual installation dialog boxes.

Desired workaround

Capture the steps of a manual installation and use them to populate template.ini.

Relevant background for a potential solution

A manual installation creates log files. So does an unattended installation. But the unattended installation writes all of the log files into a single zip file.

What is important to know is that an unattended installation creates an additional file, a *datasource.xml file. This XML file is found in the zip file with all of the other log files. If you open this XML file, you'll see that the attribute names correspond to keywords in template.ini.

Potential solution

If a manual installation could be forced to generate a *datasource.xml file, then it should be possible to map the settings in the file to keywords in template.ini.

So, how can a *datasource.xml file be created? In post http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=359678&SiteID=1, Jeffrey Baker says "add LOGNAME=<path to cab> and run setup again". Unfortunately, these instructions are too vague. Where is this added? To the command line, to a setup.ini (if so, in which directory, and in which section should he addition be made?). I did lots of searches and couldn't find the answers.

Hi John,

In SQL2K we supported the option of "recording" the installation options to a settings file which could be used in subsequent installations. This functionality was not carried forward to SQL2K5.

Using the datasource.xml file, as mentioned above, is not a supported mechanism for creating an input template.ini file. You'll need to manually author the template.ini to contain the installation settings you wish.

Calling web services from Query Analyzer

I've made a database change to a table to add home and
operational amounts. In an upgrade path, I need to
populate these columns with values. There is already C#
code that does the currency conversion based on comparing
transactional currency to both the home and operational
currency codes. Right now, our upgrade scripts are run
via Query Analyzer. Is there a way for me to call web
services and execute methods that have already been
written to do the currency conversion for me? I'd hate to
reinvent the wheel and rewrite code for something that's
already been in done C#.
We are running SQL Server 2000.
Thanks in advance,
BettinaSQL Server's T-SQL language doesn't have any in-built features that can
perform any kind of http calls - soap or otherwise.
T-SQL does provide ability to call external libraries and operating system
commands via things such as sp_OACreate (COM) and xp_cmdshell (console
commands), so it's arguable that your could conceivably call a web-service
from within the Query Analyser, consume it with sp_xml_preparedocument etc
but this is really getting into the zen mastery area & not really what Query
Analyser was designed to perform.
You might do better writing a VBScript or JScript & running that as a DTS
package, or perhaps just coding something in a VS.Net project (with
whatever's your favourite language flavour..)
Regards,
Greg Linwood
SQL Server MVP
"bpdee" <anonymous@.discussions.microsoft.com> wrote in message
news:cb4301c3ef43$84912d60$a101280a@.phx.gbl...
> I've made a database change to a table to add home and
> operational amounts. In an upgrade path, I need to
> populate these columns with values. There is already C#
> code that does the currency conversion based on comparing
> transactional currency to both the home and operational
> currency codes. Right now, our upgrade scripts are run
> via Query Analyzer. Is there a way for me to call web
> services and execute methods that have already been
> written to do the currency conversion for me? I'd hate to
> reinvent the wheel and rewrite code for something that's
> already been in done C#.
> We are running SQL Server 2000.
> Thanks in advance,
> Bettina
>|||Hi Greg,
Thank you so much for your response. Unfortunately, I'm
not a database programmer (I only have experience as an
Oracle Forms programmer) and I am not knowledgeable in
creating VBScripts, JScript, or writing something up using
VS .NET. I was hoping to find an easier answer.
Thanks again for your response.
Bettina

>--Original Message--
>SQL Server's T-SQL language doesn't have any in-built
features that can
>perform any kind of http calls - soap or otherwise.
>T-SQL does provide ability to call external libraries and
operating system
>commands via things such as sp_OACreate (COM) and
xp_cmdshell (console
>commands), so it's arguable that your could conceivably
call a web-service
>from within the Query Analyser, consume it with
sp_xml_preparedocument etc
>but this is really getting into the zen mastery area &
not really what Query
>Analyser was designed to perform.
>You might do better writing a VBScript or JScript &
running that as a DTS
>package, or perhaps just coding something in a VS.Net
project (with
>whatever's your favourite language flavour..)
>Regards,
>Greg Linwood
>SQL Server MVP
>"bpdee" <anonymous@.discussions.microsoft.com> wrote in
message
>news:cb4301c3ef43$84912d60$a101280a@.phx.gbl...
comparing
to
>
>.
>|||Sorry there's not an easier answer.. :c/
This (xml, soap etc) is an area where things are improving in SQL Server but
for now it's not a simple task to perform in QA & is better suited to
language development..
Regards,
Greg Linwood
SQL Server MVP
"bpdee" <anonymous@.discussions.microsoft.com> wrote in message
news:d76901c3ef5c$3bad51f0$a401280a@.phx.gbl...
> Hi Greg,
> Thank you so much for your response. Unfortunately, I'm
> not a database programmer (I only have experience as an
> Oracle Forms programmer) and I am not knowledgeable in
> creating VBScripts, JScript, or writing something up using
> VS .NET. I was hoping to find an easier answer.
> Thanks again for your response.
> Bettina
>
> features that can
> operating system
> xp_cmdshell (console
> call a web-service
> sp_xml_preparedocument etc
> not really what Query
> running that as a DTS
> project (with
> message
> comparing
> to

Calling web services from Query Analyzer

I've made a database change to a table to add home and
operational amounts. In an upgrade path, I need to
populate these columns with values. There is already C#
code that does the currency conversion based on comparing
transactional currency to both the home and operational
currency codes. Right now, our upgrade scripts are run
via Query Analyzer. Is there a way for me to call web
services and execute methods that have already been
written to do the currency conversion for me? I'd hate to
reinvent the wheel and rewrite code for something that's
already been in done C#.
We are running SQL Server 2000.
Thanks in advance,
BettinaSQL Server's T-SQL language doesn't have any in-built features that can
perform any kind of http calls - soap or otherwise.
T-SQL does provide ability to call external libraries and operating system
commands via things such as sp_OACreate (COM) and xp_cmdshell (console
commands), so it's arguable that your could conceivably call a web-service
from within the Query Analyser, consume it with sp_xml_preparedocument etc
but this is really getting into the zen mastery area & not really what Query
Analyser was designed to perform.
You might do better writing a VBScript or JScript & running that as a DTS
package, or perhaps just coding something in a VS.Net project (with
whatever's your favourite language flavour..)
Regards,
Greg Linwood
SQL Server MVP
"bpdee" <anonymous@.discussions.microsoft.com> wrote in message
news:cb4301c3ef43$84912d60$a101280a@.phx.gbl...
> I've made a database change to a table to add home and
> operational amounts. In an upgrade path, I need to
> populate these columns with values. There is already C#
> code that does the currency conversion based on comparing
> transactional currency to both the home and operational
> currency codes. Right now, our upgrade scripts are run
> via Query Analyzer. Is there a way for me to call web
> services and execute methods that have already been
> written to do the currency conversion for me? I'd hate to
> reinvent the wheel and rewrite code for something that's
> already been in done C#.
> We are running SQL Server 2000.
> Thanks in advance,
> Bettina
>|||Hi Greg,
Thank you so much for your response. Unfortunately, I'm
not a database programmer (I only have experience as an
Oracle Forms programmer) and I am not knowledgeable in
creating VBScripts, JScript, or writing something up using
VS .NET. I was hoping to find an easier answer.
Thanks again for your response.
Bettina
>--Original Message--
>SQL Server's T-SQL language doesn't have any in-built
features that can
>perform any kind of http calls - soap or otherwise.
>T-SQL does provide ability to call external libraries and
operating system
>commands via things such as sp_OACreate (COM) and
xp_cmdshell (console
>commands), so it's arguable that your could conceivably
call a web-service
>from within the Query Analyser, consume it with
sp_xml_preparedocument etc
>but this is really getting into the zen mastery area &
not really what Query
>Analyser was designed to perform.
>You might do better writing a VBScript or JScript &
running that as a DTS
>package, or perhaps just coding something in a VS.Net
project (with
>whatever's your favourite language flavour..)
>Regards,
>Greg Linwood
>SQL Server MVP
>"bpdee" <anonymous@.discussions.microsoft.com> wrote in
message
>news:cb4301c3ef43$84912d60$a101280a@.phx.gbl...
>> I've made a database change to a table to add home and
>> operational amounts. In an upgrade path, I need to
>> populate these columns with values. There is already C#
>> code that does the currency conversion based on
comparing
>> transactional currency to both the home and operational
>> currency codes. Right now, our upgrade scripts are run
>> via Query Analyzer. Is there a way for me to call web
>> services and execute methods that have already been
>> written to do the currency conversion for me? I'd hate
to
>> reinvent the wheel and rewrite code for something that's
>> already been in done C#.
>> We are running SQL Server 2000.
>> Thanks in advance,
>> Bettina
>
>.
>|||Sorry there's not an easier answer.. :c/
This (xml, soap etc) is an area where things are improving in SQL Server but
for now it's not a simple task to perform in QA & is better suited to
language development..
Regards,
Greg Linwood
SQL Server MVP
"bpdee" <anonymous@.discussions.microsoft.com> wrote in message
news:d76901c3ef5c$3bad51f0$a401280a@.phx.gbl...
> Hi Greg,
> Thank you so much for your response. Unfortunately, I'm
> not a database programmer (I only have experience as an
> Oracle Forms programmer) and I am not knowledgeable in
> creating VBScripts, JScript, or writing something up using
> VS .NET. I was hoping to find an easier answer.
> Thanks again for your response.
> Bettina
> >--Original Message--
> >SQL Server's T-SQL language doesn't have any in-built
> features that can
> >perform any kind of http calls - soap or otherwise.
> >
> >T-SQL does provide ability to call external libraries and
> operating system
> >commands via things such as sp_OACreate (COM) and
> xp_cmdshell (console
> >commands), so it's arguable that your could conceivably
> call a web-service
> >from within the Query Analyser, consume it with
> sp_xml_preparedocument etc
> >but this is really getting into the zen mastery area &
> not really what Query
> >Analyser was designed to perform.
> >
> >You might do better writing a VBScript or JScript &
> running that as a DTS
> >package, or perhaps just coding something in a VS.Net
> project (with
> >whatever's your favourite language flavour..)
> >
> >Regards,
> >Greg Linwood
> >SQL Server MVP
> >
> >"bpdee" <anonymous@.discussions.microsoft.com> wrote in
> message
> >news:cb4301c3ef43$84912d60$a101280a@.phx.gbl...
> >> I've made a database change to a table to add home and
> >> operational amounts. In an upgrade path, I need to
> >> populate these columns with values. There is already C#
> >> code that does the currency conversion based on
> comparing
> >> transactional currency to both the home and operational
> >> currency codes. Right now, our upgrade scripts are run
> >> via Query Analyzer. Is there a way for me to call web
> >> services and execute methods that have already been
> >> written to do the currency conversion for me? I'd hate
> to
> >> reinvent the wheel and rewrite code for something that's
> >> already been in done C#.
> >>
> >> We are running SQL Server 2000.
> >>
> >> Thanks in advance,
> >> Bettina
> >>
> >
> >
> >.
> >