Cross database ownership chaining is actually a good solution here. Here's how to implement:

1) Create the guest user on the database containing the data. Make sure it and the public...

Start monitoring the security event log of the server. Have the user log on to the SQL Server in question. What does the security event log say the Windows user...

This is not available yet. You're thinking of Managed Service Accounts which isn't available until Windows Server 2008 R2 (which isn't RTM yet). In that case, your Active Directory infrastructure...

On the server running the SQL Server, if you can, run from the command line:

netstat -ano

If need be, send this output to a text file. Compare the PID of...

It depends. Do you have the option of one central SQL Server that all the PCs connect to? If not, what is the max size you anticipate the SQL Server...

#1 - Creating the role

Use sp_addrole. The CREATE ROLE T-SQL is new in SQL Server 2005.

#2 - Creating an "executor" role.

SQL Server 2000 doesn't have the same concepts of securables...

Okay, that's a Windows security group.

1. Make sure it is added as a login to the SQL Server.

2. Make sure that login is added as a user to the particular...

You should look at seeing if you can change the application. Failing that:

1. Set a password on the login.

2. Ensure password policy enforcement is OFF.

3. Enable the login.

4. Modify the...

These are actually local security groups. Unfortunately, I don't know PolyServe, so I can't answer your question, you're going to need to check with someone at HP, most likely. When...

Is UAC on? Is Internet Explorer running in protected mode?

The role will also need ALTER SCHEMA rights on any schema that the role doesn't own or have CONTROL rights on.

For problem 1, do you mean Windows security group?

For problem 2, you should leave them alone. SQL Server 2005/2008 will only show through those objects information on the objects a...

You can't. Using a domain account in this manner means that you are on a trusted system, so far as the domain is concerned. You must use SQL Server based-logins...

This may be one of the weaknesses in the Audit Object. I need to play around a bit more to see if you can capture the parameter, but at first...

Have you applied at least SP2 to the machine running SQL Server Management Studio? This was introduced in that service pack as an extension to SSMS. You do NOT need...