SQL Server 2005 connection unusually slow even errors.



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


.



Relevant Pages

  • RE: SBS 2003 Unable to connect to database STS_Config
    ... Uninstall the SQL server from the SBS 2k3 server from add/remove programs ... Uninstall Microsoft SQL Server Desktop Engine (SHAREPOINT) ... If AV software install any extra IIS virtual directory, ...
    (microsoft.public.windows.server.sbs)
  • Re: Memory issues with 64-bit SQL Server 2005 on 64-bit Win 2003 C
    ... I also checked the individual patch levels for the .NET drivers, SQL Server ... The SQL Server is fully patched, however Windows Update reported that the OS ... Lock pages in memory -- I guess you might have taken care of it as well. ...
    (microsoft.public.sqlserver.clustering)
  • RE: migrating from wmsde to sql server
    ... Click Start, point to All Programs\Microsoft SQL Server, and then click ... then click New SQL Server Registration. ... Microsoft CSS Online Newsgroup Support ... This newsgroup only focuses on SBS technical issues. ...
    (microsoft.public.windows.server.sbs)
  • Re: Login failed for user sa. (Error code: 18456).
    ... Try to disable named pipes just to get it out of the equation... ... SharePoint Server is behind the ... firewall and SQL Server Server is in the domain. ... >> "Robert Bogue" wrote: ...
    (microsoft.public.sharepoint.portalserver)
  • RE: SBS 2003 Unable to connect to database STS_Config
    ... Uninstall the SQL server from the SBS 2k3 server from add/remove programs ... Uninstall Microsoft SQL Server Desktop Engine (SHAREPOINT) ... If AV software install any extra IIS virtual directory, ...
    (microsoft.public.windows.server.sbs)

Loading