Solved

Local SQL connection fails

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

On Demand Webinar - Networking for the Cloud Era

This webinar discusses:
-Common barriers companies experience when moving to the cloud
-How SD-WAN changes the way we look at networks
-Best practices customers should employ moving forward with cloud migration
-What happens behind the scenes of SteelConnect’s one-click button

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
T-SQL: Please describe what a page split is 5 57
T-SQL: How to extract records into a new table 7 43
grouping by date only 6 22
What is needed to become a DBA? 7 51
I have written a PowerShell script to "walk" the security structure of each SQL instance to find:         Each Login (Windows or SQL)             * Its Server Roles             * Every database to which the login is mapped             * The associated "Database User" for this …
Long way back, we had to take help from third party tools in order to encrypt and decrypt data.  Gradually Microsoft understood the need for this feature and started to implement it by building functionality into SQL Server. Finally, with SQL 2008, …
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…

739 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