Posted by php-taz on 09/11/06 15:11

Same thing, it takes a full second to connect. Another difference
between the two servers is that SQL Server on the old machine is set up
to use just Windows Authentication, while this new server uses Mixed.
Would this effect connection speed?

Chung Leong wrote:
> Try it with SQL Server authentication instead and see what happens.

• Next in forum: Re: UPDATE query appears to complete but nothing changes in data
• Prev in forum: Re: Filling form with database info
• Thread view: Re: MSSQL slow on IIS 6

[Reply to this message]