We are in the process of migrating a customer from SBS2003 + SQL to Server 2008R2 and SQL Server 2008 and having set up a test move of their main DB application (Raiser's Edge) to SQL 2008 we found the following:
If we are logged onto the client XP PC as domain admin, the logon to the DB as a User is almost instantaneous but if we are logged onto the PC as a user (who is a member of the group that has full access to the DB) then there is a delay of approx. 20 seconds
while the logon is being validated. We have set up SQL and attached the DB in accordance with the instruction from Blackbaud (The developer of Raiser's Edge) and cannot understand what is causing the delay. In fact the 20 second delay occurs twice - once when
the application connects to the DB in order to validate the user and then again when the user logs on.
I tried reducing the Remote Logon Delay but this had no effect on the problem.
Any help/advice would be appreciated.
View Complete Post