Monday, March 26, 2012

Windows authentication and database performance

Hi,

I recently added integrated windows authentication (stopped allowing anonymous access) to my asp.net application. It seems to work ok, but database access is exceedingly slow -- the DBA has decided not to allow integrated windows authentication, so instead I use sql server authentication and pass the credentials for the single user to the database.

Any ideas what's happening here?

Thanks for any help.:(Not really, we can't tell just from this description.

You may want to test the connectivity between the web server and the database server. Create a test app and place it on the web server, have it connect to the database server as well, best if it's to a test database. If it is just as slow, then you know it's a connectivity problem. If not, then it's an application problem!

0 comments:

Post a Comment