SQL Server 2005 connection unusually slow even errors.
- From: "Rico" <me@xxxxxxx>
- Date: Thu, 07 Sep 2006 18:10:19 GMT
Hello,
I have a Win2K3 Server with SS2005 developers edition. I am working on a
Windows XP Pro workstation which has SQL Server 2000 installed as well as
the SQL Native Client. I'm using an MS Access ADP to connect to the server
and for some reason it's extremely slow, even to the point of throwing time
out errors and "can't generate SSPI context" messages. I've hit the MS
website and found info on the SSPI error, but none of the items that
generate the error apply to my situation. I've tried using the surface area
manager to change the connection to name pipes, name pipes and tcpip etc,
but no luck.
Is there anything I should be looking at or any known issues that would
affect this kind of performance?
Thanks!
Rick
.
- Follow-Ups:
- Re: SQL Server 2005 connection unusually slow even errors.
- From: John Bell
- Re: SQL Server 2005 connection unusually slow even errors.
- Prev by Date: transaction inside sp_executesql
- Next by Date: Re: Creating a dynamic Global Temp Table within a stored procedure
- Previous by thread: transaction inside sp_executesql
- Next by thread: Re: SQL Server 2005 connection unusually slow even errors.
- Index(es):
Relevant Pages
|
Loading