Jump to content

Windows authentication and database performance

- - - - -

This topic has been archived. This means that you cannot reply to this topic.
1 reply to this topic

#1
Richmord

Richmord

    Newbie

  • Members
  • Pip
  • 3 posts
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.

#2
WillB

WillB

    Learning Programmer

  • Members
  • PipPipPip
  • 43 posts
Try looking into how the sql server authentication works. There should be a few different ways you can accomplish your task.

My bet, it that one of the other methods would be faster.
Everything in Life can be solved with an 'If/Else' statement.

Life is like one big try/catch statement, nested within a loop.

-Will

[SIGPIC][/SIGPIC]