Simple SQL SP3 Question Slammer


    Sponsored Links


  • 1. Enterprise Edition would not install
    I tried to install SQL Server 2000 Enterprise Edition on my laptop which has WinXP professional. It said that this version was not able to install on my operating system and then I was only allowed to install the client tools --- not SQL Server. SQL Server 2000 Developer Edition installed fully without a problem. Does anyone know why I could not install the Enterprise Edition ? Thanks, Craig
  • 2. -N start parameter
    Does anyone have information on the SQL Server -N startup parameter?
  • 3. SQLAgentMail Profile Grey on console, not on wkstn
    I'm trying to configure SQLAgentMail on a new install, 2K3, and SQL2000 SP3 and Exchange with Outlook 2000SR1. Followed the KB instructions to the letter SQL mail properties sees the outlook profile, test ok. Sends mail OK. SQL mail 100% working. SQLagent mail does not - greyed out when running enterprise manager from the console. No options selectable for Mail profile in SQLAgent properties. They both start with the same domain account. From a workstation If I connect with Enterprise manager from my workstation I CAN see the profile in SQLagent properties window. Using the test button reports that the MAPI session started and stopped correctly. However if I then select an operator and send a test email I get: Error22022 The SQLServerAgent mail session is not running; check the mail profile and/or the SQLServerAgent service startup account in the SQLserverAgent Properties dialog In the SQL Server Agent/Properties/View Error Log I get: [355] The mail system failed to initialize; check that a mail client been installed Can anyone point me to the nest step? Does this (shows profile from wkstn/not from console) indicate I should reinstall enterprise manager at the console? or do I have a deeper issue
  • 4. SQL SP3a Desktop Engine Install
    Hi, Each time I try to install the above said item, I get a message that SA userID requires strong password. 1) I don't want to change my SA password from NULL. 2) I have only the SQL engine installed as part of Sharepoint 2003 so don't know how nor want to change it for fear that it might do willies to my Sharepoint. Please help! Thank you. Regards, Richard XXXX@XXXXX.COM

Re: Simple SQL SP3 Question Re: Slammer

Postby Dinesh.T.K » Wed, 17 Sep 2003 01:10:36 GMT


Yes.Refer the below Q&A from :

'Trustworthy Computing Security Update'

question: which systems are impacteD?
Microsoft SQL Server 2000, SP1, SP2, Developer, Evaluation, and Personal
Editions, and MSDE 2000.
SQL Server 2000, SP1, SP2, Developer, and Personal Editions require either a
patch or SP3.

SQL Server FAQ at

Re: Simple SQL SP3 Question Re: Slammer

Postby Jasper Smith » Wed, 17 Sep 2003 01:16:34 GMT

Yes, however there has been a post SP3 security hotfix that you may want to
apply. Have a look at  http://www.**--****.com/ 


Jasper Smith (SQL Server MVP)

I support PASS - the definitive, global
community for SQL Server professionals -

Pretty new to MSSQL DB administrator, if I install SP3 am
I then protected againest the slammer worm?

Similar Threads:

1.fixes for the Slammer (W32.Slammer) worm, SQL Server database

2.slammer and sp3

I have sp3a installed. Does this mean that if I use an instance, I have to assign the port myself in the client network utility, or does it still dynamically pick up the port and just block overflow-causing requests? Also, at what point is the port allocated - if I hardcode a port in the client network utility will I have to change it later on

3.Simple Set statement this is very simple question


I have:
Declare @ErrorHolder int
Declare @Rowcount

Set @ErrorHolder = @@Error

set @Rowcount = @@rowcount

Why do I get @Rowcount =1 here

if I comment out   'Set @ErrorHolder = @@Error'
then I get 0 ( zero )

What does     Set @ErrorHolder = @@Error  effect @@rowcount at all




4.Upgrade SQL 2005 SP3 Desktop Enginer to SQL 2005 Standard SP3

Can anybody tell if Microsoft supports inplace (using setup.exe)
upgrade of SQL 2005 SP3 Desktop Engine to SQL 2005 Standard SP3?
When they released SQL 2005 there was not support for that.  Do they
support it now?


5.SQL Server Infected by SQL Slammer Virus

My SQL 2000 server was infected by the SQL Slammer virus. 
I have installed service pack 3 and have also installed 
the Critical Updates Tool kit for SQL 2000. 

I also installed the MS Security Bulleting MS02-061, have 
followed all the steps microsoft sugest, but still can't 
remove the virus.

I have tried with the "BullGuard" and "Stinger 1.7" 
tools, also the FixSQLex from Symantec, but none of them 
have removed the virus.

Apperently the server was infected last July 8th. 

I don't know if this is a recent version from the virus.

Can anyone help me on this?


6. SQL Slammer SQL Check Package won't Run

7. SQL Server Infected by SQL Slammer Virus

8. SQL Server 2K SP3 - Collation Questions



Who is online

Users browsing this forum: No registered users and 62 guest