[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 232
  • Last Modified:

Local SQL connection fails

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
red_75116
Asked:
red_75116
  • 3
  • 2
1 Solution
 
gmartinncCommented:
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
 
red_75116Author Commented:
It is already setup that way.  But I cant get a connection locally.
0
 
gmartinncCommented:
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
 
red_75116Author Commented:
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
 
red_75116Author Commented:
your questions helped me solve this.  thanks!
0

Featured Post

NFR key for Veeam Agent for Linux

Veeam is happy to provide a free NFR license for one year.  It allows for the non‑production use and valid for five workstations and two servers. Veeam Agent for Linux is a simple backup tool for your Linux installations, both on‑premises and in the public cloud.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now