am running MSSQL 2008 and cant seem to enable remote login with the IP address.
I have enabled
1. remote login on the sql instance ( under facets )
2. added the server IP to surface configuation manager to the TCP/IP configurations and enabled it
3. I have enabled remote login on windows firewall
4. I also ran netstat /a to check listening ports and the port 4533 is open and appears in the list, but not under the server IP, but under the 127.0.0.1 Ip and host name.
However when i try to login with the IPaddress,port number either directly through the server or remotely, I get this error message
TITLE: Connect to Server
Cannot connect to xxx.xxx.xxx.xxx,4533.
A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: TCP Provider, error: 0 - A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond.) (Microsoft SQL Server, Error: 10060)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=10060&LinkId=20476