Hi Mizi, To verify port 1433 we did nmap [servername] from a Unix machine We have disabled the local firewall.
Most of the old answers point to TCP/IP settings but they look ok for us. Old posting answers: **You need to enable TCP/IP connections at the database level **I believe there've been several posts about this already, but if memory serves... - Open the SQL Server Configuration tool and open the 'Protocols' section - Open the TCP/IP connection - Ensure on the first tab that it is enabled - On the second tab, double check each of the IP Addresses to ensure they're correct and that port 1433 is set for the TCP port - Save your changes and restart the MSSQLServer service That should do it. Good luck, ** You need to go into SQL manager and turn on TCP/IP. I had same problem, TCP/IP wasn't enabled by default when I installed SQL There are more similar answers, Regards, Janne Jan Olsson • FAST Administrator • SunGard • Front Arena • Kungsbron 2, PO Box 70351, SE-107 24 Stockholm, Sweden Tel +46 8 454 0301 • Mobile +46 768 692 301 • www.sungard.com -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Misi Mladoniczky Sent: den 12 maj 2011 12:08 To: [email protected] Subject: Re: TCP/IP connection to the host loclahost using port number 1433 failed... Hi Janne, You should give us a list of the "old solutions" to help on the way. How is your local firewall set up? How did you verify that 1433 is really listening? I was able to install a similar setup without any major problems using Win 2008 R2 and SQL Server 2008 R2. Best Regards - Misi, RRR AB, http://www.rrr.se Products from RRR Scandinavia (Best R.O.I. Award at WWRUG10): * RRR|License - Not enough Remedy licenses? Save money by optimizing. * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs. Find these products, and many free tools and utilities, at http://rrr.se. > I know this has been posted several times before. > > But all old solutions to the problem has not solved mine. > > I still can't get by the dialog that pops up. > > My TCP/IP is setup ok, The SQL is listening to port 1433, but it will > not work. > > > > We are installing a complete new server > > OS 2008 R2 SP1 > > SQL Server 2008 SP2 Standard > > Remedy server 7.5 P3 > > > > Any new ideas? > > > > Best regards, Janne > > > > Jan Olsson * FAST Administrator * SunGard * Front Arena * Kungsbron 2, > PO Box 70351, SE-107 24 Stockholm, Sweden > Tel +46 8 454 0301 * Mobile +46 768 692 301 * www.sungard.com > <blocked::BLOCKED::http://www.sungard.com> > > ________________________________ > > P Think before you print > > CONFIDENTIALITY: This email (including any attachments) may contain > confidential, proprietary and privileged information, and unauthorized > disclosure or use is prohibited. If you received this email in error, > please notify the sender and delete this email from your system. Thank > you. > > ________________________________ > > > > > _______________________________________________________________________________ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are" > _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"
