Solved

Cannot Connect via Native 2005 or 2008 ODBC XP client to 2005 SP3 instance

Posted on 2010-09-02
4
465 Views
Last Modified: 2012-05-10
Cannot Connect via Native 2005 or 2008 ODBC XP client to 2005 SP3 instance named masdcvsql404\sql404, but can connect via odbc from different SQL server 2008 box via native client 2005.

It would seem the credentials are not the problem, nor the server-side set up. Am I missing something on the client side, do i need Studio manager Express to get some sort of tool to deal with instance name?
0
Comment
Question by:jeffreyrgauser
  • 2
4 Comments
 

Author Comment

by:jeffreyrgauser
ID: 33589098
Actually, client was able to connect to this db when it was on a SQL2005 SP2 box with SQL 2000 client.  Studio Manager is not installed.
 
Do I need to request that server team enable some sort of listener for DBC specifically?
0
 
LVL 12

Accepted Solution

by:
NormanMaina earned 250 total points
ID: 33590683
on the problem machine can you connect using osql?

Try on command promt : OSQL - S instancename -U username

If that does not work then its a problem to do with firewall blocking the SQL Server port or antivirus doing that or maybe the client tools are not correctly installed.

If you can connect using OSQL then its a version issue...like trying to view an sql server 2005 instance using enterprise manager will not work.
0
 
LVL 7

Assisted Solution

by:lundnak
lundnak earned 250 total points
ID: 33596222
What port is the SQL Server instance, MASDCVSQL404\SQL404 listening to?  You can get this from SQL Server Configuration Manager.
You will want to test connectivity first.  Try this first.

telnet MASDCVSQL404 <port#>   **port # usually 1433  

If the telnet fails, then you have a network connectivity issue.  Possibly, a network issue or firewall issue.

If it works, change the ODBC connection to use TCPIP with the specific port.  It's possible that its trying to use Named Pipes.
0
 

Author Comment

by:jeffreyrgauser
ID: 33707760
Found issue to be preclusion by McAfee Access Protection Rules.  Company was not allowing tcp 1434.
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

Suggested Solutions

Title # Comments Views Activity
SCCM 2012 - Backup and Recovery Best Practice 2 63
Locks on MS Access DB not being released 9 66
Analysis of table use 7 43
Help with SQL - TOP 10 by date and by group 13 34
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
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.
Viewers will learn the different options available in the Backstage view in Excel 2013.
The viewer will learn how to simulate a series of sales calls dependent on a single skill level and learn how to simulate a series of sales calls dependent on two skill levels. Simulating Independent Sales Calls: Enter .75 into cell C2 – “skill leve…

896 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

15 Experts available now in Live!

Get 1:1 Help Now