How can I convert download SQL Server 2005 to a licensed version.

I downloaded a 180 day trial version of SQL Server 2005, and have it running. I have purchased a 5 user workgroup version. I would like to apply the 5 user license to the version that is currently installed.

My preference is to not reinstall everything since I have everything configured as I would like, and it is working great. What is the best approach?

Paul

The only way to do this is to Upgrade your Evaluation Edition to the Workgroup SKU. To do this you should run the Workgroup installation program and select the edition of SQL Server that you already have installed instead of installing a new edition.

Michelle

|||

Will this leave the installed database and all of its configuration as is?

Or will it change any of the configuration?

The reason I ask, is that due to a lack of proper planning we did not have SQL Server installed prior to a vendor arriving to install their application. I quickly downloaded the trial version, and installed it and ordered the Workgroup Edition. The applicationn is in and running, and I now want to make everything legal, and to have it run past the 180 day evaluation period.

If upgrading will change the application, I will need to pay the vendor to reconfigure things, and cause me problems.

Paul

sql

How can I change database status from loading

When I started restore, I used leave non operational. But later I find out
that I do not need to apply any additional files. I want to make it
operational. I am using SQL 7.
Any idea how can I change this status ? Thank you very much for reply.Try running the following:
RESTORE DATABASE YourDatabaseName
WITH RECOVERY
If it does not work try the last log backup filename and location.
RESTORE DATABASE YourDatabaseName
FROM DISK = 'c:\bkup.bak'
WITH RECOVERY
I do not have SQL 7 around but it works on 2000
Hope it will do the trick
Andre
"Astros" wrote:

> When I started restore, I used leave non operational. But later I find out
> that I do not need to apply any additional files. I want to make it
> operational. I am using SQL 7.
> Any idea how can I change this status ? Thank you very much for reply.|||In Query Analyzer, you can run
RESTORE [mydatabase] WITH RECOVERY
HTH
--
Kalen Delaney
SQL Server MVP
www.SolidQualityLearning.com
"Astros" <Astros@.discussions.microsoft.com> wrote in message
news:3A0FF0B5-E597-4C44-8F22-18BF700512B9@.microsoft.com...
> When I started restore, I used leave non operational. But later I find out
> that I do not need to apply any additional files. I want to make it
> operational. I am using SQL 7.
> Any idea how can I change this status ? Thank you very much for reply.|||Forgot the word DATABASE...
RESTORE DATABASE [mydatabase] WITH RECOVERY
HTH
--
Kalen Delaney
SQL Server MVP
www.SolidQualityLearning.com
"Kalen Delaney" <replies@.public_newsgroups.com> wrote in message
news:eUafDry$EHA.600@.TK2MSFTNGP09.phx.gbl...
> In Query Analyzer, you can run
> RESTORE [mydatabase] WITH RECOVERY
> --
> HTH
> --
> Kalen Delaney
> SQL Server MVP
> www.SolidQualityLearning.com
>
> "Astros" <Astros@.discussions.microsoft.com> wrote in message
> news:3A0FF0B5-E597-4C44-8F22-18BF700512B9@.microsoft.com...
>

How can I change database status from loading

When I started restore, I used leave non operational. But later I find out
that I do not need to apply any additional files. I want to make it
operational. I am using SQL 7.
Any idea how can I change this status ? Thank you very much for reply.
Try running the following:
RESTORE DATABASE YourDatabaseName
WITH RECOVERY
If it does not work try the last log backup filename and location.
RESTORE DATABASE YourDatabaseName
FROM DISK = 'c:\bkup.bak'
WITH RECOVERY
I do not have SQL 7 around but it works on 2000
Hope it will do the trick
Andre
"Astros" wrote:

> When I started restore, I used leave non operational. But later I find out
> that I do not need to apply any additional files. I want to make it
> operational. I am using SQL 7.
> Any idea how can I change this status ? Thank you very much for reply.
|||In Query Analyzer, you can run
RESTORE [mydatabase] WITH RECOVERY
HTH
Kalen Delaney
SQL Server MVP
www.SolidQualityLearning.com
"Astros" <Astros@.discussions.microsoft.com> wrote in message
news:3A0FF0B5-E597-4C44-8F22-18BF700512B9@.microsoft.com...
> When I started restore, I used leave non operational. But later I find out
> that I do not need to apply any additional files. I want to make it
> operational. I am using SQL 7.
> Any idea how can I change this status ? Thank you very much for reply.
|||Forgot the word DATABASE...
RESTORE DATABASE [mydatabase] WITH RECOVERY
HTH
Kalen Delaney
SQL Server MVP
www.SolidQualityLearning.com
"Kalen Delaney" <replies@.public_newsgroups.com> wrote in message
news:eUafDry$EHA.600@.TK2MSFTNGP09.phx.gbl...
> In Query Analyzer, you can run
> RESTORE [mydatabase] WITH RECOVERY
> --
> HTH
> --
> Kalen Delaney
> SQL Server MVP
> www.SolidQualityLearning.com
>
> "Astros" <Astros@.discussions.microsoft.com> wrote in message
> news:3A0FF0B5-E597-4C44-8F22-18BF700512B9@.microsoft.com...
>

How can I change database status from loading

When I started restore, I used leave non operational. But later I find out
that I do not need to apply any additional files. I want to make it
operational. I am using SQL 7.
Any idea how can I change this status ? Thank you very much for reply.Try running the following:
RESTORE DATABASE YourDatabaseName
WITH RECOVERY
If it does not work try the last log backup filename and location.
RESTORE DATABASE YourDatabaseName
FROM DISK = 'c:\bkup.bak'
WITH RECOVERY
I do not have SQL 7 around but it works on 2000
Hope it will do the trick
Andre
"Astros" wrote:
> When I started restore, I used leave non operational. But later I find out
> that I do not need to apply any additional files. I want to make it
> operational. I am using SQL 7.
> Any idea how can I change this status ? Thank you very much for reply.|||In Query Analyzer, you can run
RESTORE [mydatabase] WITH RECOVERY
--
HTH
--
Kalen Delaney
SQL Server MVP
www.SolidQualityLearning.com
"Astros" <Astros@.discussions.microsoft.com> wrote in message
news:3A0FF0B5-E597-4C44-8F22-18BF700512B9@.microsoft.com...
> When I started restore, I used leave non operational. But later I find out
> that I do not need to apply any additional files. I want to make it
> operational. I am using SQL 7.
> Any idea how can I change this status ? Thank you very much for reply.|||Forgot the word DATABASE...
RESTORE DATABASE [mydatabase] WITH RECOVERY
--
HTH
--
Kalen Delaney
SQL Server MVP
www.SolidQualityLearning.com
"Kalen Delaney" <replies@.public_newsgroups.com> wrote in message
news:eUafDry$EHA.600@.TK2MSFTNGP09.phx.gbl...
> In Query Analyzer, you can run
> RESTORE [mydatabase] WITH RECOVERY
> --
> HTH
> --
> Kalen Delaney
> SQL Server MVP
> www.SolidQualityLearning.com
>
> "Astros" <Astros@.discussions.microsoft.com> wrote in message
> news:3A0FF0B5-E597-4C44-8F22-18BF700512B9@.microsoft.com...
>> When I started restore, I used leave non operational. But later I find
>> out
>> that I do not need to apply any additional files. I want to make it
>> operational. I am using SQL 7.
>> Any idea how can I change this status ? Thank you very much for reply.
>

Hotfix Question

Can anyone tell me if SQL server hotfixes are cumulative? Right now we apply
all necessary hotfixes since SP3a individually.
Thanks for your help
OscarHi
Yes they are, unless the readme documentation indicates it.
0952 includes 0818, 0878 etc.
Regards
Mike
"Oscar" wrote:
> Can anyone tell me if SQL server hotfixes are cumulative? Right now we apply
> all necessary hotfixes since SP3a individually.
> Thanks for your help
> Oscar
>

Hotfix 2187 for SP4

If I Upgrade from SP3 ( 8.00.818 ) to SP4 (8.00.2039 ) and then apply hotfix
( 8.00.2187 ) will we be completely up to date with Sql Server patches ?Hi
"Bil" wrote:

> If I Upgrade from SP3 ( 8.00.818 ) to SP4 (8.00.2039 ) and then apply hotf
ix
> ( 8.00.2187 ) will we be completely up to date with Sql Server patches ?
>
AFAIK that was the last hotfix that was generally available
[url]http://www.sqlsecurity.com/FAQs/SQLServerVersionDatabase/tabid/63/Default.aspx[/ur
l] shows there were some more available from PSS
John

Hotfix 2187 for SP4

If I Upgrade from SP3 ( 8.00.818 ) to SP4 (8.00.2039 ) and then apply hotfix
( 8.00.2187 ) will we be completely up to date with Sql Server patches ?
Hi
"Bil" wrote:

> If I Upgrade from SP3 ( 8.00.818 ) to SP4 (8.00.2039 ) and then apply hotfix
> ( 8.00.2187 ) will we be completely up to date with Sql Server patches ?
>
AFAIK that was the last hotfix that was generally available
http://www.sqlsecurity.com/FAQs/SQLServerVersionDatabase/tabid/63/Default.aspx shows there were some more available from PSS
John

Hotfix 2187 for SP4

If I Upgrade from SP3 ( 8.00.818 ) to SP4 (8.00.2039 ) and then apply hotfix
( 8.00.2187 ) will we be completely up to date with Sql Server patches ?Hi
"Bil" wrote:
> If I Upgrade from SP3 ( 8.00.818 ) to SP4 (8.00.2039 ) and then apply hotfix
> ( 8.00.2187 ) will we be completely up to date with Sql Server patches ?
>
AFAIK that was the last hotfix that was generally available
http://www.sqlsecurity.com/FAQs/SQLServerVersionDatabase/tabid/63/Default.aspx shows there were some more available from PSS
John

hot fixes

Are there any fixes that I need to apply after applying sp3 or sp3a or I
should wait for sp4.
yes . . .roll up hotfix 826161 to bring minor version to 818/819
"SB138" wrote:

> Are there any fixes that I need to apply after applying sp3 or sp3a or I
> should wait for sp4.
|||Definitely.
http://support.microsoft.com/?kbid=821277
http://www.aspfaq.com/
(Reverse address to reply.)
"SB138" <SB138@.discussions.microsoft.com> wrote in message
news:257396DF-80D6-4DFF-9F9B-76D8D7D4A275@.microsoft.com...
> Are there any fixes that I need to apply after applying sp3 or sp3a or I
> should wait for sp4.
|||and u can sign up for sp4 beta if intrested :
http://support.microsoft.com/kb/290211
Andy.
"SB138" <SB138@.discussions.microsoft.com> wrote in message
news:257396DF-80D6-4DFF-9F9B-76D8D7D4A275@.microsoft.com...
> Are there any fixes that I need to apply after applying sp3 or sp3a or I
> should wait for sp4.

hot fixes

Are there any fixes that I need to apply after applying sp3 or sp3a or I
should wait for sp4.yes . . .roll up hotfix 826161 to bring minor version to 818/819
"SB138" wrote:

> Are there any fixes that I need to apply after applying sp3 or sp3a or I
> should wait for sp4.|||Definitely.
http://support.microsoft.com/?kbid=821277
http://www.aspfaq.com/
(Reverse address to reply.)
"SB138" <SB138@.discussions.microsoft.com> wrote in message
news:257396DF-80D6-4DFF-9F9B-76D8D7D4A275@.microsoft.com...
> Are there any fixes that I need to apply after applying sp3 or sp3a or I
> should wait for sp4.|||and u can sign up for sp4 beta if intrested :
http://support.microsoft.com/kb/290211
Andy.
"SB138" <SB138@.discussions.microsoft.com> wrote in message
news:257396DF-80D6-4DFF-9F9B-76D8D7D4A275@.microsoft.com...
> Are there any fixes that I need to apply after applying sp3 or sp3a or I
> should wait for sp4.

hot fixes

Are there any fixes that I need to apply after applying sp3 or sp3a or I
should wait for sp4.yes . . .roll up hotfix 826161 to bring minor version to 818/819
"SB138" wrote:
> Are there any fixes that I need to apply after applying sp3 or sp3a or I
> should wait for sp4.|||Definitely.
http://support.microsoft.com/?kbid=821277
--
http://www.aspfaq.com/
(Reverse address to reply.)
"SB138" <SB138@.discussions.microsoft.com> wrote in message
news:257396DF-80D6-4DFF-9F9B-76D8D7D4A275@.microsoft.com...
> Are there any fixes that I need to apply after applying sp3 or sp3a or I
> should wait for sp4.|||and u can sign up for sp4 beta if intrested :
http://support.microsoft.com/kb/290211
Andy.
"SB138" <SB138@.discussions.microsoft.com> wrote in message
news:257396DF-80D6-4DFF-9F9B-76D8D7D4A275@.microsoft.com...
> Are there any fixes that I need to apply after applying sp3 or sp3a or I
> should wait for sp4.