i recently deployed a c# Win application with Sql2005 as DB backend on my vista business server
there is 3xp clients and 2 2000 clients connect to this server. eveyrthing ran fast and fine untill one day the activation 30 days came up on my vista server so i did an activation online which was successful which then allowed me to do windows update. the update installed sql 2005 service pack 2. right after that i'm asuuming that's the problem nothing seem to work fine. the 2000 client computer can connect to the server perfectly fine but the XP computer would take a rediculus amount of time to connect like 20mins where the 2000 client connect in 5-20sec
i'm not sure what happen but it looks *like the windows authenication is not working properly?
does any know how to test if this is an authenication error with SQL? i even tried system restore point to an earlier date. and nothing is working.. the app should take less then 5 sec to load up not 20mins.
there is 3xp clients and 2 2000 clients connect to this server. eveyrthing ran fast and fine untill one day the activation 30 days came up on my vista server so i did an activation online which was successful which then allowed me to do windows update. the update installed sql 2005 service pack 2. right after that i'm asuuming that's the problem nothing seem to work fine. the 2000 client computer can connect to the server perfectly fine but the XP computer would take a rediculus amount of time to connect like 20mins where the 2000 client connect in 5-20sec
i'm not sure what happen but it looks *like the windows authenication is not working properly?
does any know how to test if this is an authenication error with SQL? i even tried system restore point to an earlier date. and nothing is working.. the app should take less then 5 sec to load up not 20mins.
