I'll expand a bit on what Jim said.

The way a SQL Server "advertises" its presence is with the SQL Server listener service. That's how you see it in your drop...

Create a user-defined database role within the database.

Grant that role SELECT rights against the tables you want to give access to.

Put the user in the user-defined database role.

Ok... SQLServerCentral.com has a wide range of compentency levels from novices to experts. It's intended to be a friendly place where people can ask questions without negative comments. Therefore, if...

If you have local accounts on both sides with matching passwords, pass-through authentication should work. Are they doing anything special to make the sp_OA procedures work in the other cases?

Sounds like you're on the right track.

1) As far as client tools, sounds like you're right on. You only need to install the SQL Server client tools, so when presented...

Those are the major ones people are screaming about. I think the general consensus is the XP firewall is a good step in the right direction, but grab another one...

He's talking about:

SQLServerCentral.com's Security Skills test

That looks to be a glitch. Use the Report a Problem link to let Andy, Brian, and Steve know.

Extrapolate to a groups table or the like... in much the same way as many of the community message forums work behind the scenes nowadays. Ultimately it gives a starting...

A good starting point if you want to build your own solution:

MVP Vyas Kondreddi's article on row-level security in SQL Server

Including the @password is no longer valid with Internet Explorer. It's not in the RFC for HTTP (it is for FTP) and attackers were actually using it to spoof what...

The web site, it'll be on the Internet? Generally, unless you're using something like ISA server, it's not a good idea to allow your web server to be a member...

Depends a lot on what your business needs and can afford.

Clustering provides high-availability. In other words, the loss of an entire computer, doesn't bring you down. However, it is more...

What is it needing to access on the network? Perhaps if we go at it from that direction, we might be able to come up with something workable. Any of...

You also may want to seriously consider the access your colleagues need. Do they truly need full access to the system? If not, you'll want to restrict accordingly. If you...

The server in question has to be configured to be allowed to delegate (that would be the first SQL Server you're connecting to). In addition, the accounts would all have...