[dba-SQLServer] Access disconnecting from sql express DB

i
f you set it to 0 (disabling RSS) you you eliminate the possibility of a
NIC driver not setting the RSS settings properly for the OS, which could be
a problem with Windows 2003 sp2 machines and older nics that didn't support
RSS properly.

hope this helps...


-Francisco <http://twitter.com/seecoolguy>




On Thu, Aug 15, 2013 at 8:17 AM, J- P <jnatola at hotmail.com> wrote:

> A little confused here on # 4  , the article you pointed me to says to
> ENABLE RSS, yet the instructions on turning OFF SNP says to DISABLE RSS
>
> Disable SNP as described in the following article in the Microsoft
> Knowledge Base:
>
> 948496 Update to turn off SNP features for Windows Server 2003 and Windows
> SBS 2003       Install the hotfix that is described in the following
> article in the Microsoft Knowledge Base:      950224 A Scalable Networking
> Pack (SNP) hotfix rollup package is available for Windows Server 2003
> Enable the Receive feature. By using Regedit.exe
> HKLM\SYSTEM\CurrentControlSet\Services\Tcpip\Parameters
> EnableRSS=1 (Dword)
> But when i go to the instructions to turn off SNP per article
> http://support.microsoft.com/kb/948496
>
> its says to DISABLE RSS
> Right-click EnableTCPChimney, and then
>                                 click Modify.In the Value data box, type
>                                 0, and then click OK.Right-click
> EnableRSS, and then click
>                                 Modify.In the Value data box, type
>                                 0, and then click OK.Right-click
> EnableTCPA, and then click
>                                 Modify.In the Value data box, type
>                                 0, and then click OK. Exit Registry
> Editor, and then restart the
>                                 computer.
> So do I Enable or Disbale RSS?
>
>
>
> ----------------------------------------
> > From: fhtapia at gmail.com
> > Date: Wed, 14 Aug 2013 06:39:20 -0700
> > To: dba-sqlserver at databaseadvisors.com
> > Subject: Re: [dba-SQLServer] Access disconnecting from sql express DB
> >
> > so to help troubleshoot your version of windows 2003 r2 and the sql
> server
> > engine, follow the tips in this kb
> >
> > http://support.microsoft.com/kb/942861
> >
> > and report back if any of it helps (or is unhelpful).
> >
> > good luck!
> >
> > -Francisco <http://twitter.com/seecoolguy>
> _______________________________________________
> dba-SQLServer mailing list
> dba-SQLServer at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
> http://www.databaseadvisors.com
>
>