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

[Jon M. <jo...@te...>]

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