connection rejection for (local) on sql server 2000 ?

Posted on 2007-03-28
Medium Priority
Last Modified: 2013-11-16
(local) does not work in our applications. We shipped an application which uses the connection string as (local) for Sql Server 2000. When our firewall is running , the conneciton is rejected , how can we work around this problem ? We cannot change the connection string now, can we change any settings for the firewall ?
Question by:tech_question
LVL 11

Expert Comment

by:Ved Prakash Agrawal
ID: 18808920
check the port 1433 are blocked by firewall or not..
you need to allow port 1433 for sql server to connect

Author Comment

ID: 18808968
we tried to telnet via port 1433 and it works - any other ideas ?
LVL 25

Accepted Solution

DBAduck - Ben Miller earned 2000 total points
ID: 18812743
When using (local) it is about name resolution.  (local) usually maps to Named Pipes or, but still uses Named Pipes.  I would check the Server Network Utility and make sure that TCPIP is enabled.

The other thing is that if the application is not running on teh machine that SQL Server is running on, then you have bigger problems than that, as (local) does not have a name necessarily that you can map it to via HOSTS or anything else that I know of.

Featured Post

WEBINAR: GDPR Implemented - Tips & Lessons Learned

Join the WatchGuard team on Thursday, March 29th as we recount some valuable lessons learned in weighing the needs of a business against the new regulatory environment, look ahead at the two months left before implementation, and help you understand the steps you can take today!

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

What if you have to shut down the entire Citrix infrastructure for hardware maintenance, software upgrades or "the unknown"? I developed this plan for "the unknown" and hope that it helps you as well. This article explains how to properly shut down …
When trying to connect from SSMS v17.x to a SQL Server Integration Services 2016 instance or previous version, you get the error “Connecting to the Integration Services service on the computer failed with the following error: 'The specified service …
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.
Via a live example, show how to setup several different housekeeping processes for a SQL Server.

627 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question