FIGURE 18.24
The SQL Server executable and browser in the list of firewall exceptions.Other Security Roadblocks ......................................................................................
Depending on what security software you have installed, you may have to deal with one or more
other security warnings when attempting to connect to SQL Server. On my system, when attempt-
ing to connect to SQL Server in my Windows XP partition I get a message (Figure 18.25) from the
Symantec Internet Worm Protection component of Norton Antivirus (even when connecting to
SQL Server on the same computer!), and I have to click OK to proceed with the connection.
If your front-end database needs to connect to SQL Server running on another computer on the
same network (a common scenario), this warning pops up on the server machine — this may be a
show-stopper, unless the client and server machines are side by side on your desktop. Otherwise,
you may not be able to rush over to the server computer in time to click OK on the security alert
before the connection attempt times out, and thus you won’t be able to connect to SQL Server on
the client machine.
Working with SQL Server Data 18