Changing a license from 1 processor to 2 processors

My question is, if I have a SQL2k install, licensed to 1 processor, and I
add a 2nd processor, how do I change the license for a 2nd processor? Do I
need to reconfigure the install? Do I need to type in the new serial number
somewhere? Or do I just need to buy the license for audit purposes?
Chris (IS at the domain of screenplay dot com)
YOu just jave to add them with the licence setup in the control panel.
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
"ct98" <nau97@.nospam.hotmail.com> schrieb im Newsbeitrag
news:Ors7uKIYFHA.1152@.tk2msftngp13.phx.gbl...
> My question is, if I have a SQL2k install, licensed to 1 processor, and I
> add a 2nd processor, how do I change the license for a 2nd processor? Do
> I
> need to reconfigure the install? Do I need to type in the new serial
> number
> somewhere? Or do I just need to buy the license for audit purposes?
> Chris (IS at the domain of screenplay dot com)
>
|||After purchasing the second processor license you just change the licensing
mode to two processors within the licensing applet.
Keith
"ct98" <nau97@.nospam.hotmail.com> wrote in message
news:Ors7uKIYFHA.1152@.tk2msftngp13.phx.gbl...
> My question is, if I have a SQL2k install, licensed to 1 processor, and I
> add a 2nd processor, how do I change the license for a 2nd processor? Do
> I
> need to reconfigure the install? Do I need to type in the new serial
> number
> somewhere? Or do I just need to buy the license for audit purposes?
> Chris (IS at the domain of screenplay dot com)
>
|||Purchase a license from your preferred reseller or follow the terms on your
Open/Select license agreement if you have one. Use the License Management
tool to change the license count so the Application Error log doesn't get
spammed. There may be technical issues with the OS going from a
uniprocessor to a multiprocessor system.
Geoff N. Hiten
Microsoft SQL Server MVP.
"ct98" <nau97@.nospam.hotmail.com> wrote in message
news:Ors7uKIYFHA.1152@.tk2msftngp13.phx.gbl...
> My question is, if I have a SQL2k install, licensed to 1 processor, and I
> add a 2nd processor, how do I change the license for a 2nd processor? Do
> I
> need to reconfigure the install? Do I need to type in the new serial
> number
> somewhere? Or do I just need to buy the license for audit purposes?
> Chris (IS at the domain of screenplay dot com)
>

Changing a license from 1 processor to 2 processors

My question is, if I have a SQL2k install, licensed to 1 processor, and I
add a 2nd processor, how do I change the license for a 2nd processor? Do I
need to reconfigure the install? Do I need to type in the new serial number
somewhere? Or do I just need to buy the license for audit purposes?
Chris (IS at the domain of screenplay dot com)YOu just jave to add them with the licence setup in the control panel.
--
HTH, Jens Suessmeyer.
--
http://www.sqlserver2005.de
--
"ct98" <nau97@.nospam.hotmail.com> schrieb im Newsbeitrag
news:Ors7uKIYFHA.1152@.tk2msftngp13.phx.gbl...
> My question is, if I have a SQL2k install, licensed to 1 processor, and I
> add a 2nd processor, how do I change the license for a 2nd processor? Do
> I
> need to reconfigure the install? Do I need to type in the new serial
> number
> somewhere? Or do I just need to buy the license for audit purposes?
> Chris (IS at the domain of screenplay dot com)
>|||After purchasing the second processor license you just change the licensing
mode to two processors within the licensing applet.
--
Keith
"ct98" <nau97@.nospam.hotmail.com> wrote in message
news:Ors7uKIYFHA.1152@.tk2msftngp13.phx.gbl...
> My question is, if I have a SQL2k install, licensed to 1 processor, and I
> add a 2nd processor, how do I change the license for a 2nd processor? Do
> I
> need to reconfigure the install? Do I need to type in the new serial
> number
> somewhere? Or do I just need to buy the license for audit purposes?
> Chris (IS at the domain of screenplay dot com)
>|||Purchase a license from your preferred reseller or follow the terms on your
Open/Select license agreement if you have one. Use the License Management
tool to change the license count so the Application Error log doesn't get
spammed. There may be technical issues with the OS going from a
uniprocessor to a multiprocessor system.
Geoff N. Hiten
Microsoft SQL Server MVP.
"ct98" <nau97@.nospam.hotmail.com> wrote in message
news:Ors7uKIYFHA.1152@.tk2msftngp13.phx.gbl...
> My question is, if I have a SQL2k install, licensed to 1 processor, and I
> add a 2nd processor, how do I change the license for a 2nd processor? Do
> I
> need to reconfigure the install? Do I need to type in the new serial
> number
> somewhere? Or do I just need to buy the license for audit purposes?
> Chris (IS at the domain of screenplay dot com)
>sql

Changing a license from 1 processor to 2 processors

My question is, if I have a SQL2k install, licensed to 1 processor, and I
add a 2nd processor, how do I change the license for a 2nd processor? Do I
need to reconfigure the install? Do I need to type in the new serial number
somewhere? Or do I just need to buy the license for audit purposes?
Chris (IS at the domain of screenplay dot com)YOu just jave to add them with the licence setup in the control panel.
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
--
"ct98" <nau97@.nospam.hotmail.com> schrieb im Newsbeitrag
news:Ors7uKIYFHA.1152@.tk2msftngp13.phx.gbl...
> My question is, if I have a SQL2k install, licensed to 1 processor, and I
> add a 2nd processor, how do I change the license for a 2nd processor? Do
> I
> need to reconfigure the install? Do I need to type in the new serial
> number
> somewhere? Or do I just need to buy the license for audit purposes?
> Chris (IS at the domain of screenplay dot com)
>|||After purchasing the second processor license you just change the licensing
mode to two processors within the licensing applet.
Keith
"ct98" <nau97@.nospam.hotmail.com> wrote in message
news:Ors7uKIYFHA.1152@.tk2msftngp13.phx.gbl...
> My question is, if I have a SQL2k install, licensed to 1 processor, and I
> add a 2nd processor, how do I change the license for a 2nd processor? Do
> I
> need to reconfigure the install? Do I need to type in the new serial
> number
> somewhere? Or do I just need to buy the license for audit purposes?
> Chris (IS at the domain of screenplay dot com)
>|||Purchase a license from your preferred reseller or follow the terms on your
Open/Select license agreement if you have one. Use the License Management
tool to change the license count so the Application Error log doesn't get
spammed. There may be technical issues with the OS going from a
uniprocessor to a multiprocessor system.
Geoff N. Hiten
Microsoft SQL Server MVP.
"ct98" <nau97@.nospam.hotmail.com> wrote in message
news:Ors7uKIYFHA.1152@.tk2msftngp13.phx.gbl...
> My question is, if I have a SQL2k install, licensed to 1 processor, and I
> add a 2nd processor, how do I change the license for a 2nd processor? Do
> I
> need to reconfigure the install? Do I need to type in the new serial
> number
> somewhere? Or do I just need to buy the license for audit purposes?
> Chris (IS at the domain of screenplay dot com)
>

Change version from SQL2K Developer Edition to SQL2K Standard Edition ?

Is there a "recipe" to do this ?
B.r.
Keld ThomsenJust upgrade!
"Keld Stig Thomsen" <dsl85271@.vip.cybercity.dk> wrote in message news:ckmnu6
$1mun$1@.news.cybercity.dk...
Is there a "recipe" to do this ?
B.r.
Keld Thomsen|||This type of "upgrade" is not supported according to the Online Books, Techn
et etc.
You can only upgrade an SQL2K Developer Edition to SQL2K Enterprise Edition
- NOT to Standard Edition:
http://msdn.microsoft.com/library/d.../>
ew_2xtf.asp
And that's why I'm asking for a 'recipe'.
Best regards
Keld Stig Thomsen
"TJ" <tunj@.hotmail.com> wrote in message news:uUvZyTlsEHA.3412@.TK2MSFTNGP14.
phx.gbl...
Just upgrade!
"Keld Stig Thomsen" <dsl85271@.vip.cybercity.dk> wrote in message news:ckmnu6
$1mun$1@.news.cybercity.dk...
Is there a "recipe" to do this ?
B.r.
Keld Thomsen

Change version from SQL2K Developer Edition to SQL2K Standard Edition ?

Is there a "recipe" to do this ?
B.r.
Keld Thomsen
Just upgrade!
"Keld Stig Thomsen" <dsl85271@.vip.cybercity.dk> wrote in message news:ckmnu6$1mun$1@.news.cybercity.dk...
Is there a "recipe" to do this ?
B.r.
Keld Thomsen
|||This type of "upgrade" is not supported according to the Online Books, Technet etc.
You can only upgrade an SQL2K Developer Edition to SQL2K Enterprise Edition - NOT to Standard Edition:
http://msdn.microsoft.com/library/de...rview_2xtf.asp
And that's why I'm asking for a 'recipe'.
Best regards
Keld Stig Thomsen
"TJ" <tunj@.hotmail.com> wrote in message news:uUvZyTlsEHA.3412@.TK2MSFTNGP14.phx.gbl...
Just upgrade!
"Keld Stig Thomsen" <dsl85271@.vip.cybercity.dk> wrote in message news:ckmnu6$1mun$1@.news.cybercity.dk...
Is there a "recipe" to do this ?
B.r.
Keld Thomsen

Change the logical name....

How to change the logical name of the database?
SQL2K.
Thanks,
HarryThis is a multi-part message in MIME format.
--070401030300090800000309
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
exec sp_renamedb
<http://msdn.microsoft.com/library/en-us/tsqlref/ts_sp_ra-rz_3yle.asp>
'OldName', 'NewName'
--
*mike hodgson*
blog: http://sqlnerd.blogspot.com
HarrySmith wrote:
>How to change the logical name of the database?
>SQL2K.
>Thanks,
>Harry
>
>
--070401030300090800000309
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
<tt>exec <a
href="http://links.10026.com/?link=sp_renamedb</a>">http://msdn.microsoft.com/library/en-us/tsqlref/ts_sp_ra-rz_3yle.asp">sp_renamedb</a>
'OldName', 'NewName'</tt><br>
<div class="moz-signature">
<title></title>
<meta http-equiv="Content-Type" content="text/html; ">
<p><span lang="en-au"><font face="Tahoma" size="2">--<br>
</font></span> <b><span lang="en-au"><font face="Tahoma" size="2">mike
hodgson</font></span></b><span lang="en-au"><br>
<font face="Tahoma" size="2">blog:</font><font face="Tahoma" size="2"> <a
href="http://links.10026.com/?link=http://sqlnerd.blogspot.com</a></font></span>">http://sqlnerd.blogspot.com">http://sqlnerd.blogspot.com</a></font></span>
</p>
</div>
<br>
<br>
HarrySmith wrote:
<blockquote cite="mid%2304iYpBtFHA.2348@.tk2msftngp13.phx.gbl"
type="cite">
<pre wrap="">How to change the logical name of the database?
SQL2K.
Thanks,
Harry
</pre>
</blockquote>
</body>
</html>
--070401030300090800000309--|||Hi Harry,
U can use sp_password for change of password
use sp_changedbowner for change of db owner
from
doller|||U can also use ep_renamedb
for user rename
from
doller|||U can also use sp_renamedb
for user rename
from
doller|||U can also use sp_renamedb
for user rename
from
doller|||Hi,
Looks like Harry asked to change the logical file name. For that you have to
ALTER DATABASE command.
Command is:-
ALTER DATABASE <DBNAME> modify file (NAME = 'old_MDF_NAME', NEWNAME ='NEW_MDF_NAME')
do the same for LDF file as well.
Note:
We can not change the logical file name in SQL 7. The command will only work
in SQL 2000.
THnaks
Hari
SQL Server MVP
"HarrySmith" <HarrySmith_56@.hotmail.com> wrote in message
news:%2304iYpBtFHA.2348@.tk2msftngp13.phx.gbl...
> How to change the logical name of the database?
> SQL2K.
> Thanks,
> Harry
>|||Yes. Hari's solution is the right one for my requirement. I did not try
other postings.
Thanks,
Harry
"Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
news:%23Fob8BCtFHA.3080@.TK2MSFTNGP15.phx.gbl...
> Hi,
>
> Looks like Harry asked to change the logical file name. For that you have
to
> ALTER DATABASE command.
> Command is:-
> ALTER DATABASE <DBNAME> modify file (NAME = 'old_MDF_NAME', NEWNAME => 'NEW_MDF_NAME')
>
> do the same for LDF file as well.
>
> Note:
> We can not change the logical file name in SQL 7. The command will only
work
> in SQL 2000.
> THnaks
> Hari
> SQL Server MVP
> "HarrySmith" <HarrySmith_56@.hotmail.com> wrote in message
> news:%2304iYpBtFHA.2348@.tk2msftngp13.phx.gbl...
> > How to change the logical name of the database?
> > SQL2K.
> > Thanks,
> > Harry
> >
> >
>

Change replicationAgent that starts SQLSERVERAGENT

Hi,
We are using Push subscription in our transactional replication setup in SQL
2K and I noticed that the SQLSERVERAGENT service is started by a local
account called replicationAgent. Is it a problem for me to change it to a
different local account? If it is ok to change it, do I need to change it
also in the subscriber computer and is it necessary that both account name
and password need to be the same?
Wingman
It is ok to change it to an account in the local administrator group, or an
account which has write permission to the default snapshot share.
Make sure that the job owner is sa otherwise it probably will not start.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Wingman" <Wingman@.discussions.microsoft.com> wrote in message
news:67E05E17-2202-477C-BB62-75695B821516@.microsoft.com...
> Hi,
> We are using Push subscription in our transactional replication setup in
> SQL
> 2K and I noticed that the SQLSERVERAGENT service is started by a local
> account called replicationAgent. Is it a problem for me to change it to
> a
> different local account? If it is ok to change it, do I need to change it
> also in the subscriber computer and is it necessary that both account name
> and password need to be the same?
> Wingman
|||Thanks as always.
Wing
"Wingman" wrote:

> Hi,
> We are using Push subscription in our transactional replication setup in SQL
> 2K and I noticed that the SQLSERVERAGENT service is started by a local
> account called replicationAgent. Is it a problem for me to change it to a
> different local account? If it is ok to change it, do I need to change it
> also in the subscriber computer and is it necessary that both account name
> and password need to be the same?
> Wingman

Change Object Ownership

I'm running SQL2K on an Win 2K Server. Because of addition of additions to our network, we've installed AD on the Win 2K to graduate
it to a Domain Controller Server. Checking the event log, one finds
an ownership warning:

Event Type: Warning
Event Source: SQLSERVERAGENT
Event Category: Job Engine
Event ID: 208
Date: 1/15/2002
Time: 8:00:01 PM
User: N/A
Computer: XXXXX-XXX
Description:
SQL Server Scheduled Job 'DB Backup Job for DB Maintenance Plan 'DB Maintenance Plan1'' (0x72097D93A71E1842AA6C46E6AC59750B) - Status: Failed - Invoked on: 2002-01-15 20:00:01 - Message: The job failed. The owner () of job DB Backup Job for DB Maintenance Plan 'DB Maintenance Plan1' does not have server access.

I believe this warning is generated because the SQLServer system is
looking to execute the DB Backup plan using the new Domain
administrative account. I came to this conclusion after reviewing
replication ownership warnings in the event log. I was easly able to
change replication jobs from then new Domain administrative account
to sa.

I would like to change the ownership to sa for a Maintenance Plan.
Is there a way to do this? Is this the solution?You would be better off not using a maintenance plan but coding the requirement yourself in a stored procedure. It is very easy to do and gets round these problems as you know what it is doing.

change MSDB owner

My Production's SQL2k MSDB & Model database owner is my old NT Domain
Administrator (olddomain/administrator). Can't remember how it ended that
way. Master owner is SA.
We have completed domain migration to Active Directory, if sp_changedbowner
is not going to allow me to change DB owner for MSDB & Model, does that mean
I got to keep my PDC (NT Domain) forever ?
Surely there must be a work-around for this.
Warning !!!
The following script is not a standard procedure:
[script]
use master
go
exec sp_configure 'allow updates', 1
reconfigure with override
go
update sysdatabases
set sid = 0x01
where name = 'model'
go
sp_configure 'allow updates', 0
reconfigure with override
[/script]
Cristian Lefter, SQL Server MVP
"pohkeat" <pohkeat@.hotmail.com> wrote in message
news:OYIkV$$HFHA.720@.TK2MSFTNGP10.phx.gbl...
> My Production's SQL2k MSDB & Model database owner is my old NT Domain
> Administrator (olddomain/administrator). Can't remember how it ended that
> way. Master owner is SA.
> We have completed domain migration to Active Directory, if
> sp_changedbowner
> is not going to allow me to change DB owner for MSDB & Model, does that
> mean
> I got to keep my PDC (NT Domain) forever ?
> Surely there must be a work-around for this.
>

change MSDB owner

My Production's SQL2k MSDB & Model database owner is my old NT Domain
Administrator (olddomain/administrator). Can't remember how it ended that
way. Master owner is SA.
We have completed domain migration to Active Directory, if sp_changedbowner
is not going to allow me to change DB owner for MSDB & Model, does that mean
I got to keep my PDC (NT Domain) forever ?
Surely there must be a work-around for this.Warning !!!
The following script is not a standard procedure:
[script]
use master
go
exec sp_configure 'allow updates', 1
reconfigure with override
go
update sysdatabases
set sid = 0x01
where name = 'model'
go
sp_configure 'allow updates', 0
reconfigure with override
[/script]
Cristian Lefter, SQL Server MVP
"pohkeat" <pohkeat@.hotmail.com> wrote in message
news:OYIkV$$HFHA.720@.TK2MSFTNGP10.phx.gbl...
> My Production's SQL2k MSDB & Model database owner is my old NT Domain
> Administrator (olddomain/administrator). Can't remember how it ended that
> way. Master owner is SA.
> We have completed domain migration to Active Directory, if
> sp_changedbowner
> is not going to allow me to change DB owner for MSDB & Model, does that
> mean
> I got to keep my PDC (NT Domain) forever ?
> Surely there must be a work-around for this.
>

change MSDB owner

My Production's SQL2k MSDB & Model database owner is my old NT Domain
Administrator (olddomain/administrator). Can't remember how it ended that
way. Master owner is SA.
We have completed domain migration to Active Directory, if sp_changedbowner
is not going to allow me to change DB owner for MSDB & Model, does that mean
I got to keep my PDC (NT Domain) forever ?
Surely there must be a work-around for this.Warning !!!
The following script is not a standard procedure:
[script]
use master
go
exec sp_configure 'allow updates', 1
reconfigure with override
go
update sysdatabases
set sid = 0x01
where name = 'model'
go
sp_configure 'allow updates', 0
reconfigure with override
[/script]
Cristian Lefter, SQL Server MVP
"pohkeat" <pohkeat@.hotmail.com> wrote in message
news:OYIkV$$HFHA.720@.TK2MSFTNGP10.phx.gbl...
> My Production's SQL2k MSDB & Model database owner is my old NT Domain
> Administrator (olddomain/administrator). Can't remember how it ended that
> way. Master owner is SA.
> We have completed domain migration to Active Directory, if
> sp_changedbowner
> is not going to allow me to change DB owner for MSDB & Model, does that
> mean
> I got to keep my PDC (NT Domain) forever ?
> Surely there must be a work-around for this.
>