Solved

Local SQL connection fails

Posted on 2011-03-21
5
220 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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
This Micro Tutorial hows how you can integrate  Mac OSX to a Windows Active Directory Domain. Apple has made it easy to allow users to bind their macs to a windows domain with relative ease. The following video show how to bind OSX Mavericks to …
Windows 10 is mostly good. However the one thing that annoys me is how many clicks you have to do to dial a VPN connection. You have to go to settings from the start menu, (2 clicks), Network and Internet (1 click), Click VPN (another click) then fi…

773 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