Re: Problems after SP2 Patch, With Pervasive SQL Server

From: Doug Knox MS-MVP (dknox_at_mvps.org)
Date: 08/22/04


Date: Sun, 22 Aug 2004 14:25:31 -0400

You need to find out what TCP port your SQL Server is listening on, and then make sure that port is open in the Windows firewall.

-- 
Doug Knox, MS-MVP Windows Media Center\Windows Powered Smart Display
Win 95/98/Me/XP Tweaks and Fixes
http://www.dougknox.com
--------------------------------
Per user Group Policy Restrictions for XP Home and XP Pro
http://www.dougknox.com/xp/utils/xp_securityconsole.htm
--------------------------------
Please reply only to the newsgroup so all may benefit.
Unsolicited e-mail is not answered.
 
"Dennis" <Dennis@discussions.microsoft.com> wrote in message news:A3CE733E-40B3-4979-9175-C9536021B365@microsoft.com...
>I am having problems with clients connecting to my database server, after sp2 
> patch was installed, pervasive tested tcip ok ,but won't allow access to 
> database files.
> Anybody out there with a little Pervasive experience .
>                                                                   Thanks  
> Dennis


Relevant Pages

  • Re: SQL Server 2005 on Windows Server 2008 - sqlcmd can not connect
    ... Check if your SQL Server instance allows remote connection. ... Check which TCP port your SQL Server instance is listening. ... it is most likely that your Windows Firewall block ...
    (microsoft.public.sqlserver.setup)
  • Re: SP2 Problem on Remote Access
    ... I've checked to ensure the correct TCP port is open as ... you need to enable "Allow remote administration ... Windows Firewall: Allow remote administration exception ... policy setting, Windows Firewall allows the computer to receive the ...
    (microsoft.public.windowsxp.wmi)
  • Re: WMI and XP SP2 remote connection problem !!
    ... >> There is a Group Policy setting to open for Microsoft Management ... >> Windows Firewall: Allow remote administration exception ... >> disabling this policy setting does not block TCP port 445, ...
    (microsoft.public.win32.programmer.wmi)
  • Re: WMI and XP SP2 remote connection problem !!
    ... What can be done in order to connect on remote XP SP2 machines without having to change the firewall settings manually? ... There is a Group Policy setting to open for Microsoft Management ... Windows Firewall allows the computer to receive the ... disabling this policy setting does not block TCP port 445, ...
    (microsoft.public.win32.programmer.wmi)
  • Re: Manage XP clients in ADUC?
    ... would think you need to apply this policy setting on the remote ... Windows Firewall allows the computer to receive the ... unsolicited incoming messages associated with remote administration. ... disabling this policy setting does not block TCP port 445, ...
    (microsoft.public.win2000.general)