Solved

Microsoft SQL Server, Error: 64

Posted on 2016-10-18
8
78 Views
Last Modified: 2016-10-24
Hi,

I have a computer (Win7 Pro) on our network who cannot connect to a SQL server outside the Network. However, If I try on another computer (Windows 7 Pro) to connect on the same server with the same credentials, it works. I have attached the error message from MS SQL Server Management Studio 2008. I am using the server's IP as a server name.

SQL Server Management Studio error
Thank you for your help.
0
Comment
Question by:David Dumais
8 Comments
 
LVL 40

Assisted Solution

by:Kyle Abrahams
Kyle Abrahams earned 250 total points
ID: 41849163
From:
https://social.msdn.microsoft.com/Forums/vstudio/en-US/2d11b6f9-3ada-4682-b643-c721a97af4ba/cant-connect-to-database-after-installing-vs-11-pro-beta?forum=vssetup

try opening up a command prompt as admin and running:
netsh Winsock reset

Open in new window

0
 
LVL 77

Expert Comment

by:arnold
ID: 41849466
Ip/netmask of the system that works versus the one that does not?
Are you entering the SQL login/or us it using Windows authentication? Same user logged into the two computer when the connection is attempted?
Do you require connection encryption?
Check the installed SQL native client library make sure you have SQL 2008 native client library Installed .....

What version of ssms is installed on this system versus the one that works?
0
 
LVL 4

Expert Comment

by:Daniel Jones
ID: 41849490
> Go to the SQL Configuration Manager
> Expand the SQL Network Configuration > click on the PROTOCOLS node
> Right click on TCP/IP > open up the PROPERTIES panel
> Select the IP ADDRESS tab
> Make sure the values for the IP ADDRESS fields are correct and match the system it is running on.
Restart the service

Make sure you fill in the TCP PORT, even if you are using the default 1433
0
NAS Cloud Backup Strategies

This article explains backup scenarios when using network storage. We review the so-called “3-2-1 strategy” and summarize the methods you can use to send NAS data to the cloud

 
LVL 77

Expert Comment

by:arnold
ID: 41849526
The error is a protocol mismatch, an ssms for SQL 2005 will not connect to SQL 2012 or newer successfully.
0
 
LVL 47

Expert Comment

by:Vitor Montalvão
ID: 41849564
Arnold may have a point here.
What's the version of the SQL Server instance that you're trying to connect to?
What's the version of the SSMS in your client computer? This should be equal or greater version than the target SQL Server version.
0
 

Author Comment

by:David Dumais
ID: 41850258
I tried the netsh Winsock reset and no sucess

Ip/netmask of the system that works versus the one that does not are the same

I am using a SQL login with no encryption

The Server has this SQL Version

Microsoft SQL Server Management Studio                                    12.0.2000.8
Microsoft Analysis Services Client Tools                                    12.0.2000.8
Microsoft Data Access Components (MDAC)                                    6.3.9600.17415
Microsoft MSXML                                    3.0 6.0
Microsoft Internet Explorer                                    9.11.9600.18427
Microsoft .NET Framework                                    4.0.30319.42000
Operating System                                    6.3.9600

And the client computer:

Microsoft SQL Server Management Studio                                    12.0.2569.0
Microsoft Analysis Services Client Tools                                    12.0.2569.0
Microsoft Data Access Components (MDAC)                                    6.1.7601.17514
Microsoft MSXML                                    3.0 6.0
Microsoft Internet Explorer                                    9.11.9600.18499
Microsoft .NET Framework                                    4.0.30319.42000
Operating System                                    6.1.7601
0
 
LVL 77

Accepted Solution

by:
arnold earned 250 total points
ID: 41850446
Working client info versus?
Ip/netmask can not be the same, ip has to be unique.

Do you have vlans?
Disconnect client that does not work from network, change working client ip to that that the client that does not and see if it relates to ip, do the same on the client that does not work, set its ip to the one that did.
0
 

Author Closing Comment

by:David Dumais
ID: 41857139
I did:
ipconfig /release
ipconfig /flushDNS
immediately shut down the computer.

After a fresh start, computer had a new IP and everything was working fine. Thank you very much for the help.
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

Suggested Solutions

Title # Comments Views Activity
How to share SSIS Package? 6 37
Query Help - MSSQL - Averages 5 27
Need help constructing a conditional update query 16 48
SQL2016 to ORACLE11G linked-server 6 16
Why is this different from all of the other step by step guides?  Because I make a living as a DBA and not as a writer and I lived through this experience. Defining the name: When I talk to people they say different names on this subject stuff l…
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…
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed

831 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