October 20, 2009 at 6:58 am
I have a installed a new SQL 2008 server (Standard Edition) on Windows Server 2003 (Standard Edition)
The instance name is the default MSSQLSERVER
Remote Connections are enabled
Mixed Mode Authentication is enabled
Using SQL Config Manager, I have set TCPIP Protocol as follows;
TCP Dynamic Ports = blank for all IPs
IP1 Active = Yes, Enabled = Yes, TCP Port = 1433
IP2 Active = Yes, Enabled = No, TCP Port = 1433
IP3 Active = Yes, Enabled = No, IP = 127.0.0.1, TCP Port = 1433
IPAll Active = TCP Port = 1433
I can ping the server
I can FTP the server
I can Remote Desktop
I cannot telnet <ip> <port>
I cannot connect using OSQL -S<IP>,1433 -Ufoo -Pfoo
Windows Firewall is disabled
IIS is disabled
Any thoughts ? This is driving me nuts !
October 20, 2009 at 7:06 am
Also; the SQL Browser Service is on and I have restarted the services after each config change.
And aplogies if this should have been posted in the Admin section.
October 20, 2009 at 8:24 am
Phew, finally solved this ...
In "Local Security Settings" there was a "Default Security Policy" which had a "Deny" filter enabled for "MSDE/MS SQL"
Disabled the filter and hey presto !
I must have looked at hundreds of online posts without coming across this so hopefully others will benefit from this 🙂
October 26, 2010 at 2:22 am
Hi,
I'm having similar problems and I’ve tried all sorts. When you say there was a "Default Security Policy filter enabled for "MSDE/MS SQL" was this a windows policy on one on MSQL server? Any pointer much appreciated. 🙂
October 26, 2010 at 4:14 am
I'm running Windows Server 2003. The deny setting was set in Admin Tools -> Local Security Policy -> IP Security Policies On Local Computer -> Default Security Policy
October 26, 2010 at 5:21 am
cheers chris, I'm on a 2008 box but settings are similar but didnt have MSDE/MS SQL policy listed 🙁
I'll continue to dig around.
cheers.
Viewing 6 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply