KB954606 security update failed

On Dec 22, 6:03 pm, Erland Sommarskog wrote:
> inungh ( ) writes:
> > I have SQL server 2005 express verions install and get KB954606
> > security update failed since Sep/2008.
>
> > What should I do for this?
> > Does it mean that my computer has virus or contorled by someone to
> > stop me do the update?
> > Should I uninstall SQL server 2005 express and reinstalled?
>
> > Your information is great appreciated,
>
> You should get SP3 of SQL 2005, released last week. It has the
> security fixes included:
>
> http://www.microsoft.com/downloads/details.aspx?FamilyID=3181842a-409....
>
> --
> Erland Sommarskog, SQL Server MVP, esq....RemoveThis@sommarskog.se
>
> Links for SQL Server Books Online:
> SQL 2008:http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
> SQL 2005:http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
> SQL 2000:http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

I use Windows XP 2005 Media center version and download SQL server
2008 express light version to learn develop web site.

Since September, I got Windows udpate promt all the time and went to
MS Update website which give the KB954606 failed update for SQL server
issue.

I did update SP 3 you mentioned, but I still get same prompt.
I just wonder do I need uninstall SQL server and reinstall it.
I tried to avoid that because it will takes a lot of time to do it.

Thanks again for helping,
 >> Stay informed about: KB954606 security update failed 

inungh ( ) writes:
> I did update SP 3 you mentioned, but I still get same prompt.
> I just wonder do I need uninstall SQL server and reinstall it.
> I tried to avoid that because it will takes a lot of time to do it.

Why not just decline the update? You definitely do not want to need it
now.


--
Erland Sommarskog, SQL Server MVP, esquel RemoveThis @sommarskog.se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
 >> Stay informed about: KB954606 security update failed 

"Erland Sommarskog" wrote:

> inungh ( ) writes:
> > I did update SP 3 you mentioned, but I still get same prompt.
> > I just wonder do I need uninstall SQL server and reinstall it.
> > I tried to avoid that because it will takes a lot of time to do it.
>
> Why not just decline the update? You definitely do not want to need it
> now.
>
>
> --
> Erland Sommarskog, SQL Server MVP, esquel.RemoveThis@sommarskog.se
>
> Links for SQL Server Books Online:
> SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
> SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
> SQL 2000: http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
>
>
 >> Stay informed about: KB954606 security update failed 

"Erland Sommarskog" wrote:

> inungh ( ) writes:
> > I did update SP 3 you mentioned, but I still get same prompt.
> > I just wonder do I need uninstall SQL server and reinstall it.
> > I tried to avoid that because it will takes a lot of time to do it.
>
> Why not just decline the update? You definitely do not want to need it
> now.
>
>
> --
> Erland Sommarskog, SQL Server MVP, esquel.DeleteThis@sommarskog.se
>
> Links for SQL Server Books Online:
> SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
> SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
> SQL 2000: http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
>
> I have the same problem and cannot install, denie, or remove KB954606. Will it harm my computer if I just remove SQL Server 2005? I don't even know how I got it on my computer. What service does it provide?
 >> Stay informed about: KB954606 security update failed 

tw9 (tw9@discussions.microsoft.com) writes:
> I have the same problem and cannot install, denie, or remove KB954606.
> Will it harm my computer if I just remove SQL Server 2005? I don't even
> know how I got it on my computer. What service does it provide?

If you have SQL 2005 on your machine, and you are not aware of that you
installed it yourself, it is likely that it was installed as part of
some third-party program. Which of course will stop working if you uninstall
SQL 2005.

Which operating system are you using?


--
Erland Sommarskog, SQL Server MVP, esquel RemoveThis @sommarskog.se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
 >> Stay informed about: KB954606 security update failed 

My OS is windows xp pro. Could I have gotten this through ACT software which
I no longer use. I only use the Outlook Business Contact now.

"Erland Sommarskog" wrote:

> tw9 (tw9@discussions.microsoft.com) writes:
> > I have the same problem and cannot install, denie, or remove KB954606.
> > Will it harm my computer if I just remove SQL Server 2005? I don't even
> > know how I got it on my computer. What service does it provide?
>
> If you have SQL 2005 on your machine, and you are not aware of that you
> installed it yourself, it is likely that it was installed as part of
> some third-party program. Which of course will stop working if you uninstall
> SQL 2005.
>
> Which operating system are you using?
>
>
> --
> Erland Sommarskog, SQL Server MVP, esquel.TakeThisOut@sommarskog.se
>
> Links for SQL Server Books Online:
> SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
> SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
> SQL 2000: http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
>
>
 >> Stay informed about: KB954606 security update failed 

tw9 (tw9@discussions.microsoft.com) writes:
> My OS is windows xp pro. Could I have gotten this through ACT software
> which I no longer use. I only use the Outlook Business Contact now.

If you are sure that there is no program using SQL Server on your machine,
there is all reason to uninstall it.

I would recommend that you do it in two steps. In the SQL Server program
group, find the SQL Server Configuration tool. Start this tool, and go to
Services. Stop all services, and then open each service and set the startup
type to Disabled. Leave it that way for a month or so. If no program
screams during that period, uninstall the lot.


--
Erland Sommarskog, SQL Server MVP, esquel RemoveThis @sommarskog.se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
 >> Stay informed about: KB954606 security update failed 

On Dec 31 2008, 6:38 pm, Erland Sommarskog
wrote:
> tw9 (t...@discussions.microsoft.com) writes:
> > My OS is windows xp pro.  Could I have gotten this through ACT software
> > which I no longer use.  I only use the Outlook Business Contact now.
>
> If you are sure that there is no program using SQL Server on your machine,
> there is all reason to uninstall it.
>
> I would recommend that you do it in two steps. In the SQL Server program
> group, find the SQL Server Configuration tool. Start this tool, and go to
> Services. Stop all services, and then open each service and set the startup
> type to Disabled. Leave it that way for a month or so. If no program
> screams during that period, uninstall the lot.
>
> --
> Erland Sommarskog, SQL Server MVP, esq....DeleteThis@sommarskog.se
>
> Links for SQL Server Books Online:
> SQL 2008:http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
> SQL 2005:http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
> SQL 2000:http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

Thanks for the message,

I got follwing when I tried to register ther SQL server 2005 express

Server Error in '/' Application.
--------------------------------------------------------------------------------

The resource cannot be found.
Description: HTTP 404. The resource you are looking for (or one of its
dependencies) could have been removed, had its name changed, or is
temporarily unavailable. Please review the following URL and make
sure that it is spelled correctly.

Requested URL: /ProductActivation/ProductActivation.aspx

Does it make sense to do so?

If I need uninstall SQL server, how can I backup my database?


Thanks again,
 >> Stay informed about: KB954606 security update failed 

inungh ( ) writes:
> I got follwing when I tried to register ther SQL server 2005 express
>
> Server Error in '/' Application.
> --------------------------------------------------------------------------
> ------
>
> The resource cannot be found.
> Description: HTTP 404. The resource you are looking for (or one of its
> dependencies) could have been removed, had its name changed, or is
> temporarily unavailable. Please review the following URL and make
> sure that it is spelled correctly.
>
> Requested URL: /ProductActivation/ProductActivation.aspx
>
> Does it make sense to do so?

That looks like an error from a broken website. Microsoft are good at
those. Broken web sites, that is.

> If I need uninstall SQL server, how can I backup my database?

Hm, I was under the impression that you believed that you did not need
SQL Server at all? Or are you a different person from the person I
replied to previously?

If you are a different person, I recommend that you start a new thread,
and tell us of your situation and what you need help with, or else the
recommendations may be flat our wrong.


--
Erland Sommarskog, SQL Server MVP, esquel.RemoveThis@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
 >> Stay informed about: KB954606 security update failed 

On Jan 12, 3:40 am, Erland Sommarskog wrote:
> inungh ( ) writes:
> > I got follwing when I tried to register ther SQL server 2005 express
>
> > Server Error in '/' Application.
> > --------------------------------------------------------------------------
> > ------
>
> > The resource cannot be found.
> > Description: HTTP 404. The resource you are looking for (or one of its
> > dependencies) could have been removed, had its name changed, or is
> > temporarily unavailable.  Please review the following URL and make
> > sure that it is spelled correctly.
>
> > Requested URL: /ProductActivation/ProductActivation.aspx
>
> > Does it make sense to do so?
>
> That looks like an error from a broken website. Microsoft are good at
> those. Broken web sites, that is.
>
> > If I need uninstall SQL server, how can I backup my database?
>
> Hm, I was under the impression that you believed that you did not need
> SQL Server at all? Or are you a different person from the person I
> replied to previously?
>
> If you are a different person, I recommend that you start a new thread,
> and tell us of your situation and what you need help with, or else the
> recommendations may be flat our wrong.
>
> --
> Erland Sommarskog, SQL Server MVP, esq....TakeThisOut@sommarskog.se
>
> Books Online for SQL Server 2005 athttp://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books...
> Books Online for SQL Server 2000 athttp://www.microsoft.com/sql/prodinfo/previousversions/books.mspx- Hide quoted text -
>
> - Show quoted text -

I mean that to backup my databases, but not SQL server.
Because I already has some databases created, I need backup them
before uninstall and re install SQL server.

Thanks millions again,
 >> Stay informed about: KB954606 security update failed 

inungh ( ) writes:
> I mean that to backup my databases, but not SQL server.
> Because I already has some databases created, I need backup them
> before uninstall and re install SQL server.

If you uninstall SQL Server and reinstall, you can reattach the databases,
as the database files are not removed. However, taking a backup of them as
well is a good idea.

To this end, open a DOS prompt and say

SQLCMD -S .\SQLEXPRESS

at the prompt say:

BACKUP DATABASE db TO DISK='C:\backup\db.bak'

When you have entered your commands, enter "go" on a single line to
send the commands to SQL Server.

To restore the databases do the same, but say

RESTORE DATABASE db FROM DISK='C:\backup\db.bak'


--
Erland Sommarskog, SQL Server MVP, esquel.TakeThisOut@sommarskog.se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
 >> Stay informed about: KB954606 security update failed 

On Jan 12, 5:55 pm, Erland Sommarskog wrote:
> inungh ( ) writes:
> > I mean that to backup my databases, but not SQL server.
> > Because I already has some databases created, I need backup them
> > before uninstall and re install SQL server.
>
> If you uninstall SQL Server and reinstall, you can reattach the databases,
> as the database files are not removed. However, taking a backup of them as
> well is a good idea.
>
> To this end, open a DOS prompt and say
>
>    SQLCMD -S .\SQLEXPRESS
>
> at the prompt say:
>
>   BACKUP DATABASE db TO DISK='C:\backup\db.bak'
>
> When you have entered your commands, enter "go" on a single line to
> send the commands to SQL Server.
>
> To restore the databases do the same, but say
>
>   RESTORE DATABASE db FROM DISK='C:\backup\db.bak'
>
> --
> Erland Sommarskog, SQL Server MVP, esq... RemoveThis @sommarskog.se
>
> Links for SQL Server Books Online:
> SQL 2008:http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
> SQL 2005:http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
> SQL 2000:http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

Thanks millions for the message,
Does SQL server 2005 have any user interface to do so from SQL server
management Studio express?


Thanks again,
 >> Stay informed about: KB954606 security update failed 

inungh ( ) writes:
> Thanks millions for the message,
> Does SQL server 2005 have any user interface to do so from SQL server
> management Studio express?


You can use the Query Editor. There are also specific GUI for BACKUP/
RESTORE. You find these by right-clicking the database in Object Explorer
and select Tasks. At least I think so. I never use them myself.


--
Erland Sommarskog, SQL Server MVP, esquel DeleteThis @sommarskog.se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
 >> Stay informed about: KB954606 security update failed