RE: [Bodington-developers] Bodington and SQL Server 2005

[Andrew B. <a.g...@le...>]

Yup.  It's only accepting connections on localhost.
Bad enough that the web server's IIS 6.0. 
Don Akrigg's having kittens. (For those outside Leeds, Don's our IT support
chap). 

Aggie

-----Original Message-----
From: bod...@li...
[mailto:bod...@li...] On Behalf Of Jon
Maber
Sent: 24 May 2006 17:58
To: bod...@li...
Subject: Re: [Bodington-developers] Bodington and SQL Server 2005

Peter Crowther wrote:
>> From: Andrew Booth
>> In which case you probably need to put 2005 into 2000-compatible mode.
>>     
>
> Apparently not.  In order to *connect*, merely ensure the TCP/IP
> protocol is enabled on the server (from computer management  ==>
> services and applciation ==> sql server 2005 configuration ==> network
> configuration) and live on port 1433.  God only knows about security.  I
> might have a hack at it here in a few days, when I have a SQL Server
> 2005 live on our network.
>   
Historically the TCP/IP protocol in SQL Server has been vulnerable to 
hacks but even if this vulnerability has been closed its a good idea to 
block access from all network devices but localhost. If you have some 
reason to connect to the database via that protocol using another 
computer then some kind of software or hardware firewall setup would be 
essential.

Jon



-------------------------------------------------------
All the advantages of Linux Managed Hosting--Without the Cost and Risk!
Fully trained technicians. The highest number of Red Hat certifications in
the hosting industry. Fanatical Support. Click to learn more
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=107521&bid=248729&dat=121642
_______________________________________________
Bodington-developers mailing list
Bod...@li...
https://lists.sourceforge.net/lists/listinfo/bodington-developers