named instances and sp3a - how to enable access?

As I understand it, the slammer virus took advantage of port 1434 which is e
nabled over udp for sql clients to find out the ports named instances are us
ing. If applying sp3a disables listening on port 1434, can named instances s
till be used? Do the ports
need to be known and hardcoded in advance?
TIA,
John BrownIn the Server network Utiliy simply choose a fixed port number, and the
clients would have to know the fixed port number to connect.
Or you could still use Dynamic ports, (the check box) and enable port 1434,
and the end user does NOT have to know the port number...
Wayne Snyder, MCDBA, SQL Server MVP
Computer Education Services Corporation (CESC), Charlotte, NC
www.computeredservices.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"John Brown" <anonymous@.discussions.microsoft.com> wrote in message
news:F9DBE64E-3137-41B3-91D1-ECDFC0086B08@.microsoft.com...
> As I understand it, the slammer virus took advantage of port 1434 which is
enabled over udp for sql clients to find out the ports named instances are
using. If applying sp3a disables listening on port 1434, can named instances
still be used? Do the ports need to be known and hardcoded in advance?
> TIA,
> John Brown|||Thanks Wayne,
so if I enable 1434, does this open me up to the slammer virus still?
TIA,
John Brown|||SP3a fixes the exploit in the SQL Server Resolution Service used by Slammer,
it does not stop the server listening on UDP1434 as this is required for
resolving endpoints for named instances unless every client has the port
hard coded into a connection string or an alias in the client network
utlity. As long as you have SP3a applied you'll be okay but make sure that
port is still blocked on external firewalls.
HTH
Jasper Smith (SQL Server MVP)
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"John Brown" <anonymous@.discussions.microsoft.com> wrote in message
news:F5708C23-286E-49B6-88BC-4CD6C5F1C768@.microsoft.com...
> Thanks Wayne,
> so if I enable 1434, does this open me up to the slammer virus still?
> TIA,
> John Brown

named instances and sp3a - how to enable access?

As I understand it, the slammer virus took advantage of port 1434 which is enabled over udp for sql clients to find out the ports named instances are using. If applying sp3a disables listening on port 1434, can named instances still be used? Do the ports need to be known and hardcoded in advance
TIA
John BrownIn the Server network Utiliy simply choose a fixed port number, and the
clients would have to know the fixed port number to connect.
Or you could still use Dynamic ports, (the check box) and enable port 1434,
and the end user does NOT have to know the port number...
--
Wayne Snyder, MCDBA, SQL Server MVP
Computer Education Services Corporation (CESC), Charlotte, NC
www.computeredservices.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"John Brown" <anonymous@.discussions.microsoft.com> wrote in message
news:F9DBE64E-3137-41B3-91D1-ECDFC0086B08@.microsoft.com...
> As I understand it, the slammer virus took advantage of port 1434 which is
enabled over udp for sql clients to find out the ports named instances are
using. If applying sp3a disables listening on port 1434, can named instances
still be used? Do the ports need to be known and hardcoded in advance?
> TIA,
> John Brown|||SP3a fixes the exploit in the SQL Server Resolution Service used by Slammer,
it does not stop the server listening on UDP1434 as this is required for
resolving endpoints for named instances unless every client has the port
hard coded into a connection string or an alias in the client network
utlity. As long as you have SP3a applied you'll be okay but make sure that
port is still blocked on external firewalls.
--
HTH
Jasper Smith (SQL Server MVP)
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"John Brown" <anonymous@.discussions.microsoft.com> wrote in message
news:F5708C23-286E-49B6-88BC-4CD6C5F1C768@.microsoft.com...
> Thanks Wayne,
> so if I enable 1434, does this open me up to the slammer virus still?
> TIA,
> John Brown

My Sql Instance is gone

Heeelllpp,
My Sql instance is gone from the SQL server manager. I think the problem came up after I installed Mc Afee Virus scan and updated microsoft patches (due to the problems that we have with worms recently).
After that I can't even invoke the service at all. I tried to restart everything (uninstalled the server and reinstall it again) but since the server couldn't be connected, the install process got terminated.
Can somebody help me with this?
thx
gue,
Please supply OS and SQL Server versions.
Is there SQL Server service still there in the Services applet in control
panel? Look for MSSQLServer. Installing McAfee should not remove SQL Server,
however there is the potential for virus scanners to cause problems
occasionally - but this is normally down to configuration issues, not with
the virus scanner per se.
When you say you "uninstalled the server" - what exactly do you mean? Did
you rebuild the OS, or just reinstall SQL Server? Also, what do you mean by
"the server couldn't be connected"?
It would also be very helpful if you could supply the EXACT error messages
you are getting.
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
"gue" <anonymous@.discussions.microsoft.com> wrote in message
news:96CF2A1A-923F-4A52-9A38-927FCFC13D28@.microsoft.com...
> Heeelllpp,
> My Sql instance is gone from the SQL server manager. I think the problem
came up after I installed Mc Afee Virus scan and updated microsoft patches
(due to the problems that we have with worms recently).
> After that I can't even invoke the service at all. I tried to restart
everything (uninstalled the server and reinstall it again) but since the
server couldn't be connected, the install process got terminated.
> Can somebody help me with this?
> thx

My Sql Instance is gone

Heeelllpp
My Sql instance is gone from the SQL server manager. I think the problem came up after I installed Mc Afee Virus scan and updated microsoft patches (due to the problems that we have with worms recently)
After that I can't even invoke the service at all. I tried to restart everything (uninstalled the server and reinstall it again) but since the server couldn't be connected, the install process got terminated
Can somebody help me with this
thxgue,
Please supply OS and SQL Server versions.
Is there SQL Server service still there in the Services applet in control
panel? Look for MSSQLServer. Installing McAfee should not remove SQL Server,
however there is the potential for virus scanners to cause problems
occasionally - but this is normally down to configuration issues, not with
the virus scanner per se.
When you say you "uninstalled the server" - what exactly do you mean? Did
you rebuild the OS, or just reinstall SQL Server? Also, what do you mean by
"the server couldn't be connected"?
It would also be very helpful if you could supply the EXACT error messages
you are getting.
--
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
"gue" <anonymous@.discussions.microsoft.com> wrote in message
news:96CF2A1A-923F-4A52-9A38-927FCFC13D28@.microsoft.com...
> Heeelllpp,
> My Sql instance is gone from the SQL server manager. I think the problem
came up after I installed Mc Afee Virus scan and updated microsoft patches
(due to the problems that we have with worms recently).
> After that I can't even invoke the service at all. I tried to restart
everything (uninstalled the server and reinstall it again) but since the
server couldn't be connected, the install process got terminated.
> Can somebody help me with this?
> thx

My Sql Instance is gone

Heeelllpp,
My Sql instance is gone from the SQL server manager. I think the problem cam
e up after I installed Mc Afee Virus scan and updated microsoft patches (due
to the problems that we have with worms recently).
After that I can't even invoke the service at all. I tried to restart everyt
hing (uninstalled the server and reinstall it again) but since the server co
uldn't be connected, the install process got terminated.
Can somebody help me with this?
thxgue,
Please supply OS and SQL Server versions.
Is there SQL Server service still there in the Services applet in control
panel? Look for MSSQLServer. Installing McAfee should not remove SQL Server,
however there is the potential for virus scanners to cause problems
occasionally - but this is normally down to configuration issues, not with
the virus scanner per se.
When you say you "uninstalled the server" - what exactly do you mean? Did
you rebuild the OS, or just reinstall SQL Server? Also, what do you mean by
"the server couldn't be connected"?
It would also be very helpful if you could supply the EXACT error messages
you are getting.
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
"gue" <anonymous@.discussions.microsoft.com> wrote in message
news:96CF2A1A-923F-4A52-9A38-927FCFC13D28@.microsoft.com...
> Heeelllpp,
> My Sql instance is gone from the SQL server manager. I think the problem
came up after I installed Mc Afee Virus scan and updated microsoft patches
(due to the problems that we have with worms recently).
> After that I can't even invoke the service at all. I tried to restart
everything (uninstalled the server and reinstall it again) but since the
server couldn't be connected, the install process got terminated.
> Can somebody help me with this?
> thx