- Is the user account running the client application a member of the workstation domain or the server domain? (Or perhaps a third domain?)
The are two domains Client pc is part of domain A this is the same domain that the user logs onto. The SQL Server is in domain B
- Is the client application a normal windows application or a web site?
Windows App - just to potentially muddy the waters, there are also web apps where the back end is on the same SQL server; these have not reported slow running to the same extent.
Other locations, it should be noted, don't experiance this issue to the same extent.
- How does the client application connect to SQL Server? Directly or via a server application?
Directly via ODBC
- What kind of user account does the client application uses to connect to SQL Server? A domain account, local user account (in case the server application or web site runs on the same server as SQL Server), or a SQL user account?
SQL account. Same account is used for all users.
- In the case of a domain account, which authentication scheme is used, NTLM or Kerberos? You can look this up in sys.dm_exec_connections (http://msdn.microsoft.com/en-us/library/ms181509.aspx)
SQL - don't forget this is a SQL 2005 server not 2012
-------------------------------Posting Data Etiquette - Jeff Moden [/url]Smart way to ask a question
There are naive questions, tedious questions, ill-phrased questions, questions put after inadequate self-criticism. But every question is a cry to understand (the world). There is no such thing as a dumb question. ― Carl Sagan
I would never join a club that would allow me as a member - Groucho Marx