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)
>
Showing posts with label install. Show all posts
Showing posts with label install. Show all posts
Thursday, March 22, 2012
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
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)
>
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)
>
Sunday, February 19, 2012
Change Server Default Collation
Is it possible to change the default collation on SQL2L post install, and if
so how?
See if this helps:
Rebuild Master
http://msdn.microsoft.com/library/de...ldmst_24aa.asp
AMB
"geerob" wrote:
> Is it possible to change the default collation on SQL2L post install, and if
> so how?
>
|||See "Rebuild master Utility" in SQL Server 2000 Books Online.
HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
"geerob" <geerob@.discussions.microsoft.com> wrote in message
news:9E118AC9-1D2F-42BE-B103-0A419497016E@.microsoft.com...
Is it possible to change the default collation on SQL2L post install, and if
so how?
|||Thanks for the info, this is exactly what I was looking for.
Rob
"Alejandro Mesa" wrote:
[vbcol=seagreen]
> See if this helps:
> Rebuild Master
> http://msdn.microsoft.com/library/de...ldmst_24aa.asp
>
> AMB
> "geerob" wrote:
so how?
See if this helps:
Rebuild Master
http://msdn.microsoft.com/library/de...ldmst_24aa.asp
AMB
"geerob" wrote:
> Is it possible to change the default collation on SQL2L post install, and if
> so how?
>
|||See "Rebuild master Utility" in SQL Server 2000 Books Online.
HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
"geerob" <geerob@.discussions.microsoft.com> wrote in message
news:9E118AC9-1D2F-42BE-B103-0A419497016E@.microsoft.com...
Is it possible to change the default collation on SQL2L post install, and if
so how?
|||Thanks for the info, this is exactly what I was looking for.
Rob
"Alejandro Mesa" wrote:
[vbcol=seagreen]
> See if this helps:
> Rebuild Master
> http://msdn.microsoft.com/library/de...ldmst_24aa.asp
>
> AMB
> "geerob" wrote:
Change Server Default Collation
Is it possible to change the default collation on SQL2L post install, and if
so how?See if this helps:
Rebuild Master
_24aa.asp" target="_blank">http://msdn.microsoft.com/library/d...r />
_24aa.asp
AMB
"geerob" wrote:
> Is it possible to change the default collation on SQL2L post install, and
if
> so how?
>|||See "Rebuild master Utility" in SQL Server 2000 Books Online.
--
HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
"geerob" <geerob@.discussions.microsoft.com> wrote in message
news:9E118AC9-1D2F-42BE-B103-0A419497016E@.microsoft.com...
Is it possible to change the default collation on SQL2L post install, and if
so how?|||Thanks for the info, this is exactly what I was looking for.
Rob
"Alejandro Mesa" wrote:
[vbcol=seagreen]
> See if this helps:
> Rebuild Master
> st_24aa.asp" target="_blank">http://msdn.microsoft.com/library/d.../>
st_24aa.asp
>
> AMB
> "geerob" wrote:
>
so how?See if this helps:
Rebuild Master
_24aa.asp" target="_blank">http://msdn.microsoft.com/library/d...r />
_24aa.asp
AMB
"geerob" wrote:
> Is it possible to change the default collation on SQL2L post install, and
if
> so how?
>|||See "Rebuild master Utility" in SQL Server 2000 Books Online.
--
HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
"geerob" <geerob@.discussions.microsoft.com> wrote in message
news:9E118AC9-1D2F-42BE-B103-0A419497016E@.microsoft.com...
Is it possible to change the default collation on SQL2L post install, and if
so how?|||Thanks for the info, this is exactly what I was looking for.
Rob
"Alejandro Mesa" wrote:
[vbcol=seagreen]
> See if this helps:
> Rebuild Master
> st_24aa.asp" target="_blank">http://msdn.microsoft.com/library/d.../>
st_24aa.asp
>
> AMB
> "geerob" wrote:
>
Change Server Default Collation
Is it possible to change the default collation on SQL2L post install, and if
so how?See if this helps:
Rebuild Maste
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rebldmst/rebldmst_24aa.asp
AMB
"geerob" wrote:
> Is it possible to change the default collation on SQL2L post install, and if
> so how?
>|||See "Rebuild master Utility" in SQL Server 2000 Books Online.
--
HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
"geerob" <geerob@.discussions.microsoft.com> wrote in message
news:9E118AC9-1D2F-42BE-B103-0A419497016E@.microsoft.com...
Is it possible to change the default collation on SQL2L post install, and if
so how?|||Thanks for the info, this is exactly what I was looking for.
Rob
"Alejandro Mesa" wrote:
> See if this helps:
> Rebuild Master
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rebldmst/rebldmst_24aa.asp
>
> AMB
> "geerob" wrote:
> > Is it possible to change the default collation on SQL2L post install, and if
> > so how?
> >
> >
so how?See if this helps:
Rebuild Maste
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rebldmst/rebldmst_24aa.asp
AMB
"geerob" wrote:
> Is it possible to change the default collation on SQL2L post install, and if
> so how?
>|||See "Rebuild master Utility" in SQL Server 2000 Books Online.
--
HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
"geerob" <geerob@.discussions.microsoft.com> wrote in message
news:9E118AC9-1D2F-42BE-B103-0A419497016E@.microsoft.com...
Is it possible to change the default collation on SQL2L post install, and if
so how?|||Thanks for the info, this is exactly what I was looking for.
Rob
"Alejandro Mesa" wrote:
> See if this helps:
> Rebuild Master
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rebldmst/rebldmst_24aa.asp
>
> AMB
> "geerob" wrote:
> > Is it possible to change the default collation on SQL2L post install, and if
> > so how?
> >
> >
Thursday, February 16, 2012
Change report server database
I install reporting service on 2 machines. Each RS has it's own report
server database. e.g. A_ReportServer for machine A and B_ReportServer for
machine B. Can I dynamically change the report server database ? i.e.
Machine A point to B_ReportServer database. If yes, how can I do this ?You can redirect A_ReportServer to point to Database B by running the
rsconfig.exe utility. Please refer to the following link for more
information:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSinstall/htm/gs_installingrs_v1_7oft.asp
If your looking for load balancing or failover support as in load balancing
of the web servers or Sql Server failover that is available with the
enterprise edition. Check the BOL for more info about how to configure.
"May Liu" wrote:
> I install reporting service on 2 machines. Each RS has it's own report
> server database. e.g. A_ReportServer for machine A and B_ReportServer for
> machine B. Can I dynamically change the report server database ? i.e.
> Machine A point to B_ReportServer database. If yes, how can I do this ?
server database. e.g. A_ReportServer for machine A and B_ReportServer for
machine B. Can I dynamically change the report server database ? i.e.
Machine A point to B_ReportServer database. If yes, how can I do this ?You can redirect A_ReportServer to point to Database B by running the
rsconfig.exe utility. Please refer to the following link for more
information:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSinstall/htm/gs_installingrs_v1_7oft.asp
If your looking for load balancing or failover support as in load balancing
of the web servers or Sql Server failover that is available with the
enterprise edition. Check the BOL for more info about how to configure.
"May Liu" wrote:
> I install reporting service on 2 machines. Each RS has it's own report
> server database. e.g. A_ReportServer for machine A and B_ReportServer for
> machine B. Can I dynamically change the report server database ? i.e.
> Machine A point to B_ReportServer database. If yes, how can I do this ?
Friday, February 10, 2012
Change Named to Default Instance
We are looking to install SQL 2005 Standard next to a SQL 2000 Enterprise
installation. The SQL 2K install is running under the default instance and
therefore to install the SQL 2005 we will need to run it under a named
instance. After the SQL 2005 has been configured and we are confident the DB
is how we want it we want to uninstall the SQL 2K and make the SQL 2005 the
default instance. Can anyone describe the steps need to do this. We want to
avoid having to re-write a lot of connetion strings in client applications
which would require is to re-deploy those apps.
Thanks in advance.
RT
Hi,
To add on to Tibor; you could use the automated upgrade of sql 2000 to sql
2005. steps
1. Take a complete backup of sql 2000 (including system databases)
2. Run the SQL 2005 setup program
3. This will automatically upgrades the existing SQL 2000 to SQL 2005
4. After the completion of the upgrade the existing SQL 2000 will be
upgraded to SQL 2005 with the same server name
5. After this there will not be any connecting string chnages
The only this incase of issues; you may need to install SQL 2000 and restore
all the databases backed up...
Take a look into:-
http://www.microsoft.com/technet/prodtechnol/sql/2005/sqlupgrd.mspx
Thanks
Hari
"RT" <RT@.discussions.microsoft.com> wrote in message
news:2BD744AB-1A64-4F49-8FE5-9A388A52B72D@.microsoft.com...
> We are looking to install SQL 2005 Standard next to a SQL 2000 Enterprise
> installation. The SQL 2K install is running under the default instance and
> therefore to install the SQL 2005 we will need to run it under a named
> instance. After the SQL 2005 has been configured and we are confident the
> DB
> is how we want it we want to uninstall the SQL 2K and make the SQL 2005
> the
> default instance. Can anyone describe the steps need to do this. We want
> to
> avoid having to re-write a lot of connetion strings in client applications
> which would require is to re-deploy those apps.
> Thanks in advance.
> RT
|||Sorry to use an existing post but when I try to start a new thread, nothing
happends.
I just reinstalled SQL Server 2000. During the install. I used the default
Server name of GATEWAY_COMPUTE. Now when I try to start SQL Server, the
Server name comes up as GATEWAY_COMPUTE, services is SQL Server. When I
click start I receive error message ' The service did not start due to a
login failure'.
Can someone tell me how to correct this?
installation. The SQL 2K install is running under the default instance and
therefore to install the SQL 2005 we will need to run it under a named
instance. After the SQL 2005 has been configured and we are confident the DB
is how we want it we want to uninstall the SQL 2K and make the SQL 2005 the
default instance. Can anyone describe the steps need to do this. We want to
avoid having to re-write a lot of connetion strings in client applications
which would require is to re-deploy those apps.
Thanks in advance.
RT
Hi,
To add on to Tibor; you could use the automated upgrade of sql 2000 to sql
2005. steps
1. Take a complete backup of sql 2000 (including system databases)
2. Run the SQL 2005 setup program
3. This will automatically upgrades the existing SQL 2000 to SQL 2005
4. After the completion of the upgrade the existing SQL 2000 will be
upgraded to SQL 2005 with the same server name
5. After this there will not be any connecting string chnages
The only this incase of issues; you may need to install SQL 2000 and restore
all the databases backed up...
Take a look into:-
http://www.microsoft.com/technet/prodtechnol/sql/2005/sqlupgrd.mspx
Thanks
Hari
"RT" <RT@.discussions.microsoft.com> wrote in message
news:2BD744AB-1A64-4F49-8FE5-9A388A52B72D@.microsoft.com...
> We are looking to install SQL 2005 Standard next to a SQL 2000 Enterprise
> installation. The SQL 2K install is running under the default instance and
> therefore to install the SQL 2005 we will need to run it under a named
> instance. After the SQL 2005 has been configured and we are confident the
> DB
> is how we want it we want to uninstall the SQL 2K and make the SQL 2005
> the
> default instance. Can anyone describe the steps need to do this. We want
> to
> avoid having to re-write a lot of connetion strings in client applications
> which would require is to re-deploy those apps.
> Thanks in advance.
> RT
|||Sorry to use an existing post but when I try to start a new thread, nothing
happends.
I just reinstalled SQL Server 2000. During the install. I used the default
Server name of GATEWAY_COMPUTE. Now when I try to start SQL Server, the
Server name comes up as GATEWAY_COMPUTE, services is SQL Server. When I
click start I receive error message ' The service did not start due to a
login failure'.
Can someone tell me how to correct this?
Change Named to Default Instance
We are looking to install SQL 2005 Standard next to a SQL 2000 Enterprise
installation. The SQL 2K install is running under the default instance and
therefore to install the SQL 2005 we will need to run it under a named
instance. After the SQL 2005 has been configured and we are confident the DB
is how we want it we want to uninstall the SQL 2K and make the SQL 2005 the
default instance. Can anyone describe the steps need to do this. We want to
avoid having to re-write a lot of connetion strings in client applications
which would require is to re-deploy those apps.
Thanks in advance.
RTYou cannot change instance name, nor from a default to a named instance (or
other way around). One
option is to install 2005 again, as a named instance (after removing 2000).
Then copy the databases
(backup/restore, detach/attach, for instance). But there are extra steps han
dling the data inside
the system databases, though...
Or, handle this on the client machines:
Either change the connection string.
Or, create an alias for the named instance, with only the machine name as th
e alias name.
(Basically, rename it seen from the client's perspective.)
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"RT" <RT@.discussions.microsoft.com> wrote in message
news:2BD744AB-1A64-4F49-8FE5-9A388A52B72D@.microsoft.com...
> We are looking to install SQL 2005 Standard next to a SQL 2000 Enterprise
> installation. The SQL 2K install is running under the default instance and
> therefore to install the SQL 2005 we will need to run it under a named
> instance. After the SQL 2005 has been configured and we are confident the
DB
> is how we want it we want to uninstall the SQL 2K and make the SQL 2005 th
e
> default instance. Can anyone describe the steps need to do this. We want t
o
> avoid having to re-write a lot of connetion strings in client applications
> which would require is to re-deploy those apps.
> Thanks in advance.
> RT|||Hi,
To add on to Tibor; you could use the automated upgrade of sql 2000 to sql
2005. steps
1. Take a complete backup of sql 2000 (including system databases)
2. Run the SQL 2005 setup program
3. This will automatically upgrades the existing SQL 2000 to SQL 2005
4. After the completion of the upgrade the existing SQL 2000 will be
upgraded to SQL 2005 with the same server name
5. After this there will not be any connecting string chnages
The only this incase of issues; you may need to install SQL 2000 and restore
all the databases backed up...
Take a look into:-
http://www.microsoft.com/technet/pr...5/sqlupgrd.mspx
Thanks
Hari
"RT" <RT@.discussions.microsoft.com> wrote in message
news:2BD744AB-1A64-4F49-8FE5-9A388A52B72D@.microsoft.com...
> We are looking to install SQL 2005 Standard next to a SQL 2000 Enterprise
> installation. The SQL 2K install is running under the default instance and
> therefore to install the SQL 2005 we will need to run it under a named
> instance. After the SQL 2005 has been configured and we are confident the
> DB
> is how we want it we want to uninstall the SQL 2K and make the SQL 2005
> the
> default instance. Can anyone describe the steps need to do this. We want
> to
> avoid having to re-write a lot of connetion strings in client applications
> which would require is to re-deploy those apps.
> Thanks in advance.
> RT
installation. The SQL 2K install is running under the default instance and
therefore to install the SQL 2005 we will need to run it under a named
instance. After the SQL 2005 has been configured and we are confident the DB
is how we want it we want to uninstall the SQL 2K and make the SQL 2005 the
default instance. Can anyone describe the steps need to do this. We want to
avoid having to re-write a lot of connetion strings in client applications
which would require is to re-deploy those apps.
Thanks in advance.
RTYou cannot change instance name, nor from a default to a named instance (or
other way around). One
option is to install 2005 again, as a named instance (after removing 2000).
Then copy the databases
(backup/restore, detach/attach, for instance). But there are extra steps han
dling the data inside
the system databases, though...
Or, handle this on the client machines:
Either change the connection string.
Or, create an alias for the named instance, with only the machine name as th
e alias name.
(Basically, rename it seen from the client's perspective.)
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"RT" <RT@.discussions.microsoft.com> wrote in message
news:2BD744AB-1A64-4F49-8FE5-9A388A52B72D@.microsoft.com...
> We are looking to install SQL 2005 Standard next to a SQL 2000 Enterprise
> installation. The SQL 2K install is running under the default instance and
> therefore to install the SQL 2005 we will need to run it under a named
> instance. After the SQL 2005 has been configured and we are confident the
DB
> is how we want it we want to uninstall the SQL 2K and make the SQL 2005 th
e
> default instance. Can anyone describe the steps need to do this. We want t
o
> avoid having to re-write a lot of connetion strings in client applications
> which would require is to re-deploy those apps.
> Thanks in advance.
> RT|||Hi,
To add on to Tibor; you could use the automated upgrade of sql 2000 to sql
2005. steps
1. Take a complete backup of sql 2000 (including system databases)
2. Run the SQL 2005 setup program
3. This will automatically upgrades the existing SQL 2000 to SQL 2005
4. After the completion of the upgrade the existing SQL 2000 will be
upgraded to SQL 2005 with the same server name
5. After this there will not be any connecting string chnages
The only this incase of issues; you may need to install SQL 2000 and restore
all the databases backed up...
Take a look into:-
http://www.microsoft.com/technet/pr...5/sqlupgrd.mspx
Thanks
Hari
"RT" <RT@.discussions.microsoft.com> wrote in message
news:2BD744AB-1A64-4F49-8FE5-9A388A52B72D@.microsoft.com...
> We are looking to install SQL 2005 Standard next to a SQL 2000 Enterprise
> installation. The SQL 2K install is running under the default instance and
> therefore to install the SQL 2005 we will need to run it under a named
> instance. After the SQL 2005 has been configured and we are confident the
> DB
> is how we want it we want to uninstall the SQL 2K and make the SQL 2005
> the
> default instance. Can anyone describe the steps need to do this. We want
> to
> avoid having to re-write a lot of connetion strings in client applications
> which would require is to re-deploy those apps.
> Thanks in advance.
> RT
Change Named to Default Instance
We are looking to install SQL 2005 Standard next to a SQL 2000 Enterprise
installation. The SQL 2K install is running under the default instance and
therefore to install the SQL 2005 we will need to run it under a named
instance. After the SQL 2005 has been configured and we are confident the DB
is how we want it we want to uninstall the SQL 2K and make the SQL 2005 the
default instance. Can anyone describe the steps need to do this. We want to
avoid having to re-write a lot of connetion strings in client applications
which would require is to re-deploy those apps.
Thanks in advance.
RTYou cannot change instance name, nor from a default to a named instance (or other way around). One
option is to install 2005 again, as a named instance (after removing 2000). Then copy the databases
(backup/restore, detach/attach, for instance). But there are extra steps handling the data inside
the system databases, though...
Or, handle this on the client machines:
Either change the connection string.
Or, create an alias for the named instance, with only the machine name as the alias name.
(Basically, rename it seen from the client's perspective.)
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"RT" <RT@.discussions.microsoft.com> wrote in message
news:2BD744AB-1A64-4F49-8FE5-9A388A52B72D@.microsoft.com...
> We are looking to install SQL 2005 Standard next to a SQL 2000 Enterprise
> installation. The SQL 2K install is running under the default instance and
> therefore to install the SQL 2005 we will need to run it under a named
> instance. After the SQL 2005 has been configured and we are confident the DB
> is how we want it we want to uninstall the SQL 2K and make the SQL 2005 the
> default instance. Can anyone describe the steps need to do this. We want to
> avoid having to re-write a lot of connetion strings in client applications
> which would require is to re-deploy those apps.
> Thanks in advance.
> RT|||Hi,
To add on to Tibor; you could use the automated upgrade of sql 2000 to sql
2005. steps
1. Take a complete backup of sql 2000 (including system databases)
2. Run the SQL 2005 setup program
3. This will automatically upgrades the existing SQL 2000 to SQL 2005
4. After the completion of the upgrade the existing SQL 2000 will be
upgraded to SQL 2005 with the same server name
5. After this there will not be any connecting string chnages
The only this incase of issues; you may need to install SQL 2000 and restore
all the databases backed up...
Take a look into:-
http://www.microsoft.com/technet/prodtechnol/sql/2005/sqlupgrd.mspx
Thanks
Hari
"RT" <RT@.discussions.microsoft.com> wrote in message
news:2BD744AB-1A64-4F49-8FE5-9A388A52B72D@.microsoft.com...
> We are looking to install SQL 2005 Standard next to a SQL 2000 Enterprise
> installation. The SQL 2K install is running under the default instance and
> therefore to install the SQL 2005 we will need to run it under a named
> instance. After the SQL 2005 has been configured and we are confident the
> DB
> is how we want it we want to uninstall the SQL 2K and make the SQL 2005
> the
> default instance. Can anyone describe the steps need to do this. We want
> to
> avoid having to re-write a lot of connetion strings in client applications
> which would require is to re-deploy those apps.
> Thanks in advance.
> RT|||Sorry to use an existing post but when I try to start a new thread, nothing
happends.
I just reinstalled SQL Server 2000. During the install. I used the default
Server name of GATEWAY_COMPUTE. Now when I try to start SQL Server, the
Server name comes up as GATEWAY_COMPUTE, services is SQL Server. When I
click start I receive error message ' The service did not start due to a
login failure'.
Can someone tell me how to correct this?
installation. The SQL 2K install is running under the default instance and
therefore to install the SQL 2005 we will need to run it under a named
instance. After the SQL 2005 has been configured and we are confident the DB
is how we want it we want to uninstall the SQL 2K and make the SQL 2005 the
default instance. Can anyone describe the steps need to do this. We want to
avoid having to re-write a lot of connetion strings in client applications
which would require is to re-deploy those apps.
Thanks in advance.
RTYou cannot change instance name, nor from a default to a named instance (or other way around). One
option is to install 2005 again, as a named instance (after removing 2000). Then copy the databases
(backup/restore, detach/attach, for instance). But there are extra steps handling the data inside
the system databases, though...
Or, handle this on the client machines:
Either change the connection string.
Or, create an alias for the named instance, with only the machine name as the alias name.
(Basically, rename it seen from the client's perspective.)
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"RT" <RT@.discussions.microsoft.com> wrote in message
news:2BD744AB-1A64-4F49-8FE5-9A388A52B72D@.microsoft.com...
> We are looking to install SQL 2005 Standard next to a SQL 2000 Enterprise
> installation. The SQL 2K install is running under the default instance and
> therefore to install the SQL 2005 we will need to run it under a named
> instance. After the SQL 2005 has been configured and we are confident the DB
> is how we want it we want to uninstall the SQL 2K and make the SQL 2005 the
> default instance. Can anyone describe the steps need to do this. We want to
> avoid having to re-write a lot of connetion strings in client applications
> which would require is to re-deploy those apps.
> Thanks in advance.
> RT|||Hi,
To add on to Tibor; you could use the automated upgrade of sql 2000 to sql
2005. steps
1. Take a complete backup of sql 2000 (including system databases)
2. Run the SQL 2005 setup program
3. This will automatically upgrades the existing SQL 2000 to SQL 2005
4. After the completion of the upgrade the existing SQL 2000 will be
upgraded to SQL 2005 with the same server name
5. After this there will not be any connecting string chnages
The only this incase of issues; you may need to install SQL 2000 and restore
all the databases backed up...
Take a look into:-
http://www.microsoft.com/technet/prodtechnol/sql/2005/sqlupgrd.mspx
Thanks
Hari
"RT" <RT@.discussions.microsoft.com> wrote in message
news:2BD744AB-1A64-4F49-8FE5-9A388A52B72D@.microsoft.com...
> We are looking to install SQL 2005 Standard next to a SQL 2000 Enterprise
> installation. The SQL 2K install is running under the default instance and
> therefore to install the SQL 2005 we will need to run it under a named
> instance. After the SQL 2005 has been configured and we are confident the
> DB
> is how we want it we want to uninstall the SQL 2K and make the SQL 2005
> the
> default instance. Can anyone describe the steps need to do this. We want
> to
> avoid having to re-write a lot of connetion strings in client applications
> which would require is to re-deploy those apps.
> Thanks in advance.
> RT|||Sorry to use an existing post but when I try to start a new thread, nothing
happends.
I just reinstalled SQL Server 2000. During the install. I used the default
Server name of GATEWAY_COMPUTE. Now when I try to start SQL Server, the
Server name comes up as GATEWAY_COMPUTE, services is SQL Server. When I
click start I receive error message ' The service did not start due to a
login failure'.
Can someone tell me how to correct this?
Subscribe to:
Posts (Atom)