NT Authentication slowness vs SQL Server Auth

  • THere is a process that pulls data from a SQL server 2000 database SP4 and populates a Laptop, when connecting thru NT Authentication the process is really slow, when connecting thru SQL Auth it is fast. Is there any difference on how SQL Server acts if you connect thru NT Auth compared to SQL Auth?

  • The only difference I'm aware of is when the connection is made. After that, things should run the same.

    Can you provide more details on what seems slow? I wouldn't think any permissions checking, which could be different, should take a significant amount of time.

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply