how can I change SQL 2005 Licence key

we have a server installed SQL 2005 with Microsoft Action Pack Product Key,
because we had to install a application program before we got the Licence.
Now we got the Licence and Product Key for this server. Their are two
questions I am wondered.
One is I couldn't find the licence infromation in SQL menues. Where can I
find the Licence information in SQL?
The other is How can I swap the Licence Key in this situation.Do you really need to change SQL2005 license key?
I have never found any need to fiddle with the SQL2005 license key. It's
hard coded in the install media--well, I'm not sure whether that's always th
e
case, but it's always the case where I have dealt with SQL2005.
Linchi
"snailsnail" wrote:

> we have a server installed SQL 2005 with Microsoft Action Pack Product Key
,
> because we had to install a application program before we got the Licence.
> Now we got the Licence and Product Key for this server. Their are two
> questions I am wondered.
> One is I couldn't find the licence infromation in SQL menues. Where can I
> find the Licence information in SQL?
> The other is How can I swap the Licence Key in this situation.
>

how can I change SQL 2005 Licence key

we have a server installed SQL 2005 with Microsoft Action Pack Product Key,
because we had to install a application program before we got the Licence.
Now we got the Licence and Product Key for this server. Their are two
questions I am wondered.
One is I couldn't find the licence infromation in SQL menues. Where can I
find the Licence information in SQL?
The other is How can I swap the Licence Key in this situation.
Do you really need to change SQL2005 license key?
I have never found any need to fiddle with the SQL2005 license key. It's
hard coded in the install media--well, I'm not sure whether that's always the
case, but it's always the case where I have dealt with SQL2005.
Linchi
"snailsnail" wrote:

> we have a server installed SQL 2005 with Microsoft Action Pack Product Key,
> because we had to install a application program before we got the Licence.
> Now we got the Licence and Product Key for this server. Their are two
> questions I am wondered.
> One is I couldn't find the licence infromation in SQL menues. Where can I
> find the Licence information in SQL?
> The other is How can I swap the Licence Key in this situation.
>

how can I change SQL 2005 Licence key

we have a server installed SQL 2005 with Microsoft Action Pack Product Key,
because we had to install a application program before we got the Licence.
Now we got the Licence and Product Key for this server. Their are two
questions I am wondered.
One is I couldn't find the licence infromation in SQL menues. Where can I
find the Licence information in SQL?
The other is How can I swap the Licence Key in this situation.Do you really need to change SQL2005 license key?
I have never found any need to fiddle with the SQL2005 license key. It's
hard coded in the install media--well, I'm not sure whether that's always the
case, but it's always the case where I have dealt with SQL2005.
Linchi
"snailsnail" wrote:
> we have a server installed SQL 2005 with Microsoft Action Pack Product Key,
> because we had to install a application program before we got the Licence.
> Now we got the Licence and Product Key for this server. Their are two
> questions I am wondered.
> One is I couldn't find the licence infromation in SQL menues. Where can I
> find the Licence information in SQL?
> The other is How can I swap the Licence Key in this situation.
>sql

How can i change security mode of SQL Server Express 2005

Hello,
I have created one application in visual studio 2005 and also created setup project of that application. now i want to install SQL Server Express edition with my application. so i have checked SQL Server Express 2005 in Setup Project Properities(Prerequisites...). now i want to change SQL Secirty Mode during setup. and i don't know how can we do this?

Any idia?

Thread moved to the appropriate forum|||

hi,

SQLExpress setup boostrapper accept "parameters" to define the "final" settings of the installed instance at install time..

the parameter you are looking for is SECURITYMODE=SQL to enable standard SQL Server authenticated connections..

please have a look at http://msdn2.microsoft.com/en-us/library/ms144259.aspx for all supported parameters..

regards

|||

Thank for sujession, but still it is not work.
i have entered following line for change SQL Server Security Mode Windows Auth. To SQL Auth.

Start /wait setup.exe /qb INSTANCENAME=SQLEXPRESS SECURITYMODE=SQL SAPWD=pwd12345

i have also tried this :

Start /wait setup.exe /qb UPGRADE=Client_Components INSTANCENAME=SQLEXPRESS SECURITYMODE=SQL SAPWD=pwd12345

but still it is not work. i got the same error when i run my program "Login fail for user sa. The user is not associated with a trusted SQL Server connection.

|||

hi,

the exception is correctly related to not enabled SQL Server authenticated connections..

but the SECURITYMODE=SQL parameter is there for the case, and it "must" work as expected, as it really does since MSDE 2000 installer...

please pardon me, but are you sure you are later connecting to the correct SQLExpress instance?

regards

|||

Yes i connecting to correct SQLExpress instance.

but don't warry, it's solve now bcoz i directly change parameter in package.xml(Program Files\Microsoft Visual Studio 8\SDK\v2.0\BootStrapper\Packages\SqlExpress\en) file.

How can i change security mode of SQL Server Express 2005

Hello,
I have created one application in visual studio 2005 and also created setup project of that application. now i want to install SQL Server Express edition with my application. so i have checked SQL Server Express 2005 in Setup Project Properities(Prerequisites...). now i want to change SQL Secirty Mode during setup. and i don't know how can we do this?

Any idia?

Thread moved to the appropriate forum|||

hi,

SQLExpress setup boostrapper accept "parameters" to define the "final" settings of the installed instance at install time..

the parameter you are looking for is SECURITYMODE=SQL to enable standard SQL Server authenticated connections..

please have a look at http://msdn2.microsoft.com/en-us/library/ms144259.aspx for all supported parameters..

regards

|||

Thank for sujession, but still it is not work.
i have entered following line for change SQL Server Security Mode Windows Auth. To SQL Auth.

Start /wait setup.exe /qb INSTANCENAME=SQLEXPRESS SECURITYMODE=SQL SAPWD=pwd12345

i have also tried this :

Start /wait setup.exe /qb UPGRADE=Client_Components INSTANCENAME=SQLEXPRESS SECURITYMODE=SQL SAPWD=pwd12345

but still it is not work. i got the same error when i run my program "Login fail for user sa. The user is not associated with a trusted SQL Server connection.

|||

hi,

the exception is correctly related to not enabled SQL Server authenticated connections..

but the SECURITYMODE=SQL parameter is there for the case, and it "must" work as expected, as it really does since MSDE 2000 installer...

please pardon me, but are you sure you are later connecting to the correct SQLExpress instance?

regards

|||

Yes i connecting to correct SQLExpress instance.

but don't warry, it's solve now bcoz i directly change parameter in package.xml(Program Files\Microsoft Visual Studio 8\SDK\v2.0\BootStrapper\Packages\SqlExpress\en) file.

How and what to install

Hi,

My hosting cie sugested I upgrade from Access to SQL wich I did.

I downloaded the fullest version (trial) of SQL I could find, not knowing what I realy needed.

The Trial has now expired and when I try to install the "Microsoft SQL Server 2005 Express Edition with Advanced Services " it sais that I need to uninstall some stuff (the error message is trunckated).

My use for this is to connect to and manage my live database. And to have a local copy of this database on my devellopement and testing machine that I can play around with.

Since i've install this "big version", I find that i'm only using the "sql management studio".

But when I go "add or remove prgms", it says I use everything "Frequently"!
So I do not want to uninstall something that I realy am using "frequently"...

Here is what I have in that list:

SQL server 2005
SQL server 2005 backward compatibitity
SQL server 2005 books online
SQL server Native client
SQL server setup support files
SQL server VSS writer
Visual Studio 2005 premier partner edition -ENU

This takes up 1121.62 MB !

I do not see in this list the sql management studio...?

What do I need to uninstall to be able to install "Microsoft SQL Server 2005 Express Edition with Advanced Services "?

What else should I uninstall because I just would not need ?

When I do uninstall whatever I need to uninstall, and install this express version, will it remember my conections? Find my local database? Basicly, will it screw up anything?!?

Thank you for your help!

Dominique

You can install express as a named instance, which would mean you don't need to install the other version. However, if the other version has expired, then you should uninstall all of it, it's all supporting SQL Server, and you say that doesn't work anymore anyhow.

how 2 install client tools for SQl Server

In Server Explorer of VS .NET 2003, I tried to generate SQL script of the dbo.Portal (ibs)
but got
"To use this feature, you must install the client tols for SQL Server"

When I searched for Help, I've got
"1.Insert the MS SQL Server 2000 compact disc in your CD-ROM drive"

I installed and use MSDE and cannot recall the use of any CD for installation.

1)
Does it mean that I cannot install client tools from MSDE installation?

If not...

2)
I have installation of MS SQL Server200 Enterprise that cannot be installed on Windows Xp Professional that I use. Can I still install "client tools" from Enterprise Ed. for MSDEMSDE !== SQL Server

1. you get the client tools with SQL Server, not with MSDE, which is just the data engine.
2. you should be fine to install the SQL Ent client tools on XP - but it won't let you install the server.|||Thanx, Atrax,
I aslo found in
http://www.microsoft.com/sql/msde/howtobuy/msdeuse.asp

You can only use SQL Server tools and services in conjunction with MSDE if you acquired MSDE through SQL Server 2000 (Developer Edition, Standard Edition, or Enterprise Edition), and if you are using MSDE in conjunction with a properly licensed copy of SQL Server 2000.

I am now in doubt where from I have installed MSDE, since I vaguely recall that I have MSDE installables in various places:
- free downloads
- various editions of SQL Server from CDs,
- MS Office and VS .NET installations
I remember I reinstalled them in various combinations on various PCs.

How can I determine whether MSDE is from Developer, Standard or Enterprise Ed.s or from free download?
Or it is not important?

Hot-standby SQL Server Using Alias Name?

I want to have a hot standby SQL server for my clients. My idea is to install
SQL on two separate machines, SRVA and SRVB, and configure continuous merge
replication between them. Client machines would connect to an alias name,
SRVC, with DNS for SRVC resolving to the IP address of SRVA. Upon failure, DNS
would be changed to point to SRVB. Could something like this work? If so, how
would one start to implement it?
Maybe a shorther question would be, is it possible for clients to connect to a
SQL server alias name (not a named instance) instead of the actual machine
name of the server?
--Eric RobinsonThis is a multi-part message in MIME format.
--=_NextPart_000_0370_01C3A9EA.14018070
Content-Type: text/plain;
charset="Windows-1252"
Content-Transfer-Encoding: 7bit
Consider using a clustered installation of SQL Server. It has automatic
failover and requires no human intervention.
--
Tom
---
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinnaclepublishing.com/sql
"Eric Robinson" <eric@._nospam_nvipa.com> wrote in message
news:CFN379384331352315@.news.microsoft.com...
I want to have a hot standby SQL server for my clients. My idea is to
install
SQL on two separate machines, SRVA and SRVB, and configure continuous merge
replication between them. Client machines would connect to an alias name,
SRVC, with DNS for SRVC resolving to the IP address of SRVA. Upon failure,
DNS
would be changed to point to SRVB. Could something like this work? If so,
how
would one start to implement it?
Maybe a shorther question would be, is it possible for clients to connect to
a
SQL server alias name (not a named instance) instead of the actual machine
name of the server?
--Eric Robinson
--=_NextPart_000_0370_01C3A9EA.14018070
Content-Type: text/html;
charset="Windows-1252"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
&

---

Consider using a clustered =installation of SQL Server. It has automatic failover and requires no human intervention.
-- Tom
---T=homas A. Moreau, BSc, PhD, MCSE, MCDBASQL Server MVPColumnist, SQL =Server ProfessionalToronto, ON Canadahttp://www.pinnaclepublishing.com/sql">www.pinnaclepublishing.com=/sql
"Eric Robinson" =wrote in message news:CFN3793843313523=15@.news.microsoft.com...I want to have a hot standby SQL server for my clients. My idea is to =install SQL on two separate machines, SRVA and SRVB, and configure =continuous merge replication between them. Client machines would connect to an alias =name, SRVC, with DNS for SRVC resolving to the IP address of SRVA. Upon =failure, DNS would be changed to point to SRVB. Could something like this =work? If so, how would one start to implement it?Maybe a shorther =question would be, is it possible for clients to connect to a SQL server =alias name (not a named instance) instead of the actual machine name of the server?--Eric Robinson

---

--=_NextPart_000_0370_01C3A9EA.14018070--

Hotfix 2153 will not install

I am trying to install sql2005-kb918222-x86-enu.exe, first one in the x86 family. I am getting "This machine does not have a product that matches this installation package".

I have SP1 is installed. Version and patch level are 9.1.2047. on

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.1\Setup

Any help is appreciated

Please use Setup forum to get help with any installation errors:
http://forums.microsoft.com/MSDN/ShowForum.aspx?ForumID=95&SiteID=1

Hot Standby Server w/out Clustering?

I want to have a hot standby SQL server for my clients without clustering. My
idea is to install SQL on two separate machines, SRVA and SRVB, and configure
continuous merge replication between them. Client machines would connect to an
alias name, SRVC, with DNS for SRVC resolving to the IP address of SRVA. Upon
failure, DNS would be changed to point to SRVB. Could something like this
work?
Maybe a shorther question would be, is it possible for clients to connect to a
SQL server alias name (not a named instance) instead of the actual machine
name of the server?
--Eric RobinsonWhat it sounds like you need is log shipping, not merge
replication. Replication is not the best of solutions for
a standby solution, and if you use replication for some
form of availability, it's usually transactional.
Replication is good if you have some specific data to make
available, but you're limited by rowsize and such, but as
for a complete copy of your DB, replication is not the
way. Log shipping is the standard SQL method of making a
warm standby.
You can set up NLB to do what you want to alias things,
and this is all covered in the book SQL Server 2000 HIgh
Availability on how to set it up using it as a "switch"
mechanism - not load balanced - for SQL Server. There are
even configuration instructions on the CD-ROM.
>--Original Message--
>I want to have a hot standby SQL server for my clients
without clustering. My
>idea is to install SQL on two separate machines, SRVA and
SRVB, and configure
>continuous merge replication between them. Client
machines would connect to an
>alias name, SRVC, with DNS for SRVC resolving to the IP
address of SRVA. Upon
>failure, DNS would be changed to point to SRVB. Could
something like this
>work?
>Maybe a shorther question would be, is it possible for
clients to connect to a
>SQL server alias name (not a named instance) instead of
the actual machine
>name of the server?
>--Eric Robinson
>.
>|||To have standby , it is better to use Log shipping. U can
even write scripts to take backup and mover to otherserver
and restore ,
Replication is only for data propagation not for Standby.
In case of Replication schema changes won't be applied. Of
course Merge is not useful u need Transactioal replication.
>--Original Message--
>I want to have a hot standby SQL server for my clients
without clustering. My
>idea is to install SQL on two separate machines, SRVA and
SRVB, and configure
>continuous merge replication between them. Client
machines would connect to an
>alias name, SRVC, with DNS for SRVC resolving to the IP
address of SRVA. Upon
>failure, DNS would be changed to point to SRVB. Could
something like this
>work?
>Maybe a shorther question would be, is it possible for
clients to connect to a
>SQL server alias name (not a named instance) instead of
the actual machine
>name of the server?
>--Eric Robinson
>.
>

Hot Fix 821334

Hi All,
I tryed installing Reporting Services for sql 2000 and wanted to use the
service account for install. During process I was told
that I needed to install hot fix 821334. Ok first off where can I find this
fix? Also I read that this fix causes Enterprise Manager not to function, is
this correct?
Thanks,
JJYou can find the fix on MS website.
Do a search for it via the fix number... its around 11MB. If you cant find
it, i can send it to you.
It wont break EM. Well atleast not on my 3 servers that I have installed the
fix on to :)
Immy
"JJ" <jjmraz@.-NOspAM*hotmail.com> wrote in message
news:uOMaKlSDFHA.1836@.tk2msftngp13.phx.gbl...
> Hi All,
> I tryed installing Reporting Services for sql 2000 and wanted to use the
> service account for install. During process I was told
> that I needed to install hot fix 821334. Ok first off where can I find
> this
> fix? Also I read that this fix causes Enterprise Manager not to function,
> is
> this correct?
> Thanks,
> JJ
>|||Thanks Immy
JJ
"Imtiaz Ullah" <imtiaz_ullah@.hotmail.com> wrote in message
news:uIOzXOTDFHA.2876@.TK2MSFTNGP12.phx.gbl...
> You can find the fix on MS website.
> Do a search for it via the fix number... its around 11MB. If you cant find
> it, i can send it to you.
> It wont break EM. Well atleast not on my 3 servers that I have installed
the
> fix on to :)
> Immy
> "JJ" <jjmraz@.-NOspAM*hotmail.com> wrote in message
> news:uOMaKlSDFHA.1836@.tk2msftngp13.phx.gbl...
> > Hi All,
> >
> > I tryed installing Reporting Services for sql 2000 and wanted to use
the
> > service account for install. During process I was told
> > that I needed to install hot fix 821334. Ok first off where can I find
> > this
> > fix? Also I read that this fix causes Enterprise Manager not to
function,
> > is
> > this correct?
> >
> > Thanks,
> >
> > JJ
> >
> >
>|||Hi Immy,
Could you please send it to me. Send to jjmraz@.hotmail.com
Thanks,
JJ
"Imtiaz Ullah" <imtiaz_ullah@.hotmail.com> wrote in message
news:uIOzXOTDFHA.2876@.TK2MSFTNGP12.phx.gbl...
> You can find the fix on MS website.
> Do a search for it via the fix number... its around 11MB. If you cant find
> it, i can send it to you.
> It wont break EM. Well atleast not on my 3 servers that I have installed
the
> fix on to :)
> Immy
> "JJ" <jjmraz@.-NOspAM*hotmail.com> wrote in message
> news:uOMaKlSDFHA.1836@.tk2msftngp13.phx.gbl...
> > Hi All,
> >
> > I tryed installing Reporting Services for sql 2000 and wanted to use
the
> > service account for install. During process I was told
> > that I needed to install hot fix 821334. Ok first off where can I find
> > this
> > fix? Also I read that this fix causes Enterprise Manager not to
function,
> > is
> > this correct?
> >
> > Thanks,
> >
> > JJ
> >
> >
>|||I am also looking for this download. Where can I find it.
Thanks
"JJ" wrote:
> Hi Immy,
> Could you please send it to me. Send to jjmraz@.hotmail.com
>
> Thanks,
> JJ
> "Imtiaz Ullah" <imtiaz_ullah@.hotmail.com> wrote in message
> news:uIOzXOTDFHA.2876@.TK2MSFTNGP12.phx.gbl...
> > You can find the fix on MS website.
> > Do a search for it via the fix number... its around 11MB. If you cant find
> > it, i can send it to you.
> >
> > It wont break EM. Well atleast not on my 3 servers that I have installed
> the
> > fix on to :)
> >
> > Immy
> > "JJ" <jjmraz@.-NOspAM*hotmail.com> wrote in message
> > news:uOMaKlSDFHA.1836@.tk2msftngp13.phx.gbl...
> > > Hi All,
> > >
> > > I tryed installing Reporting Services for sql 2000 and wanted to use
> the
> > > service account for install. During process I was told
> > > that I needed to install hot fix 821334. Ok first off where can I find
> > > this
> > > fix? Also I read that this fix causes Enterprise Manager not to
> function,
> > > is
> > > this correct?
> > >
> > > Thanks,
> > >
> > > JJ
> > >
> > >
> >
> >
>
>|||Hi JJ,
The file is 17MB in size! Hotmail wont let you send or recieve more than
10Mb.
Do you haven FTP location or some storage space online that I can copy it
too?
Regards
Immy
"JJ" <jjmraz@.-NOspAM*hotmail.com> wrote in message
news:%23QzWOjUDFHA.3368@.TK2MSFTNGP10.phx.gbl...
> Hi Immy,
> Could you please send it to me. Send to jjmraz@.hotmail.com
>
> Thanks,
> JJ
> "Imtiaz Ullah" <imtiaz_ullah@.hotmail.com> wrote in message
> news:uIOzXOTDFHA.2876@.TK2MSFTNGP12.phx.gbl...
>> You can find the fix on MS website.
>> Do a search for it via the fix number... its around 11MB. If you cant
>> find
>> it, i can send it to you.
>> It wont break EM. Well atleast not on my 3 servers that I have installed
> the
>> fix on to :)
>> Immy
>> "JJ" <jjmraz@.-NOspAM*hotmail.com> wrote in message
>> news:uOMaKlSDFHA.1836@.tk2msftngp13.phx.gbl...
>> > Hi All,
>> >
>> > I tryed installing Reporting Services for sql 2000 and wanted to use
> the
>> > service account for install. During process I was told
>> > that I needed to install hot fix 821334. Ok first off where can I find
>> > this
>> > fix? Also I read that this fix causes Enterprise Manager not to
> function,
>> > is
>> > this correct?
>> >
>> > Thanks,
>> >
>> > JJ
>> >
>> >
>>
>|||Can you send me a copy to dmongeb@.gmail.com. Thank|||Can you send a copy to lctan@.isatechnologies.co
Really urgent for my customer...