Greg-

Thanks for the response.

We have a fairly straight forward setup for our Intranet - one server for web and database; user logins via Windows authentication; running IIS 6, classis ASP...

I figured out this problem.

I granted NT AUTHORITY\NETWORK SERVICE to our production database and both problems have gone away.

I am not sure I understand why this was necessary for SQL...

I used SQL Server Profiler to trace the failed logins but have only caught the failure of NT AUTHORITY\NETWORK SERVICE attempting to login into database master. This user has...

The thread you suggest does not read like my problem.

I am not sure why I would need to touch each PC since my problem seems server related.

Robb

I manually redefined all of the users at the server level after attaching the production database.

The stored proc returned no results.

Which issue were you addressing? The intermittent user connectivity...