Showing posts with label directly. Show all posts
Showing posts with label directly. Show all posts

Sunday, March 11, 2012

Add Skuupgrade=1 ?

Hi!
I downloaded Sql server 2005 Standard directly, when I got this message. I am not used to the commandprompt, and does not know how to add Skoopgrade=1 .

Coud you please help me, may be I could add it in another way?
Thank you so much in advance!!

The SKUUPGRADE flag is used when upgrading one edition of SQL 2005 to another. Here is the documentation:

http://msdn2.microsoft.com/en-us/library/ms144259.aspx

[SKUUPGRADE]

Use the SKUUPGRADE parameter when upgrading from one edition of SQL Server 2005 to another edition of SQL Server 2005.

Important:

If you use the SKUUPGRADE parameter, Setup will remove all hotfix and service pack updates from the SQL Server instance being upgraded. Once the edition upgrade is complete, you must reapply all hotfix and service pack updates.

To perform an edition upgrade of a default instance of SQL Server 2005 (SQL Engine only) via unattended Setup, run the following command using either /qb or /qn:

start /wait setup.exe ADDLOCAL=SQL_Engine INSTANCENAME=MSSQLSERVER UPGRADE=SQL_Engine SKUUPGRADE=1 /qb

Thanks,
Sam Lester (MSFT)

|||Thank you so much!
So I run the following (I didn't use e CD)
C:\SQLEVAL\Servers\setup.exe ADDLOCAL=SQL_Engine,RS_Server INSTANCENAME=MSSQLSERVER UPGRADE=SQL_Engine,RS_Server SKUUPGRADE=1 /qb

.... and it tells me my operating system does not meet service packs levels for this release.

I already downloaded .net Framework 2, ISS, SQL Server 2005 Service Pack 1...

I have windows 2000 32-bit, Windows XP Service Pack 2

I would be so grateful for some help...
|||

I'm a little confused on your OS. Can you do start -> Run and type in "winver". This will tell you your OS and SP level. Can you let me know what that shows? That way we'll be able to figure out what you need to install to get going.

Thanks,
Sam

|||

G:\servers> setup SKUUPGRADE=1

Worked fine.

Also note the important section of the quoted post.

Add Skoopgrade=1 ?

Hi!
I downloaded Sql server 2005 Standard directly, when I got this message. I am not used to the commandprompt, and does not know how to add Skoopgrade=1 .

Coud you please help me, may be I could add it in another way?
Thank you so much in advance!!

The SKUUPGRADE flag is used when upgrading one edition of SQL 2005 to another. Here is the documentation:

http://msdn2.microsoft.com/en-us/library/ms144259.aspx

[SKUUPGRADE]

Use the SKUUPGRADE parameter when upgrading from one edition of SQL Server 2005 to another edition of SQL Server 2005.

Important: If you use the SKUUPGRADE parameter, Setup will remove all hotfix and service pack updates from the SQL Server instance being upgraded. Once the edition upgrade is complete, you must reapply all hotfix and service pack updates.

To perform an edition upgrade of a default instance of SQL Server 2005 (SQL Engine only) via unattended Setup, run the following command using either /qb or /qn:

start /wait setup.exe ADDLOCAL=SQL_Engine INSTANCENAME=MSSQLSERVER UPGRADE=SQL_Engine SKUUPGRADE=1 /qb

Thanks,
Sam Lester (MSFT)

|||Thank you so much!
So I run the following (I didn't use e CD)
C:\SQLEVAL\Servers\setup.exe ADDLOCAL=SQL_Engine,RS_Server INSTANCENAME=MSSQLSERVER UPGRADE=SQL_Engine,RS_Server SKUUPGRADE=1 /qb

.... and it tells me my operating system does not meet service packs levels for this release.

I already downloaded .net Framework 2, ISS, SQL Server 2005 Service Pack 1...

I have windows 2000 32-bit, Windows XP Service Pack 2

I would be so grateful for some help...
|||

I'm a little confused on your OS. Can you do start -> Run and type in "winver". This will tell you your OS and SP level. Can you let me know what that shows? That way we'll be able to figure out what you need to install to get going.

Thanks,
Sam

|||

G:\servers> setup SKUUPGRADE=1

Worked fine.

Also note the important section of the quoted post.

Add Skoopgrade=1 ?

Hi!
I downloaded Sql server 2005 Standard directly, when I got this message. I am not used to the commandprompt, and does not know how to add Skoopgrade=1 .

Coud you please help me, may be I could add it in another way?
Thank you so much in advance!!

The SKUUPGRADE flag is used when upgrading one edition of SQL 2005 to another. Here is the documentation:

http://msdn2.microsoft.com/en-us/library/ms144259.aspx

[SKUUPGRADE]

Use the SKUUPGRADE parameter when upgrading from one edition of SQL Server 2005 to another edition of SQL Server 2005.

Important:

If you use the SKUUPGRADE parameter, Setup will remove all hotfix and service pack updates from the SQL Server instance being upgraded. Once the edition upgrade is complete, you must reapply all hotfix and service pack updates.

To perform an edition upgrade of a default instance of SQL Server 2005 (SQL Engine only) via unattended Setup, run the following command using either /qb or /qn:

start /wait setup.exe ADDLOCAL=SQL_Engine INSTANCENAME=MSSQLSERVER UPGRADE=SQL_Engine SKUUPGRADE=1 /qb

Thanks,
Sam Lester (MSFT)

|||Thank you so much!
So I run the following (I didn't use e CD)
C:\SQLEVAL\Servers\setup.exe ADDLOCAL=SQL_Engine,RS_Server INSTANCENAME=MSSQLSERVER UPGRADE=SQL_Engine,RS_Server SKUUPGRADE=1 /qb

.... and it tells me my operating system does not meet service packs levels for this release.

I already downloaded .net Framework 2, ISS, SQL Server 2005 Service Pack 1...

I have windows 2000 32-bit, Windows XP Service Pack 2

I would be so grateful for some help...
|||

I'm a little confused on your OS. Can you do start -> Run and type in "winver". This will tell you your OS and SP level. Can you let me know what that shows? That way we'll be able to figure out what you need to install to get going.

Thanks,
Sam

|||

G:\servers> setup SKUUPGRADE=1

Worked fine.

Also note the important section of the quoted post.

Friday, February 24, 2012

Add Disclaimer Text to the RS report Subscription

I want to know , how to add Company Disclaimer text whenever Report is
Subscribed for Email. Either directly From Report Manager subscription / using
Create Subscription Web Methods. I don't want to put it as Report Footer.
Thanks!Hi,
It is not possible to put it in the email. Moreover you dont wont it in the
report as well. So no way, probabily you can think off at mail server end
again it will be difficult to identify each and every mail for the report. :-(
Just an idea. Its a very round about method and dont think it is advisable.
You need to write a small utility to pick up mails from the mailbox of the
server which should not have the gateway. If you dont give the gateway, what
happens is that the mails in .eml format will be at outbox at
inetpub\mailroot. your utility should pick these mails and send it through a
gateway. while sending it you may add the disclaimer.
I have not tried on adding something. But I have done this utility to pick
this mails and send it via other SMTP.
Amarnath
"RAGHAVAN JAYARAMAN" wrote:
> I want to know , how to add Company Disclaimer text whenever Report is
> Subscribed for Email. Either directly From Report Manager subscription / using
> Create Subscription Web Methods. I don't want to put it as Report Footer.
> Thanks!|||Thanks Amarnath.What if i want to add a disclaimer as Page Footer and want to
show it for only Report subscription (Email /MHTML ) or may be enable through
hidden parameter which sets to show & hide footer.
"Amarnath" wrote:
> Hi,
> It is not possible to put it in the email. Moreover you dont wont it in the
> report as well. So no way, probabily you can think off at mail server end
> again it will be difficult to identify each and every mail for the report. :-(
> Just an idea. Its a very round about method and dont think it is advisable.
> You need to write a small utility to pick up mails from the mailbox of the
> server which should not have the gateway. If you dont give the gateway, what
> happens is that the mails in .eml format will be at outbox at
> inetpub\mailroot. your utility should pick these mails and send it through a
> gateway. while sending it you may add the disclaimer.
> I have not tried on adding something. But I have done this utility to pick
> this mails and send it via other SMTP.
> Amarnath
>
> "RAGHAVAN JAYARAMAN" wrote:
> > I want to know , how to add Company Disclaimer text whenever Report is
> > Subscribed for Email. Either directly From Report Manager subscription / using
> > Create Subscription Web Methods. I don't want to put it as Report Footer.
> >
> > Thanks!|||Hi,
Thats the solution I thought first, but you had given that email should have
disclaimer and not on the report.
Again. You can do what you have mentioned but not in email. Other solution
also I thought of but didn't post it because it is something to do with
manipulating the report server tables.
It goes like this.
As you know that "catalog" table keeps report info and "subscription" has
subscription what you can do is to check any report has an entry in the
subscription table with ID from catalog. If exists then check for delivery
extension if it is email then enable the footer other wise no.
something like that . But haven;t tried.
Amarnath.
"RAGHAVAN JAYARAMAN" wrote:
> Thanks Amarnath.What if i want to add a disclaimer as Page Footer and want to
> show it for only Report subscription (Email /MHTML ) or may be enable through
> hidden parameter which sets to show & hide footer.
> "Amarnath" wrote:
> > Hi,
> >
> > It is not possible to put it in the email. Moreover you dont wont it in the
> > report as well. So no way, probabily you can think off at mail server end
> > again it will be difficult to identify each and every mail for the report. :-(
> >
> > Just an idea. Its a very round about method and dont think it is advisable.
> >
> > You need to write a small utility to pick up mails from the mailbox of the
> > server which should not have the gateway. If you dont give the gateway, what
> > happens is that the mails in .eml format will be at outbox at
> > inetpub\mailroot. your utility should pick these mails and send it through a
> > gateway. while sending it you may add the disclaimer.
> >
> > I have not tried on adding something. But I have done this utility to pick
> > this mails and send it via other SMTP.
> >
> > Amarnath
> >
> >
> > "RAGHAVAN JAYARAMAN" wrote:
> >
> > > I want to know , how to add Company Disclaimer text whenever Report is
> > > Subscribed for Email. Either directly From Report Manager subscription / using
> > > Create Subscription Web Methods. I don't want to put it as Report Footer.
> > >
> > > Thanks!