?
Solved

Local SQL connection fails

Posted on 2011-03-21
5
Medium Priority
?
228 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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 2000 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

[Webinar] Lessons on Recovering from Petya

Skyport is working hard to help customers recover from recent attacks, like the Petya worm. This work has brought to light some important lessons. New malware attacks like this can take down your entire environment. Learn from others mistakes on how to prevent Petya like worms.

Question has a verified solution.

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

This is basically a blog post I wrote recently. I've found that SARGability is poorly understood, and since many people don't read blogs, I figured I'd post it here as an article. SARGable is an adjective in SQL that means that an item can be fou…
SQL Server engine let you use a Windows account or a SQL Server account to connect to a SQL Server instance. This can be configured immediatly during the SQL Server installation or after in the Server Authentication section in the Server properties …
If you’ve ever visited a web page and noticed a cool font that you really liked the look of, but couldn’t figure out which font it was so that you could use it for your own work, then this video is for you! In this Micro Tutorial, you'll learn yo…
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…

764 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