Hi Tracy!
>From the dba's point of view: ideally that is true, unless the firewall is configured to block it!
>From the Security Mgr's point of view: no way, the firewall will block it!
Well, depending on the installation of course, they could allow access from a specific IP address. That IP address could be that of a consultant/DBA doing maintenance on the server. You can also change the port that SQL Server listens to and of course, make sure the sa password is something like *@&hsdjs&@Jska7263&@hskj@Knsj23820sjsjWJ@(SJ@)&!^!&@jdsld9lfot)(**038482jkjdhru&@^(#kjwhwlql298473KSJS28472hdmne,clkwe839((9298282L4&@
< g >
Jim Duffy
Microsoft MVP
INETA Speaker
TakeNote TechnologiesDeveloper's Choice Award Winner for Best Training Company
Specializing in VB.NET, ASP.NET, VFP, and SQL Server Training and Development