Solved

Local SQL connection fails

Posted on 2011-03-21
5
219 Views
Last Modified: 2012-05-11
Our 2005 Sql server crashed and we were able to change hardware install 2008 R2 Sql using the same server name and instance name.  We have a program that uses a database called ABTT and we have opened port 1433 through the firewall and remote off LAN connections work great, but connections locally fail.

i dont seem to be getting any error messages in the program so is there place to look for messages or a test I can run to determine what the cause is?

I think it is somethng with named pipes, but they look to be enabled and I don't know how to test.
0
Comment
Question by:red_75116
  • 3
  • 2
5 Comments
 
LVL 1

Expert Comment

by:gmartinnc
ID: 35182956
On the server:
1. Go to your start menu/Microsoft SQL Server 2008 R2/Configuration Tools/SQL Server Configuration Manager.
2. Go to SQL Server Configuration Manager (Local)/SQL Server Network Configuration/Protocols for MSSQLSERVER (or your instance).
3. Right-click Named Pipes and click "Enable".
4. Go to SQL Server Configuration Manager (Local)/SQL Native Client 10.0 Configuration/Client Protocols.
5. Right-click Named Pipes and click Enable (if it is disabled).
0
 

Author Comment

by:red_75116
ID: 35183019
It is already setup that way.  But I cant get a connection locally.
0
 
LVL 1

Accepted Solution

by:
gmartinnc earned 500 total points
ID: 35190457
Are you attempting to connect through SQL Server Management Studio or through a connection string from an application?

By "locally" do you mean you are attempting to connect from the same server or another server in the same domain?

Can you share your connection string (with passwords masked)?
0
 

Author Comment

by:red_75116
ID: 35190641
Your email helped me identify the problem, now maybe you can help me with the solution. All these programs connect via an external IP address 206.XXX.XXX.XXX.  on the old server, it must have routed to the local ip of 10.1.1.7.

We must have entered a DNS entry which routes the external to the internal either on the local or DNS.  It must have gotten deleted when we unjoined the old server and added the new box using the same name.

Any ideas how to do that??
0
 

Author Closing Comment

by:red_75116
ID: 35191100
your questions helped me solve this.  thanks!
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
This Micro Tutorial will teach you how to censor certain areas of your screen. The example in this video will show a little boy's face being blurred. This will be demonstrated using Adobe Premiere Pro CS6.
With the power of JIRA, there's an unlimited number of ways you can customize it, use it and benefit from it. With that in mind, there's bound to be things that I wasn't able to cover in this course. With this summary we'll look at some places to go…

911 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

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now