Posted by Rico on 09/07/06 18:10

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

• Next in forum: Re: Creating a dynamic Global Temp Table within a stored procedure
• Prev in forum: transaction inside sp_executesql
• Thread view: SQL Server 2005 connection unusually slow even errors.

[Reply to this message]