SQL Login vs NT Login

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Jonathan - 26 Jul 2005 21:00 GMT

Hi all.

My problem is simple.

Last week I modify my application that connect to a SQL Server 7 to use
Windows Authentication. Before, it use SQL Authentication.

Since I made that change, my application response slowly than before. I use
exactly the batch of records, update, delete and insert and the difference is
big. My application calculate some quantity and display it on screen.

For exemple, for the same batch of record, with the SQL Authentication, it
takes 15 second but with the Windows Authentication, it takes more than 1
minute.

Anybody have an idea ?

I'm in the obligation to reinstall my old application because it's too slow.

Thanks

Jonathan

Reply to this Message

Uri Dimant - 27 Jul 2005 03:35 GMT

Jonathan
I have doubt abiout trusted connection causes to the problem. Have you
investigated an execution plan of the queries? Does the optimizer available
to use indexes?

> Hi all.
>
[quoted text clipped - 21 lines]
>
> Jonathan

Reply to this Message

Jonathan - 27 Jul 2005 14:05 GMT

My query never change since 2001 and it use index since that time. I rebuilt
the index every night with my maintenance plan and my user tell me that the
application takes more time to execute since I deployed the new one.

I reinstall the old version of my application with the SQL Authentication
and it works ok.

When I install the new application with the Windows authentication, for
exemple 1 minute after, the execution is longer.

I reinstalled again the old application and it works.

It's a big problem because I'm in the process to change all my application
that I have on my company to use Windows Authentication.

Thanks ..

Jonathan

> Jonathan
> I have doubt abiout trusted connection causes to the problem. Have you
[quoted text clipped - 26 lines]
> >
> > Jonathan

Reply to this Message