Re: SQL Login vs NT Login

From: Jonathan (Jonathan_at_discussions.microsoft.com)
Date: 07/27/05 

Date: Wed, 27 Jul 2005 06:05:03 -0700

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

"Uri Dimant" wrote:

> 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?
>
>
> "Jonathan" <Jonathan@discussions.microsoft.com> wrote in message
> news:6559051D-D83A-46C2-BB36-FA2DB741EFEA@microsoft.com...
> > 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
>
>
>

Relevant Pages

  • Re: Problems connecting to SQL server on W2K3 from Win 2000 workst
    ... Can you connect to a network share on the SQL server? ... Also I know this isn't as important on 2k machines but is the primary DNS ... >> This is because you are using Windows authentication without a domain ... >> because it tends not to work, use SQL Authentication and you'll always ...
    (microsoft.public.sqlserver.connect)
  • Re: Login error when opening a deployed project
    ... You should use SQL Authentication instead of Windows Authentication. ... Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand ... command, CommandBehavior behavior) ...
    (microsoft.public.dotnet.security)
  • SQL Login vs NT Login
    ... Last week I modify my application that connect to a SQL Server 7 to use ... For exemple, for the same batch of record, with the SQL Authentication, it ... takes 15 second but with the Windows Authentication, ...
    (microsoft.public.sqlserver.security)
  • Re: trouble changing SA password on SQL Server 2005 Express
    ... I'd quickly switch to SQL Authentication, try logging in as SA with what you ... instance of SQL 2005 Express running in Windows Authentication mode. ... it throughs an error saying that I do not ...
    (microsoft.public.sqlserver.security)